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

MySQL database cluster processing method and processing system thereof

A processing method and technology of a processing system, applied in the field of MySQL database cluster processing method and MySQL database cluster processing system

Inactive Publication Date: 2017-06-13
广州勤加缘科技实业有限公司
View PDF9 Cites 23 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] Regarding the technical problems to be solved by the present invention, its specific requirements are as follows: separately process data write, update, delete requests and query requests that account for the vast majority of access, solve the scalability of data query capabilities, and prevent self-single-point Failure causes the entire cluster to fail to provide services, with high availability, flexible expansion, and low expansion cost

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 database cluster processing method and processing system thereof
  • MySQL database cluster processing method and processing system thereof
  • MySQL database cluster processing method and processing system thereof

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0032] Specific embodiments of the present invention will be described in more detail below with reference to the accompanying drawings. Although specific embodiments of the invention are shown in the drawings, it should be understood that the invention may be embodied in various forms and is not limited to the embodiments set forth herein. Rather, these embodiments are provided for more thorough understanding of the present invention and to fully convey the scope of the present invention to those skilled in the art.

[0033] It should be noted that certain terms are used in the specification and claims to refer to specific components. Those skilled in the art should understand that they may use different terms to refer to the same component. The specification and claims do not use differences in nouns as a way of distinguishing components, but use differences in functions of components as a criterion for distinguishing. "Includes" or "comprises" mentioned throughout the spe...

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 an MySQL database cluster processing method and a processing system thereof. The method comprises the following steps: in step 1, the MySQL database cluster includes a primary MySQL database for writing and a plurality of subordinate MySQL databases for querying, and users access the MySQL database cluster through web; in step 2, when the web access is a write, update or delete request, the primary MySQL database responds to the request, and when the web access is a query request, a load balancer (LVS) including a primary LVS and a subordinate LVS receives the query request, a virtual IP address (VIP) monitors whether the primary LVS and the subordinate LVS are available; in step 3, a Keepalived module monitors whether a database query server corresponding to the subordinate MySQL databases is available, automatically kicks the database query server with failure out of the cluster, and assigns query tasks according to the predetermined weight; and in step 4, the database query server that receives the query tasks carries out query and returns the query result to the user.

Description

technical field [0001] The invention belongs to the communication field, and in particular relates to a MySQL database cluster processing method and a MySQL database cluster processing system. Background technique [0002] With the advent of the era of big data, the scale of data continues to grow, and the demand for data query becomes more and more frequent. Users have increasingly strong requirements for data query speed and uninterrupted data query services. They do not want to wait too long when accessing query data, or even see "query timeout" or "database is busy". A single database cannot support the corresponding rapid increase in storage and computing intensity due to the rapid growth of data and query volume. In this case, if you buy a new database server with more expensive price and better performance to upgrade and eliminate the existing database server, it will be an extreme waste of existing hardware resources. A single database server No matter how powerful...

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
IPC IPC(8): H04L29/08G06F17/30
CPCH04L67/1031G06F16/2471H04L67/1036
Inventor 陈俊丁速滨郑中斌
Owner 广州勤加缘科技实业有限公司
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

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

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