version:Percona-XtraDB-Cluster-8.0.26-rb141904-el8-x86_64
master node ：
# Template my.cnf for PXC
# Edit to your requirements.
[client]
socket=/var/lib/mysql/mysql.sock
[mysqld]
server-id=1
datadir=/data/pxc/data
socket=/var/lib/mysql/mysql.sock
log-error=/data/pxc/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
skip-host-cache
#skip-grant-tables
lower_case_table_names=1
# Binary log expiration period is 604800 seconds, which equals 7 days
binlog_expire_logs_seconds=604800
######## wsrep ###############
# Path to Galera library
wsrep_provider=/usr/lib64/galera4/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://10.1.13.163,10.1.13.164,10.1.13.165
# In order for Galera to work correctly binlog format should be ROW
binlog_format=ROW
# 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=10.1.13.163
# Cluster name
wsrep_cluster_name=pxc-cluster
#If wsrep_node_name is not specified, then system hostname will be used
wsrep_node_name=pxc-node-3
#pxc_strict_mode allowed values: DISABLED,PERMISSIVE,ENFORCING,MASTER
pxc_strict_mode=ENFORCING
# SST method
wsrep_sst_method=xtrabackup-v2
pxc-encrypt-cluster-traffic=OFF
#wsrep_sst_receive_address=10.1.13.163:4588
max_connections=5000
sql_mode =
node2:
# Template my.cnf for PXC
# Edit to your requirements.
[client]
socket=/var/lib/mysql/mysql.sock
[mysqld]
server-id=2
datadir=/data/pxc/data
socket=/var/lib/mysql/mysql.sock
log-error=/data/pxc/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
skip-host-cache
lower_case_table_names=1
# Binary log expiration period is 604800 seconds, which equals 7 days
binlog_expire_logs_seconds=604800
######## wsrep ###############
# Path to Galera library
wsrep_provider=/usr/lib64/galera4/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://10.1.13.163,10.1.13.164,10.1.13.165
# In order for Galera to work correctly binlog format should be ROW
binlog_format=ROW
# 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=10.1.13.164
# Cluster name
wsrep_cluster_name=pxc-cluster
#If wsrep_node_name is not specified, then system hostname will be used
wsrep_node_name=pxc-node-4
#pxc_strict_mode allowed values: DISABLED,PERMISSIVE,ENFORCING,MASTER
pxc_strict_mode=ENFORCING
# SST method
wsrep_sst_method=xtrabackup-v2
pxc-encrypt-cluster-traffic=OFF
#wsrep_sst_receive_address=10.1.13.164:4588
max_connections=5000
sql_mode =
node2 logs
2023-10-11T06:20:45.724405Z 0 [Note] [MY-000000] [Galera] cleaning up 395c0eb6-acd8 (tcp://10.1.13.165:4567)
2023-10-11T06:21:10.945092Z 0 [Note] [MY-000000] [WSREP-SST] 2023/10/11 14:21:10 socat[1366708] E SSL_accept(): error:1409441B:SSL routines:ssl3_read_bytes:tlsv1 alert decrypt error
2023-10-11T06:21:10.971836Z 0 [Warning] [MY-000000] [Galera] 1.0 (pxc-node-3): State transfer to 0.0 (pxc-node-4) failed: -32 (Broken pipe)
2023-10-11T06:21:10.973273Z 0 [ERROR] [MY-000000] [Galera] gcs/src/gcs_group.cpp:gcs_group_handle_join_msg():1214: Will never receive state. Need to abort.
2023-10-11T06:21:10.973321Z 0 [Note] [MY-000000] [Galera] gcomm: terminating thread
2023-10-11T06:21:10.973368Z 0 [Note] [MY-000000] [Galera] gcomm: joining thread
2023-10-11T06:21:10.973473Z 0 [Note] [MY-000000] [Galera] gcomm: closing backend
2023-10-11T06:21:11.165394Z 0 [ERROR] [MY-000000] [WSREP-SST] ******************* FATAL ERROR **********************
2023-10-11T06:21:11.165455Z 0 [ERROR] [MY-000000] [WSREP-SST] Error while getting data from donor node: exit codes: 0 1 0
2023-10-11T06:21:11.165470Z 0 [ERROR] [MY-000000] [WSREP-SST] Line 1296
2023-10-11T06:21:11.165512Z 0 [ERROR] [MY-000000] [WSREP-SST] ******************************************************
2023-10-11T06:21:11.165527Z 0 [ERROR] [MY-000000] [WSREP-SST] Cleanup after exit with status:32
2023-10-11T06:21:11.179306Z 0 [ERROR] [MY-000000] [WSREP] Process completed with error: wsrep_sst_xtrabackup-v2 --role 'joiner' --address '10.1.13.164' --datadir '/data/pxc/data/' --basedir '/usr/' --plugindir '/usr/lib64/mysql/plugin/' --defaults-file '/etc/my.cnf' --defaults-group-suffix '' --parent '1366234' --mysqld-version '8.0.26-16.1' '' : 32 (Broken pipe)
2023-10-11T06:21:11.179382Z 0 [ERROR] [MY-000000] [WSREP] Failed to read uuid:seqno from joiner script.
2023-10-11T06:21:11.179403Z 0 [ERROR] [MY-000000] [WSREP] SST script aborted with error 32 (Broken pipe)
2023-10-11T06:21:11.179530Z 3 [Note] [MY-000000] [Galera] Processing SST received
2023-10-11T06:21:11.179570Z 3 [Note] [MY-000000] [Galera] SST request was cancelled
2023-10-11T06:21:11.179606Z 3 [ERROR] [MY-000000] [Galera] State transfer request failed unrecoverably: 32 (Broken pipe). Most likely it is due to inability to communicate with the cluster primary component. Restart required.
2023-10-11T06:21:11.179631Z 3 [Note] [MY-000000] [Galera] ReplicatorSMM::abort()
2023-10-11T06:21:11.179654Z 3 [Note] [MY-000000] [Galera] Closing send monitor...
2023-10-11T06:21:11.179681Z 3 [Note] [MY-000000] [Galera] Closed send monitor.
2023-10-11T06:21:11.976799Z 0 [Note] [MY-000000] [Galera] Current view of cluster as seen by this node
view (view_id(NON_PRIM,39fb168a-a1e9,6)
memb {
39fb168a-a1e9,0
}
joined {
}
left {
}
partitioned {
e5c1930b-b81f,0
}
)
2023-10-11T06:21:11.976914Z 0 [Note] [MY-000000] [Galera] PC protocol downgrade 1 -> 0
2023-10-11T06:21:11.976940Z 0 [Note] [MY-000000] [Galera] Current view of cluster as seen by this node
view ((empty))
2023-10-11T06:21:11.977200Z 0 [Note] [MY-000000] [Galera] gcomm: closed
2023-10-11T06:21:11.977240Z 0 [Note] [MY-000000] [Galera] /usr/sbin/mysqld: Terminated.
2023-10-11T06:21:11.977267Z 0 [Note] [MY-000000] [WSREP] Initiating SST cancellation
2023-10-11T06:21:11.977279Z 3 [Note] [MY-000000] [Galera] gcomm: terminating thread
2023-10-11T06:21:11.977344Z 0 [Note] [MY-000000] [WSREP] Terminating SST process
2023-10-11T06:21:11.977372Z 3 [Note] [MY-000000] [Galera] gcomm: joining thread
