CN116302688A - Database processing method, device, electronic device and storage medium - Google Patents

Abstract

The invention provides a database processing method, a device, electronic equipment and a storage medium, which are applied to a server, wherein the server comprises a database to be processed, and the method comprises the following steps: acquiring a database to be processed; creating a file backup script corresponding to the database to be processed under the condition that the system service of the server is running, and carrying out backup operation on the database to be processed based on the file backup script to obtain a backup file; and under the condition that the data of the database to be processed is lost, creating a database recovery script corresponding to the backup file based on the backup file, and constructing a recovery database corresponding to the database to be processed based on the database recovery script and the backup file, so that the server is recovered to obtain the recovery database under the condition that the system service is operated. On the premise of not suspending the operation of the server, the database can be backed up and restored, so that the experience and satisfaction of the user in the use process can be improved.

Description

Database processing method, device, electronic device and storage medium

technical field

The present invention relates to the technical field of data processing, in particular to a database processing method, device, electronic equipment and storage medium.

Background technique

With the popularization and development of computer technology, all walks of life have greatly improved production efficiency with the help of computers. Among them, the database plays a pillar role in data storage.

It is known in the related art that during the process of backing up and restoring the database, it is often necessary to suspend the operation of the server, which will affect the experience of the user during use. Currently, finding a way to back up and restore the database without suspending the operation of the server has become a research hotspot.

Contents of the invention

The invention provides a database processing method, device, electronic equipment and storage medium, which realize backup and recovery operations on the database without suspending the operation of the server.

The present invention provides a database processing method, which is applied to a server. The server includes a database to be processed, and the database processing method includes: obtaining the database to be processed; when the system service of the server is running, creating and The file backup script corresponding to the database to be processed, and perform a backup operation on the database to be processed based on the file backup script to obtain a backup file; in the case of data loss in the database to be processed, based on the backup file , creating a database recovery script corresponding to the backup file, and constructing a recovery database corresponding to the database to be processed based on the database recovery script and the backup file, so that the server is running when the system service is running In case of recovery get the recovery database.

According to a database processing method provided by the present invention, performing a backup operation on the database to be processed based on the file backup script to obtain a backup file specifically includes: determining the database to be processed based on the file backup script A corresponding backup command; based on the backup command, perform a backup operation on the database to be processed to obtain a backup file.

According to a database processing method provided by the present invention, performing a backup operation on the database to be processed based on the backup command to obtain a backup file specifically includes: performing backup on the database to be processed based on the backup command operation to obtain backup files at different backup times; and use the backup files whose backup time is the latest backup time as the backup files for constructing the recovery database.

According to a database processing method provided by the present invention, after the backup operation is performed on the database to be processed based on the backup command to obtain the backup file, the method further includes: based on the file backup script, determining and A compression command corresponding to the backup file; based on the compression command, compress the backup file to obtain a compressed backup file; create a database recovery script corresponding to the backup file based on the backup file Before, the method further includes: decompressing the compressed backup file to obtain the backup file.

According to a database processing method provided by the present invention, the constructing a recovery database corresponding to the database to be processed based on the database recovery script and the backup file specifically includes: based on the database recovery script, determining the first command, wherein the first command is a command to close the user's access authority to the database to be processed; if the user's access authority to the database to be processed is successfully closed based on the first command, based on the The database recovery script is used to determine a second command, wherein the second command is a command for performing a rename operation on the database to be processed; in the case of successfully performing a rename operation on the database to be processed based on the second command, Based on the database recovery script, determine a third command, wherein the third command is a command to create a blank database, and the blank database is used to undertake the backup file; when the blank is successfully created based on the third command In the case of a database, a fourth command is determined based on the database recovery script, wherein the fourth command is a command for importing the backup file into the blank database; When the backup file is imported into the blank database, the blank database containing the backup file is obtained, and the blank database containing the backup file is used as the restoration database.

According to a database processing method provided by the present invention, after the blank database containing the backup file is obtained, the method further includes: determining a fifth command based on the database recovery script, wherein the first The fifth command is a command to delete the database to be processed and/or the backup file; based on the fifth command, delete the database to be processed and/or the backup file.

According to a database processing method provided by the present invention, after the second command is determined based on the database recovery script, the method further includes: renaming the database to be processed based on the second command unsuccessfully In the case of an operation, re-enable the user's access right to the database to be processed, and stop the operation of determining the third command.

According to a database processing method provided by the present invention, after the third command is determined based on the database recovery script, the method further includes: if the blank database is not successfully created based on the third command , changing the name of the database to be processed to the original name, re-enabling the user’s access right to the database to be processed, and stopping the operation of determining the fourth command.

According to a database processing method provided by the present invention, after the fourth command is determined based on the database recovery script, the method further includes: after unsuccessfully importing the backup file to the In the case of the blank database, change the name of the database to be processed to the original name, re-enable the user’s access authority to the database to be processed, and delete the blank database.

According to a database processing method provided by the present invention, the database to be processed is a cluster mode database.

According to a database processing method provided by the present invention, the system service of the server is provided by a single application, or provided by a microservice.

The present invention also provides a database processing device, which is applied to a server, the server includes a database to be processed, and the database processing device includes: a first module, used to acquire the database to be processed; a second module, used to When the system service of the server is running, create a file backup script corresponding to the database to be processed, and perform a backup operation on the database to be processed based on the file backup script to obtain a backup file; the third module uses In the case of data loss in the database to be processed, based on the backup file, create a database recovery script corresponding to the backup file, and based on the database recovery script and the backup file, construct a Processing the restoration database corresponding to the database, so that the server restores and obtains the restoration database when the system service is running.

The present invention also provides an electronic device, including a memory, a processor, and a computer program stored on the memory and operable on the processor. When the processor executes the program, the database processing described in any one of the above is realized. method.

The present invention also provides a non-transitory computer-readable storage medium on which a computer program is stored, and when the computer program is executed by a processor, the database processing method described in any one of the above-mentioned methods is realized.

The present invention also provides a computer program product, including a computer program. When the computer program is executed by a processor, the database processing method described in any one of the above is implemented.

The database processing method, device, electronic equipment and storage medium provided by the present invention create a file backup script corresponding to the database to be processed when the system service of the server is running, and perform a backup operation on the database to be processed based on the file backup script In order to obtain the backup file; in the case of data loss in the database to be processed, create a database recovery script corresponding to the backup file, and build a recovery database corresponding to the database to be processed based on the database recovery script and backup file, so that the server will Resume to restore the database in case of suspension of system services. Ensure that the database can be backed up and restored without suspending the operation of the server, so as to improve the user experience and satisfaction during use.

Description of drawings

In order to more clearly illustrate the present invention or the technical solutions in the prior art, the accompanying drawings that need to be used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the accompanying drawings in the following description are the present invention. For some embodiments of the invention, those skilled in the art can also obtain other drawings based on these drawings without creative effort.

Fig. 1 is one of the flow diagrams of the database processing method provided by the present invention;

Fig. 2 is that the database to be processed is carried out backup operation based on file backup script provided by the present invention, obtains the schematic flow chart of backup file;

Fig. 3 is the schematic flow chart of constructing the recovery database corresponding to the database to be processed based on the database recovery script and the backup file provided by the present invention;

Fig. 4 is the second schematic flow chart of the database processing method provided by the present invention;

Fig. 5 is a schematic structural diagram of a database processing device provided by the present invention;

Fig. 6 is a schematic structural diagram of an electronic device provided by the present invention.

Detailed ways

In order to make the purpose, technical solutions and advantages of the present invention clearer, the technical solutions in the present invention will be clearly and completely described below in conjunction with the accompanying drawings in the present invention. Obviously, the described embodiments are part of the embodiments of the present invention , but not all examples. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of the present invention.

Currently, in the process of backing up and restoring the database, it is often necessary to suspend the operation of the server. In addition, the server does not support the backup and restoration of the database in cluster mode, which will affect the user experience during use.

The database processing method provided by the present invention can support backup and recovery operations of the database when the server is running normally, and the system service of the server is provided by a single application or microservice. Among them, the monolithic application refers to the architecture in which all the functions and modules in the system are coupled in one application. That is, the project organization method that includes all codes and functions in a WAR package. Its composition is that multiple modules (all resources) are packaged into a war package and run on a server, that is, a process to run. Microservice is to split a large application into multiple small applications. These small applications are relatively independent. Each small application has its own container and its own running process. These small applications communicate through the network protocol (HTTP Rest) communicate with each other, and all applications work together to complete the business of the entire project. It is understandable that a system service can be provided by a monolithic application or by multiple microservices.

Fig. 1 is one of the schematic flowcharts of the database processing method provided by the present invention.

In order to further introduce the database processing method provided by the present invention, it will be described below in conjunction with FIG. 1 .

In an exemplary embodiment of the present invention, the database processing method may be applied to a server. In an example, the system service of the server is provided by a monolithic application or a microservice. During the application process, the server may also correspond to a database to be processed. It can be seen from FIG. 1 that the database processing method may include step 110 to step 130, and each step will be introduced below.

In step 110, the database to be processed is obtained.

In an embodiment, the database to be processed may be considered as a database that needs to be backed up and restored. Wherein, the database to be processed may include multiple data.

In yet another embodiment, the information of each database may be acquired, such as database service address, database port number, database user name, and the like. Further, based on the information of the database, the database to be processed that needs to be backed up and restored can be automatically found.

In an example, the database to be processed may be a cluster mode database. In the application process, when the server is a server corresponding to microservices, the server may be a clustered server, wherein each server in the clustered server may correspond to each database in the clustered database.

In step 120, when the system service of the server is running, a file backup script corresponding to the database to be processed is created, and a backup operation is performed on the database to be processed based on the file backup script to obtain a backup file.

In one embodiment, when the system service of the server is running, a file backup script corresponding to the database to be processed can be created, and further, the database to be processed can be backed up by executing the file backup script to obtain the backup file .

It should be noted that the backup operation can be performed without losing data in the database to be processed, so that a backup file with complete data can be obtained.

Wherein, the function of the file backup script is to execute the database backup operation and compress the backed up database file. The database processing method provided by the present invention will be described below based on the function of the file backup script.

In an exemplary embodiment of the present invention, referring to FIG. 2 , it can be known that performing a backup operation on the database to be processed based on the file backup script to obtain the backup file may include Step 210 and Step 220 , and each step will be introduced below.

In step 210, based on the file backup script, determine the backup command corresponding to the database to be processed;

In step 220, based on the backup command, the database to be processed is backed up to obtain a backup file.

In an embodiment, the backup command corresponding to the database to be processed may be determined based on the file backup script. Wherein, the backup commands corresponding to different databases to be processed are different. Further, based on the backup command, the database to be processed can be backed up to obtain the backup file. In this implementation, the file-based backup script can automatically obtain the backup file without affecting the operation of the server, laying a foundation for the recovery operation of the database to be processed.

In yet another exemplary embodiment of the present invention, based on the backup command, the database to be processed is backed up, and the backup file can also be obtained in the following manner:

Based on the backup command, the database to be processed is backed up to obtain backup files at different backup times;

The backup file whose backup time is the latest backup time is used as the backup file for constructing the recovery database.

In an embodiment, based on the backup command, the database to be processed can be backed up multiple times at preset time intervals. Since the data contained in the database to be processed at different backup times may be different as time goes by, it can be understood that the data contained in the database to be processed at the latest backup time can be considered to be the most comprehensive. Therefore, in the application process, the database to be processed can be backed up based on the backup command to obtain backup files at different backup times; and the backup file whose backup time is the latest backup time can be used as the backup file for building the restored database. Through this embodiment, it can be ensured that the backup file is the latest and most comprehensive data contained in the database to be processed, thereby laying a foundation for accurate restoration of the database to be processed.

In yet another embodiment, it can also be confirmed whether the version of the backup file is the same as the version corresponding to the data in the database to be processed. file to build a recovery database corresponding to the pending database.

In yet another exemplary embodiment of the present invention, continue to take the embodiment described in Fig. 2 as an example to illustrate, based on the backup command, the database to be processed is backed up, and after the backup file (corresponding to step 220) is obtained, the database processing method The following steps may also be included:

Based on the file backup script, determine the compression command corresponding to the backup file;

Based on the compression command, the backup file is compressed to obtain the compressed backup file;

Before constructing a recovery database corresponding to the database to be processed based on the backup file, the database processing method may further include the following steps:

Decompress the compressed backup file to obtain the backup file.

In one embodiment, the compression command corresponding to the backup file may be determined based on the file backup script, and the backup file may be compressed based on the compression command to obtain the compressed backup file. In this embodiment, by compressing the backup file corresponding to the database to be processed to obtain the compressed backup file, storage space can be saved during the storage process.

Further, when the data loss of the database to be processed is detected, that is, when the database to be processed needs to be restored, the stored compressed backup file can be decompressed to obtain the backup file, and then based on the decompressed backup file, the construction and processing The database corresponds to the recovery database. Through this embodiment, the storage space of the backup file can be saved under the premise of ensuring effective recovery of the database to be processed.

In step 130, in the case of data loss in the database to be processed, create a database recovery script corresponding to the backup file based on the backup file, and build a recovery database corresponding to the database to be processed based on the database recovery script and the backup file, to Restoring the server with system services running gets the recovery database.

It should be noted that the backup operation of the database to be processed to obtain the backup file may be performed under the condition that no data loss occurs in the database to be processed. During the application process, when the data loss of the database to be processed is detected, that is, when the database to be processed needs to be restored, in this scenario, the recovery database corresponding to the database to be processed can be constructed based on the backup file. Wherein, the data included in the recovery database is a backup file. Through this embodiment, the recovery operation of the database to be processed can be realized without affecting the operation of the server.

In yet another exemplary embodiment of the present invention, a database recovery script corresponding to the backup file may be created, and a recovery database corresponding to the database to be processed may be constructed based on the database recovery script and the backup file.

In one embodiment, the compressed database backup file (corresponding to the compressed backup file) may be obtained, and then the compressed database backup file may be decompressed to obtain a backup file capable of constructing a restored database.

Further, a database recovery script corresponding to the backup file is created and executed, so that a recovery database corresponding to the database to be processed can be constructed. Among them, the main functions of the database recovery script include closing the user’s access to the database to be processed, renaming the database to be processed, creating a blank database, restoring the database based on the blank database, and deleting the database to be processed and backup files.

The database processing method provided by the present invention is to create a file backup script corresponding to the database to be processed when the system service of the server is running, and perform a backup operation on the database to be processed based on the file backup script to obtain a backup file ; In the case of data loss in the database to be processed, create a database recovery script corresponding to the backup file, and build a recovery database corresponding to the database to be processed based on the database recovery script and backup file, so that the server does not suspend system services. In case recovery gets the recovery database. Ensure that the database can be backed up and restored without suspending the operation of the server, so as to improve the user experience and satisfaction during use.

The present invention will describe the process of executing a database recovery script in conjunction with the following embodiments.

FIG. 3 is a schematic flowchart of constructing a recovery database corresponding to the database to be processed based on the database recovery script and backup files provided by the present invention.

In an exemplary embodiment of the present invention, referring to FIG. 3, it can be seen that based on the database recovery script and the backup file, constructing the recovery database corresponding to the database to be processed may include steps 310 to 350, and each step will be introduced below.

In step 310, based on the database recovery script, a first command is determined, wherein the first command is a command to close the user's access right to the database to be processed.

In step 320, in the case that the user's access authority to the database to be processed is successfully closed based on the first command, a second command is determined based on the database recovery script, wherein the second command is a command for performing a rename operation on the database to be processed .

In an embodiment, the first command may be determined according to the database recovery script, where the first command is a command for closing the user's access right to the database to be processed. During the application process, successfully closing the user's access authority to the database to be processed through the first command can ensure that the user cannot access the database to be processed temporarily, laying a foundation for successful recovery of the database to be processed.

Further, in the case that the user's access right to the database to be processed is successfully closed based on the first command, the second command may be determined based on the database recovery script, wherein the second command is a command for performing a rename operation on the database to be processed. It can be understood that the successful operation of renaming the database to be processed is also the basis for realizing the recovery operation of the database to be processed.

In step 330, in the case that the database to be processed is successfully renamed based on the second command, a third command is determined based on the database recovery script, wherein the third command is a command to create a blank database, and the blank database is used to carry backup files .

In step 340, if the blank database is successfully created based on the third command, a fourth command is determined based on the database recovery script, wherein the fourth command is a command for importing the backup file into the blank database.

In step 350, if the backup file is successfully imported into the blank database based on the fourth command, a blank database containing the backup file is obtained, and the blank database containing the backup file is used as a recovery database.

In one embodiment, in the case that the database to be processed is successfully renamed based on the second command, the third command can be determined based on the database recovery script, wherein the third command is a command for creating a blank database, and the blank database is used for Undertake backup files.

During the application process, under the premise of successfully renaming the database to be processed, a blank database can be created. The blank database does not contain any data temporarily, but is used to undertake the backup file. It is understandable that the backup file is included The blank database can be used as a recovery database.

Further, in the case that the blank database is successfully created based on the third command, the fourth command may be determined based on the database restoration script, wherein the fourth command is a command for importing the backup file into the blank database. During the application process, the operation of restoring the database can be performed, and the backup file can be imported into the blank database to obtain a blank database containing the backup file, and the blank database containing the backup file can be used as the recovery database. Through this embodiment, a recovery database corresponding to the database to be processed can be obtained, wherein the recovery database includes backup files.

In yet another exemplary embodiment of the present invention, continue to take the embodiment described in Figure 3 as an example to illustrate, after obtaining the blank database (corresponding to step 350) that contains the backup file, the database processing method may also include the following steps:

Based on the database recovery script, the fifth command is determined, wherein the fifth command is a command to delete the database to be processed and/or the backup file;

Based on the fifth command, delete the pending database and/or backup file.

In one embodiment, in order to save the storage space of the server system, after successfully restoring the database to be processed, the fifth command can also be determined based on the database recovery script, and based on the fifth command, the database to be processed and/or the backup file can be deleted . Wherein, the fifth command is a command to delete the database to be processed and/or the backup file.

In yet another exemplary embodiment of the present invention, after determining the second command (corresponding to step 320) based on the database recovery script, the database processing method may further include the following steps:

In the case that the database to be processed is not successfully renamed based on the second command, the user's access right to the database to be processed is reopened, and the operation of determining the third command is stopped.

In one embodiment, when the operation of renaming the database to be processed fails, the user's access right to the database to be processed needs to be re-enabled, so as to prevent the user from being unable to access the database and avoid affecting the user's experience. Further, since renaming the database to be processed is the primary condition for restoring the database to be processed, if the database to be processed is not successfully renamed, operations in subsequent steps will not be performed, such as stopping the operation of determining the third command.

In yet another exemplary embodiment of the present invention, after determining the third command (corresponding to step 330) based on the database recovery script, the database processing method may further include the following steps:

If the blank database is not successfully created based on the third command, the name of the database to be processed is changed to the original name, and the user's access right to the database to be processed is reopened, and the operation of determining the fourth command is stopped.

In one embodiment, when the blank database is not successfully created, the name of the database to be processed needs to be changed to the original name, and the user's access authority to the database to be processed needs to be re-opened, thereby preventing the user from being unable to access the database and avoiding affecting the user's sense of experience. Further, since the successful creation of a blank database is a necessary condition for restoring the database to be processed, when the blank database is not successfully created, the operation of the subsequent steps is not performed, for example, the operation of determining the fourth command is stopped.

In yet another exemplary embodiment of the present invention, after determining the fourth command (corresponding to step 340) based on the database restoration script, the database processing method may further include the following steps:

In the event that the backup file is not successfully imported into the blank database based on the fourth command, the name of the database to be processed is changed to the original name, the user's access right to the database to be processed is reopened, and the blank database is deleted.

In one embodiment, when the backup file is not successfully imported into the blank database, it is necessary to change the name of the database to be processed to the original name, re-enable the user's access to the database to be processed, and delete the blank database, so that users can avoid Unable to access the database, so as not to affect the user experience.

Fig. 4 is the second schematic flow diagram of the database processing method provided by the present invention.

In order to further introduce the database processing method provided by the present invention, it will be described below in conjunction with FIG. 4 .

In an exemplary embodiment of the present invention, it can be known with reference to FIG. 4 that the database processing method may include step 401 to step 417, and each step will be introduced respectively below.

In step 401, a database backup file is acquired.

In one embodiment, a file backup script corresponding to the database to be processed may be created, and a backup operation is performed on the database to be processed based on the file backup script to obtain a backup file (corresponding to a database backup file). Furthermore, the database backup file can also be compressed to obtain a compressed backup file, thereby saving storage space during storage.

In step 402, the database backup file is decompressed.

In step 403, database backup information is acquired.

In step 404, the restore script is executed.

In one embodiment, when the database to be processed needs to be restored, that is, when data loss in the database to be processed is detected, the compressed backup file may be decompressed to obtain the database backup file. Further, the database backup information can be obtained, such as the backup time and version of the database backup file, and when the backup time of the database backup file is the latest time and the version corresponds to the database to be processed, the recovery script operation can be executed. Among them, the role of the data recovery script mainly includes closing the user’s access to the database (corresponding to the database to be processed), renaming the existing database (corresponding to the database to be processed), creating a recovery database (corresponding to a blank database), restoring the database, and deleting the existing database. There are database backups (corresponding to backup files), etc.

In step 405, the user's access to the database is disabled.

In one embodiment, the user's access authority to the database can be closed, so that other users cannot access the database temporarily. Thereby, the smooth progress of the pending database recovery operation can be ensured.

In step 406, if the user's access right to the database is successfully closed, the existing database is renamed.

In step 407, if the user's access right to the database is not successfully closed, the user's access right to the database is enabled.

In one embodiment, the existing database (corresponding to the database to be processed) is renamed to prevent failure in restoring the database. If the renaming operation fails, the user's access to the database will be re-opened, and the recovery operation will end, so that the user's access to the database will not be affected, and the user's experience and satisfaction during use will be improved.

In step 408, in case of a successful rename operation of the existing database, a recovery database is created.

In step 409, if the operation of renaming the existing database is unsuccessful, the database name is changed back.

In step 410, the user's access right to the database is enabled.

In one embodiment, if the renaming operation is successful, a recovery database (corresponding to a blank database) is created to take over the data of the backup database file. If the new recovery database (blank database) fails, then change the database name back, re-enable the user's access to the database, and end the recovery operation.

In step 411, if the recovery database is created successfully, the recovery database operation is performed.

In step 412, if the recovery database is not created successfully, the created recovery database is deleted.

In step 413, the database name is changed back.

In step 414, the user's access right to the database is enabled.

In one embodiment, if the recovery database (corresponding to the blank database) is successfully created, the database recovery operation is performed, and the data of the backup database file is imported into the newly created database (corresponding to the blank database). If the restore database operation fails, delete the created restore database (corresponding to a blank database), change the database name back, and re-enable the user's access to the database.

In step 415, in case of a successful restore database operation, the existing database backup is deleted.

In step 416, in the event that the existing database backup was not successfully deleted, the process ends.

In step 417, in case the existing database backup is successfully deleted, the process ends.

In one embodiment, if the operation of restoring data is successful, the backup of the existing database (corresponding to the database to be processed) is deleted, and the residual database backup file (corresponding to the backup file) is removed. If the deletion of the existing database backup fails, try to delete the existing database backup operation again, and end the operation whether it fails or not, and return the information that the deletion of the existing database backup operation failed. If the deletion of the existing database backup is successful, then return the message that the operation of deleting the existing database backup is successful, and end the operation.

According to the above description, it can be seen that the database processing method provided by the present invention, by creating a file backup script corresponding to the database to be processed when the system service of the server is running, and backing up the database to be processed based on the file backup script operation to obtain the backup file; in the case of data loss in the database to be processed, create a database recovery script corresponding to the backup file, and build a recovery database corresponding to the database to be processed based on the database recovery script and backup file, so that the server Restoring restores the database without suspending system services. Ensure that the database can be backed up and restored without suspending the operation of the server, so as to improve the user experience and satisfaction during use.

Based on the same idea, the present invention also provides a database processing device.

The database processing device provided by the present invention is described below, and the database processing device described below and the database processing method described above can be referred to in correspondence.

Fig. 5 is a schematic structural diagram of a database processing device provided by the present invention.

In an exemplary embodiment of the present invention, the database processing device is applied to a server, and the server includes a database to be processed. As can be seen from FIG. 5 , the database processing apparatus may include a first module 510 , a second module 520 and a third module 530 , and each step will be introduced below.

The first module 510 may be configured to acquire the database to be processed;

The second module 520 may be configured to create a file backup script corresponding to the database to be processed when the system service of the server is running, and perform a backup operation on the database to be processed based on the file backup script to obtain a backup file;

The third module 530 may be configured to create a database recovery script corresponding to the backup file based on the backup file when there is data loss in the database to be processed, and to construct a database corresponding to the database to be processed based on the database recovery script and the backup file. The corresponding recovery database, so that the server recovers the recovery database while the system service is running.

In an exemplary embodiment of the present invention, the second module 520 can implement the backup operation based on the file backup script to the database to be processed in the following manner to obtain the backup file:

Based on the file backup script, determine the backup command corresponding to the database to be processed;

Based on the backup command, the database to be processed is backed up to obtain a backup file.

In an exemplary embodiment of the present invention, the second module 520 can implement the backup operation based on the backup command to obtain the backup file based on the backup command in the following manner:

Based on the backup command, the database to be processed is backed up to obtain backup files at different backup times;

The backup file whose backup time is the latest backup time is used as the backup file for constructing the recovery database.

In an exemplary embodiment of the present invention, the second module 520 may also be configured to:

Based on the file backup script, determine the compression command corresponding to the backup file;

Based on the compression command, the backup file is compressed to obtain the compressed backup file;

Decompress the compressed backup file to obtain the backup file.

In an exemplary embodiment of the present invention, the third module 530 may implement, based on the backup file, building a recovery database corresponding to the database to be processed in the following manner:

Create a database recovery script corresponding to the backup file, and build a recovery database corresponding to the database to be processed based on the database recovery script and the backup file.

In an exemplary embodiment of the present invention, the third module 530 can use the following method to realize building a recovery database corresponding to the database to be processed based on the database recovery script and the backup file:

Based on the database recovery script, the first command is determined, wherein the first command is a command to close the user's access authority to the database to be processed;

In the case that the user's access authority to the database to be processed is successfully closed based on the first command, a second command is determined based on the database recovery script, wherein the second command is a command for renaming the database to be processed;

In the case of successfully renaming the database to be processed based on the second command, a third command is determined based on the database recovery script, wherein the third command is a command to create a blank database, and the blank database is used to accept backup files;

In the case of successfully creating a blank database based on the third command, a fourth command is determined based on the database recovery script, wherein the fourth command is an order for importing the backup file into the blank database;

If the backup file is successfully imported into the blank database based on the fourth command, a blank database containing the backup file is obtained, and the blank database containing the backup file is used as a recovery database.

In an exemplary embodiment of the present invention, the third module 530 may also be configured to:

Based on the database recovery script, the fifth command is determined, wherein the fifth command is a command to delete the database to be processed and/or the backup file;

Based on the fifth command, delete the pending database and/or backup file.

In an exemplary embodiment of the present invention, the third module 530 may also be configured to:

In the case that the database to be processed is not successfully renamed based on the second command, the user's access right to the database to be processed is reopened, and the operation of determining the third command is stopped.

In an exemplary embodiment of the present invention, the third module 530 may also be configured to:

If the blank database is not successfully created based on the third command, the name of the database to be processed is changed to the original name, and the user's access right to the database to be processed is reopened, and the operation of determining the fourth command is stopped.

In an exemplary embodiment of the present invention, the third module 530 may also be configured to:

In the event that the backup file is not successfully imported into the blank database based on the fourth command, the name of the database to be processed is changed to the original name, the user's access right to the database to be processed is reopened, and the blank database is deleted.

In an exemplary embodiment of the present invention, the database to be processed is a cluster mode database.

In an exemplary embodiment of the present invention, the system service of the server is provided by a monolithic application, or provided by a microservice.

FIG. 6 illustrates a schematic diagram of the physical structure of an electronic device. As shown in FIG. 6, the electronic device may include: a processor (processor) 610, a communication interface (Communications Interface) 620, a memory (memory) 630 and a communication bus 640, Wherein, the processor 610 , the communication interface 620 , and the memory 630 communicate with each other through the communication bus 640 . The processor 610 may call the logic instructions in the memory 630 to execute a database processing method, the database processing method is applied to a server, the server includes a database to be processed, and the method includes: acquiring the database to be processed; When the system service of the server is running, create a file backup script corresponding to the database to be processed, and perform a backup operation on the database to be processed based on the file backup script to obtain a backup file; in the database to be processed In the case of data loss, based on the backup file, create a database recovery script corresponding to the backup file, and based on the database recovery script and the backup file, construct a recovery database corresponding to the database to be processed, The server recovers to obtain the recovery database when the system service is running.

In addition, the logic instructions in the above-mentioned memory 630 may be implemented in the form of software functional units and when sold or used as an independent product, may be stored in a computer-readable storage medium. Based on this understanding, the essence of the technical solution of the present invention or the part that contributes to the prior art or the part of the technical solution can be embodied in the form of a software product, and the computer software product is stored in a storage medium, including Several instructions are used to make a computer device (which may be a personal computer, a server, or a network device, etc.) execute all or part of the steps of the methods described in 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. .

On the other hand, the present invention also provides a computer program product. The computer program product includes a computer program that can be stored on a non-transitory computer-readable storage medium. When the computer program is executed by a processor, the computer can Executing the database processing method provided by each of the above methods, the database processing method is applied to a server, the server includes a database to be processed, and the method includes: obtaining the database to be processed; when the system service of the server is running In this case, create a file backup script corresponding to the database to be processed, and perform a backup operation on the database to be processed based on the file backup script to obtain a backup file; when there is data loss in the database to be processed, Create a database recovery script corresponding to the backup file based on the backup file, and construct a recovery database corresponding to the database to be processed based on the database recovery script and the backup file, so that the server is in the When the system service is running, recover to obtain the recovery database.

In yet another aspect, the present invention also provides a non-transitory computer-readable storage medium, on which a computer program is stored, and when the computer program is executed by a processor, it is implemented to execute the database processing method provided by the above methods, and the database processing The method is applied to a server, and the server includes a database to be processed, and the method includes: obtaining the database to be processed; when the system service of the server is running, creating a file backup script corresponding to the database to be processed , and perform a backup operation on the database to be processed based on the file backup script to obtain a backup file; in the case of data loss in the database to be processed, create a database corresponding to the backup file based on the backup file Restoring a script, and constructing a restoration database corresponding to the database to be processed based on the database restoration script and the backup file, so that the server restores and obtains the restoration database when the system service is running.

The device embodiments described above are only illustrative, and the units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in One place, or it can be distributed to multiple network elements. Part or all of the modules can be selected according to actual needs to achieve the purpose of the solution of this embodiment. It can be understood and implemented by those skilled in the art without any creative effort.

Through the above description of the implementations, those skilled in the art can clearly understand that each implementation can be implemented by means of software plus a necessary general-purpose hardware platform, and of course also by hardware. Based on this understanding, the essence of the above technical solution or the part that contributes to the prior art can be embodied in the form of software products, and the computer software products can be stored in computer-readable storage media, such as ROM/RAM, magnetic discs, optical discs, etc., including several instructions to make a computer device (which may be a personal computer, server, or network device, etc.) execute the methods described in various embodiments or some parts of the embodiments.

It can be further understood that although operations are described in a specific order in the drawings in the embodiments of the present invention, it should not be understood as requiring that these operations be performed in the specific order shown or in a serial order, or that Do all of the operations shown to get the desired result. In certain circumstances, multitasking and parallel processing may be advantageous.

Finally, it should be noted that: the above embodiments are only used to illustrate the technical solutions of the present invention, rather than 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: it can still be Modifications are made to the technical solutions described in the foregoing embodiments, or equivalent replacements are made to some of the technical features; and these modifications or replacements do not make the essence of the corresponding technical solutions deviate from the spirit and scope of the technical solutions of the various embodiments of the present invention.

Claims (14)

1. A database processing method, characterized in that it is applied to a server, and the server includes a database to be processed, and the method comprises: Obtain the database to be processed; When the system service of the server is running, create a file backup script corresponding to the database to be processed, and perform a backup operation on the database to be processed based on the file backup script to obtain a backup file; In the case that there is data loss in the database to be processed, based on the backup file, create a database recovery script corresponding to the backup file, and based on the database recovery script and the backup file, construct a script related to the database to be processed The recovery database corresponding to the database, so that the server recovers and obtains the recovery database when the system service is running. 2. The database processing method according to claim 1, wherein the backup operation is performed on the database to be processed based on the file backup script to obtain a backup file, which specifically includes: Based on the file backup script, determine a backup command corresponding to the database to be processed; Based on the backup command, a backup operation is performed on the database to be processed to obtain a backup file. 3. The database processing method according to claim 2, wherein the backup operation is performed on the database to be processed based on the backup command to obtain a backup file, which specifically includes: Based on the backup command, perform a backup operation on the database to be processed to obtain backup files at different backup times; The backup file whose backup time is the latest backup time is used as the backup file for constructing the recovery database. 4. The database processing method according to claim 2 or 3, wherein, after performing a backup operation on the database to be processed based on the backup command and obtaining a backup file, the method further comprises: determining a compression command corresponding to the backup file based on the file backup script; Compressing the backup file based on the compression command to obtain a compressed backup file; Before creating a database recovery script corresponding to the backup file based on the backup file, the method further includes: Decompressing the compressed backup file to obtain the backup file. 5. The database processing method according to claim 1, wherein the recovery database corresponding to the database to be processed is constructed based on the database recovery script and the backup file, specifically comprising: Determining a first command based on the database recovery script, wherein the first command is a command to close the user's access authority to the database to be processed; In the case that the user's access right to the database to be processed is successfully closed based on the first command, a second command is determined based on the database restoration script, wherein the second command is to perform a database recovery operation on the database to be processed command for renaming operation; In the case that the database to be processed is successfully renamed based on the second command, a third command is determined based on the database recovery script, wherein the third command is a command for creating a blank database, and the blank The database is used to undertake the backup file; In the case that the blank database is successfully created based on the third command, a fourth command is determined based on the database restoration script, wherein the fourth command is a command for importing the backup file into the blank database ; In the case that the backup file is successfully imported into the blank database based on the fourth command, the blank database containing the backup file is obtained, and the blank database containing the backup file is used as The recovery database. 6. The database processing method according to claim 5, characterized in that, after said obtaining said blank database comprising said backup file, said method further comprises: A fifth command is determined based on the database recovery script, wherein the fifth command is a command to delete the database to be processed and/or the backup file; Based on the fifth command, delete the database to be processed and/or the backup file. 7. The database processing method according to claim 5, characterized in that, after the second command is determined based on the database restoration script, the method further comprises: In the case that the operation of renaming the database to be processed is unsuccessful based on the second command, re-enable the user's access right to the database to be processed, and stop the operation of determining the third command. 8. The database processing method according to claim 5, wherein, after the third command is determined based on the database restoration script, the method further comprises: In the case that the blank database is not successfully created based on the third command, the name of the database to be processed is changed to the original name, and the user's access right to the database to be processed is reopened, and determination of the fourth The operation of the command. 9. The database processing method according to claim 5, wherein, after the fourth command is determined based on the database restoration script, the method further comprises: In the case of unsuccessfully importing the backup file into the blank database based on the fourth command, changing the name of the database to be processed to the original name, reopening the user's access authority to the database to be processed, and delete said blank database. 10. The database processing method according to claim 1, wherein the database to be processed is a cluster mode database. 11. The database processing method according to claim 1, wherein the system service of the server is provided by a monolithic application, or provided by a microservice. 12. A database processing device, characterized in that it is applied to a server, the server includes a database to be processed, and the device includes: A first module, configured to acquire the database to be processed; The second module is configured to create a file backup script corresponding to the database to be processed when the system service of the server is running, and perform a backup operation on the database to be processed based on the file backup script to obtain backup file; The third module is configured to create a database recovery script corresponding to the backup file based on the backup file when there is data loss in the database to be processed, and based on the database recovery script and the backup file, Constructing a restoration database corresponding to the database to be processed, so that the server restores and obtains the restoration database when the system service is running. 13. An electronic device comprising a memory, a processor, and a computer program stored on the memory and operable on the processor, wherein the processor according to claim 1 is implemented when executing the program. The database processing method described in any one of to 11. 14. A non-transitory computer-readable storage medium on which a computer program is stored, wherein the computer program implements the database processing method according to any one of claims 1 to 11 when executed by a processor.

Images