Friday, October 06, 2017

Getting Started With MariaDB Galera and MariaDB MaxScale on CentOS

DZone Database Zone
Getting Started With MariaDB Galera and MariaDB MaxScale on CentOS
Getting Started With MariaDB Galera and MariaDB MaxScale on CentOS

A perk of using Galera as a high availability solution for MariaDB is that it is rather easy to set up and use, as far as high availability can be easy. Also, both MariaDB and Galera are well-documented. To use MariaDB MaxScale for failover with a MariaDB Galera Cluster is also rather straightforward and well-documented. The issue is that there are three technologies at play here, and although they are all well-documented and reasonably easy to use, when it comes to using all of them together, things get slightly more difficult.

This post then aims to show all these three technologies at play together, starting from scratch and creating a MariaDB Galera Cluster based on MariaDB Galera 10.2.7 and MaxScale 2.1. The operating system we are going to use for this example is CentOS version 7.2. Before we get started, I also want to mention that we are here looking at a minimal initial installation; we will not look at many fancy features in either product.

No comments:

Fun With SQL: Functions in Postgres

DZone Database Zone Fun With SQL: Functions in Postgres In our previous  Fun with SQL  post on the  Citus Data  blog, we covered w...