I want to learn how to use Galera cluster replication (MariaDB).
- Can anyone give an advice that I can start from specific point?
- Is it compatible with vsphere?
For your first question:
Multiply Things you must know before using Galera Cluster.
- Galera Cluster is not for scale write
- Galera Cluster is not load balancer. It must integrate with HA Tools for this option
It's virtually synchronized Multi-master Replication
You need minimum of 3 nodes/servers(or 2 nodes and 1 abrirator) to avoid split/brain.
- 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.
-
-
@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
COMMITwhile 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
