diff --git a/README.md b/README.md index 50aaf60..b2dee06 100644 --- a/README.md +++ b/README.md @@ -53,3 +53,96 @@ 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 +```