Nginx-based highly-available MySQL database realization method

An implementation method and database technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as business stoppage, achieve the effect of improving high availability and reducing pressure

Inactive Publication Date: 2017-07-04
XUZHOU MEDICAL UNIV
View PDF2 Cites 15 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In order to solve the problem of long-term business suspension caused by service interruption on a large-scale MySQL database software platform, the present invention provides an implementation method of a high-availability MySQL database based on Nginx, which realizes the separation of data reading and data writing, without changing the method based on In addition to the traditional relational data design architecture and SQL access method, it can also be scalable to deal with large concurrency and large data volumes, enabling applications to obtain extremely high scalability and scalability without any modification. high availability

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
  • Nginx-based highly-available MySQL database realization method
  • Nginx-based highly-available MySQL database realization method
  • Nginx-based highly-available MySQL database realization method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] Such as figure 1 Shown, a kind of realization method based on Nginx highly available MySQL database, it comprises Web server cluster, master-slave database server cluster, Nginx reverse proxy server, page cache server and data cache server; User sends to Nginx reverse proxy server Connection request, Nginx reverse proxy server forwards the request to the Web server cluster, and the Web server receives the request, first checks whether there is corresponding data in the page cache server and data cache server, and if it exists, directly uses the cached data; if If it does not exist, analyze the SQL statement through the database connection tool DBConnection to judge the read and write operations and connect to the corresponding master-slave database server. The master-slave database server performs the corresponding operation and returns the result to the Web server.

[0035] Multiple web servers form a web server cluster. When the Nginx reverse proxy server receives a r...

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 Nginx-based highly-available MySQL database realization method. The method comprises a Web server cluster, a master-subordinate database server cluster, an Nginx reverse proxy server, a page buffering server and a data buffering server. A user sends a connection request to the Nginx reverse proxy server; the Nginx reverse proxy server transfers the request to the Web server cluster; the Web server receives the request, and checks whether or not relative data exists in the page buffering server and the data buffering server; if relative data exists, the buffering data can be directly utilized; if the relative data does not exist, then the Web server is connected to a tool DBConnection via a database to analyze SQL sentence to determine read-or-write operation and is connected to the master-subordinate database server; and the master-subordinate database server conducts relative operation and returns a result to the Web server. By the use of the method, data reading and data writting can be separated.

Description

technical field [0001] The invention relates to the technical field of server clusters and database high availability, in particular to an implementation method of a high availability MySQL database based on Nginx. Background technique [0002] With the rapid development of technology, there are more and more ways for people to obtain information and store information, and the Internet has become the main way for people to communicate and communicate. However, with the increasing number of Internet users and the increasing number of website visits, how the server can quickly respond to the request sent by the client has become a difficult problem. Therefore, how to provide a high-availability solution for database servers that is fast, reliable, easy to implement and maintain, and fast to recover from failures has become particularly important. Contents of the invention [0003] In order to solve the problem of long-term business suspension caused by service interruption ...

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/30
CPCG06F16/24552G06F16/275
Inventor 王换换余文文王竞吴响
Owner XUZHOU MEDICAL UNIV
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap