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

CN110532278BActive Publication Date: 2020-01-31AIKESHENG INFORMATION TECH SHANGHAI
4 Cites 0 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Publication Date
2020-01-31

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
Patent Text Reader

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.
Need to check novelty before this filing date? Find Prior Art

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...

Examples

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...