Over 15 years helping companies reach their financial and branding goals. Nexix Inc is a value-driven technology agency dedicated to our clients.

Contact Info

525 11 Ave SW Suite 302 Calgary, Alberta

sales@nexix.com

+1 403.313.2949

Technology

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).

Leave a comment

Your email address will not be published. Required fields are marked *