Remote database disaster recovery backup method and device

Abstract

The invention discloses a remote database disaster recovery backup method and device and relates to the field of network security. The method comprises the steps of A, a source database is monitored,and monitored data changes are packaged into records to be written into a buffer; B, records in the buffer are asynchronously sent to a plurality of remote one-stage databases, and data changes are replayed in the one-stage databases; C, changes of the remote one-stage databases are monitored and copied to a plurality of remote two-stage databases, and accordingly, multipoint backup of a local database is realized. According to the method, the local database is monitored in real time, the monitored data changes are packaged into the records to be written into the buffer, then the records in the mass buffer are asynchronously sent to the plurality of remote one-stage databases simultaneously, and the changes of the remote one-stage databases are monitored and copied to the plurality of remote two-stage databases, so that the database data viability is improved greatly, and the method has the advantages that the real-time performance is good, the backup fineness is fine, the implementation and deployment are simple and flexible and the like.

Description

Technical field [0001] The invention belongs to the field of network security, and particularly relates to a remote database disaster tolerance backup method and device. Background technique [0002] With the continuous advancement of the social informatization process, the information systems of enterprises and institutions increasingly rely on databases, and most of the key data are stored in the database. The loss or damage of database data will bring immeasurable losses to enterprises and institutions. How to prevent database data loss and damage has attracted more and more attention, and database disaster recovery is becoming a hot research topic in the field of information security. [0003] At present, the research on disaster recovery and remote replication technology is mainly concentrated in foreign countries. The disaster recovery products or technologies they provide generally require dedicated lines or fiber channels, which are expensive; the backup granularity is rel...

AI Technical Summary

Problems solved by technology

[0005] The purpose of the present invention is to provide a remote database disaster recovery backup method and device, by monitoring the local database in real time, the monitored data changes are packaged into records, written into the buffer, and then the records in the massive buffer are asynchronously Send to multiple remote level 1 databases, and replay data changes on these level 1 databases, and the data changes in level 1 databases will be monitored and copied to multiple remote level 2 databases, which solves the existing backup line requirements It is relatively high, expensive, has many restrictions on distance, and the backup granularity is relatively thick, so it has great limitations when applied to database disaster recovery.

Images