Mysql – thesql replication using galera

galeramariadbMySQLreplication

I want to learn how to use Galera cluster replication (MariaDB).

  1. Can anyone give an advice that I can start from specific point?
  2. Is it compatible with vsphere?

Best Answer

For your first question:

Multiply Things you must know before using Galera Cluster.

  1. Galera Cluster is not for scale write
  2. Galera Cluster is not load balancer. It must integrate with HA Tools for this option
  3. It's virtually synchronized Multi-master Replication

  4. You need minimum of 3 nodes/servers(or 2 nodes and 1 abrirator) to avoid split/brain.

  5. You can't use MyISAM all of tables must be InnoDB.

So if you want to use Galera Cluster I thinks this article is good for start.