0

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?

1 Answer 1

1

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.

5
  • You can write to every node; what do you mean by your point #1?
    – Rick James
    Nov 27, 2016 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, 2016 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, 2016 at 20:31
  • one last thing , can i use it to do the replication across tow datacenters?
    – Yaser Jawi
    Nov 28, 2016 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, 2016 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.