Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

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

Pending Publication Date: 2021-04-16
紫光云技术有限公司
View PDF9 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

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 backup library in different places, and through cross- IDC synchronization, the disadvantage of this method is that the delay is high and real-time backup cannot be done

Method used

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
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Remote disaster recovery method for high-availability MySQL
  • Remote disaster recovery method for high-availability MySQL

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] It should be noted that, in the case of no conflict, the embodiments of the present invention and the features in the embodiments can be combined with each other.

[0028] In describing the present invention, it should be understood that the terms "center", "longitudinal", "transverse", "upper", "lower", "front", "rear", "left", "right", " The orientations or positional relationships indicated by "vertical", "horizontal", "top", "bottom", "inner" and "outer" are based on the orientations or positional relationships shown in the drawings, and are only for the convenience of describing the present invention and Simplified descriptions, rather than indicating or implying that the device or element referred to must have a particular orientation, be constructed and operate in a particular orientation, and thus should not be construed as limiting the invention. In addition, the terms "first", "second", etc. are used for descriptive purposes only, and should not be understood ...

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

PUM

No PUM Login to View More

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.

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

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F11/14G06F16/27G06F16/28
Inventor 王君
Owner 紫光云技术有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com