Mysql online migration system and method based on MHA

A technology for migrating systems and nodes, applied in the field of database management, can solve the problems of difficulty in mass migration of database nodes, inability to perform mass migration, and low efficiency, so as to avoid data inconsistency, ensure data consistency, and automate the degree of high effect

Active Publication Date: 2017-09-26
杭州铭师堂数字科技有限公司
View PDF5 Cites 8 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] (1) The operation is cumbersome: there are many migration steps and a long time
[0004] (2) Error-prone: During the migration process, the probability of errors is high
[0006] (4) Mass migration cannot be achieved: Due to the lack of automation and low efficiency, it is difficult to migrate database nodes in large quantities

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
  • Mysql online migration system and method based on MHA
  • Mysql online migration system and method based on MHA

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0047] The present invention will be described in further detail below in conjunction with the accompanying drawings and specific embodiments.

[0048] A kind of MHA-based mysql online migration system provided by the present invention, such as figure 1 As shown, it includes three units: MHA management node, mysql master-slave node and new slave node:

[0049] (1) MHA management node

[0050] Including MHA management module, online switching module and updating MHA configuration module, MHA management software package and node software package need to be deployed on this node, when it is necessary to switch the mysql main library, one-click operation can be realized through the MHA management node; when the mysql master-slave node When a change occurs, you need to change the MHA-related configuration to correctly detect the mysql master-slave status.

[0051] (2) mysql master-slave node

[0052] Including online data module and offline library module. From the mysql master...

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 discloses a mysql online migration system and method based on MHA. The system comprises an MHA management node, a mysql master slave node and a new slave node, wherein the MHA management node comprises an MHA management module, an online switching module and an MHA configuration updating module; the mysql master slave node comprises an online data setting module and an offline slave database module; the new slave node module comprises a slave database setting module. The mysql online migration system and method has the advantages that the method is simple in operation steps, mysql database node migration can be completed by several simple commands, and especially the migration of the mysql master database node is convenient and simple; high stability is achieved, errors can hardly occur, and migration quality is increased; data consistency is well guaranteed, and data inconsistency is avoided; high automation level is achieved, and work efficiency is increased; due to the fact that operation is simple, multiple mysql master slave clusters can be operated at the same time, and the online migration of multiple mysql database nodes is achieved.

Description

technical field [0001] The invention belongs to the technical field of database management and is mainly applied to online migration of mysql database nodes. Background technique [0002] For Internet companies, mysql databases are used more and more widely, and the availability of mysql database services is becoming more and more important. In the process of managing mysql database, it is often necessary to migrate database nodes. The traditional method of migrating database nodes has the following disadvantages: [0003] (1) The operation is cumbersome: the migration steps are numerous and the time is long. [0004] (2) Error-prone: During the migration process, the probability of errors is high. [0005] (3) Data inconsistency: After migration, the new database node data is inconsistent. [0006] (4) Mass migration cannot be achieved: Due to the lack of automation and low efficiency, it is difficult to migrate database nodes in large quantities. Contents of the inve...

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): G06F17/30
CPCG06F16/214G06F16/25G06F16/27
Inventor 顾伟涛
Owner 杭州铭师堂数字科技有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap