The way to set up MySQL cluster

This article will explain in detail the way to set up a MySQL cluster for you. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

The ways of mysql cluster are: combination of LVS and Keepalived and MySQL, combination of MySQL Proxy,MySQL and MHA, combination of MySQL and MMM, MySQL Cluster and so on.

Several ways of setting up MySQL Cluster

LVS+Keepalived+MySQL (brain fissure problem? But it seems that many people recommend this)

DRBD+Heartbeat+MySQL: is there a machine available? Heartbeat switching time is longer? Have a brain fissure problem? )

MySQL Proxy (immature and stable? Using Lua? Is it possible to use him as a sub-table so that you don't have to change the client logic? )

MySQL Cluster (community version does not support INNODB engine? Lack of commercial cases? )

MySQL + MHA (if matched with asynchronous replication, it seems to be a good choice, and the problem? )

MySQL + MMM (seems to reflect that there are a lot of problems, has not been practiced, who can give an explanation)

Mode selection

If you are in dual-master replication mode, you do not have to split the data, then you can choose MHA or Keepalive or heartbeat

If you have dual master replication and split the data, you can consider using Cobar

If you have dual master replication + Slave and split the data, you need to read and write classification. You can consider Amoeba.

This is the end of the way to set up a MySQL cluster. I hope the above content can be helpful to you and learn more knowledge. If you think the article is good, you can share it for more people to see.