[LINUX] MARIADB GALERA METHOD RSYNC UBUNTU 22.04 - fourslickz/notes GitHub Wiki

NODE-1

Install package

apt install mariadb-server rsync

Stop service mariadb

systemctl stop mariadb

edit galera config

nano /etc/mysql/mariadb.conf.d/60-galera.cnf
#
# * Galera-related settings
#
# See the examples of server wsrep.cnf files in /usr/share/mysql
# and read more at https://mariadb.com/kb/en/galera-cluster/

[galera]
# Mandatory settings
wsrep_provider           = /usr/lib/galera/libgalera_smm.so
wsrep_on                 = ON
wsrep_cluster_name       = "MariaDB Galera Cluster"
wsrep_cluster_address    = "gcomm://103.175.216.175,103.175.216.168"

# Node configuration
wsrep_node_name="galera-node-01"
wsrep_node_address="103.175.216.175"

# SST (State Snapshot Transfer)
wsrep_sst_method=rsync

binlog_format            = row
default_storage_engine   = InnoDB
innodb_autoinc_lock_mode = 2

# Allow server to accept connections on all interfaces.
bind-address = 0.0.0.0

# Optional settings
wsrep_slave_threads = 1
innodb_flush_log_at_trx_commit = 0

Generate Galera Cluster

galera_new_cluster

Check status mariadb

systemctl status mariadb

NODE-2

/etc/mysql/mariadb.conf.d/60-galera.cnf

#
# * Galera-related settings
#
# See the examples of server wsrep.cnf files in /usr/share/mysql
# and read more at https://mariadb.com/kb/en/galera-cluster/

[galera]
# Mandatory settings
wsrep_provider           = /usr/lib/galera/libgalera_smm.so
wsrep_on                 = ON
wsrep_cluster_name       = "MariaDB Galera Cluster"
wsrep_cluster_address    = "gcomm://103.175.216.175,103.175.216.168"

# Node configuration
wsrep_node_name="galera-node-02"
wsrep_node_address="103.175.216.168"

# SST (State Snapshot Transfer)
wsrep_sst_method=rsync

binlog_format            = row
default_storage_engine   = InnoDB
innodb_autoinc_lock_mode = 2

# Allow server to accept connections on all interfaces.
bind-address = 0.0.0.0

# Optional settings
wsrep_slave_threads = 1
innodb_flush_log_at_trx_commit = 0

check state

mysql -u root -p -e "SHOW VARIABLES LIKE 'wsrep_provider';"
mysql -u root -p -e "SHOW STATUS LIKE 'wsrep_cluster_status';"
mysql -u root -p -e "SHOW STATUS LIKE 'wsrep_cluster_size';"
mysql -u root -p -e "SHOW VARIABLES LIKE 'wsrep_cluster_address';"
mysql -u root -p -e "SHOW STATUS LIKE 'wsrep_local_state_comment';"