Install Galera Mariadb Centos 7
yum updaye -y
===============================
sudo vi /etc/yum.repos.d/MariaDB.repo
#MariaDB 10.5 CentOS repository list – created 2022-01-17 03:23 UTC
# https://mariadb.org/download/
[mariadb]
name = MariaDB
baseurl = https://mirror.its.dal.ca/mariadb/yum/10.5/centos7-amd64
gpgkey=https://mirror.its.dal.ca/mariadb/yum/RPM-GPG-KEY-MariaDB
gpgcheck=1
sudo yum makecache –disablerepo=’*’ –enablerepo=’mariadb’
sudo yum install MariaDB-server MariaDB-client -y
sudo systemctl start mariadb
sudo mysql_secure_installation
sudo systemctl start rsyncd
sudo systemctl enable rsyncd
sudo yum install rsync policycoreutils-python -y
sudo vi /etc/my.cnf.d/server.cnf
==================
Firewalld
sudo firewall-cmd –permanent –zone=public –add-port=3306/tcp
sudo firewall-cmd –permanent –zone=public –add-port=4567/tcp
sudo firewall-cmd –permanent –zone=public –add-port=4568/tcp
sudo firewall-cmd –permanent –zone=public –add-port=4444/tcp
sudo firewall-cmd –permanent –zone=public –add-port=4567/udp
sudo firewall-cmd –reload
======================
Selinux
sudo semanage port -a -t mysqld_port_t -p tcp 4567
sudo semanage port -a -t mysqld_port_t -p udp 4567
sudo semanage port -a -t mysqld_port_t -p tcp 4568
sudo semanage port -a -t mysqld_port_t -p tcp 4444
sudo semanage permissive -a mysqld_t
sudo systemctl stop mariadb
=========================
First Node
================
sudo galera_new_cluster
second Node
====================
sudo systemctl start mariadb
third node
========================
sudo systemctl start mariadb
verif:
=======================
mysql -u root -p –execute=”SHOW GLOBAL STATUS WHERE Variable_name IN (‘wsrep_ready’, ‘wsrep_cluster_size’, ‘wsrep_cluster_status’, ‘wsrep_connected’);”
============================================
centos 7
why there's no voice on this video?