How Galera Cluster works
The following are some advantages of Galera Cluster:
True multimaster: It can read and write to any node at any time
Synchronous replication: There is no slave lag and no data is lost at node crash
Consistent data: All nodes have the same state (same data exists between nodes at a point in time)
Multithreaded slave: This enables better performance with any workload
No need of an HA Cluster for management: There are no master-slave failover operations (such as Pacemaker, PCR, and so on)
Hot standby: There is no downtime during failover
Transparent to applications: No specific drivers or application changes are required
No read and write splitting needed: There is no need to split the read and write requests
WAN: Galera Cluster supports WAN replication
Galera Cluster needs at least three nodes to work properly (because of the notion of quorum, election, and so on). You can also work with a two-node cluster, but you will need an arbiter (hence three nodes). The arbiter...