[MARIADB] GALERA CLUSTER ERP - fourslickz/notes GitHub Wiki

NODE-1

#
# * 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://10.130.249.230,10.130.249.231,10.130.249.232"

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

# 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

NODE-2

#
# * 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://10.130.249.230,10.130.249.231,10.130.249.232"

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

# 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

NODE-3

#
# * 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://10.130.249.230,10.130.249.231,10.130.249.232"

# Node configuration
wsrep_node_name="galera-node-03"
wsrep_node_address="10.130.249.232"

# 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