CN116701053A - Data backup and recovery method, device, equipment and medium for production environment database - Google Patents

Abstract

The embodiment of the invention discloses a method, a device, equipment and a medium for restoring data backup of a production environment database. Applied to a data backup and recovery system, the system comprises: a task repeater and at least one task executor, the method comprising: responding to the target backup task through the task relay, and determining a target task executor corresponding to the target backup task; acquiring a user identification of a target user through a target task executor, and creating a backup log record corresponding to a target backup task according to the user identification; acquiring each target data in a production environment database according to the backup log record, and assembling each target data to obtain a backup data message; and responding to the target recovery task, unpacking the data message, and recovering to obtain each target data. The scheme of the embodiment of the invention can accurately backup or restore the related data from the production environment database and provides basis for subsequent operation.

Description

Data backup and recovery method, device, equipment and medium for production environment database

technical field

The embodiments of the present invention relate to the field of computer technology, and in particular to a method, device, device and medium for data backup and restoration of a production environment database.

Background technique

In business fields such as finance and administration, all business systems are deployed in the corresponding user business environment, and developers cannot connect to the user business environment through the network; when a business system fails, developers cannot locate the fault; this , it is necessary to backup or restore relevant data from the production environment database to the corresponding location for debugging.

Due to the huge amount of data that needs to be backed up and the intricate correlation between each data, it is difficult to back up related data.

How to accurately backup or restore relevant data from the production environment database to provide a basis for subsequent operations is a key issue in the industry's research.

Contents of the invention

Embodiments of the present invention provide a data backup and restoration method, device, equipment and medium for a production environment database, so as to accurately back up or restore relevant data from the production environment database, and provide a basis for subsequent operations.

According to an aspect of the embodiments of the present invention, a data backup and recovery method for a production environment database is provided, which is applied to a data backup and recovery system, and the data backup and recovery system includes: a task repeater and at least one task executor, the The task repeater communicates with each of the task executors; the method includes:

determining a target task executor corresponding to the target backup task in response to a target backup task for target data in the production environment database initiated by the target user through the task repeater;

Obtaining the user ID of the target user through the target task executor, and creating a backup log record corresponding to the target backup task according to the user ID;

Obtain each target data in the production environment database according to the backup log records, and assemble each target data to obtain a backup data message;

In response to the target recovery task initiated by the target user for the target data in the production environment database, the data packet is unpacked, and each target data is recovered.

According to another aspect of the embodiments of the present invention, there is provided a data backup and recovery device for a production environment database, which is applied to a data backup and recovery system, and the data backup and recovery system includes: a task repeater and at least one task executor, the The task repeater is connected in communication with each of the task executors; the device includes:

A task executor determining module, configured to determine a target task executor corresponding to the target backup task in response to the target backup task for the target data in the production environment database initiated by the target user through the task repeater;

A backup log record creating module, configured to obtain the user ID of the target user through the target task executor, and create a backup log record corresponding to the target backup task according to the user ID;

The backup data message determination module is used to obtain each target data in the production environment database according to the backup log records, and assemble each of the target data to obtain a backup data message;

The target data determination module is configured to unpack the data packet and recover the target data in response to the target recovery task for the target data in the production environment database initiated by the target user.

According to another aspect of the embodiments of the present invention, an electronic device is provided, and the electronic device includes:

at least one processor; and

a memory communicatively coupled to the at least one processor; wherein,

The memory stores a computer program that can be executed by the at least one processor, and the computer program is executed by the at least one processor, so that the at least one processor can execute any of the embodiments of the present invention. The data backup and recovery method of the production environment database described above.

According to another aspect of the embodiments of the present invention, a computer-readable storage medium is provided, the computer-readable storage medium stores computer instructions, and the computer instructions are used to enable a processor to implement any one of the embodiments of the present invention. The data backup recovery method of the production environment database described in the embodiment.

In the technical solution of the embodiment of the present invention, the target task executor corresponding to the target backup task is determined by the task repeater in response to the target backup task for the target data in the production environment database initiated by the target user; through the target The task executor obtains the user identification of the target user, and creates a backup log record corresponding to the target backup task according to the user identification; obtains each target data in the production environment database according to the backup log record, and The target data is assembled to obtain a backup data message; in response to the target recovery task initiated by the target user for the target data in the production environment database, the data message is unpacked, and the target data is recovered to obtain each target data, which can be Accurately back up or restore relevant data from the production environment database to provide a basis for subsequent operations.

It should be understood that the content described in this section is not intended to identify key or important features of the embodiments of the present invention, nor is it intended to limit the scope of the embodiments of the present invention. Other features of the embodiments of the present invention will be easily understood through the following description.

Description of drawings

In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the following will briefly introduce the drawings that need to be used in the description of the embodiments. Obviously, the drawings in the following description are only some implementations of the embodiments of the present invention. For example, those of ordinary skill in the art can also obtain other drawings based on these drawings on the premise of not paying creative efforts.

FIG. 1 is a flow chart of a data backup and recovery method for a production environment database according to Embodiment 1 of the present invention;

2 is a flowchart of a data backup and recovery method for a production environment database provided according to Embodiment 2 of the present invention;

3 is a schematic structural diagram of a data backup and recovery device for a production environment database provided according to Embodiment 3 of the present invention;

FIG. 4 is a schematic structural diagram of an electronic device implementing a data backup and recovery method for a production environment database according to an embodiment of the present invention.

Detailed ways

In order to enable those skilled in the art to better understand the embodiments of the present invention, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described implementation Examples are only some of the embodiments of the present invention, not all of them. Based on the embodiments in the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts shall fall within the protection scope of the embodiments of the present invention.

It should be noted that the terms "first" and "second" in the description and claims of the embodiments of the present invention and the above drawings are used to distinguish similar objects, but not necessarily to describe a specific order or sequence order. It is to be understood that the data so used are interchangeable under appropriate circumstances such that the embodiments of the invention described herein can be practiced in sequences other than those illustrated or described herein. Furthermore, the terms "comprising" and "having", as well as any variations thereof, are intended to cover a non-exclusive inclusion, for example, a process, method, system, product or device comprising a sequence of steps or elements is not necessarily limited to the expressly listed instead, may include other steps or elements not explicitly listed or inherent to the process, method, product or apparatus.

Embodiment one

Fig. 1 is a flow chart of a data backup and recovery method for a production environment database according to Embodiment 1 of the present invention. This embodiment is applicable to the situation where the relevant data is accurately backed up or restored from the production environment database. The method It can be executed by the data backup and recovery device of the production environment database, which can be implemented in the form of hardware and/or software, and the data backup and recovery device of the production environment database can be configured on a computer, server or tablet In electronic equipment such as computers.

It should be noted that the data backup and recovery method for the production environment database involved in this embodiment can be applied to a data backup and recovery system, and the data backup and recovery system can include: a task repeater and at least one task executor, the The task repeater communicates with each of the task executors; exemplary, in an example of this embodiment, the data backup and recovery system may include a task repeater and two task executors, and the task repeaters are respectively It communicates with the two task executors, and the two task executors can perform data backup tasks and data recovery tasks respectively.

Specifically, referring to Fig. 1, the method specifically includes the following steps:

Step 110: Responding to the target backup task for the target data in the production environment database initiated by the target user through the task repeater, determine a target task executor corresponding to the target backup task.

Wherein, the target user can be any registered user, and it can send a target backup task for the target data to the data backup and restoration system through the client; wherein, the target data can be one data or multiple data, or one Type or multiple types of data are not limited in this embodiment. Exemplarily, the target data may be the turnover or revenue and expenditure of the first quarter in the financial field.

In an optional implementation of this embodiment, after the data backup and recovery system receives the target backup task for the target data in the production environment database initiated by the target user, the received target backup task can be processed through the task repeater Processing is performed to determine the target executor corresponding to the target backup task, that is, the task execution time and resource consumption of the received target backup task can be estimated through the task repeater, so as to distribute the task.

Optionally, in this embodiment, determining the target task executor corresponding to the target backup task through the task repeater may include: generating a target task corresponding to the target backup task, and placing the target task adding to the task queue; obtaining the target task from the task queue, determining the resource consumption of the target task; determining the target task executor according to the resource consumption of the target task.

Optionally, in this embodiment, generating the target task corresponding to the target backup task may include: directly generating the target task corresponding to the target backup task according to the target backup task; or, intercepting the target Backup task, extracting the user access ID of the target backup task, and performing business access arbitration according to the user access ID; in the case of passing the business access arbitration, generating a target task corresponding to the target backup task; otherwise, returning mistake.

In an optional implementation of this embodiment, after receiving the target backup task for the target data in the production environment database initiated by the target user, the target task corresponding to the target backup task can be directly generated, and the generated target Tasks are added to the task queue; further, each task in the task queue can be obtained in turn, the resource consumption of each task in the task queue can be determined, and the task executor of each task can be determined according to the resource consumption; in this embodiment , after the target task is acquired from the task queue, the resource consumption of the target task can be determined, and the target task executor of the target task, that is, the target task executor corresponding to the target backup task, can be determined according to the resource consumption of the target task.

In another optional implementation of this embodiment, after receiving the target backup task for the target data in the production environment database initiated by the target user, the target backup task can be intercepted to extract the user access data of the target backup task. ID, and perform business access arbitration according to the user access ID; if the business access arbitration is passed, generate the target task corresponding to the target backup task, and add the generated target task to the task queue; further, the task queue can be obtained in sequence For each task in the task queue, the resource consumption of each task in the task queue is determined, and the task executor of each task is determined according to each resource consumption.

Specifically, after receiving the target backup task for the target data in the production environment database initiated by the target user, the business interceptor will intercept the target backup task, extract the user access ID, and apply for business access arbitration at the task repeater , if the arbitration result is access denied, directly return user error. If the arbitration result is passed, then the product corresponds to the task. In this embodiment, the data backup and restoration system may also include a business interceptor; the business interceptor may be used to prevent secondary data pollution and data errors if the user performs other business data operations during task execution.

Step 120: Obtain the user ID of the target user through the target task executor, and create a backup log record corresponding to the target backup task according to the user ID.

In an optional implementation of this embodiment, after the target task executor corresponding to the target backup task is determined through the task repeater, the user ID of the target user may be further obtained through the target task executor, and according to the acquired Create a backup log record corresponding to the target backup task for the user ID that was accessed.

Wherein, the backup log record may include at least one of the following: task identification, version, time and status fields.

Optionally, in this embodiment, when the target task executor receives the target backup task, it can create a global task identifier (that is, a user identifier) in the log database; further, it can obtain metadata through the metadata database, and Schedule execution according to the type of task performed by the user.

Step 130: Obtain each target data in the production environment database according to the backup log records, and assemble each target data to obtain a backup data message.

In an optional implementation of this embodiment, after obtaining the user ID of the target user through the target task executor, and creating a backup log record corresponding to the target backup task according to the obtained user ID, the target task executor can further According to the backup log records, each target data is obtained in the production environment database, and each target data is assembled to obtain a backup data message.

Wherein, the target data is data related to the target backup task in the production environment database.

Optionally, in this embodiment, the target task executor can obtain data from the business database according to "task + node + data identification + version", that is, according to the backup log records, and perform data assembly to form a format in json datagrams.

In an optional implementation of this embodiment, after obtaining the target data in the production environment database according to the backup log records, and assembling the target data to obtain the backup data message, it may also include: The backup message data is encrypted and/or compressed to obtain backup data corresponding to the target backup task.

Optionally, in this embodiment, after the data assembly is completed, the data sm3 can be encrypted; further, the ciphertext of the data message can be compressed in a data format; finally, the data backup file can be output to the storage server , for users to download and update the log database "Backup" field.

Step 140 , in response to the target recovery task initiated by the target user for the target data in the production environment database, unpack the data packet, and restore each target data.

In an optional implementation of this embodiment, if the target recovery task for the production environment database initiated by the target user continues to be received, the target task executor can unpack the backup data message obtained above, so as to restore each target data.

Optionally, in this embodiment, in response to the target recovery task initiated by the target user for the target data in the production environment database, unpacking the data packet, and recovering the target data may include: Read the backup data corresponding to the target backup task, decrypt the backup data to obtain decrypted data files, and divide the decrypted data files according to the task nodes to obtain the corresponding task nodes. splitting the file; assembling each of the split files to obtain a database statement; recovering the target data according to each database statement.

In an optional implementation of this embodiment, after receiving the target recovery task for the target data in the production environment database initiated by the target user, the decryption operation can be reduced for the backup data message, and the decrypted Data files, and split by task nodes. Furthermore, the database data can be deleted according to the user ID, and the task node file corresponding to recovery can be obtained according to the metadata task node, and the data can be loaded, and the database statement can be automatically assembled to execute the data recovery. After the data recovery is completed, the different results can be performed as follows Operation: Success: Prompt the user of the version that has been restored; Failure: Delete the currently restored data and return to the operation of decrypting the backup data.

In the technical solution of this embodiment, the target task executor corresponding to the target backup task is determined through the task repeater in response to the target backup task for the target data in the production environment database initiated by the target user; through the target task The executor obtains the user ID of the target user, and creates a backup log record corresponding to the target backup task according to the user ID; obtains each target data in the production environment database according to the backup log record, and performs the The target data is assembled to obtain the backup data message; in response to the target recovery task initiated by the target user for the target data in the production environment database, the data message is unpacked, and the target data is recovered to obtain the target data, which can be accurately Backup or restore relevant data from the production environment database in a timely manner to provide a basis for subsequent operations.

Embodiment two

Fig. 2 is a flow chart of a data backup and recovery method for a production environment database according to Embodiment 2 of the present invention. This embodiment is a further refinement of the above-mentioned technical solutions. The technical solutions in this embodiment can be compared with the above-mentioned one Or a combination of alternative solutions in multiple embodiments. As shown in Figure 2, the data backup recovery method of the production environment database may include the following steps:

Step 210, assemble each metadata in the production environment database based on preset rules.

In an optional implementation manner of this embodiment, before responding to the target backup task for the target data in the production environment database initiated by the target user, it may further include: metadata for assembly.

Wherein, the preset rule may be an extensible markup language schema document specification (XML SchemaDocumentation, XSD).

Optionally, in this embodiment, before responding to the target backup task for the target data in the production environment database initiated by the target user, each metadata in the production environment database may also be assembled based on the XSD specification. That is, technicians can sort out user business scenarios and configure task metadata based on XSD specifications.

Step 220, through the task repeater, respond to the target backup task for the target data in the production environment database initiated by the target user, and determine the target task executor corresponding to the target backup task;

Step 230: Obtain the user ID of the target user through the target task executor, and create a backup log record corresponding to the target backup task according to the user ID;

Step 240: Obtain each target data in the production environment database according to the backup log records, and assemble each target data to obtain a backup data message;

Step 250 , in response to the target recovery task initiated by the target user for the target data in the production environment database, unpack the data packet, and recover the target data.

In the solution of this embodiment, before responding to the target backup task for the target data in the production environment database initiated by the target user, each metadata in the production environment database may be assembled based on preset rules to provide for subsequent Provide a basis for backup and recovery of target data.

Embodiment Three

FIG. 3 is a schematic structural diagram of a data backup and recovery device for a production environment database according to Embodiment 3 of the present invention. As shown in FIG. 3 , the device includes: a task executor determination module 310 , a backup log record creation module 320 , a backup data packet determination module 330 and a target data determination module 340 .

A task executor determination module 310, configured to determine a target task executor corresponding to the target backup task in response to the target backup task for the target data in the production environment database initiated by the target user through the task repeater;

A backup log record creation module 320, configured to obtain the user ID of the target user through the target task executor, and create a backup log record corresponding to the target backup task according to the user ID;

The backup data message determining module 330 is used to obtain each target data in the production environment database according to the backup log record, and assemble each of the target data to obtain a backup data message;

The target data determination module 340 is configured to unpack the data packet and recover the target data in response to the target recovery task for the target data in the production environment database initiated by the target user.

In the solution of this embodiment, the target task executor corresponding to the target backup task is determined in response to the target backup task for the target data in the production environment database initiated by the target user through the task executor determination module; through the log record creation module Obtain the user ID of the target user, and create a backup log record corresponding to the target backup task according to the user ID; obtain each target data in the production environment database according to the backup log record through the data message determination module, and Assemble each of the target data to obtain a backup data message; through the data determination module, respond to the target recovery task for the target data in the production environment database initiated by the target user, unpack the data message, and recover to obtain Each of the target data can be accurately backed up or restored from the production environment database to provide a basis for subsequent operations.

In an optional implementation of this embodiment, the data backup and recovery device for the production environment database further includes: an assembly module, configured to assemble each metadata in the production environment database based on preset rules;

Wherein, the preset rule is: Extensible Markup Language Schema Document Specification XSD.

In an optional implementation of this embodiment, the task executor determination module 310 is specifically configured to generate a target task corresponding to the target backup task, and add the target task to a task queue;

acquiring the target task from the task queue, and determining resource consumption of the target task;

The target task executor is determined according to the resource consumption of the target task.

In an optional implementation of this embodiment, the task executor determining module 310 is further specifically configured to directly generate a target task corresponding to the target backup task according to the target backup task;

or,

Intercepting the target backup task, extracting the user access ID of the target backup task, and performing service access arbitration according to the user access ID;

If the service access arbitration is passed, generate a target task corresponding to the target backup task;

Otherwise, an error is returned.

In an optional implementation of this embodiment, the data backup and recovery device for the production environment database further includes: an encryption module, configured to encrypt and/or compress the backup message data to obtain the corresponding backup data.

In an optional implementation of this embodiment, the target data determination module 340 is specifically configured to read the backup data corresponding to the target backup task, decrypt the backup data, obtain a decrypted data file, and Segmenting the decrypted data file according to the task nodes to obtain the segmented files corresponding to each task node;

Assembling each of the split files to obtain a database statement;

The target data is restored according to each database statement.

In an optional implementation of this embodiment, the backup log records include at least one of the following:

Task ID, Version, Time, and Status fields.

The data backup and restoration device of the production environment database provided by the embodiment of the present invention can execute the data backup and restoration method of the production environment database provided by any embodiment of the present invention, and has corresponding functional modules and beneficial effects for executing the method.

Embodiment Four

FIG. 4 shows a schematic structural diagram of an electronic device 10 that can be used to implement an embodiment of the present invention. Electronic device is intended to represent various forms of digital computers, such as laptops, desktops, workstations, personal digital assistants, servers, blade servers, mainframes, and other suitable computers. Electronic devices may also represent various forms of mobile devices, such as personal digital processing, cellular phones, smart phones, wearable devices (eg, helmets, glasses, watches, etc.), and other similar computing devices. The components shown herein, their connections and relationships, and their functions, are by way of example only, and are not intended to limit implementations of the embodiments of the invention described and/or claimed herein.

As shown in FIG. 4, the electronic device 10 includes at least one processor 11, and a memory connected in communication with the at least one processor 11, such as a read-only memory (ROM) 12, a random access memory (RAM) 13, etc., wherein the memory stores There is a computer program executable by at least one processor, and the processor 11 can operate according to a computer program stored in a read-only memory (ROM) 12 or loaded from a storage unit 18 into a random access memory (RAM) 13. Various appropriate actions and processes are performed. In the RAM 13, various programs and data necessary for the operation of the electronic device 10 are also stored. The processor 11 , ROM 12 , and RAM 13 are connected to each other through a bus 14 . An input/output (I/O) interface 15 is also connected to the bus 14 .

Multiple components in the electronic device 10 are connected to the I/O interface 15, including: an input unit 16, such as a keyboard, a mouse, etc.; an output unit 17, such as various types of displays, speakers, etc.; a storage unit 18, such as a magnetic disk, an optical disk etc.; and a communication unit 19, such as a network card, a modem, a wireless communication transceiver, and the like. The communication unit 19 allows the electronic device 10 to exchange information/data with other devices through a computer network such as the Internet and/or various telecommunication networks.

Processor 11 may be various general and/or special purpose processing components having processing and computing capabilities. Some examples of processor 11 include, but are not limited to, central processing units (CPUs), graphics processing units (GPUs), various dedicated artificial intelligence (AI) computing chips, various processors that run machine learning model algorithms, digital signal processing processor (DSP), and any suitable processor, controller, microcontroller, etc. The processor 11 executes various methods and processes described above, for example, a data backup and recovery method for a production environment database.

In some embodiments, the data backup and recovery method for the production environment database can be implemented as a computer program, which is tangibly contained in a computer-readable storage medium, such as the storage unit 18 . In some embodiments, part or all of the computer program may be loaded and/or installed on the electronic device 10 via the ROM 12 and/or the communication unit 19 . When the computer program is loaded into the RAM 13 and executed by the processor 11, one or more steps of the method for data backup and restoration of the production environment database described above can be executed. Alternatively, in other embodiments, the processor 11 may be configured in any other appropriate way (for example, by means of firmware) to execute the data backup and recovery method for the production environment database.

Various implementations of the systems and techniques described above herein can be implemented in digital electronic circuit systems, integrated circuit systems, field programmable gate arrays (FPGAs), application specific integrated circuits (ASICs), application specific standard products (ASSPs), systems on chips Implemented in a system of systems (SOC), load programmable logic device (CPLD), computer hardware, firmware, software, and/or combinations thereof. These various embodiments may include being implemented in one or more computer programs executable and/or interpreted on a programmable system including at least one programmable processor, the programmable processor Can be special-purpose or general-purpose programmable processor, can receive data and instruction from storage system, at least one input device, and at least one output device, and transmit data and instruction to this storage system, this at least one input device, and this at least one output device an output device.

Computer programs for implementing the methods of the embodiments of the present invention can be written in any combination of one or more programming languages. These computer programs can be provided to a processor of a general-purpose computer, a special-purpose computer, or other programmable data processing apparatus, so that the computer program causes the functions/operations specified in the flowcharts and/or block diagrams to be implemented when executed by the processor. A computer program may execute entirely on the machine, partly on the machine, as a stand-alone software package partly on the machine and partly on a remote machine or entirely on the remote machine or server.

In the context of embodiments of the present invention, a computer-readable storage medium may be a tangible medium that may contain or store a computer program for use by or in conjunction with an instruction execution system, apparatus, or device . A computer readable storage medium may include, but is not limited to, electronic, magnetic, optical, electromagnetic, infrared, or semiconductor systems, apparatus, or devices, or any suitable combination of the foregoing. Alternatively, a computer readable storage medium may be a machine readable signal medium. More specific examples of machine-readable storage media would include one or more wire-based electrical connections, portable computer discs, hard drives, random access memory (RAM), read only memory (ROM), erasable programmable read only memory (EPROM or flash memory), optical fiber, compact disk read only memory (CD-ROM), optical storage, magnetic storage, or any suitable combination of the foregoing.

In order to provide interaction with the user, the systems and techniques described herein can be implemented on an electronic device having a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display)) for displaying information to the user. monitor); and a keyboard and pointing device (eg, a mouse or a trackball) through which the user can provide input to the electronic device. Other kinds of devices can also be used to provide interaction with the user; for example, the feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and can be in any form (including Acoustic input, speech input or, tactile input) to receive input from the user.

The systems and techniques described herein can be implemented in a computing system that includes back-end components (e.g., as a data server), or a computing system that includes middleware components (e.g., an application server), or a computing system that includes front-end components (e.g., as a a user computer having a graphical user interface or web browser through which a user can interact with embodiments of the systems and techniques described herein), or including such backend components, middleware components, Or any combination of front-end components in a computing system. The components of the system can be interconnected by any form or medium of digital data communication, eg, a communication network. Examples of communication networks include: local area networks (LANs), wide area networks (WANs), blockchain networks, and the Internet.

A computing system can include clients and servers. Clients and servers are generally remote from each other and typically interact through a communication network. The relationship of client and server arises by computer programs running on the respective computers and having a client-server relationship to each other. The server can be a cloud server, also known as a cloud computing server or a cloud host. It is a host product in the cloud computing service system to solve the problems of difficult management and weak business expansion in traditional physical hosts and VPS services. defect.

It should be understood that steps may be reordered, added or deleted using the various forms of flow shown above. For example, the steps described in the embodiments of the present invention may be executed in parallel, sequentially, or in a different order, as long as the expected results of the technical solutions of the embodiments of the present invention can be achieved, no limitation is imposed herein.

The above specific implementation manners do not constitute a limitation to the scope of protection of the embodiments of the present invention. It should be apparent to those skilled in the art that various modifications, combinations, sub-combinations and substitutions may be made depending on design requirements and other factors. Any modifications, equivalent replacements and improvements made within the spirit and principles of the embodiments of the present invention shall be included within the protection scope of the embodiments of the present invention.

Claims (10)

1. A data backup and recovery method of a production environment database is applied to a data backup and recovery system, and the data backup and recovery system comprises the following steps: the task relay is in communication connection with each task executor; characterized in that the method comprises:

determining a target task executor corresponding to a target backup task by the task relay in response to the target backup task initiated by a target user and aiming at target data in a production environment database;

acquiring a user identification of the target user through the target task executor, and creating a backup log record corresponding to the target backup task according to the user identification;

acquiring each target data in a production environment database according to the backup log record, and assembling each target data to obtain a backup data message;

and responding to a target recovery task initiated by a target user and aiming at target data in a production environment database, unpacking the data message, and recovering to obtain each target data.

2. The method of claim 1, further comprising, prior to responding to a target user initiated target backup task for target data in the production environment database:

assembling each metadata in the production environment database based on a preset rule;

wherein, the preset rule is: extensible markup language schema document specification XSD.

3. The method of claim 1, wherein the determining a target task executor corresponding to the target backup task comprises:

generating a target task corresponding to the target backup task, and adding the target task to a task queue;

acquiring the target task from a task queue, and determining the resource consumption of the target task;

and determining the target task executor according to the resource consumption of the target task.

4. The method of claim 3, wherein the generating a target task corresponding to the target backup task comprises:

directly generating a target task corresponding to the target backup task according to the target backup task;

or,

intercepting the target backup task, extracting a user access identifier of the target backup task, and performing service access arbitration according to the user access identifier;

generating a target task corresponding to the target backup task under the condition that the service access arbitration passes;

otherwise, an error is returned.

5. The method of claim 1, further comprising, after obtaining each target data in a production environment database according to the backup log record and assembling each target data to obtain a backup data packet:

and encrypting and/or compressing the backup data message to obtain backup data corresponding to the target backup task.

6. The method according to claim 5, wherein said unpacking said data message and recovering each of said target data in response to a target recovery task initiated by a target user for target data in a production environment database comprises:

reading backup data corresponding to the target backup task, decrypting the backup data to obtain decrypted data files, and dividing the decrypted data files according to task nodes to obtain divided files corresponding to each task node;

assembling each divided file to obtain a database statement;

and recovering the target data according to each database statement.

7. The method of claim 1, wherein the backup log record comprises at least one of:

task identity, version, time, and status fields.

8. A data backup and recovery device of a production environment database is applied to a data backup and recovery system, and the data backup and recovery system comprises: the task relay is in communication connection with each task executor; characterized in that the device comprises:

the task executor determining module is used for determining a target task executor corresponding to a target backup task initiated by a target user and aiming at target data in a production environment database through the task repeater;

the backup log record creation module is used for acquiring the user identification of the target user through the target task executor and creating a backup log record corresponding to the target backup task according to the user identification;

the backup data message determining module is used for acquiring each target data in the production environment database according to the backup log record, and assembling each target data to obtain a backup data message;

and the target data determining module is used for responding to a target recovery task initiated by a target user and aiming at target data in the production environment database, unpacking the data message and recovering to obtain each target data.

9. An electronic device, the electronic device comprising:

at least one processor; and

a memory communicatively coupled to the at least one processor; wherein,,

the memory stores a computer program executable by the at least one processor to enable the at least one processor to perform the data backup restoration method of the production environment database of any one of claims 1-7.

10. A computer readable storage medium storing computer instructions for causing a processor to perform the method of recovering data backup of a production environment database according to any one of claims 1-7.