Unlock instant, AI-driven research and patent intelligence for your innovation.

MariaDB Galera Cluster method for automatically recovering power failure

An automatic recovery and node technology, which is applied in the field of cloud platform basic database, can solve problems such as time-consuming and labor-intensive, does not meet the construction requirements, and the database cluster function cannot be automatically restored.

Active Publication Date: 2017-06-13
WUHAN FIBERHOME INFORMATION INTEGRATION TECH CO LTD
View PDF5 Cites 10 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In order to ensure the high efficiency of cloud platform operation, MariaDB Galera Cluster is widely used nowadays. MariaDB Galera Cluster is a synchronous multi-master cluster of MariaDB database. Manual intervention is required to restore the database cluster, which is time-consuming and laborious, and does not meet the construction needs of the automated society advocated today

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
  • MariaDB Galera Cluster method for automatically recovering power failure

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0016] The present invention will be described in further detail below in conjunction with the accompanying drawings.

[0017] see figure 1 As shown, the present invention provides a method for automatically restoring a power-off MariaDB Galera Cluster, which is used to restore services of a MariaDB Galera Cluster that is powered off and powered on again. MariaDB Galera Cluster is a multi-master read-write database cluster. MariaDB Galera Cluster is a synchronous multi-master cluster of MariaDB database. MariaDB database is a branch of MySQL, which is a relational database management system. The present invention comprises the following steps:

[0018] Step S1: After the nodes of MariaDB Galera Cluster are powered off and powered on, report the status IDs of all nodes to the service discovery cluster through the startup script. In this embodiment, the service discovery cluster is the Etcd service discovery cluster;

[0019] Step S2: After confirming that the status IDs of al...

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 MariaDB Galera Cluster method for automatically recovering power failure. A MariaDB Galera Cluster is a synchronous multi-master cluster of a MariaDB and relates to the field of a basic database of a cloud platform. The method comprises the steps of reporting state IDs of all nodes to a service discovery cluster after the nodes of the MariaDB Galera Cluster are powered-off and powered-on; traversing the state IDs of the nodes, judging whether a value of a current state ID is a maximum value in values of the state IDs of all the nodes or not, and if yes, starting a service of the node corresponding to the current state ID, otherwise, performing skipping; and after the service of the node corresponding to the state ID with the maximum value is started, starting services of all other nodes. According to the method, the services of the basic database of the cloud platform can be quickly recovered.

Description

technical field [0001] The invention relates to the field of cloud platform basic databases, in particular to a method for automatically restoring a power-off MariaDBGalera Cluster. Background technique [0002] The database is the basic component of the cloud platform. How to ensure the high reliability of the database is a project that needs to be focused on in the construction of the cloud platform. In order to ensure the high efficiency of cloud platform operation, MariaDB Galera Cluster is widely used nowadays. MariaDB Galera Cluster is a synchronous multi-master cluster of MariaDB database. Manual intervention is required to restore the database cluster, which is time-consuming and laborious, and does not meet the construction needs of the automated society advocated today. Contents of the invention [0003] Aiming at the defects in the prior art, the purpose of the present invention is to provide a method for automatically recovering a power-down MariaDB Galera Clu...

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
IPC IPC(8): G06F11/14G06F17/30
CPCG06F11/1479G06F16/25
Inventor 陈林祥田松
Owner WUHAN FIBERHOME INFORMATION INTEGRATION TECH CO LTD