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

A database control method and database system

A control method and database technology, applied in the computer field, can solve the problems of complicated MySQL database deployment, operation and maintenance, failure of read-write separation, etc., and achieve the effect of reducing the complexity of deployment and operation and maintenance

Active Publication Date: 2021-04-16
NETEASE (HANGZHOU) NETWORK CO LTD
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The embodiment of the present invention discloses a database control method and a database system, aiming to solve the problems in the prior art that MySQL database deployment, operation and maintenance are complex, and read-write separation fails under abnormal circumstances

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 database control method and database system
  • A database control method and database system
  • A database control method and database system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0072] The principle and spirit of the present invention will be described below with reference to several exemplary embodiments. It should be understood that these embodiments are given only to enable those skilled in the art to better understand and implement the present invention, rather than to limit the scope of the present invention in any way. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the disclosure to those skilled in the art.

[0073] Those skilled in the art know that the embodiments of the present invention can be implemented as a system, device, device, method or computer program product. Therefore, the present disclosure may be embodied in the form of complete hardware, complete software (including firmware, resident software, microcode, etc.), or a combination of hardware and software.

[0074] According to the embodiments of the present invention, a database control method an...

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

Embodiments of the present invention provide a database control method and a database system. The database includes a master node, a backup node and a read-only node. The method includes: data transmission between the master node, the backup node and the read-only node through a consensus protocol; when the master node is down, the backup node is set as the new master node. After the master node completes the failure recovery, set the master node as the new standby node. The deployment architecture of the present invention is the same as the traditional mode in terms of deployment hardware cost, but greatly reduces the complexity of deployment and operation and maintenance, and can also avoid the overlap between the master node and the read-only node, resulting in the failure of read-write separation.

Description

technical field [0001] The embodiments of the present invention relate to the computer field, and more specifically, the embodiments of the present invention relate to a database control method and a database system. Background technique [0002] The MySQL database is currently the most popular open source database and has been widely used all over the world. In the prior art, when a MySQL database is deployed, a primary node and a secondary node are usually deployed, and data is replicated between the primary node and the secondary node in a synchronous or asynchronous manner. This deployment method can meet the business needs of many scenarios. [0003] However, this deployment method has defects such as complex deployment, operation and maintenance, and read-write separation failure under abnormal circumstances. Contents of the invention [0004] The embodiment of the invention discloses a database control method and a database system, aiming at solving the problems i...

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/27G06F11/14
CPCG06F11/1464
Inventor 温正湖裘昕
Owner NETEASE (HANGZHOU) NETWORK CO LTD