CN117891661A - Data backup method, device, electronic device and readable storage medium - Google Patents

Abstract

The invention provides a data backup method, a device, an electronic device and a readable storage medium, comprising the following steps: receiving a first response signal used for representing that the logic replication relationship between each machine in the main machine room and each machine in the standby machine room is established, wherein the logic replication relationship is used for representing the mapping relationship between a first main node of each machine in the standby machine room and a second mirror node of each machine in the main machine room; decoding the data change in the second mirror image node of each machine in the main machine room based on the logic replication relationship, and modifying the data in the first main node in the standby machine room according to the decoding result; and if the host computer room fails, controlling a first main node in the standby computer room to respond to a first target request, wherein the first target request is a data request for requesting data stored in the main computer room. The invention solves the problem that real-time backup cannot be performed during cross-machine room data backup.

Description

Data backup method, device, electronic device and readable storage medium

Technical Field

The present invention relates to the field of data processing technology, and in particular to a data backup method, device, electronic device and readable storage medium.

Background technique

Greenplum database is a distributed database management system with a large-scale parallel processing architecture. The characteristic of Greenplum database is that data is stored in different nodes of different machines in the cluster, and the data volume is generally large. However, when a computer room fails, the existing full backup solution requires a certain backup cycle, so it is impossible to achieve real-time backup, which increases the gap between the data in the backup computer room and the data in the main computer room.

Summary of the invention

In view of this, the embodiments of the present invention provide a data backup method, device, electronic device and readable storage medium to solve the problem that real-time backup is not possible when backing up data across computer rooms.

According to one aspect of the present invention, a data backup method is provided, which is applied to a management node in a Greenplum database system. The Greenplum database system further includes a main computer room and a backup computer room. Each machine in the main computer room and the backup computer room includes a first master node and a second mirror node. The second mirror node is a mirror node of the first master node of other machines. The method includes:

receiving a first response signal, the first response signal being used to indicate that a logical replication relationship between each machine in the main machine room and each machine in the standby machine room has been established, the logical replication relationship being used to indicate a mapping relationship between a first master node of each machine in the standby machine room and a second mirror node of each machine in the main machine room;

Based on the logical replication relationship, the data changes in the second mirror node of each machine in the main computer room are decoded, and the data in the first main node in the standby computer room is modified according to the decoding results;

If a failure occurs in the main computer room, the first master node in the standby computer room is controlled to respond to the first target request, wherein the first target request is a data request for data stored in the main computer room.

Optionally, before receiving the first response signal, the method further includes:

receiving a first instruction, the first instruction being a signal for establishing a logical replication relationship between each machine in the standby computer room and each machine in the main computer room;

In response to the first instruction, the data objects and changes therein in the second mirror node of each machine in the main computer room are copied to the first main node of each machine in the corresponding standby computer room.

Optionally, after receiving the first response signal, the method further includes:

receiving a first newly added signal, where the first newly added signal is a signal of newly added data in the second mirror node of each machine in the main computer room;

In response to the first new signal, the new data in the second mirror node of each machine in the main computer room is copied to the first main node in the standby computer room.

Optionally, before receiving the first response signal, the method further includes:

receiving a second instruction, where the second instruction is a signal for establishing a replication relationship between the second mirror node and the first master node;

In response to the first instruction, the data in the first main node of each machine in the main computer room is copied to the corresponding second mirror node;

receiving a second newly added signal, where the second newly added signal is a signal for changing data in a first main node of each machine in the main computer room;

In response to the second new addition signal, the data object corresponding to the change signal and its changes are copied to the second mirror master node of each machine in the main computer room.

Optionally, after the data in the first main node of each machine in the main computer room is copied to the corresponding second mirror node in response to the first instruction, the method further includes:

If the first main node of any machine in the main computer room fails, the corresponding second mirror node is controlled to respond to the second target request, wherein the second target request is a data request requesting the first main node to store data.

According to a second aspect of the present invention, a data backup device is provided, which is applied to a management node in a Greenplum database system. The Greenplum database system further includes a main computer room and a backup computer room. Each machine in the main computer room and the backup computer room includes a first master node and a second mirror node. The second mirror node is a mirror node of the first master node of other machines. The device includes:

A first receiving module is used to receive a first response signal, the first response signal is used to indicate that a logical replication relationship between each machine in the main computer room and each machine in the standby computer room has been established, and the logical replication relationship is used to indicate a mapping relationship between a first master node of each machine in the standby computer room and a second mirror node of each machine in the main computer room;

The first processing module decodes the data changes in the second mirror node of each machine in the main computer room based on the logical replication relationship, and modifies the data in the first main node in the standby computer room according to the decoding result;

The first control module controls the first master node in the standby computer room to respond to the first target request if a failure occurs in the main computer room, wherein the first target request is a data request for storing data in the main computer room.

Optionally, the data backup device further includes:

A second receiving module is used to receive a first instruction, where the first instruction is a signal for establishing a logical replication relationship between each machine in the standby computer room and each machine in the main computer room;

The second processing module, in response to the first instruction, copies the data objects and changes thereof in the second mirror nodes of each machine in the main computer room to the first main nodes of each machine in the corresponding standby computer room.

Optionally, the data backup device further includes:

A third receiving module is used to receive a first newly added signal, where the first newly added signal is a newly added signal of data in the second mirror node of each machine in the main computer room;

The third processing module, in response to the first new signal, copies the new data in the second mirror node of each machine in the main computer room to the first main node in the standby computer room.

According to a third aspect of the present invention, there is provided an electronic device, comprising:

Processor; and

Memory for storing programs,

The program includes instructions, and when the instructions are executed by a processor, the processor executes any one of the methods according to the first aspect of the present invention.

According to a fourth aspect of the present invention, there is provided a non-transitory computer-readable storage medium storing computer instructions, wherein the computer instructions are used to cause a computer to execute any method according to the first aspect of the present invention.

One or more technical solutions provided in the embodiments of the present application are based on the logical replication relationship established between the first master node in the standby computer room and the second mirror node in the main computer room. When the data of the second mirror node in the main computer room changes, the data change is decoded, and the addition, deletion and modification are performed on the first master node in the standby computer room according to the decoding result, so as to achieve a real-time, incremental backup effect without backing up all historical data every time. And based on the characteristic that the second mirror node, as a mirror node of the first master node, does not need to participate in the operation, the data objects and their changes in the second mirror node in the main computer room are copied to the first master node in the standby computer room, which will not affect the performance of the first master node in the main computer room. This solution makes full use of the characteristics of the Greenplum database and the logical replication algorithm to achieve a real-time cross-computer room backup effect and minimize the data loss caused by computer room-level failures.

BRIEF DESCRIPTION OF THE DRAWINGS

Further details, features and advantages of the invention are disclosed in the following description of exemplary embodiments in conjunction with the accompanying drawings, in which:

FIG1 shows a flow chart of a data backup method according to an exemplary embodiment of the present invention;

FIG2 shows a cross-machine room structure diagram of a data backup method according to an exemplary embodiment of the present invention;

FIG3 shows a schematic block diagram of a data backup device according to an exemplary embodiment of the present invention;

FIG. 4 shows a block diagram of an exemplary electronic device that can be used to implement an embodiment of the present invention.

Detailed ways

Embodiments of the present invention will be described in more detail below with reference to the accompanying drawings. Although certain embodiments of the present invention are shown in the accompanying drawings, it should be understood that the present invention can be implemented in various forms and should not be construed as being limited to the embodiments described herein, which are instead provided for a more thorough and complete understanding of the present invention. It should be understood that the drawings and embodiments of the present invention are only for exemplary purposes and are not intended to limit the scope of protection of the present invention.

It should be understood that the various steps described in the method embodiments of the present invention may be performed in different orders and/or in parallel. In addition, the method embodiments may include additional steps and/or omit the steps shown. The scope of the present invention is not limited in this respect.

The term "including" and its variations used in this document are open inclusions, that is, "including but not limited to". The term "based on" means "based at least in part on". The term "one embodiment" means "at least one embodiment"; the term "another embodiment" means "at least one other embodiment"; the term "some embodiments" means "at least some embodiments". Relevant definitions of other terms will be given in the following description. It should be noted that the concepts of "first", "second", etc. mentioned in the present invention are only used to distinguish different devices, modules or units, and are not used to limit the order or interdependence of the functions performed by these devices, modules or units.

It should be noted that the modifications of "one" and "plurality" mentioned in the present invention are illustrative rather than restrictive, and those skilled in the art should understand that unless otherwise clearly indicated in the context, it should be understood as "one or more".

The names of the messages or information exchanged between multiple devices in the embodiments of the present invention are only used for illustrative purposes, and are not used to limit the scope of these messages or information.

The following describes the solution of the present invention with reference to the accompanying drawings, and explains the technical solution provided by the embodiments of the present application in detail through specific embodiments and their application scenarios.

In existing cross-datacenter backup scenarios, full backup is often used. Each backup requires clearing and then synchronizing the historical full data. Therefore, when facing a large amount of data, the backup data synchronization time will be very long. It will also miss the changes in data during the backup, making it impossible for the backup data center to maintain data consistency with the main data center. Therefore, the existing cross-datacenter backup solution cannot meet the purpose of real-time backup.

In view of this, the present invention provides a data backup method, device, electronic device and readable storage medium, wherein the data backup method is applied to any electronic device with data backup function, and the electronic device includes but is not limited to: personal mobile terminal device, computer or server device, etc.

As shown in FIG. 1 , FIG. 1 is a flow chart of a data backup method provided in an embodiment of the present application. The data backup method is applied to a management node in a Greenplum database system. The Greenplum database system further includes a main computer room and a backup computer room. Each machine in the main computer room and the backup computer room includes a first master node and a second mirror node. The second mirror node is a mirror node of the first master node of other machines. The data backup method may include the following steps S101 to S103:

S101, receiving a first response signal, wherein the first response signal is used to indicate that a logical replication relationship between each machine in the main computer room and each machine in the backup computer room has been established, and the logical replication relationship is used to indicate a mapping relationship between a first master node of each machine in the backup computer room and a second mirror node of each machine in the main computer room.

As an implementation method, the Greenplum database system adopts a distributed database cluster architecture to facilitate the provision of large amounts of data storage and computing functions. The Greenplum database system includes a main computer room and a backup computer room. Both the main computer room and the backup computer room contain several machines. Each machine includes a first master node and a second mirror node. The second mirror node serves as a mirror node of the first master node in other machines and is used to replicate the data in the corresponding first master node. If the first master node and the second mirror node are not in the same machine, it can be ensured that when a machine fails, the corresponding second mirror node, which is the first master node in the current failed machine, can replace the first master node to respond to data requests for the first master node.

A logical replication relationship between each machine in the main machine room and each machine in the standby machine room in the Greenplum database system is established in advance, so that the data objects and changes in the second mirror node of each machine in the main machine room are replicated to the first master node of each machine in the standby machine room. At the same time, the management node in the Greenplum database system receives a response signal that the logical replication relationship between each machine in the main machine room and each machine in the standby machine room has been established.

As a specific implementation method, as shown in Figure 2, computer room A is used as the main computer room, and computer room B is used as the backup computer room of computer room A. When computer room A fails, the management node in the Greenplum database system controls computer room B to respond to data requests for data stored in computer room A. The main computer room and the backup computer room are also called Internet data centers IDCs.

The cluster data of computer room A and computer room B are stored in multiple machines such as machine 1, machine 2...machine n. There are multiple postgresql data instances on each machine. The postgresql data instances in each machine are divided into the first primary node primary and the second mirror node mirror. The first primary node primary is the node that actually executes the calculation, and the second mirror node mirror is the mirror node of the first primary node of other machines.

S102, based on the logical replication relationship, decode the data changes in the second mirror node of each machine in the main computer room, and modify the data in the first main node in the standby computer room according to the decoding result.

As an implementation method, based on the logical replication relationship between the first master node of each machine in the standby computer room and the second mirror node of each machine in the main computer room, a configuration file of the logical replication relationship is generated at the management node in the Greenplum database system. When performing logical replication, the logical replication relationship recorded in the configuration file is read to perform logical replication.

When the management node in the Greenplum database system learns that the data of the second mirror node in the main computer room has changed, it decodes the change and performs modifications on the first master node in the standby computer room according to the decoding result, so that the data in the first master node in the standby computer room is kept consistent with the data in the second mirror node in the main computer room in real time, achieving the replication effect of real-time backup across computer rooms. There is no need to back up all the data again, and the backup is only performed based on data changes, which also achieves the replication effect of incremental backup across computer rooms. Among them, the modifications performed on the first master node in the standby computer room will be performed in the time sequence of the data changes in the second mirror node in the main computer room, thereby ensuring the consistency of logical replication.

As a specific implementation method, when publishing the node data of the second mirror node mirror in computer room A, the stand-alone postgresql database in computer room B is used for subscription to realize the logical replication between the second mirror node mirror and the stand-alone postgresql database. For each second mirror node mirror, a non-repeated postgressql database is used for subscription. When the node data of the second mirror node mirror in computer room A changes, the management node in the Greenplum database system decodes the data changes in the second mirror node, determines the first master node in the corresponding standby computer room according to the configuration file, and modifies the data in the first master node in the standby computer room according to the decoding result.

The number of machines in the standby computer room is not less than the number of machines in the main computer room, and each machine in the main computer room corresponds to a machine in the standby computer room. When performing cross-computer room backup, the standby computer room needs to be able to store the number of machines of all the data in the main computer room.

S103: If a failure occurs in the main computer room, control the first master node in the backup computer room to respond to a first target request, wherein the first target request is a data request for storing data in the main computer room.

As an implementation method, when the management node in the Greenplum database system receives an instruction of a main computer room failure, it controls the first master node in the standby computer room to replace the main computer room to respond to the first target request, thereby ensuring the normal operation of the Greenplum database system. The main computer room failure refers to hardware failure, software failure, virus failure, human failure and false failure in the main computer room.

In one embodiment of the present application, before receiving the first response signal, the method further includes:

S101a, receiving a first instruction, where the first instruction is a signal for establishing a logical replication relationship between each machine in the standby computer room and each machine in the main computer room;

S101b, in response to the first instruction, copy the data objects and changes thereof in the second mirror node of each machine in the main computer room to the corresponding first main node of each machine in the standby computer room.

As an implementation method, a logical replication relationship is established between the first master node of each machine in the standby computer room and the second mirror node of each machine in the main computer room, wherein logical replication is a method of replicating data objects and their changes according to the replica identity of the data object. After receiving the signal for establishing the logical replication relationship between each machine in the standby computer room and each machine in the main computer room, the management node in the Greenplum database system replicates the data objects and their changes in the second mirror node of each machine in the main computer room to the corresponding first master node of each machine in the standby computer room.

As a specific implementation method, as shown in FIG2 , a logical replication relationship is established between the first master node of each machine in the standby computer room and the second mirror node of each machine in the main computer room, wherein the first master node pg1 is a stand-alone postgresql database built on machine 2 in computer room B, as the first master node of the machine, and the first master node pg2 is a stand-alone postgresql database built on machine n in computer room B, as the first master node of the machine. Through the management node in the Greenplum database system, the logical replication relationship between the second mirror node mirror1 in computer room A and the first master node pg1 in computer room B is set in a one-to-one cycle manner, and the logical replication relationship between the second mirror node mirror2 in computer room A and the first master node pg2 in computer room B is set..., and so on. It is also possible to set it in a random deployment manner through the management node in the Greenplum database system, generate a configuration file for the logical replication relationship according to the setting, and read the logical replication relationship recorded in the configuration file for logical replication when performing logical replication.

In one embodiment of the present application, after receiving the first response signal, the method further includes:

S101c, receiving a first newly added signal, where the first newly added signal is a signal of newly added data in the second mirror node of each machine in the main computer room;

S101d, in response to the first new signal, copy the new data in the second mirror node of each machine in the main computer room to the first main node in the standby computer room.

As an implementation method, based on the logical replication relationship between the first master node of each machine in the standby computer room and the second mirror node of each machine in the main computer room, when data is added to the second mirror node of each machine in the main computer room and a new signal is generated, the management node in the Greenplum database system copies the data corresponding to the new signal to the first master node of the corresponding standby computer room, without the need to copy all the data, thus avoiding the problem of low backup efficiency.

The data corresponding to the newly added signal is copied to the first master node of the corresponding standby computer room by using the incremental backup method. Incremental backup means that after a full backup or the last incremental backup, each subsequent backup only needs to back up the content that has been added or modified compared to the previous one. This backup method achieves real-time, incremental data backup. Compared with full backup, it does not need to back up all historical data every time, so the backup efficiency is guaranteed and no data loss will occur during disaster recovery. Compared with full backup, it is better in terms of real-time performance, efficiency and recovery of data loss. At the same time, it will also reduce the workload during logical replication and improve backup efficiency.

In one embodiment of the present application, before receiving the first response signal, the method further includes:

S101e, receiving a second instruction, where the second instruction is a signal for establishing a replication relationship between the second mirror node and the first master node;

S101f, in response to the first instruction, copying the data in the first main node of each machine in the main computer room to the corresponding second mirror node;

S101g, receiving a second newly added signal, where the second newly added signal is a signal of data change in the first master node of each machine in the main computer room;

S101h: In response to the second added signal, the data object corresponding to the change signal and its changes are copied to the second mirror master node of each machine in the main computer room.

As an implementation method, the consistency of the second mirror node mirror and the first primary node primary is synchronized through the streaming replication method. The streaming replication method is that the first primary node continuously sends the transaction log xlog, and the second mirror node as the mirror node continuously receives the transaction log xlog of computer room A, and continuously replays the process of maintaining data synchronization.

Since the second mirror node mirror has the same data and transaction log xlog as the first primary node primary, the release based on the second mirror node mirror will not cause data loss. The second mirror node mirror will not perform operations when the cluster is running normally, and is only used as a mirror of the first primary node primary. Therefore, the release based on the second mirror node mirror will basically have no impact on the performance of the original cluster. In addition, in order to ensure that when the first primary node fails, the corresponding second mirror node can be controlled to respond to data requests, the first primary node and its corresponding second mirror node are not in the same machine.

As a specific implementation method, the management node in the Greenplum database system sets the mirroring relationship between the first primary node primary1 in machine 1 and the second mirror node mirror2 in machine 2, the mirroring relationship between the first primary node primary2 in machine 2 and the second mirror node mirror3 in machine 3, and so on in a one-to-one cycle manner. The management node in the Greenplum database system can also set the mirroring relationship between the first primary node primary in machine 1 and the second mirror nodes mirror in other idle machines in a random deployment manner, so that the first primary node and the second mirror node are not in the same machine, ensuring that when any machine fails, the corresponding second mirror node as the first primary node in the current failed machine can replace the first primary node to respond to data requests for the first primary node.

In one embodiment of the present application, after the data in the first main node of each machine in the main computer room is copied to the corresponding second mirror node in response to the first instruction, the method further includes:

S101i, if the first main node of any machine in the main computer room fails, control the corresponding second mirror node to respond to the second target request, wherein the second target request is a data request requesting the first main node to store data.

As a specific implementation method, when the first primary node primary in computer room A fails, the second mirror node mirror serves as the mirror node of the first primary node primary, and the management node in the Greenplum database system controls its second mirror node mirror to replace the first primary node primary and respond to data requests requesting the first primary node to store data.

The data backup method provided in the embodiment of the present application is based on the logical replication relationship established between the first master node in the standby computer room and the second mirror node in the main computer room. When the data of the second mirror node in the main computer room changes, the data change is decoded, and the addition, deletion and modification are performed on the first master node in the standby computer room according to the decoding result, so as to achieve a real-time, incremental backup effect without backing up all historical data every time. And based on the characteristic that the second mirror node, as a mirror node of the first master node, does not need to participate in the operation, the data objects and their changes in the second mirror node in the main computer room are copied to the first master node in the standby computer room, which will not affect the performance of the first master node in the main computer room. This solution makes full use of the characteristics of the Greenplum database and the logical replication algorithm to achieve a real-time cross-computer room backup effect and minimize the data loss caused by computer room-level failures.

Corresponding to the above embodiment, referring to FIG. 3 , the embodiment of the present application further provides a data backup device 300, which is applied to a management node in a Greenplum database system. The Greenplum database system further includes a main computer room and a backup computer room. Each machine in the main computer room and the backup computer room includes a first master node and a second mirror node. The second mirror node is a mirror node of the first master node of other machines. The data backup device 300 includes:

A first receiving module 301 is used to receive a first response signal, wherein the first response signal is used to indicate that a logical replication relationship between each machine in the main computer room and each machine in the standby computer room has been established, and the logical replication relationship is used to indicate a mapping relationship between a first primary node of each machine in the standby computer room and a second mirror node of each machine in the main computer room;

The first processing module 302 decodes the data changes in the second mirror node of each machine in the main computer room based on the logical replication relationship, and modifies the data in the first main node in the standby computer room according to the decoding result;

The first control module 303 controls the first master node in the standby computer room to respond to a first target request if the main computer room fails, wherein the first target request is a data request for storing data in the main computer room.

Optionally, the data backup device 300 further includes:

The second receiving module 304 is used to receive a first instruction, where the first instruction is a signal for establishing a logical replication relationship between each machine in the standby computer room and each machine in the main computer room;

The second processing module 305, in response to the first instruction, copies the data objects and changes thereof in the second mirror node of each machine in the main computer room to the first main node of each machine in the corresponding standby computer room.

Optionally, the data backup device 300 further includes:

The third receiving module 306 is used to receive a first newly added signal, where the first newly added signal is a newly added signal of data in the second mirror node of each machine in the main computer room;

The third processing module 307, in response to the first new signal, copies the new data in the second mirror node of each machine in the main computer room to the first main node in the standby computer room.

Optionally, the data backup device 300 further includes:

A fourth receiving module 308, configured to receive a second instruction, where the second instruction is a signal for establishing a replication relationship between the second mirror node and the first master node;

The fourth processing module 309, in response to the first instruction, copies the data in the first main node of each machine in the main computer room to the corresponding second mirror node;

A fifth receiving module 310 is used to receive a second newly added signal, where the second newly added signal is a data change signal in the first master node of each machine in the main computer room;

The fifth processing module 311, in response to the second added signal, copies the data object corresponding to the change signal and its changes to the second mirror master node of each machine in the main computer room.

Optionally, the data backup device 300 further includes:

The second control module 312 controls the corresponding second mirror node to respond to a second target request if a first main node of any machine in the main computer room fails, wherein the second target request is a data request for requesting the first main node to store data.

The data backup device provided in the embodiment of the present application is based on the logical replication relationship established between the first master node in the standby computer room and the second mirror node in the main computer room. When the data of the second mirror node in the main computer room changes, the data change is decoded, and the addition, deletion and modification are performed on the first master node in the standby computer room according to the decoding result, so as to achieve a real-time, incremental backup effect without backing up all historical data every time. And based on the characteristic that the second mirror node, as a mirror node of the first master node, does not need to participate in the operation, the data objects and their changes in the second mirror node in the main computer room are copied to the first master node in the standby computer room, which will not affect the performance of the first master node in the main computer room. This solution makes full use of the characteristics of the Greenplum database and the logical replication algorithm to achieve a real-time cross-computer room backup effect and minimize the data loss caused by computer room-level failures.

The exemplary embodiment of the present invention also provides an electronic device, comprising: at least one processor; and a memory connected to the at least one processor in communication. The memory stores a computer program that can be executed by the at least one processor, and the computer program is used to cause the electronic device to perform the method according to the embodiment of the present invention when executed by the at least one processor.

Exemplary embodiments of the present invention also provide a non-transitory computer-readable storage medium storing a computer program, wherein the computer program, when executed by a processor of a computer, is used to cause the computer to perform a method according to an embodiment of the present invention.

An exemplary embodiment of the present invention further provides a computer program product, including a computer program, wherein the computer program is used to cause the computer to perform a method according to an embodiment of the present invention when executed by a processor of a computer.

With reference to Fig. 4, the structural block diagram of the electronic device 400 that can be used as the server or client of the present invention will now be described, which is an example of the hardware device that can be applied to various aspects of the present invention. The electronic device is intended to represent various forms of digital electronic computer equipment, such as laptop computers, desktop computers, workbenches, personal digital assistants, servers, blade servers, mainframe computers, and other suitable computers. The electronic device can also represent various forms of mobile devices, such as personal digital processing, cellular phones, smart phones, wearable devices and other similar computing devices. The components shown herein, their connections and relationships, and their functions are only used as examples, and are not intended to limit the implementation of the present invention described and/or required herein.

As shown in Figure 4, electronic device 400 includes a computing unit 401, which can perform various appropriate actions and processes according to a computer program stored in a read-only memory (ROM) 402 or a computer program loaded from a storage unit 408 into a random access memory (RAM) 403. In RAM 403, various programs and data required for the operation of electronic device 400 can also be stored. Computing unit 401, ROM 402 and RAM 403 are connected to each other via bus 404. Input/output (I/O) interface 405 is also connected to bus 404.

A plurality of components in the electronic device 400 are connected to the I/O interface 405, including: an input unit 406, an output unit 407, a storage unit 408, and a communication unit 409. The input unit 406 may be any type of device capable of inputting information to the electronic device 400, and the input unit 406 may receive input digital or character information, and generate key signal inputs related to user settings and/or function control of the electronic device. The output unit 407 may be any type of device capable of presenting information, and may include, but is not limited to, a display, a speaker, a video/audio output terminal, a vibrator, and/or a printer. The storage unit 408 may include, but is not limited to, a disk, an optical disk. The communication unit 409 allows the electronic device 400 to exchange information/data with other devices via a computer network such as the Internet and/or various telecommunication networks, and may include, but is not limited to, a modem, a network card, an infrared communication device, a wireless communication transceiver, and/or a chipset, such as a Bluetooth™ device, a WiFi device, a WiMax device, a cellular communication device, and/or the like.

The computing unit 401 may be a variety of general and/or special processing components with processing and computing capabilities. Some examples of the computing unit 401 include, but are not limited to, a central processing module (CPU), a graphics processing module (GPU), various dedicated artificial intelligence (AI) computing chips, various computing units running machine learning model algorithms, digital signal processors (DSPs), and any appropriate processors, controllers, microcontrollers, etc. The computing unit 401 performs the various methods and processes described above. For example, in some embodiments, the data backup method may be implemented as a computer software program, which is tangibly contained in a machine-readable medium, such as a storage unit 408. In some embodiments, part or all of the computer program may be loaded and/or installed on the electronic device 400 via the ROM 402 and/or the communication unit 409. In some embodiments, the computing unit 401 may be configured to perform the data backup method in any other appropriate manner (e.g., by means of firmware).

The program code for implementing the method of the present invention can be written in any combination of one or more programming languages. These program codes can be provided to a processor or controller of a general-purpose computer, a special-purpose computer or other programmable data backup device, so that the program code, when executed by the processor or controller, enables the functions/operations specified in the flow chart and/or block diagram to be implemented. The program code can be executed entirely on the machine, partially on the machine, partially on the machine and partially on a remote machine as a stand-alone software package, or entirely on a remote machine or server.

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

As used herein, the terms "machine-readable medium" and "computer-readable medium" refer to any computer program product, apparatus, and/or device (e.g., disk, optical disk, memory, programmable logic device (PLD)) for providing machine instructions and/or data to a programmable processor, including a machine-readable medium that receives machine instructions as a machine-readable signal. The term "machine-readable signal" refers to any signal for providing machine instructions and/or data to a programmable processor.

To provide interaction with a user, the systems and techniques described herein can be implemented on a computer having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to the user; and a keyboard and pointing device (e.g., a mouse or trackball) through which the user can provide input to the computer. Other types 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 input from the user can be received in any form (including acoustic input, voice input, or tactile input).

The systems and techniques described herein may 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., a user computer with a graphical user interface or a web browser through which a user can interact with implementations of the systems and techniques described herein), or a computing system that includes any combination of such back-end components, middleware components, or front-end components. The components of the system may be interconnected by any form or medium of digital data communication (e.g., a communications network). Examples of communications networks include: a local area network (LAN), a wide area network (WAN), and the Internet.

A computer system may include clients and servers. Clients and servers are generally remote from each other and usually interact through a communication network. The relationship of client and server is generated by computer programs running on respective computers and having a client-server relationship to each other.

Claims (10)

1. A data backup method, characterized in that the data backup method is applied to a management node in a Greenplum database system, the Greenplum database system further includes a main computer room and a backup computer room, each machine in the main computer room and the backup computer room includes a first master node and a second mirror node, the second mirror node is a mirror node of the first master node of other machines, the method comprising: receiving a first response signal, wherein the first response signal is used to indicate that a logical replication relationship between each machine in the main machine room and each machine in the standby machine room has been established, wherein the logical replication relationship is used to indicate a mapping relationship between a first master node of each machine in the standby machine room and a second mirror node of each machine in the main machine room; Based on the logical replication relationship, the data changes in the second mirror node of each machine in the main computer room are decoded, and the data in the first main node in the standby computer room is modified according to the decoding result; If the main computer room fails, the first master node in the standby computer room is controlled to respond to a first target request, wherein the first target request is a data request for storing data in the main computer room. 2. The data backup method according to claim 1, characterized in that before receiving the first response signal, it also includes: receiving a first instruction, wherein the first instruction is a signal for establishing a logical replication relationship between each machine in the standby computer room and each machine in the main computer room; In response to the first instruction, the data objects and changes therein in the second mirror node of each machine in the main computer room are copied to the corresponding first main node of each machine in the standby computer room. 3. The data backup method according to claim 1, characterized in that after receiving the first response signal, it further comprises: receiving a first newly added signal, where the first newly added signal is a newly added signal of data in a second mirror node of each machine in the main computer room; In response to the first new signal, the new data in the second mirror node of each machine in the main computer room is copied to the first main node in the standby computer room. 4. The data backup method according to claim 1, characterized in that before receiving the first response signal, it also includes: receiving a second instruction, where the second instruction is a signal for establishing a replication relationship between the second mirror node and the first master node; In response to the first instruction, copy the data in the first main node of each machine in the main computer room to the corresponding second mirror node; receiving a second newly added signal, where the second newly added signal is a signal for changing data in a first master node of each machine in the main computer room; In response to the second new signal, the data object corresponding to the change signal and its changes are copied to the second mirror master node of each machine in the main computer room. 5. The data backup method according to claim 4, characterized in that after the data in the first main node of each machine in the main computer room is copied to the corresponding second mirror node in response to the first instruction, it also includes: If the first main node of any machine in the main computer room fails, the corresponding second mirror node is controlled to respond to a second target request, wherein the second target request is a data request requesting the first main node to store data. 6. A data backup device, characterized in that the data backup device is applied to a management node in a Greenplum database system, the Greenplum database system further includes a main computer room and a backup computer room, each machine in the main computer room and the backup computer room includes a first master node and a second mirror node, the second mirror node is a mirror node of the first master node of other machines, and the device includes: A first receiving module, used to receive a first response signal, wherein the first response signal is used to indicate that a logical replication relationship between each machine in the main computer room and each machine in the standby computer room has been established, wherein the logical replication relationship is used to indicate a mapping relationship between a first primary node of each machine in the standby computer room and a second mirror node of each machine in the main computer room; A first processing module, based on the logical replication relationship, decodes the data changes in the second mirror node of each machine in the main computer room, and modifies the data in the first main node in the standby computer room according to the decoding result; The first control module controls the first master node in the standby computer room to respond to a first target request if the main computer room fails, wherein the first target request is a data request for storing data in the main computer room. 7. The data backup device according to claim 6, characterized in that the data backup device further comprises: A second receiving module is used to receive a first instruction, where the first instruction is a signal for establishing a logical replication relationship between each machine in the standby computer room and each machine in the main computer room; The second processing module, in response to the first instruction, copies the data objects and changes thereof in the second mirror node of each machine in the main computer room to the first main node of each machine in the corresponding standby computer room. 8. The data backup device according to claim 6, characterized in that the data backup device further comprises: A third receiving module is used to receive a first newly added signal, where the first newly added signal is a newly added signal of data in the second mirror node of each machine in the main computer room; The third processing module, in response to the first new signal, copies the new data in the second mirror node of each machine in the main computer room to the first main node in the standby computer room. 9. An electronic device comprising: Processor; and Memory for storing programs, The program includes instructions, which, when executed by the processor, cause the processor to perform the method according to any one of claims 1 to 5. 10. A non-transitory computer-readable storage medium storing computer instructions, wherein the computer instructions are used to cause a computer to execute the method according to any one of claims 1 to 5.