Skip to content

Instantly share code, notes, and snippets.

@raykao
Created February 10, 2017 19:10
Show Gist options
  • Save raykao/027e42847392a0eafb6c7b51c3291191 to your computer and use it in GitHub Desktop.
Save raykao/027e42847392a0eafb6c7b51c3291191 to your computer and use it in GitHub Desktop.
Basic MariaDB Galera Cluster configuration file.
# /etc/mysql/conf.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/lib/galera/libgalera_smm.so
# Galera Cluster Configuration
wsrep_cluster_name="mariadb_galerna_cluster"
wsrep_cluster_address="gcomm://first_ip"
# Galera Synchronization Configuration
wsrep_sst_method=rsync
# Galera Node Configuration
wsrep_node_address="this_node_ip"
wsrep_node_name="this_node_name"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment