多点多跳的数据库异地容灾备份方法

为有效提高数据库数据的生存能力,提出了一种数据库异地容灾备份方法(MMDRB).该方法实时监控本地数据库,将监控到的数据变化封装成记录,写到海量缓存器中,然后异步地将海量缓存器中的记录同时发送给多个远程1级数据库,并在这些远程1级数据库上重放数据变化,而远程1级数据库的数据变化又将被监控并复制到多个远程2级数据库上,从而实现本地数据库数据的多点多跳容灾备份.该方法具有多点多跳备份、实时性好、备份粒度细、备份线路要求低等优点.理论分析和实验结果表明该方法是数据库异地容灾备份一种有效的新途径.

A Multi-point and Multi-hop Database Remote Backup Method

In order to improve the survivability of the database, a remote backup method(MMDRB) was presented. The local database was monitored in real time, and the data changes of it were encapsulated into records, which were put into a mass buffer. Then, records in the mass buffer were sent to several remote one-level databases asynchronously, and the data changes were replayed on the remote one-level databases. And also, the data changes of the remote one-level databases were monitored and replicated to several remote two-level databases. The multi-point and multi-hop remote backup of the local database was achieved. The proposed method had the features of multi-point and multi-hop backup, good real-time capability, fine backup granularity and low network requirement. The theoretical analysis and the experiment results showed that this method was a new good approach of database remote backup.