MariaDB-Clustering-With-Galera-1

Topologi

Berikut ini adalah topologi yang digunakan:

Master : 103.41.xx.xx Slave 1 : 103.41.xx.xx Slave 2 : 103.41.xx.xx

Task

Berikut ini adalah task yang harus dikerjakan:

1. Instalasi dan konfigurasi Galera
2. Instalasi dan konfigurasi Nginx
3. Instalasi Wordpress
4. Penggunaan SSL For Free
5. Pengujian

Langkah Kerja

1. Instalasi dan Konfigurasi Galera

Master dan Slave

1. Menambahkan repositori MariaDB

yum update -y

sudo vi /etc/yum.repos.d/mariadb.repo

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.4/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

2. Melakukan instalasi MariaDB

yum install MariaDB-server MariaDB-client -y

yum list installed | grep mariadb

systemctl start mariadb

systemctl enable mariadb

systemctl status mariadb

Master

3. Konfigurasi galera pada master

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

[mysqld]
binlog_format=ROW
default-storage-engine=innodb
innodb_autoinc_lock_mode=2
bind-address=0.0.0.0

# Galera Provider Configuration
wsrep_on=ON
wsrep_provider=/usr/lib64/galera-4/libgalera_smm.so

# Galera Cluster Configuration
wsrep_cluster_name="test_cluster"
wsrep_cluster_address="gcomm://103.41.xx.xx,103.41.xx.xx,103.41.xx.xx"

# Galera Synchronization Configuration
wsrep_sst_method=rsync

# Galera Node Configuration
wsrep_node_address="103.41.xx.xx"
wsrep_node_name="Master"

Slave 1

4. Konfigurasi galera pada slave 1

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

[mysqld]
binlog_format=ROW
default-storage-engine=innodb
innodb_autoinc_lock_mode=2
bind-address=0.0.0.0

# Galera Provider Configuration
wsrep_on=ON
wsrep_provider=/usr/lib64/galera-4/libgalera_smm.so

# Galera Cluster Configuration
wsrep_cluster_name="test_cluster"
wsrep_cluster_address="gcomm://103.41.xx.xx,103.41.xx.xx,103.41.xx.xx"

# Galera Synchronization Configuration
wsrep_sst_method=rsync

# Galera Node Configuration
wsrep_node_address="103.41.xx.xx"
wsrep_node_name="Slave1"

Slave 2

5. Konfigurasi galera pada slave 2

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

[mysqld]
binlog_format=ROW
default-storage-engine=innodb
innodb_autoinc_lock_mode=2
bind-address=0.0.0.0

# Galera Provider Configuration
wsrep_on=ON
wsrep_provider=/usr/lib64/galera-4/libgalera_smm.so

# Galera Cluster Configuration
wsrep_cluster_name="test_cluster"
wsrep_cluster_address="gcomm://103.41.xx.xx,103.41.xx.xx,103.41.xx.xx"

# Galera Synchronization Configuration
wsrep_sst_method=rsync

# Galera Node Configuration
wsrep_node_address="103.41.xx.xx"
wsrep_node_name="Slave2"

Master dan Slave

6. Mematikan service MariaDB

systemctl stop mariadb

systemctl status mariadb