WO2020248375A1

WO2020248375A1 - Method and system for synchronizing data between databases, computer device and storage medium

Info

Publication number: WO2020248375A1
Application number: PCT/CN2019/102843
Authority: WO
Inventors: 刘益伟; 杨茂星
Original assignee: 平安科技（深圳）有限公司
Priority date: 2019-06-14
Filing date: 2019-08-27
Publication date: 2020-12-17
Also published as: CN110347747A

Abstract

Provided in the embodiments of the present application is a method for synchronizing data between databases. The method comprises the following steps: by means of acquiring a data operation instruction and parsing the data operation instruction, obtaining a table name of a data table included in the data operation instruction, wherein the data operation instruction is an SQL sentence-based instruction; determining whether a data table matching the table name exists in a preset synchronizing record table; if the data table matching the table name exists in the preset synchronizing record table, recording incremental data generated by a data processing service executed according to the data operation instruction; and regularly synchronizing the incremental data to a target database. Further provided in the embodiments of the present application are a system for synchronizing data between databases, a computer device and a non-volatile computer storage medium. The embodiments of the present application can improve the extensibility of a system and reduce the development cost.

Description

Data synchronization method, system, computer equipment and storage medium between databases

This application claims the priority of a Chinese patent application filed with the Chinese Patent Office on June 14, 2019, the application number is 201910513290.2, and the invention title is "Data synchronization method, system, computer equipment and storage medium between databases". The reference is incorporated in this application.

Technical field

The embodiments of the present application relate to the field of data processing technology, and in particular, to a method, system, computer device, and storage medium for data synchronization between databases.

Background technique

In the prior art, when realizing data synchronization between various systems, the synchronization between systems is generally achieved by customizing and developing tables to be synchronized between the systems. However, the inventor realized that when a system needs to synchronize data with multiple other systems, it is necessary to customize and develop tables to be synchronized between multiple systems to achieve data synchronization between the system and multiple systems. This implementation method Trivial and insufficient flexibility.

Summary of the invention

In view of this, the purpose of the embodiments of the present application is to provide a data synchronization method, system, computer device, and non-volatile computer-readable storage medium between databases, which can increase the scalability of the system and reduce development costs.

To achieve the foregoing objective, an embodiment of the present application provides a data synchronization method between databases, which includes the following steps:

Acquiring a data operation instruction, and analyzing the data operation instruction to obtain a table name of a data table included in the data operation instruction, where the data operation instruction is an instruction based on a SQL statement;

Judging whether there is a data table matching the table name in the preset synchronization record table;

If it exists, record the incremental data generated by the data processing service executed according to the data operation instruction; and

Synchronize the incremental data to the target database regularly.

To achieve the foregoing objective, an embodiment of the present application also provides a computer device, including a memory, a processor, and computer-readable instructions stored in the memory and running on the processor, and the processor executes the computer-readable instructions. The steps of the method for data synchronization between databases as described above are implemented when instructed.

In order to achieve the above objective, the embodiments of the present application also provide a non-volatile computer-readable storage medium. The non-volatile computer-readable storage medium stores computer-readable instructions, and the computer-readable instructions may Is executed by at least one processor, so that the at least one processor executes the steps of the method for data synchronization between databases as described above.

The method, system, computer equipment, and non-volatile computer-readable storage medium for data synchronization between databases provided by the embodiments of the present application acquire data operation instructions and analyze the data operation instructions to obtain the data operation instructions. The table name of the included data table, the data operation instruction is an instruction based on the SQL statement; it is judged whether there is a data table matching the table name in the preset synchronization record table; if it exists, the record is based on the data The incremental data generated by the data processing service executed by the operation instruction; and the incremental data is periodically synchronized to the target database, so that the scalability of the system can be increased and the development cost can be reduced.

Description of the drawings

FIG. 1 is a schematic diagram of the implementation process of the first embodiment of the data synchronization method between databases of this application.

FIG. 2 is a detailed flow diagram of the steps of obtaining data operation instructions in this application and analyzing the data operation instructions to obtain the table names of the data tables included in the data operation instructions.

FIG. 3 is a detailed flow diagram of the step of synchronizing the incremental data to the target database regularly in this application.

4 is a schematic diagram of the implementation process of the second embodiment of the method for data synchronization between databases of this application.

FIG. 5 is a schematic diagram of program modules of a data synchronization system between databases according to an embodiment of this application.

FIG. 6 is a schematic diagram of the hardware structure of a computer device according to an embodiment of the application.

Detailed ways

In order to make the purpose, technical solutions, and advantages of this application clearer, the following further describes this application in detail with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the application, and not used to limit the application. Based on the embodiments in this application, all other embodiments obtained by those of ordinary skill in the art without creative work shall fall within the protection scope of this application.

Referring to FIG. 1, it shows a flowchart of a method for data synchronization between databases in the first embodiment of the present application. It can be understood that the flowchart in this method embodiment is not used to limit the order of execution of the steps. The following is an exemplary description with an inter-database data synchronization system (hereinafter referred to as “synchronization system” for short) as the execution subject, and the synchronization system can be applied to computer equipment. details as follows:

Step S100: Obtain a data operation instruction, and parse the data operation instruction to obtain a table name of a data table included in the data operation instruction. The data operation instruction is an instruction based on a SQL statement.

Specifically, the synchronization system may obtain data operation instructions sent by the user equipment, and the data operation instructions may include data addition instructions, data deletion instructions, data modification instructions, and so on. After receiving the data operation instruction, the synchronization system may further execute data processing services according to the data operation instructions. The data processing services may include data addition services, data deletion services, data modification services, etc. to the database. For example, if the data operation instruction is a data modification instruction, the synchronization system modifies the corresponding data in the database according to the data modification instruction.

In this embodiment, after receiving the data operation instruction, the synchronization system can also parse the data operation instruction to obtain the data table information involved in the data operation instruction. The data table information includes the table name of the data table. .

It should be noted that the data operation instruction in the embodiment of the present application is an instruction based on a SQL (Structured Query Language) statement, that is, the data operation instruction is an SQL statement.

Further, referring to FIG. 2, in an embodiment, the step of obtaining a data operation instruction and analyzing the data operation instruction to obtain the table name of the data table included in the data operation instruction includes:

Step S200, intercept the data operation instruction through the mybtis interceptor, and obtain the SQL statement in the data operation instruction; and

Step S202: parse the SQL statement to extract the table name of the data table included in the SQL statement.

Specifically, the synchronization system can call the mybtis interceptor to intercept the data operation instruction, thereby capturing the SQL statement in the data operation instruction. After the SQL statement is captured, the SQL statement can be further analyzed to extract the SQL statement The data table information includes the table name of the data table.

In the implementation of the invention, when the table name of the data table contained in the data operation instruction does not need to be obtained, the mybtis interceptor can be shielded.

Step S102: Determine whether there is a data table matching the table name in the preset synchronization record table.

Specifically, the synchronization record table is a data table that needs to be synchronized in each data table of the source database. The synchronization record table can be set according to business requirements. For example, if the current business requirement is to synchronize the modified data in data table A and data table B in the source database, the synchronization record table can be set to include Data table A and data table B, that is, only the modified data in data table A and data table B need to be synchronized in the future, and the data in other data tables does not need to be synchronized; if the current business requirement is to synchronize the source database , You can set the synchronization record table to include all data tables in the source database, that is, as long as the data in the source database is modified subsequently, the modified data must be synchronized.

In the specific judgment process, the obtained table name and the table name of each data table contained in the synchronization record table can be compared with the obtained table name one by one to determine whether the synchronization record table exists and The data table whose table name matches.

Step S104, if it exists, record the incremental data generated by the data processing service executed according to the data operation instruction.

Specifically, when there is a data table matching the table name, it indicates that the data processing service executed by the data operation instruction needs to be synchronized. Therefore, when there is a data table that matches the table name, the synchronization system needs to record the incremental data generated by the data processing service executed according to the data operation instruction. The incremental data includes the SQL statement corresponding to the data operation instruction and the data table information, database information, etc. involved in the SQL statement.

Step S106: Synchronize the incremental data to the target database regularly.

Specifically, the synchronization system regularly synchronizes incremental data to the target database, for example, synchronizes all incremental data to the target database every 1 minute. The target database is the database to which the data in the source database is to be synchronized, and there may be multiple target databases, for example, database A, database B, database C, and so on.

In this embodiment, when the incremental data is synchronized, the SQL statement contained in the incremental data can be executed in the target database, thereby achieving data synchronization.

It is understandable that in order to synchronize the incremental data in the source data to the target database, the address of the target database needs to be maintained in the source database in advance.

The method for data synchronization between databases proposed in this embodiment of the application obtains data operation instructions and parses the data operation instructions to obtain the table name of the data table included in the data operation instruction. It is an instruction based on SQL statement; it is determined whether there is a data table matching the table name in the preset synchronization record table; if it exists, it records the incremental data generated by the data processing service executed according to the data operation instruction ; And regularly synchronize the incremental data to the target database, which can increase the scalability of the system and reduce development costs.

Further, referring to FIG. 3, in an embodiment, the step of periodically synchronizing the incremental data to the target database includes:

Step S300: Determine the incremental data that currently needs to be synchronized.

Specifically, because the incremental data is synchronized at regular intervals, it is necessary to determine the incremental data recorded in this synchronization cycle before the data synchronization is performed, and the incremental data recorded in this synchronization cycle It is the incremental data recorded between the time stamp of the last synchronization cycle and the time stamp of this synchronization cycle. For example, the time stamp of the last synchronization cycle is 15:12:10, and the time stamp of this synchronization cycle is 15:13:10, it is between 15:12:10 and 15:13:10 The incremental data recorded in the time period is the incremental data that needs to be synchronized currently.

Step S302: Obtain the first data table associated with each incremental data.

Specifically, each incremental data is associated with a first data table, and the first data table associated with different incremental data may be the same or different.

Step S304: Determine the address information of the target database corresponding to each incremental data according to the first data table.

Specifically, a mapping table between each first data table and the target database is pre-stored in the synchronization system, and the mapping table includes the corresponding relationship between each first data table and the target database, and the address information of each target database. The address information Including the IP address and port number of the target server. In this embodiment, each first data table may correspond to one target database, or may correspond to multiple target databases. For example, data table a corresponds to target database B, data table b corresponds to target database C and target database D, and so on.

Step S306: Synchronize each incremental data to the corresponding target database according to the address information.

Specifically, after obtaining the address information, the synchronization system can synchronize the incremental data to the corresponding target database through the address of the target server.

Further, in an embodiment, after the step of synchronizing each incremental data to the corresponding target database according to the address information, the method further includes:

Receiving the data synchronization result returned by the corresponding target database; and

If the data synchronization result is that the synchronization is successful, a corresponding flag is set for the synchronized incremental data.

Specifically, after receiving the incremental data, the target database executes the SQL statement in the incremental data, thereby achieving data synchronization. After the target database performs the data synchronization operation, it will feed back a data synchronization result to the synchronization system. After receiving the synchronization result, the synchronization system parses the synchronization result, and then can determine that the target database is checking the data according to the parsed synchronization result Whether the data synchronization was successfully completed during synchronization. When it is determined that the data synchronization result is a successful synchronization, you can set identification information for the incremental data that has been synchronized, such as setting the “complete” flag or the “1” flag to Indicates that the incremental data has completed data synchronization. In this embodiment, by setting the corresponding identifier, it is possible to avoid multiple repeated synchronization operations on the same amount of data.

In another embodiment of the present application, after the target database receives the incremental data, it continuously executes the SQL statement in the incremental data several times (for example, 3 times), and the data synchronization is still not achieved, then the synchronization can be fed back The failed synchronization result is sent to the synchronization system. After receiving the synchronization result, the synchronization system parses the synchronization result, and then can determine whether the target database successfully completes the data synchronization when synchronizing the data according to the parsed synchronization result. When it is determined that the data synchronization result is a synchronization failure, a notification message is sent to the preset user. The notification message can be sent by email or by SMS. The preset user is preferably a maintenance person of the target server.

Further, in another embodiment, when the data synchronization of the incremental data is successfully completed, the synchronized incremental data may be stored in the historical data table as a record. In this embodiment, by storing the successfully synchronized incremental data in the historical data table, it is convenient to troubleshoot the problem based on the data in the historical data table when a problem occurs later.

Refer to FIG. 4, which is a schematic diagram of the implementation process of the second embodiment of the data synchronization method between databases of the present application. In this embodiment, according to different requirements, the execution order of the steps in the flowchart shown in FIG. 4 can be changed, and some steps can be omitted. The following exemplarily describes an inter-database data synchronization system (hereinafter referred to as “synchronization system” for short) as the execution subject, and the synchronization system can be applied to a server. details as follows:

Step S400: Set a data record range corresponding to the data processing service, and add the data record range to the synchronization record table.

Specifically, the data record range corresponding to the data processing service can be set according to business requirements, and the data record range is specifically which data tables in the source database need to be synchronized. The data recording range can be set in advance, or can be set later based on user input information. For example, if the user needs to synchronize the data table a in the source database, the user can input the information corresponding to the data table a to the synchronization system. After receiving the input information, the synchronization system sets the data table a according to the input information. Data logging range.

After setting the data record range, add the data record range to the synchronization record table.

Step S402: Obtain a data operation instruction, and parse the data operation instruction to obtain a table name of a data table included in the data operation instruction. The data operation instruction is an instruction based on a SQL statement.

Step S404: Determine whether there is a data table matching the table name in the preset synchronization record table;

Step S406, if it exists, record the incremental data generated by the data processing service executed according to the data operation instruction.

Step S408: Synchronize the incremental data to the target database regularly.

The foregoing steps S402-S408 are similar to steps S100-S106, and will not be repeated in this embodiment.

In the method for data synchronization between databases proposed in the embodiments of the present application, by setting the data record range corresponding to the data processing service, the system has good scalability.

Please refer to FIG. 5, which shows a schematic diagram of program modules of an inter-database data synchronization system 500 (hereinafter referred to as "synchronization system" 500) according to an embodiment of the present application. In this embodiment, the synchronization system 500 may include or be divided into one or more program modules, and the one or more program modules are stored in a storage medium and executed by one or more processors to complete the application , And can realize the above-mentioned data synchronization method between databases. The program module referred to in the embodiments of the present application refers to an instruction segment of a series of computer-readable instructions capable of completing specific functions, and is more suitable for describing the execution process of the data synchronization method between databases in the storage medium than the program itself. The following description will specifically introduce the functions of each program module in this embodiment:

The obtaining module 501 is configured to obtain a data operation instruction, and parse the data operation instruction to obtain a table name of a data table included in the data operation instruction, and the data operation instruction is an instruction based on a SQL statement.

Specifically, the obtaining module 501 may obtain a data operation instruction sent by a user equipment, and the data operation instruction may include a data addition instruction, a data deletion instruction, a data modification instruction, and so on. After receiving the data operation instruction, the acquisition module 501 may further execute data processing services according to the data operation instructions. The data processing services may include data addition services, data deletion services, data modification services, etc., to the database. For example, if the data operation instruction is a data modification instruction, the acquisition module 501 modifies the corresponding data in the database according to the data modification instruction.

In this embodiment, after receiving the data operation instruction, the acquisition module 501 can also parse the data operation instruction to obtain the data table information involved in the data operation instruction. The data table information includes the table of the data table. name.

Further, in one embodiment, the step of obtaining the data operation instruction and analyzing the data operation instruction to obtain the table name of the data table included in the data operation instruction includes: checking all the data through the mybtis interceptor. The data operation instruction is intercepted, and the SQL statement in the data operation instruction is obtained; and used to parse the SQL statement to extract the table name of the data table contained in the SQL statement.

Specifically, the acquisition module 501 can call the mybtis interceptor to intercept the data operation instruction, thereby capturing the SQL statement in the data operation instruction. After the SQL statement is captured, the SQL statement can be further parsed to extract the SQL statement The data table information in the data table information contains the table name of the data table.

The judging module 502 is configured to judge whether there is a data table matching the table name in the preset synchronization record table.

The recording module 503 is configured to record the incremental data generated by the data processing service executed according to the data operation instruction when there is a data table matching the table name.

Specifically, when there is a data table matching the table name, it indicates that the data processing service executed by the data operation instruction needs to be synchronized. Therefore, when there is a data table matching the table name, the recording module 503 needs to record the incremental data generated by the data processing service executed according to the data operation instruction. The incremental data includes the SQL statement corresponding to the data operation instruction and the data table information, database information, etc. involved in the SQL statement.

The synchronization module 504 is configured to periodically synchronize the incremental data to the target database.

Specifically, the synchronization module 504 periodically synchronizes the incremental data to the target database, for example, synchronizes all the incremental data to the target database every 1 minute. The target database is the database to which the data in the source database is to be synchronized, and there may be multiple target databases, for example, database A, database B, database C, etc.

The data synchronization system between databases proposed in this embodiment of the application obtains the data operation instruction and parses the data operation instruction to obtain the table name of the data table included in the data operation instruction. It is an instruction based on SQL statement; it is determined whether there is a data table matching the table name in the preset synchronization record table; if it exists, it records the incremental data generated by the data processing service executed according to the data operation instruction ; And regularly synchronize the incremental data to the target database, which can increase the scalability of the system and reduce development costs.

Further, in an embodiment, the step of periodically synchronizing the incremental data to the target database includes:

Step 1. Determine the incremental data that currently needs to be synchronized.

Step 2: Obtain the first data table associated with each incremental data.

Step 3: Determine the address information of the target database corresponding to each incremental data according to the first data table.

Step 4. Synchronize each incremental data to the corresponding target database according to the address information.

In another embodiment of the present application, the synchronization system 500 further includes:

The setting module is used to set the data record range corresponding to the data processing service, and add the data record range to the synchronization record table.

Specifically, the data record range corresponding to the data processing service can be set according to business requirements, and the data record range is specifically which data tables in the source database need to be synchronized. The data recording range can be set in advance, or can be set later based on user input information. For example, if the user needs to synchronize the data table a in the source database, the user can input the information corresponding to the data table a into the setting module of the synchronization system. After receiving the input information, the setting module will use the input information Set the data recording range.

Refer to FIG. 6, which is a schematic diagram of the hardware architecture of a computer device 600 according to an embodiment of the present application. In this embodiment, the computer device 600 is a device that can automatically perform numerical calculation and/or information processing according to pre-set or stored instructions. As shown in the figure, the computer device 600 at least includes, but is not limited to, a memory 601, a processor 602, a network interface 603, and a data synchronization system 604 between databases that can communicate with each other through a system bus. among them:

In this embodiment, the memory 601 includes at least one type of non-volatile computer-readable storage medium. The readable storage medium includes flash memory, hard disk, multimedia card, card-type memory (for example, SD or DX memory, etc.), Random access memory (RAM), static random access memory (SRAM), read only memory (ROM), electrically erasable programmable read only memory (EEPROM), programmable read only memory (PROM), magnetic memory, magnetic disk, optical disk Wait. In some embodiments, the memory 601 may be an internal storage unit of the computer device 600, such as a hard disk or memory of the computer device 600. In other embodiments, the memory 601 may also be an external storage device of the computer device 600, such as a plug-in hard disk, a smart memory card (Smart Media Card, SMC), and a secure digital (Secure Digital, SD) card, flash card (Flash Card), etc. Of course, the memory 601 may also include both the internal storage unit of the computer device 600 and its external storage device. In this embodiment, the memory 601 is generally used to store the operating system and various application software installed in the computer device 600, such as the program code of the data synchronization system 604 between databases. In addition, the memory 601 can also be used to temporarily store various types of data that have been output or will be output.

The processor 602 may be a central processing unit (Central Processing Unit, CPU), a controller, a microcontroller, a microprocessor, or other data processing chips in some embodiments. The processor 602 is generally used to control the overall operation of the computer device 600. In this embodiment, the processor 602 is configured to run the program code or process data stored in the memory 601, for example, to run the inter-database data synchronization system 604 to implement the inter-database data synchronization method in each of the foregoing embodiments.

The network interface 603 may include a wireless network interface or a wired network interface, and the network interface 603 is generally used to establish a communication connection between the computer device 600 and other electronic devices. For example, the network interface 603 is used to connect the computer device 600 to an external terminal through a network, and to establish a data transmission channel and a communication connection between the computer device 600 and the external terminal. The network may be an intranet (Intranet), the Internet (Internet), a global system of mobile communications (Global System of Mobile) communication, GSM), Wideband Code Division Multiple Access (Wideband Code Division Multiple Access, WCDMA), 4G network, 5G network, Bluetooth (Bluetooth), Wi-Fi and other wireless or wired networks.

It should be pointed out that FIG. 6 only shows a computer device 600 with components 601-604, but it should be understood that it is not required to implement all the components shown, and more or fewer components may be implemented instead.

In this embodiment, the inter-database data synchronization system 604 stored in the memory 601 can also be divided into one or more program modules, and the one or more program modules are stored in the memory 601 and consist of one Or executed by multiple processors (processor 602 in this embodiment) to complete the data synchronization method between databases of this application.

This embodiment also provides a non-volatile computer-readable storage medium, such as flash memory, hard disk, multimedia card, card-type memory (for example, SD or DX memory, etc.), random access memory (RAM), static random access memory ( SRAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), programmable read-only memory (PROM), magnetic memory, magnetic disk, optical disk, server, App application mall, etc., on which storage There are computer-readable instructions, and the corresponding functions are realized when the program is executed by the processor. The non-volatile computer-readable storage medium of this embodiment is used to store the inter-database data synchronization system 500 or 604, so as to implement the following steps when executed by a processor:

Synchronize the incremental data to the target database regularly.

The serial numbers of the foregoing embodiments of the present application are only for description, and do not represent the advantages and disadvantages of the embodiments.

Through the description of the above embodiments, those skilled in the art can clearly understand that the method of the above embodiments can be implemented by means of software plus the necessary general hardware platform. Of course, it can also be implemented by hardware, but in many cases the former is better.的实施方式。

The above are only preferred embodiments of this application, and do not limit the scope of this application. Any equivalent structure or equivalent process transformation made using the content of the description and drawings of this application, or directly or indirectly used in other related technical fields , The same reason is included in the scope of patent protection of this application.

Claims

A method for data synchronization between databases includes the following steps:

Acquiring a data operation instruction, and analyzing the data operation instruction to obtain a table name of a data table included in the data operation instruction, where the data operation instruction is an instruction based on a SQL statement;

Judging whether there is a data table matching the table name in the preset synchronization record table;

If it exists, record the incremental data generated by the data processing service executed according to the data operation instruction; and

Synchronize the incremental data to the target database regularly.
The method for data synchronization between databases according to claim 1, wherein the method for data synchronization between databases further comprises:

Set a data record range corresponding to the data processing service, and add the data record range to the synchronization record table.
The method for data synchronization between databases according to claim 1, wherein the step of obtaining a data operation instruction and analyzing the data operation instruction to obtain the table name of the data table included in the data operation instruction comprises:

Intercept the data operation instruction through the mybtis interceptor, and obtain the SQL statement in the data operation instruction; and

The SQL statement is parsed to extract the table name of the data table contained in the SQL statement.
3. The method for data synchronization between databases according to claim 2, wherein the step of obtaining a data operation instruction and analyzing the data operation instruction to obtain the table name of the data table included in the data operation instruction comprises:

Intercept the data operation instruction through the mybtis interceptor, and obtain the SQL statement in the data operation instruction; and

The SQL statement is parsed to extract the table name of the data table contained in the SQL statement.
8. The method for data synchronization between databases according to claim 1, wherein the step of regularly synchronizing the incremental data to the target database comprises:

Determine the incremental data that currently needs to be synchronized;

Acquiring the first data table associated with each incremental data;

Determining the address information of the target database corresponding to each incremental data according to the first data table; and

Synchronize each incremental data to the corresponding target database according to the address information.
3. The method for data synchronization between databases according to claim 2, wherein the step of regularly synchronizing the incremental data to the target database comprises:

Determine the incremental data that currently needs to be synchronized;

Acquiring the first data table associated with each incremental data;

Determining the address information of the target database corresponding to each incremental data according to the first data table; and

Synchronize each incremental data to the corresponding target database according to the address information.
8. The method for data synchronization between databases according to claim 5, after the step of synchronizing each incremental data to the corresponding target database according to the address information, the method further comprises:

Receiving the data synchronization result returned by the corresponding target database; and

If the data synchronization result is that the synchronization is successful, a corresponding flag is set for the synchronized incremental data.
7. The method for data synchronization between databases according to claim 6, after the step of synchronizing each incremental data to the corresponding target database according to the address information, further comprising:

Receiving the data synchronization result returned by the corresponding target database; and

If the data synchronization result is that the synchronization is successful, a corresponding flag is set for the synchronized incremental data.
8. The method for data synchronization between databases according to claim 7, after the step of receiving the data synchronization result returned by the corresponding target database, further comprising:

If the result of the data synchronization is that the synchronization fails, a notification message is sent to the preset user.
8. The method for data synchronization between databases according to claim 8, after the step of receiving the data synchronization result returned by the corresponding target database, further comprising:

If the result of the data synchronization is that the synchronization fails, a notification message is sent to the preset user.
8. The method for data synchronization between databases according to claim 7, wherein the method for data synchronization between databases further comprises:

Store the synchronized incremental data in the historical data table.
8. The method for data synchronization between databases according to claim 8, wherein the method for data synchronization between databases further comprises:

Store the synchronized incremental data in the historical data table.
A data synchronization system between databases, including:

The acquisition module is used to acquire a data operation instruction, and parse the data operation instruction to obtain the table name of the data table contained in the data operation instruction, and the data operation instruction is an instruction based on a SQL statement;

The judgment module is used to judge whether there is a data table matching the table name in the preset synchronization record table;

The recording module is used to record the incremental data generated by the data processing service executed according to the data operation instruction if there is a data table matching the table name; and

The synchronization module is used to periodically synchronize the incremental data to the target database.
The data synchronization system between databases according to claim 13, wherein the data synchronization system between databases further comprises:

The setting module is used to set the data record range corresponding to the data processing service, and add the data record range to the synchronization record table.
The data synchronization system between databases according to claim 13, wherein the acquisition module is also used to intercept the data operation instruction through the mybtis interceptor, and to acquire the SQL statement in the data operation instruction; and The SQL statement is parsed to extract the table name of the data table contained in the SQL statement.
The data synchronization system between databases according to claim 14, wherein the acquisition module is also used to intercept the data operation instruction through the mybtis interceptor, and obtain the SQL statement in the data operation instruction; and The SQL statement is parsed to extract the table name of the data table contained in the SQL statement.
A computer device includes a memory, a processor, and computer readable instructions stored on the memory and running on the processor, and the processor executes the following steps when the processor executes the computer readable instructions:

Acquiring a data operation instruction, and analyzing the data operation instruction to obtain a table name of a data table included in the data operation instruction, where the data operation instruction is an instruction based on a SQL statement;

Judging whether there is a data table matching the table name in the preset synchronization record table;

If it exists, record the incremental data generated by the data processing service executed according to the data operation instruction; and

Synchronize the incremental data to the target database regularly.
17. The computer device of claim 17, wherein the processor further executes the following steps when executing the computer-readable instructions:

Set a data record range corresponding to the data processing service, and add the data record range to the synchronization record table.
17. The computer device of claim 17, wherein the processor further executes the following steps when executing the computer-readable instructions:

Intercept the data operation instruction through the mybtis interceptor, and obtain the SQL statement in the data operation instruction; and

The SQL statement is parsed to extract the table name of the data table contained in the SQL statement.
A non-volatile computer-readable storage medium, the non-volatile computer-readable storage medium stores computer-readable instructions, the computer-readable instructions can be executed by at least one processor, so that the at least one The processor performs the following steps:

Acquiring a data operation instruction, and analyzing the data operation instruction to obtain a table name of a data table included in the data operation instruction, where the data operation instruction is an instruction based on a SQL statement;

Judging whether there is a data table matching the table name in the preset synchronization record table;

If it exists, record the incremental data generated by the data processing service executed according to the data operation instruction; and

Synchronize the incremental data to the target database regularly.