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

Implementation system and implementation method for enhancing availability of MySQL database

An implementation method and system implementation technology, which is applied in the field of MySQL database, can solve problems such as waste of resources, and achieve the effect of easy scalability

Inactive Publication Date: 2012-09-12
北京互动百科网络技术有限公司
View PDF2 Cites 14 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0010] This solution can realize automatic failover, but the disadvantages are also very obvious. The main disadvantage is that only one of the two nodes provides external services at the same time, and the other is in a standby state, which is equivalent to wasting half of the resources.

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
  • Implementation system and implementation method for enhancing availability of MySQL database
  • Implementation system and implementation method for enhancing availability of MySQL database
  • Implementation system and implementation method for enhancing availability of MySQL database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] Such as figure 1 Shown is a schematic structural diagram of a system for enhancing the usability of the MySQL database in the present invention. The system includes a two-way asynchronous replication module 1, which is used to make the MySQL database services in a plurality of node servers master and slave each other, and the databases of each node server are all It can accept read and write requests from front-end applications at the same time, and maintain data consistency with each other. The virtual IP module 2 provides one or more virtual IPs, so that the front-end application can access the node server through the virtual IP when the node server database fails. Database service monitoring module 3, when the node server holding the virtual IP fails, it can automatically move the virtual IP to the database server that is still working, so that the front-end application does not need to be modified, so as to ensure the high quality of the entire database service ava...

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 an implementation system and an implementation method for enhancing availability of a MySQL database; two-way read-write and two-way synchronization are implemented on the basis of traditional copy characteristics of MySQL to increase read-write ability of the database; fault automatically-switching for MySQL database services is implemented through application of open-source software keepalived to ensure high availability of MySQL database services.

Description

technical field [0001] The invention relates to a MySQL database, in particular to a realization system and method for enhancing the usability of the MySQL database. Background technique [0002] MYSQL is widely used in many small and medium-sized websites. The management of MYSQL database is particularly important. How to ensure the continuous and stable operation of the database has become a problem that needs to be solved. The currently popular solution is the solution provided in the MYSQL technical documentation, which is implemented based on the third-party open source software DRBD and HEARTBEAT, where DRBD is responsible for data synchronization between the two nodes, and HEARTBEAT provides the virtual IP for the front-end application connection. When the service node fails, HEARTBEAT can automatically switch the virtual IP to the normal node, so that the MySQL database can always provide external services. The specific implementation method is as follows: [0003] ...

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): G06F17/30H04L12/24
Inventor 潘海东梅春李丙洋
Owner 北京互动百科网络技术有限公司
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com