Heterogeneous database synchronization method and device, computer equipment and storage medium

Abstract

Embodiments of the invention disclose a heterogeneous database synchronization method and apparatus, computer equipment and a storage medium. The method comprises the following steps: obtaining database incremental data; packaging the incremental data of the database into target transmission data according to a preset custom packaging protocol; and transmitting the target transmission data to a heterogeneous database system, so that the target transmission data is synchronously transmitted in a plurality of databases in the heterogeneous database system. According to the embodiment of the invention, database incremental data is acquired, the database incremental data is packaged into target transmission data according to a preset custom packaging protocol, and the target transmission datais transmitted to a heterogeneous database system, so the target transmission data is synchronously transmitted by multiple databases in the heterogeneous database system, data conflicts possibly occurring in the data transmission process can be effectively avoided, final consistency of the data is achieved, version iterability of the bottom-layer database is improved, and replacement and migration of the database are facilitated.

Description

technical field [0001] Embodiments of the present invention relate to the technical field of data synchronization, in particular to a heterogeneous database synchronization method, device, computer equipment, and storage medium. Background technique [0002] With the development of network technology, the database tends to develop more and more in the direction of high availability. In some existing solutions, the data conflict resolution algorithm can be uniformly controlled by setting the proxy layer to hijack business access, that is, by invading the original database to quickly access the database. Local writing, but this solution is not universal and does not support heterogeneous databases. In other solutions, heterogeneous databases can be used, which can realize data sharing and transparent access. Several database systems already existed before joining the heterogeneous database system, with their own data array management system, external Each component of the dat...

AI Technical Summary

Problems solved by technology

[0003] However, for the one-master-multiple-slave mode, all write operations are completed at the master point, which will greatly depend on the network conditions between the business point and the master point. For example, in the process of global business deployment, when the business point When the data point is in Europe and the data point is in Asia, the data transmission between the business point and the data point will be affected by the quality of the network, resulting in the problem of long data transmission time

Images