MySQL high-availability architecture method based on distributed block device

Abstract

The invention provides a MySQL high-availability architecture method based on distributed block equipment, which is characterized in that high stability and continuity of a database are ensured by adopting Heartbeat dual-computer hot standby software, and data consistency is ensured through a DRBD tool; under the default condition, only one MySQL works, when the main MySQL server goes wrong, the system is automatically switched to the standby machine to continue to provide the service, and when the main database is repaired, the service is switched back to continue to be provided by the main MySQL. The MySQL high-availability architecture method based on the distributed block device has the beneficial effects that the high stability and continuity of a database are ensured by adopting Heartbeat dual-computer hot standby software, the data consistency is ensured by a DRBD tool, only one MySQL works under a default condition, and when a main MySQL server goes wrong, the system is automatically switched to the standby machine to continue to provide the service, and when the main database is repaired, the service is switched back to continue to be provided by the main MySQL.

Description

technical field [0001] The invention belongs to the MySQL field, and in particular relates to a distributed block device-based MySQL high-availability architecture method. Background technique [0002] At present, most of MySQL's high-availability solutions adopt master-salve synchronization (master-salve) or master-master synchronization (master-master). Synchronization is based on the binary log mechanism. The master server uses binary logs to record changes in the database. Execute this log file to keep the data consistent with the master server. Features based on binary log synchronization: 1. Improve the performance of the database by adding slave servers, perform writes and updates on the master server, and provide read functions on the slave server, and dynamically adjust the number of slave servers, thereby Adjust the performance of the entire database; 2. Improve data security - because the data has been copied to the slave server, the slave server can terminate th...

AI Technical Summary

Problems solved by technology

Features based on binary log synchronization: 1. Improve the performance of the database by adding slave servers, perform writes and updates on the master server, and provide read functions on the slave server, and dynamically adjust the number of slave servers, thereby Adjust the performance of the entire database; 2. Improve data security - because the data has been copied to the slave server, the slave server can terminate the replication process, so it can be backed up on the slave server without destroying the corresponding data of the master server; 3. Generated on the master server Real-time data, and analyze the data on the slave server to improve the performance of the master server; the above scheme currently has some limitations: although the master-slave replication adds a database copy, the data from the slave database and the master database will eventually be consistent

In addition, this database copy seems to solve the database single-point problem, but it is not perfect: because under this architecture, if the master server goes down, the slave server needs to be manually switched, and the business interruption cannot be restored or switched immediately, which cannot meet the high availability of the application. requirements

Images