Hi,
I have configured below details in my.cnf of first node, But while bootstrap It’s not coming up.
[root@percona-xtradb1 mysql]# cat /etc/my.cnf
Template my.cnf for PXC
Edit to your requirements.
[client]
socket=/var/lib/mysql/mysql.sock
[mysqld]
server-id=2
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
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://172.16.12.222,172.16.12.223,172.16.12.224
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=percona-xtradb1
Cluster name
wsrep_cluster_name=pxc-cluster
#If wsrep_node_name is not specified, then system hostname will be used
wsrep_node_name=pxc2
#pxc_strict_mode allowed values: DISABLED,PERMISSIVE,ENFORCING,MASTER
pxc_strict_mode=ENFORCING
SST method
wsrep_sst_method=xtrabackup-v2
#Enable automatic configuration of SSL encryption
pxc-encrypt-cluster-traffic=ON
ssl-key=/home/adminuser/server-key.pem
ssl-ca=/home/adminuser/ca.pem
ssl-cert=/home/adminuser/server-cert.pem
[root@percona-xtradb1 mysql]# systemctl start mysql@bootstrap.service
Job for mysql@bootstrap.service failed because the control process exited with error code.
See “systemctl status mysql@bootstrap.service” and “journalctl -xeu mysql@bootstrap.service” for details.