mysql replication using galera

Question

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

HamoonDBA · Accepted Answer · 2016-11-30 04:09:09Z

1

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.

answered Nov 26, 2016 at 10:59

HamoonDBA

6074 silver badges10 bronze badges

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

Add a comment |

1 Answer 1