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?

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.

| improve this answer | |
  • You can write to every node; what do you mean by your point #1? – Rick James Nov 27 '16 at 4:40
  • @RickJames I mean it is not suitible tool for concurrent writing on multiply Masters because it can lead to deadlock. – HamoonDBA Nov 27 '16 at 6:05
  • Any configuration can lead to deadlocks. Arguably Galera can get more deadlocks because of the delay in COMMIT while it checks with the other nodes. Some applications never have deadlocks because they are never hitting the same rows. – Rick James Nov 27 '16 at 20:31
  • one last thing , can i use it to do the replication across tow datacenters? – Yaser Jawi Nov 28 '16 at 7:48
  • @YaserJawi Yes you can do it. Even you can design Geo-Distributed Database Clusters. Read this article for more information galeracluster.com/2015/07/…: – HamoonDBA Nov 28 '16 at 9:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.