Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

MySQL read-only instance management method and system

A management method and instance node technology, applied in the Internet field, can solve the problems that database instances cannot simultaneously satisfy read requests and fast response to write operations, so as to reduce the risk of misoperation, improve efficiency, and improve the efficiency of deployment and operation and maintenance

Active Publication Date: 2021-04-16
SHANDONG LANGCHAO YUNTOU INFORMATION TECH CO LTD
View PDF6 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003]In an application scenario where there are a small number of write requests to the database but a large number of read requests, the read requests of the database become the bottleneck of the database, and the existing database instance cannot simultaneously satisfy the read requests. Fast response to requests and writes

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
  • MySQL read-only instance management method and system
  • MySQL read-only instance management method and system
  • MySQL read-only instance management method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0058] The present invention will be further described below in conjunction with the accompanying drawings and specific embodiments.

[0059] In order to improve the read performance of the database and share the pressure on the database, one or more read-only instances can be created to form a read-only instance group, and read-only instances can be used to meet a large number of database read requirements. After creating the read-only instance group, configure the address of the master instance and the virtual IP (VIP) of the address of the read-only instance in the application, so that the write request can be forwarded to the master instance, and the read request can be forwarded to the read-only instance, so as to realize read and write separate.

[0060] The embodiment of the present invention provides a MySQL read-only instance management method. By expanding the read-only instance node, the write request is connected to the database main instance, and the read request ...

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 discloses a MySQL read-only instance management method and system, and belongs to the technical field of the Internet, and the method comprises the steps of enabling a write request to be connected to a database main instance through expanding a read-only instance node, and enabling a read request to be connected to a read-only instance; mounting HAProxy and Keepalived in the instance node, managing the state of read-only instances in the read-only instance group through HAProxy and Keepalived, keeping high availability of the read-only instances, and the method comprises creating the read-only instance group, creating the read-only instances, updating HAProx configuration management read-only instance loads, deleting the read-only instances and deleting the read-only instance group. According to the invention, the cloud database can automatically manage read-only instances, the deployment operation and maintenance efficiency is improved, and the misoperation risk is reduced.

Description

technical field [0001] The invention relates to the technical field of the Internet, in particular to a MySQL read-only instance management method and system. Background technique [0002] In the application scenario of the Internet, the read request of the database has a large amount of data and high concurrency requirements, and a database architecture with read and write separation is required to meet its needs. Among them, the read-only instance group is an implementation of read-write separation. [0003] In an application scenario where there are a small number of write requests to the database but a large number of read requests, the read requests of the database become the bottleneck of the database, and the existing database instance cannot satisfy the fast response of both read requests and write operations. Contents of the invention [0004] The technical task of the present invention is to provide a MySQL read-only instance management method and system for the...

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/2458G06F16/27
Inventor 厉颖赵山王阳
Owner SHANDONG LANGCHAO YUNTOU INFORMATION TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products