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

Database cluster recovery method based on Galera and terminal equipment

A recovery method and database technology, applied in the database field, can solve the problems that data cannot effectively synchronize data consistency, cannot meet usage scenarios, cannot detect fields, etc., so as to improve reliability and stability, and avoid residual files and topology structures. Simplified effect

Inactive Publication Date: 2020-07-03
安超云软件有限公司
View PDF6 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Although this prior art reveals the Galera MySQL database, in order to maintain data synchronization between control node A and control node B, it points out that it can be realized by means of heartbeat detection, but heartbeat detection can only detect the two-dimensional data of the third layer of the database. The data table (Table), but the field (Filed) of the fourth layer cannot be detected, because only the field can represent the uniqueness of the data
Therefore, the prior art has the defects that the data in the master-slave nodes cannot be effectively synchronized and the data consistency is not high due to the low degree of detection; at the same time, the technical solution disclosed by the prior art cannot satisfy the three or node More usage scenarios

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
  • Database cluster recovery method based on Galera and terminal equipment
  • Database cluster recovery method based on Galera and terminal equipment
  • Database cluster recovery method based on Galera and terminal equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0039] ginseng Figure 1 to Figure 4 A specific implementation manner of the disclosed Galera-based database cluster recovery method of the present invention.

[0040] In this embodiment, the synchronization operation is performed based on the recovery policy of the Galera cluster. ginseng figure 2 As shown, the Galera-based database cluster recovery method (hereinafter referred to as "recovery method" or "method") performs synchronization operations through the Galera cluster recovery strategy in an instance environment of a database cluster containing three database nodes. The database cluster includes two or more database nodes; specifically, in this embodiment, the database cluster includes three nodes, namely the database node 10, the database node 20, and the database node 30, and the database node 10 is deployed on the host 1 Among them, the database node 20 is deployed in the host 2, and the database node 30 is deployed in the host 3, and the hosts 1 to 3 can be und...

Embodiment 2

[0064] combine Figure 5 As shown, this embodiment discloses a specific implementation manner of a terminal device 100 .

[0065] In this embodiment, the terminal device 100 includes: a processor 51 , a storage device 52 , and a communication bus 53 establishing a communication connection between the processor 51 and the storage device 52 . The processor 51 is configured to execute one or more programs stored in the storage device 52, the programs being the Galera-based database cluster recovery method described in Embodiment 1. The storage device 52 is composed of a storage unit 521 to a storage unit 52i, and the parameter i is a positive integer greater than or equal to 1. The terminal device 100 can be understood as a computer, a cluster server, or a cloud platform.

[0066] For the specific technical solution of the Galera-based database cluster recovery method that the terminal device 100 relies on / includes disclosed in this embodiment, please refer to the description i...

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 database cluster recovery method based on Galera. The database cluster comprises two or more database nodes; when all the database nodes are not available, synchronous recovery is carried out through the method, and the method comprises the steps that all the database nodes are restarted, and the database nodes with the seqno value being-1 in grastate.dat files contained in all the database node directories serve as database nodes for abnormal shutdown; when the database nodes in the database cluster are all shut down abnormally, the database nodes with my _ uuid equalto view _ id contained in the gvwstat.dat file of the database nodes are found out in a traversal mode to serve as starting nodes, and synchronous operation is started in a bootstrap mode. Through the technical scheme disclosed by the invention, the problem of residual files in the database cluster is effectively avoided, and the reliability and stability of the Galera-based database cluster during operation are improved; and the strong consistency of the database cluster based on the Galera is ensured.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a Galera-based database cluster recovery method and terminal equipment. Background technique [0002] In the traditional MVC single system architecture (Model View Controller) or the early architecture based on PHP, MYSQL and NGINX, business and functions are coupled together and deployed on a server node. With the rapid growth of business volume and QPS, the existing traditional business architecture has been unable to meet the rapid growth of massive business and QPS. Therefore, a distributed service architecture came into being. [0003] The MySQL database is a database architecture commonly used in cloud platforms at present, and its built-in replication function is the basis for building large-scale, high-performance applications. The master-slave architecture of the MySQL database realizes the master-slave replication and read-write separation functions of the database....

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): G06F16/27G06F16/22G06F11/14
CPCG06F16/27G06F16/2219G06F11/1448
Inventor 李瑞友
Owner 安超云软件有限公司