Capacity expansion method and device of database system, electronic equipment and storage medium

Abstract

The invention discloses a capacity expansion method and device of a database system, electronic equipment and a storage medium, the capacity expansion method of the database system is executed by a database capacity expansion server, the method comprises the steps of calling a database installation program, and installing a new database in the server capable of being used for capacity expansion to serve as a newly added sub-database of a database system to be expanded; according to the database feature information of the original sub-database in the database system to be expanded, initializing the database feature information of the newly added sub-database, so that the database feature information of the newly added sub-database is consistent with the database feature information of the original sub-database; and performing environment deployment on the initialized newly-added sub-libraries, so that the newly-added sub-libraries after environment deployment can provide data services corresponding to the original sub-libraries. According to the method, the manual operation process is reduced through automatic capacity expansion, errors and step omission can be avoided, information is more accurate, the communication cost between related personnel is reduced, and the capacity expansion efficiency of the database system is improved.

Description

technical field [0001] The present application relates to the technical field of databases, and in particular to a database system expansion method, device, electronic equipment, and storage medium. Background technique [0002] The database in the online environment usually uses the open source MySQL database (a relational database management system) for data management, but in the case of a large amount of data, a single database has performance problems. The sub-database for storing data forms a database system. For example, in the field of financial business, each transaction data generated will be routed to the corresponding sub-database after being calculated by the middleware. However, as the business volume continues to increase, the capacity of the sub-database will also encounter bottlenecks. Therefore, the database system needs to be expanded to undertake greater transaction volume. [0003] If the expansion method of the database system is performed manually, p...

AI Technical Summary

Problems solved by technology

However, as the business volume continues to increase, the capacity of the sub-database will also encounter bottlenecks, so it is necessary to expand the database system to undertake greater transaction volume

[0003] If the expansion method of the database system is carried out manually, it will lead to problems such as high expansion cost and low efficiency.

Images