MySQL / MariaDB Galera Cluster overview, pros, cons, deployment srategy

In depth overview of MySQL/MariaDB Galera Cluster:

1. MySQL Galera Installation

2. MySQL Galera Configuration

3. MySQL Galera Analysis - Pros, Cons deployment scenarios.

Galera Cluster for MySQL Features MySQL/Galera is synchronous multi-master cluster for MySQL/InnoDB database, having features like:

Synchronous replication Active-active multi-master topology Read and write to any cluster node Automatic membership control, failed nodes drop from the cluster Automatic node joining True parallel replication, on row level Direct client connections, native MySQL look & feel Benefits These features yield un-seen benefits for a DBMS clustering solution:

No slave lag No lost transactions Both read and write scalability Smaller client latencies