In general it is IMHO a very bad idea to use different data or log paths on different nodes. Cluster should be formed from homogeneous nodes in all aspects.
With rsync SST method, even if both nodes have the same datadir and innodb_data_home_dir paths, the SST fails. So the problem here is datadir != innodb_data_home_dir.
With wsrep_sst_method=xtrabackup-v2 this is no problem though.
[root@percona2 ~]# ls -lh /var/lib/mysql/
total 321M
-rw-------. 1 mysql mysql 129M Jun 17 12:04 galera.cache
-rw-rw----. 1 mysql mysql 104 Jun 17 12:04 grastate.dat
-rw-rw----. 1 mysql mysql 64M Jun 17 12:04 ib_logfile0
-rw-rw----. 1 mysql mysql 64M Jun 17 12:04 ib_logfile1
-rw-rw----. 1 mysql mysql 64M Jun 17 12:04 ib_logfile101
drwx------. 2 mysql mysql 4.0K Jun 17 12:04 mysql
-rw-rw----. 1 mysql mysql 191 Jun 17 12:04 percona1-bin.000008
-rw-rw----. 1 mysql mysql 0 Jun 17 12:04 percona2-bin.index
-rw-r-----. 1 mysql root 15K Jun 17 12:04 percona2_error.log
drwx------. 2 mysql mysql 4.0K Jun 17 12:04 performance_schema
drwx------. 2 mysql mysql 4.0K Jun 17 12:04 test
[root@percona2 ~]# ls -lh /srv/mysql/
total 12M
-rw-rw----. 1 mysql mysql 12M Jun 17 12:04 ibdata1
Error logs in attachments. Clearly the ibdata1 was not copied from donor.
In general it is IMHO a very bad idea to use different data or log paths on different nodes. Cluster should be formed from homogeneous nodes in all aspects.
With rsync SST method, even if both nodes have the same datadir and innodb_ data_home_ dir paths, the SST fails. So the problem here is datadir != innodb_ data_home_ dir. method= xtrabackup- v2 this is no problem though.
With wsrep_sst_
This is the configuration I used on nodes.
Donor:
[root@percona1 ~]# cat /etc/my.cnf /var/lib/ mysql data_home_ dir = /srv/mysql percona1_ error.log /usr/lib64/ libgalera_ smm.so address= gcomm:/ /192.168. 3.2,192. 168.3.3, 192.168. 3.4 address= 192.168. 3.2 threads= 2 name=L1 method= rsync sst_method= xtrabackup- v2 auth=root: provider_ options = "pc.ignore_ sb=true; gcache. size=64M" name=percona1 locks_unsafe_ for_binlog= 1 autoinc_ lock_mode= 2 log_file_ size=64M 192.168. 3.2 file_per_ table=1 gtid_consistenc y=1 percona1- bin
[mysqld]
datadir=
innodb_
user=mysql
log_error=
binlog_format=ROW
wsrep_provider=
wsrep_cluster_
wsrep_node_
wsrep_slave_
wsrep_cluster_
wsrep_sst_
#wsrep_
wsrep_sst_
#wsrep_
wsrep_node_
innodb_
innodb_
innodb_
bind-address=
innodb_
log_slave_updates
server-id=1
#support GTID
enforce_
gtid_mode=on
log-bin=
Joiner:
[root@percona2 ~]# cat /etc/my.cnf /var/lib/ mysql data_home_ dir = /srv/mysql
[mysqld]
datadir=
innodb_
user=mysql percona2_ error.log /usr/lib64/ libgalera_ smm.so address= gcomm:/ /192.168. 3.2,192. 168.3.3, 192.168. 3.4 address= 192.168. 3.3 threads= 2 name=L1 method= rsync sst_method= xtrabackup- v2 auth=root: name=percona2 locks_unsafe_ for_binlog= 1 autoinc_ lock_mode= 2 log_file_ size=64M 192.168. 3.3 file_per_ table=1 gtid_consistenc y=1 percona2- bin
log_error=
binlog_format=ROW
wsrep_provider=
wsrep_cluster_
wsrep_node_
wsrep_slave_
wsrep_cluster_
wsrep_sst_
#wsrep_
wsrep_sst_
wsrep_node_
innodb_
innodb_
innodb_
bind-address=
innodb_
log_slave_updates
server-id=2
#support GTID
enforce_
gtid_mode=on
log-bin=
After SST on joiner:
[root@percona2 ~]# ls -lh /var/lib/mysql/
total 321M
-rw-------. 1 mysql mysql 129M Jun 17 12:04 galera.cache
-rw-rw----. 1 mysql mysql 104 Jun 17 12:04 grastate.dat
-rw-rw----. 1 mysql mysql 64M Jun 17 12:04 ib_logfile0
-rw-rw----. 1 mysql mysql 64M Jun 17 12:04 ib_logfile1
-rw-rw----. 1 mysql mysql 64M Jun 17 12:04 ib_logfile101
drwx------. 2 mysql mysql 4.0K Jun 17 12:04 mysql
-rw-rw----. 1 mysql mysql 191 Jun 17 12:04 percona1-bin.000008
-rw-rw----. 1 mysql mysql 0 Jun 17 12:04 percona2-bin.index
-rw-r-----. 1 mysql root 15K Jun 17 12:04 percona2_error.log
drwx------. 2 mysql mysql 4.0K Jun 17 12:04 performance_schema
drwx------. 2 mysql mysql 4.0K Jun 17 12:04 test
[root@percona2 ~]# ls -lh /srv/mysql/
total 12M
-rw-rw----. 1 mysql mysql 12M Jun 17 12:04 ibdata1
Error logs in attachments. Clearly the ibdata1 was not copied from donor.