Greetings and salutations,
I hope this thread will be helpful to those who follow in my foot steps as well as getting any advice based on what I have done / documented.
To discuss this thread, please participate here: << Insert Ubuntu Forums Link >>
MariaDB Galera is a multi-master cluster for MariaDB. In MariaDB Galera Cluster, multiple database servers are interconnected with each other and keep synchronized to provide high availability redundancy.
This tutorial will cover how to setup a redundant database system. This will provide high availability when a database server goes offline...such as for maintenance tasks.
MariaDB Galera needs a minimum of 3 nodes. You can easily add more but make sure the total number of nodes in the cluster is an odd number (e.g. 3, 5, 7, 9, 11, etc.).
This is an overview image of a highly-available web server platform.
This article covers the database cluster.
Tools utilized in this process
- Ubuntu Server 18.04.2 LTS, 64-bit
- MariaDB 10.4.6
- Portable PuTTY 0.71
- VMware vSphere 6.0.0
- VirtualBox 6.0.10
The list below are sources of information that was helpful in the creation of this document.
This documentation will need to make use of some very-specific information that will most-likely be different for each person / location. And as such, this information will be noted in red in this section.
Under no circumstance should you use the actual values listed below. They are place-holders for the real thing. This is just a checklist template you need to have answered before you start the install process.
Wherever you see the values below in this document, you need to substitute it for you will use in your environment.
- Ubuntu Admin ID: administrator
- Ubuntu Admin Password: myadminpass
- Email Server Name (remote): srv-mail
- Email Server Internal IP (remote): 192.168.107.25
- Database Server #1: Internal IP Address: 192.168.107.101
- Database Server #2: Internal IP Address: 192.168.107.102
- Database Server #3: Internal IP Address: 192.168.107.103
It is also assumed the reader knows how to use the VI editor. If not, you will need to beef up your skill set or use a different editor in place of it.