Dilatation method and system of distributed database

Abstract

The invention discloses a dilatation method and system of a distributed database. The dilatation method comprises the following steps: S1) segmenting the data of Mysql_A and Mysql_B of a database system 1 into two databases through a proxy rule 1, segmenting the data of the Mysql_A to a database Schema1 and a database Schema 2 after segmentation is carried out, and segmenting the data of the Mysql_B to the database Schema1 and the database Schema 2, wherein the database system 1 comprises the Mysql_A and the Mysql_B connected with a DBProxy (Database Proxy), and the data of the Mysql_A and the Mysql_B is set to be dual-master mutual backup; S2) revising the proxy rule 1 into a proxy rule 2; S3) according to the proxy rule 2, stopping the data copying functions of the Mysql_A and the Mysql_B, and deleting the database Schema2 contained in the Mysql_A and the database Schema1 contained in the Mysql_B; and S4) independently setting the backup nodes of the Mysql_A and the Mysql_B into Mysql_A_slave and Mysql_B_slave, and independently importing the data of the Mysql_A and the Mysql_B into the Mysql_A_slave and the Mysql_B_slave. The dilatation method and system has the advantages of being simple in operation and short in dilation time and supports the dilatation of the distributed database of all scenes.

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 ...

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

Images