[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:// # 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= 8 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=192.168.70.63 # Cluster name #wsrep_cluster_name=pxc-cluster #If wsrep_node_name is not specified, then system hostname will be used #wsrep_node_name=pxc-cluster-node-1 #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:s3cretPass" #------------------------------------------------------------------------------# wsrep_cluster_name = pxc-cluster_3321 wsrep_sst_method = rsync wsrep_sst_auth = "repliuser:geheimesPasswort" ### Standard für DB: 3306 -> 233XX port = 23321 bind-address = 0.0.0.0 ### Standard für SST: 4444 -> 33XX4 (das , am Zeilenende muss unbedingt bleiben) ### Standard für IST / replication: 4568 -> 33XX8 (:) wsrep_sst_donor = galera01.lan:33214,galera02.lan:33214,galera03.lan:33214, ### Standard für InterCom: 4567 -> 33XX7 #wsrep_cluster_address = gcomm:// wsrep_cluster_address = "gcomm://galera01.lan:33217,galera02.lan:33217,galera03.lan:33217" ### Standard für GCache: 128 MB -> 4G ### IST bezieht seine Daten aus dem GCache, vergleichbar mit der BIN-LOG-Historie bei GTID-Replikation ### Je größer der GCache ist, desto länger dürfen Wartungsarbeiten sein. wsrep_provider_options = "gcache.size=4G;" #------------------------------------------------------------------------------#