MariaDB Replication Cluster ⚙️

The mariadb-replication-setup project is designed to deploy MariaDB master-slave replication clusters on Ubuntu (both focal, jammy, mantic). This solution is tailored for use on dedicated physical servers, virtual machines, and within both on-premises and cloud-based infrastructures.

This project currently only facilitates the creation of new clusters.

---

MariaDB Master-Slave Replication Topology

Requirements

This playbook requires root privileges or sudo.

Deployment: quick start

1. Install ansible on control node

apt update && apt install -y ansible

2. Clone this repository

git clone https://github.com/vickyphang/mariadb-replication-setup

3. Edit the inventory file

Specify hostname, IP addresses (ansible_host) and connection settings (ansible_user, ansible_ssh_pass or ansible_ssh_private_key_file for your environment

nano inventory

4. Edit the variable file vars/main.yml

nano vars/main.yml

Minimum set of variables:

• mariadb_version
• mariadb_replication_user # user to connect to the Master server and request binary logs
• mariadb_replication_password
• (Optional) create_user # if set to true, create new user. must fill mariadb_user, mariadb_password, mariadb_host

5. Try to connect and ping to all hosts

ansible all -m ping

6. Run playbook

ansible-playbook deploy_cluster.yml