Linux serverNETWORK ADMINISTRATIONS

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’);”

============================================

source

centos 7

One thought on “Install Galera Mariadb Centos 7

Comments are closed.