What are the methods of mysql cluster?

Mysql cluster methods include: LVS and Keepalived and MySQL combination, MySQL Proxy, MySQL and MHA combination, MySQL and MMM combination, MySQL Cluster and other methods

Several ways to set up a MySQL cluster

LVS Keepalived MySQL (Have split-brain problems? But many people seem to recommend this)

DRBD Heartbeat MySQL (Is there a spare machine? It takes a long time to switch to Heartbeat? Is there a split-brain problem?)

MySQL Proxy (Not mature and stable enough? Is it using Lua? Is it possible to use it to create sub-tables without changing the client? End logic?)

MySQL Cluster (The community version does not support the INNODB engine? Insufficient commercial cases?)

MySQL MHA (If paired with asynchronous replication, it seems to be a good choice. What’s the problem? )

MySQL MMM (It seems that there are many problems, which have not been practiced before. Who can give an explanation)

Method selection

If it is dual-master replication mode, there is no need to split data, then you can choose MHA or Keepalive or heartbeat

If it is dual-master replication and data splitting is also done, you can consider using Cobar;

If Dual-master replication Slave also splits the data and requires read and write classification. You can consider Amoeba;

The above is the detailed content of What are the methods of mysql cluster?. For more information, please follow other related articles on the PHP Chinese website!