(403) 313-2949
Suite 229, 2770 3 Ave NE, Calgary AB

MariaDB Galera Cluster

MariaDB Galera Cluster is a growing popular MySQL cluster solution available for Linux. Having a reliable, fast and expandable MySQL database solution for your business is important when it comes to your MySQL reliant applications.

 

What’s the difference between MySQL and MariaDB?

 

MariaDB is (and claims to always be) open source, written by the original MySQL developers. The entire project has focussed on making it seamless for migrating existing MySQL databases and as a drop-in replacement of MySQL (now owned by Oracle). MariaDB Server is licensed as GPLv2, while MySQL has two licensing options – GPLv2 (for Community edition) and Enterprise. The main difference between the two licenses for MySQL is the available features and support.

MariaDB Galera Cluster is a virtually synchronous multi-master cluster for MariaDB. It is available on Linux only, and only supports the XtraDB/InnoDB storage engines.

 

Features:

  • Virtually 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 MariaDB look & feel

 

Benefits:

  • No slave lag
  • No lost transactions
  • Read scalability
  • Smaller client latencies

There are some great guides online available (MariaDB Getting Started Guide to start) which can help you build your very own Galera cluster quickly. There are also many cloud providers which are great for hosting your Galera clusters (Amazon AWS, Digital Ocean, Linode, Microsoft Azure to name a few).