Database data synchronous parallel execution method and device based on asynchronous submission

Abstract

The embodiment of the invention provides a database data synchronous parallel execution method and device based on asynchronous submission. The method comprises the following steps: capturing and analyzing a transaction log of a source-end database in the source-end database, converting the analyzed transaction log of the source-end database into a transaction log in an internal message format, and sending the transaction log to a target-end data synchronization service for execution; Receiving and caching a transaction log in an internal message format at the target end data synchronization service, if a commit operation log of a transaction is received, activating a log execution thread, and executing submitted transaction operation in parallel; And asynchronously submitting the transaction, waking up and waiting for other transactions submitted by the transaction, continuing to execute disk refreshing submission, refreshing the current transaction operation log to the log file, andexecuting the database data synchronization transaction. According to the database data synchronization parallel execution method and device based on asynchronous submission provided by the embodimentof the invention, a data synchronization method of affairs can be executed in parallel during database data synchronization.

Description

technical field [0001] Embodiments of the present invention relate to the technical field of database data processing, and in particular to a method and device for synchronously and parallelly executing database data based on asynchronous submission. Background technique [0002] The traditional database-based master-backup mechanism realizes real-time replication of database data, which is an important solution for data disaster recovery and backup to ensure data security. At present, such as Oracle's DataGuard and Dameng Database's DM7 master and backup products are mature commercial products that realize this solution. Under the database master-backup mechanism, the standby machine is generally used as the backup node, and usually only provides read-only access. Some read-only access applications such as report analysis and data mining can be performed on the standby machine, but cannot provide read-write access like the main machine. In addition, the database master-bac...

AI Technical Summary

Problems solved by technology

If the target-side data replication software performs replication in strict accordance with the transaction operation log sequence in the source-side log stream, the consistency of data replication can be effectively guaranteed, but the replication efficiency will be very low, because the commit operation requires the database to copy the transaction operation log It can only be returned after flashing to the log file, a large amount of IO will slow down the synchronized data

Images