MariaDB - Config Galera Cluster in RockyOS

MariaDB - Config Galera Cluster in RockyOS

I. Install MariaDB

Ref: 

1. https://www.digitalocean.com/community/tutorials/how-to-install-mariadb-on-centos-7

2. https://centlinux.com/install-mariadb-galera-cluster-on-linux/

II. Install Galera Cluster

-- Install Galera Pacakges

$ dnf -y install mariadb-server-galera 

-- Open firewall 

$ $firewall-cmd --add-service=mysql

$ firewall-cmd --add-port={3306/tcp,4567/tcp,4568/tcp,4444/tcp}

$ firewall-cmd --runtime-to-permanent 

-- Config Node as below

$ vi /etc/my.cnf.d/galera.cnf 

-- Stop/Start Maria Server again. If not, we can reboot servers

-- Check Galera work or not

$mysql -uroot -p
SQL: 

- SHOW STATUS LIKE 'wsrep_%'" // Show all parameter

- show global status like 'wsrep_cluster_size'; /. Show Cluster Node Number

We can test that by creating a new database in node #1 and checking on node #2.

is updating...