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

Method and system for reading and writing separation database

A read-write separation and database technology, applied in the field of network communication, can solve problems such as excessive read-write requests, master replication data delay, DB response performance decline, etc., to achieve the effect of improving response performance and reducing delay

Active Publication Date: 2015-06-10
TENCENT TECH (BEIJING) CO LTD
View PDF2 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The structure of the web2.0 application system in the solution of the prior art will cause the master to generate too many slave read and write requests to multiple slaves, resulting in the delay of the master copying data and the decline of the response performance of the DB

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 reading and writing separation database
  • Method and system for reading and writing separation database
  • Method and system for reading and writing separation database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0016] The present invention provides an embodiment. This embodiment provides a method for reading and writing separate databases. The technical scenario realized by this embodiment is as follows. figure 1 As shown, including: content delivery network (content delivery network, CDN), load balancing product F5 series (optional), multiple servers, application server App and DB, in which all Mysql servers are divided into 2 groups, a group of master, A set of slaves. The method as figure 2 shown, including the following steps:

[0017] After the S21 and F5 series receive the user's read and write requests, they are balanced to the CDN network, and the CDN network distributes the read and write requests to the server, and the server sends the read and write commands to the master in the DB through the APP;

[0018] Among them, the function of CDN can be: as the second layer of distribution requests, the basic idea of ​​CDN is to avoid as far as possible the bottlenecks and link...

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 embodiment of the invention provides a method for establishing a network application architecture, particularly a method and a system for reading and writing a separation database. The method and the system belong to the field of network communication. The method comprises the following steps that: a master application server (master) copies and sends a reading and writing command to a transmission slave application server (slave); the transmission slave transmits the reading and writing command to other slaves in a slave group; and the other slaves processes the reading and writing command, wherein the transmission slave has a function of transmitting the reading and writing command to other slaves. The method and the system have the advantages of reducing the delay time when the master copies the data and enhancing the response performance of a data bank (DB).

Description

technical field [0001] The invention relates to the field of network communication, in particular to a method and system for separating read and write databases. Background technique [0002] With the development of the Internet, the reading and writing mechanism of the database is becoming more and more important. The method of separating the reading and writing of the database under the existing web2. ) to multiple slave application servers (slave), and the slave completes the user's read and write requests, that is, completes the reading of the database (data-base, DB). [0003] In the process of realizing the present invention, the technical solutions provided by the prior art have the following problems: [0004] The structure of the web2.0 application system in the solution of the prior art will cause the master to generate too many slave read and write requests to multiple slaves, resulting in a delay in copying data by the master and a decrease in the response perfo...

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 Patents(China)
IPC IPC(8): G06F17/30
Inventor 马晓伟
Owner TENCENT TECH (BEIJING) CO LTD