Hi,
I have a cluster with 3 nodes, I’m setting up a 4th node to join the cluster, however need to have the same donor as the nodes number 3 only. Below is my my.cnf configuration and error that returns me to the log of the node 4.
MY.CNF - Node 4
[mysqld]
datadir=/var/lib/mysql
user=mysql
tmpdir=/tmp
server-id = 4
Path to Galera library
wsrep_provider=/usr/lib64/libgalera_smm.so
Cluster connection URL contains the IPs of node#1, node#2, node#3 and node#4
wsrep_cluster_address=gcomm://MYSQL01,MYSQL02,MYSQL03,MYSQL04
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 is a recommended tuning variable for performance
innodb_locks_unsafe_for_binlog=1
This changes how InnoDB autoincrement locks are managed and is a requirement for Galera
innodb_autoinc_lock_mode=2
wsrep_sst_donor=MYSQL03
Node #4 address
wsrep_node_address=MYSQL04
SST method
wsrep_sst_method=xtrabackup
Cluster name
wsrep_cluster_name=RHCLUSTER
Authentication for SST method
wsrep_sst_auth=“sstuser:pass”
ERROR node 4
130724 11:46:30 [Warning] WSREP: last inactive check more than PT1.5S ago (PT3.51292S), skipping check
130724 11:47:00 [Note] WSREP: view((empty))
130724 11:47:00 [ERROR] WSREP: failed to open gcomm backend connection: 110: failed to reach primary view: 110 (Connection timed out)
at gcomm/src/pc.cpp:connect():139
130724 11:47:00 [ERROR] WSREP: gcs/src/gcs_core.c:gcs_core_open():195: Failed to open backend connection: -110 (Connection timed out)
130724 11:47:00 [ERROR] WSREP: gcs/src/gcs.c:gcs_open():1289: Failed to open channel ‘RHCLUSTER’ at ‘gcomm://MYSQL01,MYSQL02,MYSQL03,MYSQL04’: -110 (Connection timed out)
130724 11:47:00 [ERROR] WSREP: gcs connect failed: Connection timed out
130724 11:47:00 [ERROR] WSREP: wsrep::connect() failed: 6
130724 11:47:00 [ERROR] Aborting
Could anyone help me?