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

![GitHub Logo](https://cdn.shopify.com/shopifycloud/hatchful-web/assets/6fcc76cfd1c59f44d43a485167fb3139.png)

# 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
```