Rapid horizontal extending method for databases

Abstract

The invention discloses a rapid horizontal extending method for databases, which belongs to the field of data migration and storage. The method comprises the following steps: a monitoring and control system carries out monitoring on the disk storage space of the existing database, and when the disk size reaches a preset storage capacity threshold, the monitoring and control system triggers a hardware storage increasing action so as to make a hardware environment preparation for data migration; and a routing protocol carries out a modular computation on the instance number N of the current database according to a major key ID to be inserted currently, and routes the line number of data to be inserted into a specified database, and when the number of inserted lines exceeds a preset storage number threshold, the routing protocol triggers a database segmentation action so as to migrate specified data into a new database, thereby completing the rapid horizontal extending of the database. The method disclosed by the invention can be applied to disk databases or memory databases, and the method is easy to use and simple, and avoids the problem that hotspots are distributed nonuniformly caused by traditional horizontal extending of databases; in addition, as the scale of migration of data segmented each time is small, the extending speed is improved. In conclusion, the overall architecture meets the requirements on high availability, high reliability, high speed, high efficiency and the like.

Description

technical field [0001] The invention relates to a method for expanding the storage capacity of a database, in particular to a method for quickly and horizontally expanding the database in response to the ever-increasing demand for the data storage capacity of an enterprise-level database. Background technique [0002] With the rapid development of the Internet, the amount of application data and the number of visits are increasing rapidly. For the traditional enterprise IT architecture system, the storage data of the disk database is facing the huge pressure of large concurrency and high data volume transmission. In order to cope with the trend of big data and improve the scalability of database capacity, the choice of expansion scheme is particularly critical. [0003] In the prior art, the problem of data growth storage is realized by increasing the disk of a single database, and the scalability of the system is solved. There are usually two solutions: vertical scalabilit...

AI Technical Summary

Problems solved by technology

[0005] The vertical expansion architecture needs to add high-performance hardware. Usually, the cost of large-scale servers is more expensive than that of ordinary minicomputers; secondly, the front-end processing capability and the number of back-end disks of the entire storage system can be continuously expanded, but the upgrade and expansion to a certain extent will cause front-end control. Performance bottlenecks where servers cannot scale

[0006] Horizontally expanding the storage system architecture requires re-planning the storage network architecture. Therefore, it is necessary to cooperate with the manufacturer's system integration services to integrate existing storage resources. There will be large-scale data migration, long downtime and other problems, and the requirements for online services are higher. scenario does not apply

Images