Shulou(Shulou.com)05/31 Report--

This article mainly shows you the "MySQL database HA program example analysis", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and study the "MySQL database HA scheme example analysis" this article.

1. MySQL Replication

For the single MySQL synchronization function, the automatic switching of IP address can not be realized, and the function listed in this table is the one-way synchronization mode of MySQL Replication, which needs to be improved to two-way synchronization, so the functions of two-way synchronization, resynchronization and database switching can be realized.

II. MySQL Replication+Heartbeat

For the second scheme, heartbeat is introduced, so IP address switching can be realized. Heartbeat only aims at the switching of host and network failures, so it is unable to monitor database failures, so additional tools and configurations are needed, and the working mechanism of MySQL Replication is asynchronous communication, which may affect the consistency of synchronous data.

III. MySQL+Heartbeat+DRBD

For the third kind, DRBD,DRBD is Distributed Replicated Block Device, which is a virtual block device tool developed based on the kernel. The software can virtualize a block device on an actual block device or partition and mount it to the system. The two hosts can synchronize the data on the block device through configuration, which can achieve the function of two-way real-time synchronization, but only one host can be active at the same time. The virtual block device on the slave server cannot be mounted, so the MySQL service of the slave server cannot be started. When switching, it is necessary to control the startup order of the slave server, switch DRBD sequentially, mount the virtual block device, and start MySQL, which has a long delay in debugging. And DRBD is based on the kernel, in the application debugging, many problems lead to the server kernel problems and lead to the host crash, so the high stability of the server is not satisfied.

IV. MySQL Cluster

The cluster mode is generally used in load balancing, using one-way synchronization. The modification of the data is only carried out on one database server, and the query is given to other database servers. At the same time, the automatic switching of IP addresses cannot be completed, so there is no debugging.

5. MySQL+memcached

This scheme uses shared memory to make multiple MySQL share the same memory buffer, so it is not suitable for backup purpose.

VI. Other options

1. MySQL Proxy:

The function of IP address switching can also be realized by MySQL Proxy, which works by adding a proxy device between MySQL Server and Client, handling data requests through lua scripts, and using lua scripts to achieve different functions according to business requirements, but this method will add an extra MySQL Proxy server, so it will not be considered.

2. MyBalance and MyReplication

For the synchronization function, in addition to the synchronization and DRBD of MySQL itself, there are MyBalance and MyReplication two tools that can be realized, but these two tools can only carry out one-way synchronization, not suitable for the purpose of two-way backup, so they can not meet the needs.

The above is all the contents of the article "sample Analysis of MySQL Database HA Scheme". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.