Unable to add a mysql node to the percona cluster
Getting the below error while trying to add a node to the cluster
[![enter image description here][1]][1]
I have the below config settings
Node1(boot strapped node)
------------
[client]
socket=/var/lib/mysql/mysql.sock
port = 3306
[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
default_storage_engine = InnoDB
binlog_expire_logs_seconds=604800
wsrep_provider=/usr/lib64/galera4/libgalera_smm.so
wsrep_cluster_address=gcomm://172.32.17.83:3306,172.32.20.122:3306,10.0.168.105:3306
binlog_format=ROW
wsrep_slave_threads=8
wsrep_log_conflicts
innodb_autoinc_lock_mode=2
wsrep_node_address=172.32.20.122
wsrep_cluster_name=percona
pxc_strict_mode=ENFORCING
wsrep_sst_method=xtrabackup-v2
Node 2:
---------
[client]
socket=/var/lib/mysql/mysql.sock
port = 3306
[mysqld]
server-id=1
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
default_storage_engine = InnoDB
binlog_expire_logs_seconds=604800
wsrep_provider=/usr/lib64/galera4/libgalera_smm.so
wsrep_cluster_address=gcomm://172.32.17.83:3306,172.32.20.122:3306,10.0.168.105:3306
binlog_format=ROW
wsrep_slave_threads=8
wsrep_log_conflicts
innodb_autoinc_lock_mode=2
wsrep_node_address=172.32.17.83
wsrep_cluster_name=percona
wsrep_node_name=ip-172-32-17-83.eu-west-1.compute.internal
pxc_strict_mode=ENFORCING
wsrep_sst_method=xtrabackup-v2x
I have tried adding the entries of port 4567 to the IPtables and disable the firewall and run **service mysql start**
The SHOW STATUS LIKE 'wsrep%'; status is showing as primary
Any help would be appreciated
-
Official comment
Hi,
Can you please open a ticket with us? Please generate an error report from the ClusterControl and attach it to the ticket. We will try to understand what is happening in your cluster and help you.
Comment actions
Please sign in to leave a comment.
Comments
1 comment