A high-availability method for a declarative mysql database system

A database, declarative technology, applied in the database field, can solve problems such as intolerance of errors, inability to support more flexible steps, etc., to achieve the effect of flexible switching

Active Publication Date: 2020-01-31
AIKESHENG INFORMATION TECH SHANGHAI
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The disadvantage of this type of high-availability system is that the operations supported by the high-availability system are established operations. For example, the above-mentioned switching operation specifically involves the following multiple detailed steps:
Therefore, more flexible steps cannot be supported and errors cannot be tolerated in the above handover process

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
  • A high-availability method for a declarative mysql database system
  • A high-availability method for a declarative mysql database system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] In order to make the purpose and features of the present invention more comprehensible, the specific implementation manners of the present invention will be further described below in conjunction with the accompanying drawings. However, the present invention can be implemented in different forms and should not be limited to the described embodiments. Moreover, in the case of no conflict, the embodiments in the present application and the features in the embodiments are allowed to be combined or replaced with each other. The advantages and features of the present invention will become clearer in conjunction with the following descriptions.

[0028] It should be noted that all the drawings are in a very simplified form and use imprecise scales, and are only used to facilitate and clearly assist the purpose of illustrating the embodiments of the present invention.

[0029] It should also be stated that the purpose of numbering the steps in the present invention is to faci...

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 relates to the technical field of databases. The invention provides a declarative high-availability method for a MySQL database system. The method is provided with a master database anda slave database, and comprises the following steps of: acquiring health indexes of the MySQL database system, judging whether the health indexes are normal, and entering a master-slave database switching process if an exception of triggering switching of the master database and the slave database exists; if the recoverable exception exists, feeding back an exceptional health index to the MySQL database system, and finishing self-repairing work by the MySQL database system; and repeating the above steps until all the health indexes are normal, and completing a master-slave database switching process. According to the method, the health indexes are continuously collected in the master-slave switching process so as to feed back the state of the database system in the switching process, so that the database system obtains the opportunity of rapid recovery, the defect of blind switching in the master-slave database switching process of a high-availability system is overcome, and the database system is prevented from being stuck in the switching process.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a high-availability method for a declarative MySQL database system. Background technique [0002] High availability is a feature that large-scale data systems must have. Specifically, it refers to the ability to ensure that the database system can provide a specified level of service for a long enough time. It can also be understood as providing a certain level of stable service under limited failure conditions. Ability. [0003] Existing MySQL database system high availability systems (such as MHA, Master High Availability master database high availability) are implemented based on state machines. One of the typical processes is: the state of the MySQL database system is known to be A before the decision-making; the current monitoring value S of MySQL is detected; the next operation of the database is determined according to the state A and the monitoring value S, that is, th...

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 Patents(China)
IPC IPC(8): G06F16/23G06F16/27G06F16/28
CPCG06F16/2365G06F16/27G06F16/284
Inventor 黄炎李恒
Owner AIKESHENG INFORMATION TECH SHANGHAI
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