Remote disaster recovery method for high-availability MySQL

An off-site backup and off-site technology, applied in the field of data processing, can solve the problems of unavailability of backup and high delay, and achieve the effect of disaster recovery
CN112667440APending Publication Date: 2021-04-16紫光云技术有限公司
9 Cites 1 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
紫光云技术有限公司
Publication Date
2021-04-16

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
Patent Text Reader

Abstract

The invention provides a remote disaster recovery method for high-availability MySQL, which comprises a central control area, a data center A and a data center B. A set of MySQL instances of HA are deployed in the data center A, a set of single-node MySQL instances are deployed in the data center B, and a high-availability synchronization service Server and a synchronization service client are deployed in the central control area. The synchronization service Server and the data center A as well as the synchronization service client and the data center B are connected through a private network, the synchronization service Server simulates an interaction protocol of MySQL slave, disguises itself as MySQL slave and sends a dump protocol to the MySQL master, and the MySQL master receives a dump request, starts to push a binary log to the slave and sends the data to the synchronization service client. According to the remote disaster recovery method of the high-availability MySQL, real-time synchronization with low time delay or even without time delay can be achieved.
Need to check novelty before this filing date? Find Prior Art

Description

technical field

[0001] The invention belongs to the technical field of data processing, and in particular relates to a high-availability MySQL remote disaster recovery method. Background technique

[0002] With the development of business, users have higher and higher requirements for high availability of business systems. They are no longer satisfied with disaster recovery across availability zones. Users hope that even if a system in a certain region is unavailable, it can still be used Systems in other regions continue to provide services, which is cross-region disaster recovery. At present, the common remote disaster recovery methods are divided into two types: local master backup and remote disaster backup. Most of them are local master backup. Dual-machine hot backup) cannot effectively deal with unexpected downtime caused by data or software logic failures, such as human misoperation, network virus attacks, etc. Remote disaster backup is to place the main library and...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More