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

A method and system for expanding the capacity of a distributed database

A database and distributed technology, applied in the field of distributed databases and cloud computing, can solve the problems of large application program impact, complex operation, and complicated expansion steps, so as to achieve the effect of short expansion time and simple operation.

Active Publication Date: 2018-04-03
北京思特奇信息技术股份有限公司
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The existing distributed database system cannot realize capacity expansion. With the increase of business, the data volume of each node increases sharply, and the performance of the entire distributed database drops sharply; the expansion time is long and has a great impact on the application program; the expansion has strong limitations and only supports some special The scenario is not suitable for all scenarios; the expansion steps are cumbersome and the operation is complicated

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
  • A method and system for expanding the capacity of a distributed database
  • A method and system for expanding the capacity of a distributed database
  • A method and system for expanding the capacity of a distributed database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0030] The principles and features of the present invention are described below in conjunction with the accompanying drawings, and the examples given are only used to explain the present invention, and are not intended to limit the scope of the present invention.

[0031] Mysql involved in the present invention refers to a relational database management system, and DBProxy is a database proxy for scheduling / load balancing.

[0032] figure 1 It is a flow chart of the method for expanding the capacity of the distributed database in the present invention.

[0033] Such as figure 1 As shown, a method for expanding the capacity of a distributed database includes the following steps:

[0034] Step S1, through the proxy rule 1, the database system 1 divides the data of Mysql_A and Mysql_B into two databases; wherein the database system 1 includes Mysql_A and Mysql_B connected to DBProxy, and the data of Mysql_A and Mysql_B are set as dual primary and mutual prepared; after segment...

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 present invention relates to a method and a system for expanding the capacity of a distributed database, including step S1, the database system 1 divides the data of Mysql_A and Mysql_B into two databases through the proxy rule 1; wherein the database system 1 includes a database connected to DBProxy Mysql_A and Mysql_B, and the data of Mysql_A and Mysql_B are set as dual master and mutual backup; after splitting, the data of Mysql_A is split into database Schema1 and database Schema2, and the data of Mysql_B is split into database Schema1 and database Schema2; step S2 , modify proxy rule 1 to proxy rule 2; step S3, stop the data replication function of Mysql_A and Mysql_B according to proxy rule 2 and delete the database Schema2 contained in Mysql_A and the database Schema1 contained in Mysql_B; step S4, set the backup node of Mysql_A and Mysql_B They are Mysql_A_slave and Mysql_B_slave respectively, and the data of Mysql_A and Mysql_B are respectively imported into Mysql_A_slave and Mysql_B_slave; the present invention is simple in operation and short in expansion time; it supports the expansion of distributed databases in all scenarios.

Description

technical field [0001] The invention relates to the field of distributed database and cloud computing, in particular to a method and system for expanding the capacity of a distributed database. Background technique [0002] In many key fields such as the Internet and telecommunications, with the continuous development of enterprise business, the I / T environment of enterprises is also constantly evolving. It is difficult for a single database to meet the requirements of massive database storage and high concurrent data access. The emergence of distributed databases has become Inevitably, distributed databases can effectively solve massive data storage and concurrency problems. Through horizontal alignment of data and vertical segmentation of data tables, massive data storage is effectively alleviated, and high Concurrency issues. However, with the increase in the online business volume of the distributed database, the data volume of each node increases, and the expansion of ...

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
CPCG06F16/27
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