Database automatic partition management method and system based on horizontal partitions

Abstract

The invention particularly relates to a database automatic partition management method and system based on horizontal partitions. The database automatic partition management method based on horizontalpartitions is characterized in that the partition attributes are flexibly configured according to business requirements, partition operation is automatically executed, task scheduling is automatically carried out according to a configuration period, partition objects meeting time intervals are periodically inspected, the partition creation, deletion and data dump are carried out according to theconfiguration information, the manual intervention is not needed after one-time configuration, and then the automatic partition management is achieved. According to the database automatic partition management method and system based on the horizontal partitions, the effective partitioning of the MySQL database can be achieved while the normal operation of online services is not affected, the database access performance is improved, meanwhile, the manual intervention is reduced, the partitioning operation is simplified, the hidden dangers caused by the manual mistaken writing and mistaken writing can be avoided, and a large amount of labor cost is saved.

Description

technical field [0001] The invention relates to the technical field of database expansion, in particular to a horizontal partition-based automatic database partition management method and system. Background technique [0002] With the rapid development of Internet technology, the amount of data has expanded rapidly, and the increasing amount of data will inevitably lead to a decline in database performance. On the premise of not affecting the normal operation of online business, how to manage these data and control the scale of data has become a problem that enterprises have to solve. Horizontal partitioning of MySQL database is one of the most common solutions. [0003] MySQL is a small relational database management system, and the data in the MySQL database is stored on the disk in the form of files. If the amount of data in a table is too large, the file capacity will increase, and the search for data will become slower. At this time, if the database is horizontally p...

AI Technical Summary

Problems solved by technology

[0005] First, because the data is required to be written into the existing partitions that meet the rules, if the database maintenance personnel do not create the expected partitions in advance, new data will not be written into the correct partitions, or even cause data loss;

[0006] Second, the partition configuration provided by the MySQL database is single, which cannot meet business needs such as creating multiple partitions at a time;

[0008] Fourth, partition operations are mostly periodic repetitive work, which consumes manpower

Images