WO2011076058A1

WO2011076058A1 - Distributed databases upgrade method, upgrade processing device and upgrade controlling device

Info

Publication number: WO2011076058A1
Application number: PCT/CN2010/079425
Authority: WO
Inventors: 郑国斌
Original assignee: 中兴通讯股份有限公司
Priority date: 2009-12-22
Filing date: 2010-12-03
Publication date: 2011-06-30
Also published as: CN102103613B; CN102103613A

Abstract

A distributed databases upgrade method, an upgrade processing device and an upgrade controlling device are provided. The distributed databases comprise at least two database equipments, and the upgrade processing device is disposed on each of the database equipments; and the upgrade processing device receives and stores the first database script sent by the upgrade controlling device (101), and creates the new data object according to the first database script and upgrades the database of the database equipment (102); the upgrade processing device switches the currently used database script from the second database script to the first database script after the update is successful (103); the second database script is the database script used to process the data access request before the upgrade is successful. The present invention can still use the database script pre-upgraded to process the data access request during the upgrade so as to implement the service without interruption during the upgrade and to ensure the data access quality.

Description

Distributed database upgrade method, upgrade processing device and upgrade control device

The present invention relates to the field of distributed databases, and in particular, to a method for upgrading a distributed database, an upgrade processing device, and an upgrade control device. Background technique

With the development of information technology (IT) software and hardware and the acceleration of social information processing, distributed databases are becoming more and more widely used in communications and finance industries. Distributed database can realize large-capacity and multi-category data storage, and can provide high-performance data access services through collaborative work between multiple database devices. At the same time, it can be realized by database devices distributed on multiple sites. The data is disaster-tolerant at the site level, which greatly ensures the reliability and security of the data. Degrees and risks, in the process of implementing the present invention, the inventors found that the distributed database in the prior art has the following defects when performing online upgrade: In the database device, a new data object is created by using a new database script, and the database is performed. When upgrading, the external data access service will be interrupted, affecting the quality of the business/application access database. In the communications industry, if some of the database devices fail to work, it will cause a response delay that affects the end user experience. Summary of the invention

The technical problem to be solved by the present invention is to provide a method for upgrading a distributed database, an upgrade processing device, and an upgrade control device, which can solve the problem that a distributed database has a business interruption during the upgrade process.

In order to solve the above technical problem, the embodiments of the present invention provide the following technical solutions: A method for a distributed database upgrade, where the distributed database includes at least two database devices, each of which is provided with an upgrade processing device, and the method includes:

The upgrade processing device receives and stores a first database script sent by the upgrade control device, and creates a new data object according to the first database script, and upgrades the database of the database device;

After the upgrade is successful, the upgrade processing device switches the currently used database script from the second database script to the first database script; the second database script is a database script for processing the data access request before the upgrade succeeds.

Before the upgrade processing device receives and stores the first database script sent by the upgrade control device, the method further includes:

The upgrade processing device receives a database script query request sent by the upgrade control device, and returns a second database script to the upgrade control unit.

After the upgrade processing device switches the database script from the second database script to the first database script, the method further includes:

Upon receiving the data access request, the upgrade processing device processes the data access request using the first database script.

The upgrade processing device returns an upgrade result to the upgrade control device.

After the upgrade processing device returns the upgrade result to the upgrade control device, the method further includes:

The upgrade processing device corresponding to the upgraded database receives the fallback request sent by the upgrade control device;

The upgrade processing device switches the currently used database script from the first database script to the second database script according to the received backoff request, and deletes the newly created database Data object.

An upgrade processing device is deployed on a database device of a distributed database, and the device includes:

a receiving module, configured to receive a first database script sent by the upgrade control device;

An upgrade module, configured to create a new data object according to the first database script, and upgrade a database of the database device;

a switching module, configured to: after the upgrade succeeds, switch the currently used database script from the second database script to the first database script, where the second database script is a database script for processing the data access request before the upgrade succeeds .

The device also includes:

a query module, configured to receive a database script query request, and query the database script currently used by the database device according to the query module;

And a sending module, configured to return a second database script to the upgrade control device.

The device also includes:

And a processing module, configured to process the data access request by using the first database script after the switching module switches the database script from the second database script to the first database script.

The device also includes:

Receiving a fallback request module, configured to receive a fallback request sent by the upgrade control device after the upgrade is successful;

The fallback module is configured to switch the currently used database script from the first database script to the second database script, and delete the newly created data object.

An upgrade control device is used for the upgrade of the distributed database, the distributed database includes at least two database devices, and the upgrade processing device is deployed on the database device, and the upgrade control device includes:

a sending module, configured to send a database script query request to the upgrade processing device; a control module, configured to determine, according to the second database script returned by the upgrade processing device, that the database of the database device needs to be upgraded, and control the sending module to send the first for the database upgrade to the upgrade processing device Database script.

The device also includes:

a receiving module, configured to receive a storage result returned by the upgrade processing device;

The sending module is further configured to send an upgrade request to the upgraded processing device that is successfully stored according to the storage result received by the receiving module.

The receiving module is further configured to receive an upgrade result returned by the upgrade processing device, where the sending module is further configured to perform an upgrade upgrade process successfully when a part of the database upgrade fails according to the upgrade result received by the receiving module. The device sends a fallback request.

Embodiments of the present invention have the following beneficial effects:

The upgrade control device centrally controls the upgrade progress of multiple upgrade processing devices in the distributed database to achieve centralized upgrade. The upgrade processing device simultaneously saves at least two database scripts before and after the upgrade, and the upgrade processing device creates a new data object process after the upgrade. The database script is not switched, so that the database script can be used to process the data access request during the upgrade process, so that the service is not interrupted during the upgrade process, and the data access quality is guaranteed. DRAWINGS

1 is a flowchart of a distributed database upgrade according to an embodiment of the present invention;

2 is a diagram of an upgrade processing apparatus according to an embodiment of the present invention;

3 is a diagram of an upgrade control apparatus according to an embodiment of the present invention;

4 is a schematic diagram showing the relationship between an upgrade control device and an upgrade processing device according to an embodiment of the present invention;

FIG. 5 is a flowchart of a distributed database upgrade according to another embodiment of the present invention. detailed description

The technical problems, the technical solutions, and the advantages of the embodiments of the present invention will become more apparent from the following detailed description.

The embodiment of the present invention is directed to the problem that the distributed database is interrupted during the upgrade process in the prior art, and provides a distributed database upgrade method, an upgrade processing device, and an upgrade control device, which can avoid the distributed database during the upgrade process. A business disruption occurred.

The embodiment of the present invention provides a method for upgrading a distributed database. The distributed database includes at least two database devices, and an upgrade processing device is deployed on each database device. As shown in FIG. 1 , the embodiment includes:

Step 101: The upgrade processing device receives and stores the first database script sent by the upgrade control device.

Step 102: The upgrade processing device creates a new data object according to the first database script, and upgrades the database of the database device.

Step 103: After the upgrade is successful, the upgrade processing device switches the database script from the second database script to the first database script, and the second database script is a database script for the upgrade processing device to process the data access request before and during the upgrade process.

The first database script is a new database script received by the upgrade processing device, and the second database script corresponds to an old database script stored before the upgrade processing device.

In the distributed database upgrade method of the embodiment, the upgrade processing device saves the database scripts before and after the upgrade, and does not switch the database script during the process of upgrading the database after creating the upgraded new data object. During the upgrade process, you can still use the pre-upgrade database script to process data access requests, so that services are not interrupted during the upgrade process, ensuring data access quality.

The embodiment of the present invention further provides an upgrade processing apparatus, which is deployed on each database device of the distributed database. As shown in FIG. 2, the embodiment includes: The receiving module 20 is configured to receive a first database script sent by the upgrade control device, a storage module 21, configured to store the first database script received by the receiving module 20, and an upgrade module 22, configured to create new data according to the first database script. Object, upgrade the database of the database device;

The switching module 23 is configured to switch the database script from the second database script to the first database script after the upgrade is successful, and the second database script is a database script used by the upgrade processing device to process the data access request before and during the upgrade process. .

Wherein, the device further comprises:

The query module 24 is configured to receive a database script query request sent by the upgrade control device, and query a database script currently used by the database device;

The sending module 25 is configured to return a second database script to the upgrade control device, where the first database script is a script sent by the upgrade control device for the database upgrade when the database needs to be upgraded according to the returned second database script.

The device also includes:

The processing module 26 is configured to process the data access request received by the database device by using the first database script after the switching module 23 switches the database script from the second database script to the first database script.

The processing module 26 is further configured to process the data access request received by the database device using the second database script before the switching module 23 switches the database script from the second database script to the first database script.

The device also includes:

Receiving a fallback request module 27, configured to receive a fallback request sent by the upgrade control device after the upgrade is successful, where the rollback request is a request sent by the upgrade control device when the partial database upgrade fails; the fallback module 28 is configured to use the database The script switches from the first database script to the second database script and deletes the newly created data object. No connection is required between multiple upgrade processing devices on a distributed database.

The upgrade processing device of this embodiment saves both the pre-upgrade and post-upgrade database scripts, and does not switch the database script during the process of upgrading the database after creating the upgraded new data object, so that the upgrade process can still be performed during the upgrade process. Use the database script before the upgrade to process the data access request, so that the service is not interrupted during the upgrade process, and the data access quality is guaranteed. In this embodiment, after the upgrade is successful, the database script before the upgrade is not deleted, so that when the rollback request is received, the workload of the rollback can be reduced, the rollback efficiency is improved, and the rollback does not generate an error, thereby avoiding the quality of the data access service. decline.

The embodiment of the present invention further provides an upgrade control apparatus, which is used for upgrading a distributed database. The distributed database includes at least two database devices, and an upgrade processing device is deployed on each database device, as shown in FIG. Examples include:

The sending module 30 is configured to send a database script query request to the upgrade processing device. The control module 31 is configured to determine, according to the second database script returned by the upgrade processing device, that the database of the database device needs to be upgraded, and the control sending module 31 sends the upgrade to the upgrade processing device. The first database script for database upgrades.

Wherein, the device further comprises:

The receiving module 32 is configured to receive a storage result returned by the upgrade processing device.

The sending module 30 is further configured to send an upgrade request to the upgrade processing device that successfully stores according to the storage result received by the receiving module 32.

The receiving module 32 is further configured to receive the upgrade result returned by the upgrade processing device. The sending module 30 is further configured to send a fallback request to the upgraded upgrade processing device when the partial database upgrade fails according to the upgrade result received by the receiving module 32. .

The upgrade control device of this embodiment may be deployed in the same number as one upgrade processing device. According to the library device, it can also be deployed on a single computer device. The upgrade control device and the upgrade processing device are connected by a network including a local area network and a wide area network.

The upgrade control device of the embodiment can centrally control the upgrade or rollback progress of multiple database devices in the distributed database, thereby implementing centralized upgrade of the distributed database, and avoiding inconsistent database versions between different database devices of the distributed database. The problem of inconsistent data leading to business/application access.

In practical applications, the relationship between the upgrade control device and the upgrade processing device is shown in Figure 4. The method for upgrading the distributed database in the embodiment of the present invention is further described below with reference to FIG. 5. As shown in FIG. 5, the embodiment includes:

Step 501: The upgrade control device sends a database version query request to the upgrade processing device. The upgrade control device sends a database version query request to the upgrade processing device (only one upgrade processing device is shown in FIG. 5), and requests the database version information to be queried. ;

Step 502: The upgrade processing device returns database version information to the upgrade control device. The upgrade processing device queries database version information of the database device, and returns version information of the database device to the upgrade control device.

Step 503: The upgrade control device confirms the database device that needs to be upgraded;

The upgrade control device confirms the database device to be upgraded according to the database version information returned by the upgrade processing device; for example, the upgrade control device needs to upgrade all the database devices to use the new database script, first query the database script currently used by the database device, if some are received The database version information returned by the upgrade processing device on the database device is the old database script used by the database device, then it is confirmed that these database devices need to be upgraded; if some database devices use the old database script, but do not need to upgrade, It does not affect other database devices that need to be upgraded, so you can not upgrade these databases.

Step 504: The upgrade control device sends a new database script to the upgrade processing device; and the upgrade control device loads the upgrade process on one or more database devices that need to be upgraded. Sending a new database script; if the bandwidth between the upgrade control device and the upgrade processing device is limited, the upgrade control device may compress the new database script and then send it to the upgrade processing device; Step 505: The upgrade processing device receives and saves the new database script ;

The upgrade processing device on the database device receives and saves the new database script to the local storage medium, and the upgrade processing device also stores the old database script;

Step 506: The upgrade processing device returns a storage result to the upgrade control device.

The upgrade processing device on the database device returns a new database script storage result to the upgrade control device;

Step 507: The upgrade control device sends an upgrade request to the upgrade processing device that is successfully stored. The upgrade control device sends an upgrade request to the upgrade processing device that successfully receives and stores the new database script according to the received storage result. For the upgrade processing device that fails to save the new database script or does not return the storage result within the first preset time, the upgrade control device may use the retransmission mechanism to resend the new database to the upgrade processing device after the second preset time. Step 508: The upgrade processing device creates a new data object according to the new database script; the upgrade processing device compares whether the upgraded new database script and the old database script before the upgrade are compatible, and analyzes the new data object added by the new database script. At the same time, the old database script is used to process the data access request from the service/application, and the request for the service/application access to the database can be processed normally.

After analyzing the new database script successfully and judging the compatibility of the old and new database scripts, the upgrade processing device creates a new data object, upgrades the database of the database device in which it is located, and uses the old database script to process the service/application from the same time while creating the new data object. Data access request; Step 509: The upgrade processing device switches the database script;

After the upgrade is successful, the upgrade processing device processes the data access request from the business/application using the new database script;

Step 510: The upgrade processing device returns an upgrade result to the upgrade control device. In step 508, if the upgrade processing device fails to analyze the new database or the new and old database scripts are incompatible, or the upgrade processing device fails to create a new data object, the upgrade processing device returns an upgrade result of the upgrade failure to the upgrade control device, otherwise returns Upgrade successful upgrade results.

If some database device upgrade fails during the upgrade process, that is, after the upgrade control device sends the upgrade request to the upgrade processing device, the upgrade result returned by the partial upgrade processing device is not received or the partial upgrade process is received within the third preset time. If the device returns an upgrade result that fails to be upgraded, you need to perform the following steps:

Step 511: The upgrade control device sends a fallback request to the upgraded upgrade processing device; after the partial database upgrade fails, the upgrade control device returns a request to the upgraded database device;

Step 512: The upgrade processing device switches the database script and deletes the newly created data object. After receiving the fallback request, the upgrade processing device switches the data access request of the processing service/application to the old database script before the upgrade, and automatically deletes the upgraded file. New data object created;

Step 513: The upgrade processing device returns a rollback result to the upgrade control device.

The upgrade control device may query the upgrade processing device for the version information of the database device before and after the upgrade or the upgrade process, and the upgrade processing device queries the database version information and returns the information to the upgrade control device.

The distributed database upgrade method in this embodiment can implement centralized upgrade of databases on multiple database devices of a distributed database, thereby avoiding the problem of inconsistent data of multiple database devices. And during the upgrade process, the upgrade processing device saves at least two database scripts before and after the upgrade, and the upgrade processing device does not switch the database script during the process of creating the upgraded new data object, so that the upgrade process can still be used before the upgrade process. The database script processes the data access request, so that the service is not interrupted during the upgrade process, and the data access quality is guaranteed. The method embodiment is corresponding to the device embodiment, and the portion not described in detail in the method embodiment may refer to the description of the relevant part in the device embodiment, and the partial reference method not described in detail in the device embodiment. The description of the relevant parts in the embodiment can be.

It will be understood by those skilled in the art that all or part of the steps of the foregoing embodiments may be implemented by a program to instruct related hardware, and the program may be stored in a computer readable storage medium. When executed, the method includes the steps of the foregoing method embodiment, such as: a magnetic disk, an optical disk, a read-only memory (ROM), or a random access memory (RAM). Wait.

In the method embodiments of the present invention, the sequence numbers of the steps are not used to limit the sequence of the steps. For those skilled in the art, the steps of the steps are changed without any creative work. It is also within the scope of the invention.

The above is a preferred embodiment of the present invention, and it should be noted that those skilled in the art can also make several improvements and retouchings without departing from the principles of the present invention. It should be considered as the scope of protection of the present invention.

Claims

Claim

A method for upgrading a distributed database, wherein the distributed database includes at least two database devices, and each database device is provided with an upgrade processing device, and the method includes:

The method according to claim 1, wherein before the upgrading processing device receives and stores the first database script sent by the upgrade control device, the method further includes:

The method according to claim 1, wherein after the upgrading processing device switches the database script from the second database script to the first database script, the method further includes:

The method according to any one of claims 1 to 3, wherein after the upgrading processing device switches the database script from the second database script to the first database script, the method further includes:

The method according to claim 4, wherein, after the upgrade processing device returns an upgrade result to the upgrade control device, the method further includes: The upgrade processing device corresponding to the upgraded database receives the fallback request sent by the upgrade control device;

The upgrade processing device switches the currently used database script from the first database script to the second database script according to the received fallback request, and deletes the newly created data object.

An upgrade processing device, which is deployed on a database device of a distributed database, the device comprising:

The device according to claim 6, wherein the device further comprises: a query module, configured to receive a database script query request, and query the database script currently used by the database device according to the query module;

The device according to claim 6, wherein the device further comprises: a processing module, configured to: after the switching module switches the database script from the second database script to the first database script, The first database script processes the data access request.

9. Apparatus according to any one of claims 6 to 8, wherein the apparatus further comprises:

a fallback module, configured to cut a currently used database script from the first database script Switching to the second database script and deleting the newly created data object.

An upgrade control device, characterized in that it is used for an upgrade of a distributed database, the distributed database includes at least two database devices, and an upgrade processing device is deployed on the database device, and the upgrade control device includes:

a sending module, configured to send a database script query request to the upgrade processing device, and a control module, configured to determine, according to the second database script returned by the upgrade processing device, that the database of the database device needs to be upgraded, and control the sending The module sends a first database script for the database upgrade to the upgrade processing device.

The device according to claim 10, further comprising: a receiving module, configured to receive a storage result returned by the upgrade processing device;

12. Apparatus according to claim 11 wherein: