CN111427889A - Method and device for upgrading database table and server - Google Patents

Abstract

The present invention provides a method, device and server for database table upgrading, and relates to the field of computer technology. The method is applied to server clusters. Each server in the server cluster corresponds to a database, and the servers in the server cluster are divided into multiple batches. The method includes: determining a new version database table for the new version software, and the new version database table has a data clearing attribute; after all batches have determined the new version database table, sequentially performing the steps for each batch in the multiple batches After the new version database table of all batches has written data, replace the old version database table in use in each batch of multiple batches with the new version database table in turn . The invention can effectively improve the data connection between the old and new database tables in the software upgrade process, and ensure the normal operation or operation of the online program in the upgrade process.

Description

Method, device and server for database table upgrade

technical field

The present invention relates to the field of computer technology, and in particular, to a method, a device and a server for upgrading a database table.

Background technique

The database plays a very important role in the device, and stores key information such as the current configuration of the device. Whether it is correct or not directly affects whether the device runs normally. During the operation of the network device, the software version may need to be changed due to the addition of new functions or the repair of problems. In order to be able to adapt to the new version of the software, it is usually necessary to upgrade the database tables. When the database tables are upgraded, if the database tables are not compatible and the data connection between the old and new versions of the database tables is not good, the user configuration will be disordered, and the reconfiguration will be very cumbersome. , waste time and energy, if all servers are stopped for upgrade, it will cause the online program to fail to run or run normally.

SUMMARY OF THE INVENTION

The purpose of the present invention is to provide a database table upgrade method, device and server, which can effectively improve the data connection between new and old databases and ensure the normal operation or operation of online programs during the upgrade process.

In a first aspect, the embodiment provides a database upgrade method, the method is applied to a server cluster, each server in the server cluster corresponds to a database, and the servers in the server cluster are divided into multiple batches; the method includes: determining the software for the new version. The new version of the database table; the new version of the database table has the property of data clearing; when all batches of servers have determined the new version of the database table, write data to the new version of the database table of each batch in multiple batches in turn ; After all batches of new version database tables have written data, replace the old version database tables in use in each batch in multiple batches with the new version database tables in turn.

In an optional implementation manner, after all batches of servers have determined the new version database table, the step of sequentially writing data to the new version database table of each batch in the multiple batches includes: when all batches of After the batches of servers have determined the new version of the database table, while the old version of the database table reads and writes data, it sequentially writes data to the new version of the database table in each batch in multiple batches; The table is the database table used before the upgrade.

In an optional embodiment, after data is written to the database tables of the new version of all batches, the database tables of the old version in use in each batch of the multiple batches are sequentially replaced with the database tables of the new version. The steps include: after all batches of new version database tables have written data, sequentially reading and writing data to new version database tables of each batch in multiple batches; in all batches of new version database tables After the tables have read and written data, replace the old version database table with the new version database table.

In an optional embodiment, after all batches of new version database tables have read and written data, the step of replacing old version database tables with new version database tables includes: in all batches of new version database tables After the data has been read and written, the data clearing operation is performed on the old version database tables of each batch in multiple batches in turn; when the data clearing operation is performed on the old version database tables of all batches, Tables are replaced with new version database tables.

In an optional embodiment, after replacing the database table of the old version in use in each batch of the multiple batches with the database table of the new version, the method further includes: deleting the database table of the old version.

In an optional implementation manner, the database table of the new version is a database table with a different table name and table structure from the database table of the old version.

In a second aspect, the embodiment provides a database upgrade device, the device is applied to a server cluster, each server in the server cluster corresponds to a database, and the servers in the server cluster are divided into multiple batches; the device includes: a new database table determination module , used to determine the new version of the database table for the new version of the software; the new version of the database table has the attribute of data clearing; the write data module is used for the multiple batches after the server of all batches has determined the new version of the database table. Write data to the database tables of the new version of each batch of Replace the old version database table with the new version database table.

In an optional implementation manner, the data writing module is configured to, after the servers of all batches have determined the database table of the new version, read and write data to the database table of the old version while reading and writing data to each of the multiple batches in turn. The new version database table of the batch is used for writing data; the old version database table is the database table used before the upgrade.

In a third aspect, an embodiment provides a server, including a memory and a processor; the memory stores a computer program, and the computer program executes the method according to any one of the foregoing embodiments when executed by the processor .

In a fourth aspect, the embodiments provide a computer-readable storage medium for storing computer software instructions used in the method according to any one of the foregoing embodiments.

The method, device and server for database table upgrading provided by the present invention are applied to a server cluster. Each server in the server cluster corresponds to a database, and the servers in the server cluster are divided into multiple batches. The new version database table of the new version software, the new version database table has the attribute of data clearing, after all batches of servers have determined the new version database table, the new version database of each batch in multiple batches is sequentially analyzed. After the data is written to the new version database table of all batches, the old version database table in use in each batch of multiple batches is sequentially replaced with the new version database table. The above method upgrades the database tables in batches, which can ensure that the database tables are updated backward compatible in the software upgrade process under the condition that the old version of the software is in normal use, and the data connection between the old and new versions of the software caused by the direct conversion of the database is avoided. It can effectively improve the data connection between the old and new database tables during the software upgrade process, and ensure the normal operation or operation of the online program during the upgrade process.

Description of drawings

In order to illustrate the specific embodiments of the present invention or the technical solutions in the prior art more clearly, the following briefly introduces the accompanying drawings that need to be used in the description of the specific embodiments or the prior art. Obviously, the accompanying drawings in the following description The drawings are some embodiments of the present invention. For those of ordinary skill in the art, other drawings can also be obtained based on these drawings without creative efforts.

1 is a schematic flowchart of a method for upgrading a database table according to an embodiment of the present invention;

2 is a schematic flowchart of another method for upgrading a database table provided by an embodiment of the present invention;

FIG. 3 is a schematic structural diagram of an apparatus for upgrading a database table according to an embodiment of the present invention;

FIG. 4 is a schematic structural diagram of a server according to an embodiment of the present invention.

Detailed ways

In order to make the purposes, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments These are some embodiments of the present invention, but not all embodiments. The components of the embodiments of the invention generally described and illustrated in the drawings herein may be arranged and designed in a variety of different configurations.

Thus, the following detailed description of the embodiments of the invention provided in the accompanying drawings is not intended to limit the scope of the invention as claimed, but is merely representative of selected embodiments of the invention. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative efforts shall fall within the protection scope of the present invention.

It should be noted that like numerals and letters refer to like items in the following figures, so once an item is defined in one figure, it does not require further definition and explanation in subsequent figures.

Some embodiments of the present invention will be described in detail below with reference to the accompanying drawings. The embodiments described below and features in the embodiments may be combined with each other without conflict.

Considering that when the database is upgraded, if the connection between the old and new database data is poor, the database will be incompatible, which will lead to disordered user configuration. It will be cumbersome to redo the configuration and waste time and energy, and if all servers are stopped to upgrade, It will affect the normal operation and operation of the online program. In response to this problem, the embodiments of the present invention provide a database table upgrade method, device and server, which can effectively improve the data connection between new and old databases and ensure the normal operation and operation of online programs during the upgrade process.

Example 1

For ease of understanding, a method for upgrading a database table provided by an embodiment of the present invention is first introduced in detail. Referring to the schematic flowchart of a method for upgrading a database table shown in FIG. 1 , the method is applied to a server cluster. Each server corresponds to a database, and the method mainly includes the following steps S102 to S106:

Step S102: Determine a new version database table for the new version software; the new version database table has the attribute of data clearing.

In one embodiment, the server cluster can communicate with the controller, and the controller controls the servers in the server cluster. Due to the difference in information obtained by the read and write operations of the old and new versions of the software online, the logical processing is also different. In order to ensure that the old and new versions of the software can run normally during the software upgrade process, that is, the old and new versions of the software must exchange data at any time. In this embodiment, the servers in the server cluster are divided into multiple batches, and an upgrade operation is performed on the servers of each batch in sequence. Since it is stipulated that when the services of the old and new versions of the software share data, the last one to leave the shared task deletes the content in the database table, so it is necessary to ensure that the database table of the new version has the data clearing attribute.

First determine a new version database table for the new version software, the new version database table is a database table with a different table name and table structure from the old version database table, and is used for data exchange for users of the new version software. In one embodiment, the old and new database tables may include both intersection and complement, that is, the new and old database tables may have some of the same fields. In another implementation manner, there may be no complements between the old and new database tables, that is, the fields of the old and new database tables are all different. In practical applications, it can be implemented according to specific conditions, and is not specifically limited here.

Step S104: After the servers of all batches have determined the new version database table, write data to the new version database table of each batch in the multiple batches in turn.

In one embodiment, after all batches of servers have determined the new version of the database table, the software still uses the old version of the data table to read and write data at this time, but the new version of the database table also starts to compare the data in batches. The new version of the database table for writing data. Since the number of servers in a server cluster is usually relatively large, in this embodiment, the running data is written to each new version database table corresponding to each batch of servers in turn, and all the new version database tables of the current batch are written in the current batch. After running the data, write the running data to the next batch of database tables of the new version until all the database tables of the new version are written with the running data.

It is understandable that, at this time, the new version database tables of all batches of data writing still have the attribute of data clearing. Therefore, when a user shares data, in order to avoid the existence of junk data after the end of sharing, the data is deleted from the database table of the new version that exits last. For ease of understanding, taking chat software as an example, when multiple people chat ends and exit the chat room, the database table corresponding to the chat software of the last user who exits the room will perform data clearing, so as to ensure that after the chat ends, the chat room will be cleared. There is no remnant of junk data in the memory.

Step S106: After all batches of new version database tables have written data, sequentially replace the old version database tables in use in each of the multiple batches with the new version database tables.

In one embodiment, after all batches of new version database tables have been written data, the software reads and writes data based on the old version database tables. In order to ensure that the data in the upgrade process is backward compatible, Read and write data to the new version database table of each batch in the multiple batches in turn, thereby sequentially replacing the old version database table in use with the new version database table. The old version of the database in use refers to the read and write operations using the old version of the database. Replacing the old version of the database with the new version of the database in turn refers to the replacement in batches. The replacement refers to replacing the old version of the database table with Use the new version of the database table, that is, read and write data using the new version of the database table. Replace the old version database for read and write operations with the new version database for read and write operations until all batches of databases are replaced and the database upgrade is complete.

In addition, because there is a process of interaction between old and new versions of software in practical applications, that is, during data exchange, the software versions used by users are not all the latest versions. Therefore, after the above read and write operations use the new version of the database, the old version The database also needs to perform data writing operations, thereby ensuring that users of different software versions can interact.

In the database upgrade method provided by the present invention, the new version database table for the new version software is determined, and the new version database table has the attribute of data clearing. Write data to the new version database table of each batch in the batch, after all batches of the new version database table have written data, sequentially use the old version database for each batch in multiple batches. Tables are replaced with new version database tables. The above method upgrades the database tables in batches, which can ensure that the database tables are updated backward compatible in the software upgrade process under the condition that the old version of the software is in normal use, and the data connection between the old and new versions of the software caused by the direct conversion of the database is avoided. It can effectively improve the data connection between the old and new database tables during the software upgrade process, so as not to affect the normal operation or operation of the online program. Therefore, the embodiments of the present invention effectively improve the data connection between the old and new database tables in the software upgrade process, and ensure the normal operation or operation of the online program in the upgrade process.

Example 2

The embodiment of the present invention provides a specific example of a method for upgrading database tables. When upgrading in practical applications, it is usually necessary to upgrade database tables of software versions corresponding to many servers. For ease of understanding, in this embodiment, three The server, the database with each server corresponding to a software version, and the software version of each batch of updating a database are taken as examples for detailed description. Refer to the schematic flowchart of another method for database table upgrade as shown in FIG. 2 . Arrows are read and write operations, unidirectional arrows are write operations, and dashed arrows are data clearing operations. The database table of the old version is table A (that is, TA in the figure), and the database table of the new version is table B (that is, TB in the figure). The first version is the software of the first version, which is the version before the upgrade. Version, Version 2, Version 3, Version 4, Version 5 are new versions of software corresponding to each round of upgrade operations.

The database table used by the software of the initial version (version 1) is the database table TA of the old version, and the read and write operations of the software of the initial version are all on the TA. Since TA cannot meet the requirements of the upgraded version of the software, it is necessary to determine the new version database table TB for the new version of the software. TB is a database table with a different table name and table structure from TA.

The first round of upgrade process shown in Figure 2, when two software versions have been upgraded to the second version, the second version software and the first version software still use TA when reading and writing data, but for the second version software The new version of database table TB already has the property of clear data. When the first round of upgrades is completed, all software versions are version 2 software, and the data operation status of version 2 software for database tables is to use A to delete B, using A means that all data reads and writes are still in On the old database table TA, deleting B means that the new table TB has the property of clearing data, so that when the old and new versions of the service share data in the same data sharing environment, the last database table TB that ends the data sharing process will save the data. Clear the data to avoid the problem of residual junk data caused by the inability to clear the data.

When each batch of servers has completed the first round of upgrade operations, the second round of upgrades is performed. At this time, the old database table TA is still the one that reads and writes data, but the new database table TB can start to perform write operations in batches. . As shown in the figure, at this time, the third version-1 and the third version-2 have performed the data write operation for TB, and at the same time, for the new database table TB, they still have the above-mentioned data cleaning function. After all batches are written, the second round of upgrade process ends. At this time, all software versions are version 3. All software versions of version 3 use TA to read and write data and write data through TB. . In this way, it can be ensured that users using the old and new versions of the software have data in the new data table TB when performing session control (sension).

After all batches of new database tables TB have completed writing data operations, perform the third round of upgrade. At this time, the new version software (version 4 software) uses the new database table TB to read and write data, as shown in the figure for version 4-1 and version 4-2, at this time, version 4-1 and version 4 Version-2 only performs data write operations for TA, that is, writes A with B. When the third round of upgrade operation is completed, all software versions at this time are the fourth version, and each version 4 software uses TB to read and write data. Version 4 software also needs to perform a write operation on the old database table TA, so that data exchange can be guaranteed at any upgrade stage.

When all software versions use TB to read and write data, enter the fourth round of upgrade process. At this time, version 4 and version 5 also use TB to read and write data, but for version 5 software, delete TA. When all software versions delete TA, the fourth round of upgrade ends. The database table used at this time is the new database table TB, that is, data is read and written through the new data table TB. For the 5th version in use, the delete A operation can be performed, that is, the old database table can be deleted, and the method of batch deletion can also be used. Finally, using the new database table TB, the upgrade of the database table is completed.

The method for upgrading database tables provided in this embodiment, by performing each round of upgrading operations in batches, can ensure that the database tables are updated in a downward compatible manner during the software upgrade process under the condition that the old version of the software is in normal use, thereby effectively improving the The data connection between the old and new database tables during the software upgrade process ensures the normal operation or operation of the online program during the upgrade process.

Example 3

For the database upgrade method corresponding to the above-mentioned Embodiment 1, the embodiment of the present invention further provides a database upgrade apparatus. Referring to the schematic structural diagram of a database table upgrade apparatus shown in FIG. 3 , the apparatus is applied to a server cluster. Each server in the cluster has a corresponding database, and the servers in the server cluster are divided into multiple batches. The device includes the following parts:

A new database table determination module 302, configured to determine a new version database table for the new version software; the new version database table has a data clearing attribute;

The data writing module 304 is used for sequentially writing data to the new version database table of each batch in the multiple batches after the servers of all batches have determined the new version database table;

The upgrading module 306 is configured to sequentially replace the database tables of the old version in use in each batch of the multiple batches with the database tables of the new version after data has been written to the database tables of the new version of all batches.

In the database upgrade device provided by the present invention, the above-mentioned device upgrades the database in batches, which can ensure the establishment of a new version of the database when the old version of the software is in normal use, and avoids the direct conversion of the database. In this way, the data connection between the old and new databases is effectively improved, and the stability of the database upgrade is further improved. Therefore, the embodiment of the present invention can effectively improve the data connection between the old and new databases, and ensure the normal operation or running of the online program during the upgrade process.

In one embodiment, the above-mentioned data writing module 304 is further configured to, when all batches of servers have determined the new version of the database table, read and write data in the old version of the database table in turn, sequentially write the data in the multiple batches. Data is written to the database table of the new version of each batch; the database table of the old version is the database table used before the upgrade.

In one embodiment, the above-mentioned upgrade module 306 is further configured to sequentially read the new version database tables of each batch of the multiple batches after data has been written to the new version database tables of all batches Write data; after all batches of new version database tables have read and written data, replace the old version database tables with the new version database tables.

In one embodiment, the above-mentioned upgrade module 306 is further configured to execute the operation on the old version database tables of each batch of multiple batches in turn after all batches of new version database tables have read and written data. Data purging operation; after all batches of old version database tables have performed data purging operations, replace old version database tables with new version database tables.

In one embodiment, after replacing the database of the old version in use in each batch of the multiple batches with the database of the new version, the above-mentioned apparatus further includes: a deletion module, configured to delete the database table of the old version.

The implementation principle and technical effects of the device provided by the embodiment of the present invention are the same as those of the foregoing method embodiment. For brief description, for the parts not mentioned in the device embodiment, reference may be made to the corresponding content in the foregoing method embodiment.

Example 4

An embodiment of the present invention also provides a server, specifically, the server includes a processor and a storage device; a computer program is stored on the storage device, and the computer program executes any one of the foregoing embodiments when run by the processor method described in item.

4 is a schematic structural diagram of a server according to an embodiment of the present invention. The server 100 includes: a processor 40 , a memory 41 , a bus 42 and a communication interface 43 , and the processor 40 , the communication interface 43 and the memory 41 pass through the bus 42 Connection; processor 40 is used to execute executable modules, such as computer programs, stored in memory 41 .

The memory 41 may include a high-speed random access memory (RAM, Random Access Memory), and may also include a non-volatile memory (non-volatile memory), such as at least one disk memory. The communication connection between the network element of the system and at least one other network element is realized through at least one communication interface 43 (which may be wired or wireless), which may use the Internet, a wide area network, a local network, a metropolitan area network, and the like.

The bus 42 may be an ISA bus, a PCI bus, an EISA bus, or the like. The bus can be divided into an address bus, a data bus, a control bus, and the like. For ease of presentation, only one bidirectional arrow is used in FIG. 4, but it does not mean that there is only one bus or one type of bus.

The memory 41 is used to store a program, and the processor 40 executes the program after receiving the execution instruction. The method executed by the device defined by the stream process disclosed in any of the foregoing embodiments of the present invention can be applied to processing in the processor 40 , or implemented by the processor 40 .

The processor 40 may be an integrated circuit chip with signal processing capability. In the implementation process, each step of the above-mentioned method can be completed by a hardware integrated logic circuit in the processor 40 or an instruction in the form of software. The above-mentioned processor 40 may be a general-purpose processor, including a central processing unit (Central Processing Unit, CPU for short), a network processor (Network Processor, NP for short), etc.; it may also be a digital signal processor (Digital Signal Processing, DSP for short) , Application Specific Integrated Circuit (ASIC for short), Field-Programmable Gate Array (FPGA for short) or other programmable logic devices, discrete gate or transistor logic devices, and discrete hardware components. Various methods, steps, and logical block diagrams disclosed in the embodiments of the present invention can be implemented or executed. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like. The steps of the method disclosed in conjunction with the embodiments of the present invention may be directly embodied as executed by a hardware decoding processor, or executed by a combination of hardware and software modules in the decoding processor. The software modules may be located in random access memory, flash memory, read-only memory, programmable read-only memory or electrically erasable programmable memory, registers and other storage media mature in the art. The storage medium is located in the memory 41, and the processor 40 reads the information in the memory 41, and completes the steps of the above method in combination with its hardware.

The method, the device, and the computer program product of the server for updating the database table provided by the embodiments of the present invention include a computer-readable storage medium storing non-volatile program codes executable by the processor, and the computer-readable storage medium is stored with a computer-readable storage medium. A computer program, when the computer program is run by a processor, executes the methods described in the foregoing method embodiments, and the specific implementation can refer to the method embodiments, which will not be repeated here.

Those skilled in the art can clearly understand that, for the convenience and brevity of description, for the specific working process of the system described above, reference may be made to the corresponding process in the foregoing embodiments, and details are not repeated here.

The computer program product of the readable storage medium provided by the embodiments of the present invention includes a computer-readable storage medium storing program codes, and the instructions included in the program codes can be used to execute the methods described in the foregoing method embodiments. Reference may be made to the method embodiment, and details are not described herein again.

The functions, if implemented in the form of software functional units and sold or used as independent products, may be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present invention can be embodied in the form of a software product in essence, or the part that contributes to the prior art or the part of the technical solution. The computer software product is stored in a storage medium, including Several instructions are used to cause a computer device (which may be a personal computer, a server, or a network device, etc.) to execute all or part of the steps of the methods described in the various embodiments of the present invention. The aforementioned storage medium includes: U disk, mobile hard disk, Read-Only Memory (ROM, Read-Only Memory), Random Access Memory (RAM, Random Access Memory), magnetic disk or optical disk and other media that can store program codes .

Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, but not to limit them; although the present invention has been described in detail with reference to the foregoing embodiments, those of ordinary skill in the art should understand that: The technical solutions described in the foregoing embodiments can still be modified, or some or all of the technical features thereof can be equivalently replaced; and these modifications or replacements do not make the essence of the corresponding technical solutions deviate from the technical solutions of the embodiments of the present invention. scope.

Claims (10)

1. A method for database table upgrade, wherein the method is applied to a server cluster, each server in the server cluster corresponds to the database, and the servers in the server cluster are divided into multiple batches ; the method includes: Determine a new version database table for the new version software; the new version database table has a data clearing attribute; After all the batches of servers have determined the new version database table, sequentially write data to the new version database table of each batch in the multiple batches; After data is written to the database tables of the new version in all batches, the database tables of the old version in use in each of the multiple batches are sequentially replaced with the database tables of the new version. 2 . The method according to claim 1 , wherein, after the servers of all batches have determined the database table of the new version, the new version of the database table of each batch in the plurality of batches is sequentially updated. 3 . The steps for writing data to the version database table include: After all the batches of servers have determined the new version database table, while the old version database table reads and writes data, the new version database table of each batch in the multiple batches is sequentially performed. Write data; wherein, the old version database table is the database table used before the upgrade. 3. The method according to claim 1, characterized in that, after the new version database tables of all batches have written data, the old version in use in each batch of the plurality of batches is sequentially used. The steps of replacing the database table with the new version database table include: After all batches of the new version database tables have written data, sequentially read and write data to the new version database tables of each batch in the multiple batches; After all batches of the new version database tables have read and written data, the old version database tables are replaced with the new version database tables. 4. The method according to claim 3, characterized in that, after the new version database table of all batches has read and written data, the old version database table is replaced with the new version database Table of steps, including: After all batches of the new version database tables have read and written data, perform a data clearing operation on the old version database tables of each batch in the multiple batches in turn; After all batches of the old version database tables have performed the data clearing operation, the old version database tables are replaced with the new version database tables. 5. The method according to claim 1, wherein after replacing the database table of the old version in use in each batch of the plurality of batches with the database table of the new version, the method further comprises: Delete the old version database table. 6 . The method according to claim 1 , wherein the database table of the new version is a database table with a table name and table structure different from the database table of the old version. 7 . 7. An apparatus for upgrading database tables, wherein the apparatus is applied to a server cluster, each server in the server cluster corresponds to the database, and the servers in the server cluster are divided into multiple batches ; the device includes: a new database table determination module for determining a new version database table for the new version software; the new version database table has a data clearing attribute; a data writing module, configured to sequentially write data to the new version database table of each batch in multiple batches after all the batches of servers have determined the new version database table; The upgrade module is configured to sequentially replace the database table of the old version in use in each batch of the multiple batches with the database table of the new version after data has been written to the database table of the new version of all batches. 8. The device according to claim 7, wherein the data writing module is used to read and write data in the old version database table after all batches of servers have determined the new version database table At the same time, data is sequentially written to the database table of the new version of each batch in the multiple batches; wherein the database table of the old version is the database table used before the upgrade. 9. A server, comprising a memory and a processor; A computer program is stored on the memory which, when executed by the processor, performs the method of any one of claims 1 to 6. 10. A computer-readable storage medium, characterized in that it is used for storing computer software instructions used in the method according to any one of claims 1 to 6.

Images