Method and equipment for realizing active and standby database synchronization through standby database

Abstract

The invention aims at providing a method and equipment for realizing active and standby database synchronization through a standby database. Concretely, a data updating log which is sent from an active database to the standby data base and includes corresponding complete data pages and data updating information is received; the data updating log is replayed. Compared with the prior art, the method and the equipment provided by the invention have the advantages that the data updating log which is sent from the active database to the standby database and includes the corresponding complete data pages and the data updating information is received; the data updating log is replayed; the complete data page in the data updating log and the data updating information are used for forming a new data page; an old data page in the standby database is covered; the problems that during the data synchronization of the active and standby databases, the updating log sent from the active database to the standby database can be combined for performing changing operation only after the standby database firstly reads the data page, so that the data page change of the standby database consumes long time are solved; the performance of the active and standby databases is improved; the standby database changing speed is accelerated.

Description

technical field [0001] The present application relates to the field of computers, and in particular to a technique for realizing synchronization of primary and secondary databases through standby databases. Background technique [0002] With the advent of the era of big data, the surge in data processing has led to the development of databases. Generally, the primary database and the standby database are used to jointly ensure the high reliability of the database. Synchronous mode is used for data backup between the main and standby databases. During the synchronization process of the main database and the standby database, the data changes of the main database need to be synchronized to the standby database. The cache area or disk of the database reads the data pages, and according to the log, makes corresponding changes to the read data pages of the standby database, and then re-stores them to the cache area or disk of the standby database for synchronization. [0003] Ho...

AI Technical Summary

Problems solved by technology

[0004] One purpose of this application is to provide a method and device for synchronizing the main and standby databases through the standby database, so as to solve the time-consuming problem of changing the data pages of the standby database when the main and standby databases are synchronizing data

[0005] In order to achieve the above object, according to one aspect of the present application, the present application provides a method for realizing the synchronization of the main and standby databases through the standby database. Time-consuming issues, the method involves:

Images