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

Method and system for realizing MYSQL cluster

An implementation method and system implementation technology, applied in the database field, can solve the problem that mysqlcluster does not achieve high-availability load balancing, etc.

Inactive Publication Date: 2016-01-06
深圳市华验防伪科技有限公司
View PDF5 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In view of the above-mentioned deficiencies in the prior art, the object of the present invention is to provide a method and system for implementing a MYSQL cluster, aiming to solve the defects in the prior art that mysqlcluster does not achieve high availability and load balancing on management nodes and SQL nodes

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
  • Method and system for realizing MYSQL cluster
  • Method and system for realizing MYSQL cluster

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0031] The present invention provides a MYSQL cluster implementation method and system. In order to make the purpose, technical solution and effect of the present invention more clear and definite, the present invention will be further described in detail below. It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

[0032] See figure 1 , figure 1 It is a flow chart of a preferred embodiment of a method for implementing a MYSQL cluster in the present invention. Such as figure 1 As shown, it includes the following steps:

[0033] Step S100, setting up a load scheduling layer on the Linux server, and generating virtual nodes to provide a unified entrance to the outside world;

[0034] Step S200, the load scheduling layer obtains the total number of current connections of each SQL node in the SQL layer according to the weighted least connection scheduling algorithm, calculates t...

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 method and a system for realizing an MYSQL cluster. The method comprises the following steps: setting up a load scheduling layer on a Linux server, generating a virtual node, and providing a unified external entrance; using the load scheduling layer to obtain current total number of SQL nodes in connection of an SQL layer according to a weighted least connection scheduling algorithm, to perform weighing calculation and to send the latest connection to an SQL node with the minimum weight in the SQL layer; and checking the states of double computers of the load scheduling layer through keepalived, and when a host in the double computers has failure, enabling a slave computer to provide scheduling service. The method disclosed by the invention is used for realizing high availability of a database in various aspects and load balance in an inquiry process, and meanwhile, double management nodes are configured so as to prevent a single-node failure problem.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a method and system for realizing a MYSQL cluster. Background technique [0002] Currently, mysqlcluster itself implements high availability and load balancing at the storage layer, but does not implement high availability and load balancing at the management nodes and SQL nodes. [0003] Therefore, the prior art still needs to be improved and developed. Contents of the invention [0004] In view of the above deficiencies in the prior art, the purpose of the present invention is to provide a method and system for implementing a MYSQL cluster, aiming at solving the defect in the prior art that mysqlcluster does not achieve high availability and load balancing on management nodes and SQL nodes. [0005] Technical scheme of the present invention is as follows: [0006] A kind of MYSQL cluster realization method, wherein, described method comprises the following steps: [0007...

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): H04L12/24H04L29/08G06F17/30
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