Galera Cluster: open-source synchronous multi-master cluster for MariaDB
MariaDB is a community-developed, commercially supported fork of the MySQL relational database management system (RDBMS), intended to remain free and open-source software under the GNU General Public License.
MariaDB intended to maintain high compatibility with MySQL, ensuring a drop-in replacement capability with library binary parity and exact matching with MySQL APIs and commands. However, new features diverge more (ex: XtraDB replaces InnoDB).
MariaDB server can be integrated with Galera Cluster that extends it with the feature of acting as a synchronous multi-master cluster.
- Galera Cluster for MySQL is a true Multi-Master Cluster based on synchronous replication.
- It's an easy-to-use, high-availability solution, which provides high system up-time, no data loss and scalability for future growth.
- Easy to Use and Deploy.
- True Multi-master, Active-Active Cluster Read and write to any node at any time.
- Synchronous Replication No slave lag, no data is lost at node crash.
- Tightly Coupled All nodes hold the same state. No diverged data between nodes allowed.
- Multi-threaded Slave For better performance. For any workload.
- No Master-Slave Failover Operations or Use of VIP.
Project Design and Security
- Hot Standby No downtime during failover (since there is no failover).
- Automatic Node Provisioning No need to manually back up the database and copy it to the new node.
- Transparent to Applications Required no (or minimal changes) to the application.
- No Read and Write Splitting Needed.
## Sample Configuration for Galera Cluster over MariaDB @ /etc/my.cnf