MariaDB Clustering related
Server | Hostname | IP Address |
DB 1 | mariadb-node1 | 10.0.1.102 |
DB 2 | mariadb-node2 | 10.0.1.103 |
DB 3 | mariadb-node3 | 10.0.1.104 |
1. Linux OS level pre-config
Without DNS | With DNS |
sudo vim /etc/hosts 10.0.1.102 mariadb-node1.ckc.im mariadb-node1 10.0.1.103 mariadb-node2.ckc.im mariadb-node2 10.0.1.204 mariadb-node3.ckc.im mariadb-node3 | config A record set correct target DNS for each node |
sudo apt update sudo apt -y install mariadb-server mariadb-client
sudo mysql_secure_installation
mariadb-node1
sudo vim /etc/mysql/mariadb.conf.d/50-server.cnf
mariadb-node2
sudo vim /etc/mysql/mariadb.conf.d/50-server.cnf
systemctl restart mariadb
Validate
mysql -u root -p
show status like 'wsrep_%';
>
wsrep_cluster_size 3
Reference:
https://computingforgeeks.com/install-mariadb-galera-cluster-on-ubuntu-with-proxysql/