配置一192.168.70.71
[mysqld]
……
……
###--------------PXC--------------------------
# Path to Galera library
wsrep_provider=/usr/lib64/libgalera_smm.so
# Cluster connection URL contains the IPs of node#1, node#2 and node#3
wsrep_cluster_address=gcomm://192.168.70.71,192.168.70.72,192.168.70.73
# 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
# This changes how InnoDB autoincrement locks are managed and is a requirement for Galera
innodb_autoinc_lock_mode=2
# Node #1 address
wsrep_node_address=192.168.70.71
wsrep_node_name=gq-p2pdb-01
wsrep_slave_threads=8
# SST method#wsrep_sst_method=rsync
wsrep_sst_method=xtrabackup-v2
# Cluster name
wsrep_cluster_name=Percona
# Authentication for SST method
wsrep_sst_auth="sst:123456"
wsrep_provider_options="gcache.size=4G"配置92.168.70.72,192.168.70.73
只需修改红色部分
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29974949/viewspace-1813814/ ，如需转载，请注明出处，否则将追究法律责任。
