Self-starting recovery system and method for multiple main clusters of database
A recovery system and recovery method technology, applied in the field of database management, can solve problems such as poor timeliness and security, and achieve the effect of reducing risks and improving operation and maintenance efficiency
Active Publication Date: 2020-07-10
贵州新致普惠信息技术有限公司
View PDF10 Cites 2 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
This system and method aims to solve the problem of poor timeliness and security of the traditional database multi-master cluster system galera in the case of unplanned shutdown. Using the cluster_starter module can start the database nodes in no particular order without human intervention. The database cluster can Automatically start recovery, improve operation and maintenance efficiency, and reduce risks
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 moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0036] The present invention will be further described below through specific embodiments in conjunction with the accompanying drawings. These embodiments are only used to illustrate the present invention, and are not intended to limit the protection scope of the present invention.
[0037] The present invention provides a self-starting recovery system of a database multi-master cluster, such as figure 2 As shown, the system includes an odd number of nodes and communication components 6 connected to each node; in this embodiment, the system is provided with three nodes, node a, node b, and node c.
[0038] Each node includes the cluster_starter module 1 and the database multi-master cluster connected in sequence; the database multi-master cluster includes the database cluster system galera 2 and the open source database system mairadb 3.
[0039] Among them, such as image 3 As shown, the cluster_starter module 1 includes a database reading module 5 and a database starting m...
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
Login to View More Abstract
The invention discloses a self-starting recovery system for multiple main clusters of a database. The system comprises an odd number of nodes and communication assemblies connected with the nodes, wherein each node comprises a database recovery module and a database multi-master cluster which are connected in sequence; the cluster starting module comprises a database reading module and a databasestarting module; the database reading module reads the IP address and the starting sequence number of each node; the first end of the database starting module is connected with the database reading module, and the second end of the database starting module is connected with the communication assembly; the cluster negotiation is conducted according to the starting sequence number of each node, thestarting sequence numbers of all the nodes are obtained, the main node is determined and started, and self-starting recovery is completed. According to the method and the system, the problems of poortimeliness and safety of starting of a traditional database multi-master cluster system galera under the condition of non-planned shutdown are solved; by adopting the cluter_starter module, the database nodes can be opened in sequence without human intervention, and the database cluster can be automatically started and recovered, so the operation and maintenance efficiency is improved, and the risk is reduced.
Description
technical field [0001] The invention relates to the technical field of database management, in particular to a self-starting recovery system and method for a database multi-master cluster. Background technique [0002] The Galera Cluster cluster architecture is a system architecture that realizes multi-master and real-time data synchronization on the innodb storage engine. There is no need to separate read and write at the business level, and the read and write pressure of the database can be distributed to each database according to the established rules. node up. [0003] The open source database mariadb is a database software based on the innodb storage engine, but the database itself has no cluster function and cannot complete data synchronization of cluster nodes, so the multi-master database cluster system galera is needed to realize the database cluster function. [0004] In the cloud environment, the database management system branch MariaDB+database multi-master cl...
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
Login to View More IPC IPC(8): G06F11/14G06F16/21G06F16/27
CPCG06F11/1438G06F16/21G06F16/275
Inventor 郭玮张俊辉
Owner 贵州新致普惠信息技术有限公司