Database backup system and backup method and slave database server of database backup system

Abstract

The invention discloses a database backup system and a backup method and a slave database server of the database backup system. The system comprises a master database server, the slave database server and a storage node cluster. The master database server is used for maintaining a database, the slave database server is used for backup of the database and transmitting a backup result after the backup result is obtained, the storage node cluster is based on the HDFS (Hadoop distributed file system) technology and comprises a storage control node and at least one storage node, and the storage control node is used for receiving the backup result transmitted from the slave database server and is responsible for managing backup file distributed storage of the various storage nodes. As the backup result is transmitted to the storage node cluster based on the HDFS technology to store backup files, the storage control node can comprehensively manage and adjust storage of the backup files according to storage space of the various storage nodes, the backup result is uniformly stored in the various storage nodes in a distributed storage mode, and utilization rate of the storage space can be increased in a database backup process.

Description

technical field [0001] The invention relates to database technology, in particular to a database backup system, a backup method and a slave database server. Background technique [0002] With the rapid development of office automation and e-commerce, enterprises rely more and more on information systems, and databases play an important role as the core of information systems. Especially in some industries that require high data reliability such as banking, securities, telecommunications, etc., if unexpected downtime or data loss occurs, the loss will be very heavy. Therefore, it is necessary to back up the database. In this way, after the database fails and is damaged, it can be restored through the backed up database. [0003] At present, the industry usually adopts the xtrabackup hot backup method to back up the MySQL database with a large amount of data; the database backup system architecture that uses this method for backup, such as figure 1 As shown, including: mast...

AI Technical Summary

Problems solved by technology

[0009] However, the inventors of the present invention have found that as time goes by, the data volumes of databases based on different businesses, or different databases of the same business, increase unevenly; the data volume of some databases increases very rapidly, and the data volume of some databases Slow growth; or, in a certain period of time, the data volume of a certain database increases greatly, while the data volume of other databases increases very little; in another period, the data volume growth of the database changes again; thus, resulting in The storage capacity and traffic in each storage server are unbalanced: it may appear that the storage capacity of some storage servers has exceeded 90%,

Images