Created
December 29, 2018 16:13
-
-
Save mshafiee/b46b90707eba58db5607e843e9a90011 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[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