Skip to content

Instantly share code, notes, and snippets.

@mshafiee
Created December 29, 2018 16:13
Show Gist options
  • Save mshafiee/b46b90707eba58db5607e843e9a90011 to your computer and use it in GitHub Desktop.
Save mshafiee/b46b90707eba58db5607e843e9a90011 to your computer and use it in GitHub Desktop.
[mysqld]
# Path to Galera library
wsrep_provider=/usr/lib/galera3/libgalera_smm.so
# Cluster connection URL contains IPs of nodes
#If no IP is found, this implies that a new cluster needs to be created,
#in order to do that you need to bootstrap this node
wsrep_cluster_address=gcomm://172.16.10.20,172.16.20.20,172.16.30.20
# In order for Galera to work correctly binlog format should be ROW
binlog_format=ROW
# MyISAM storage engine has only experimental support
default_storage_engine=InnoDB
# Slave thread to use
wsrep_slave_threads= 64 # Very Important 4*CPU
wsrep_log_conflicts
# This changes how InnoDB autoincrement locks are managed and is a requirement for Galera
innodb_autoinc_lock_mode=2
# Node IP address
wsrep_node_address=172.16.10.20
# Cluster name
wsrep_cluster_name=farayad-cluster
#If wsrep_node_name is not specified, then system hostname will be used
wsrep_node_name=pxc-node-10
#pxc_strict_mode allowed values: DISABLED,PERMISSIVE,ENFORCING,MASTER
pxc_strict_mode=ENFORCING
# SST method
wsrep_sst_method=xtrabackup-v2
#Authentication for SST method
wsrep_sst_auth="sstuser:s3creT"
~
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment