Hi all,
I'm trying to get working a galera cluster with IPv6 but it doesn't work and my 2nd node won't join the cluster.
When I launch mysqld on the 2nd node here's the log :
151010 12:05:59 [Note] WSREP: State transfer required:
Group state: 6efb46cc-565b-11e5-af41-33af6c7758d0:8765
Local state: 00000000-0000-0000-0000-000000000000:-1
151010 12:05:59 [Note] WSREP: New cluster view: global state: 6efb46cc-565b-11e5-af41-33af6c7758d0:8765, view# 97: Primary, number of nodes: 2, my index: 0, protocol version 3
151010 12:05:59 [Warning] WSREP: Gap in state sequence. Need state transfer.
151010 12:05:59 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'joiner' --address '192.168.1.220' --auth '' --datadir '/var/lib/mysql/' --defaults-file '/etc/mysql/my.cnf' --defaults-group-suffix '' --parent '2768' --binlog '/var/log/mysql/mariadb-bin' '
151010 12:05:59 [Note] WSREP: Prepared SST request: rsync|
192.168.1.220:4444/rsync_sst151010 12:05:59 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
Here's the log on my 1st server :
Oct 10 18:07:10 mx02-2 mysqld: 151010 18:07:10 [Note] WSREP: (8c4d4cd8, 'tcp://[::]:4567') reconnecting to 84eae1b1 (tcp://[2a01:e34:ec7d:490::10]:4567), attempt 30
Oct 10 18:07:55 mx02-2 mysqld: 151010 18:07:55 [Note] WSREP: (8c4d4cd8, 'tcp://[::]:4567') reconnecting to 84eae1b1 (tcp://[2a01:e34:ec7d:490::10]:4567), attempt 60
Oct 10 18:08:06 mx02-2 mysqld: rsync: failed to connect to 192.168.1.220 (192.168.1.220): Connection timed out (110)
Oct 10 18:08:06 mx02-2 mysqld: rsync error: error in socket IO (code 10) at clientserver.c(128) [sender=3.1.1]
Oct 10 18:08:06 mx02-2 mysqld: WSREP_SST: [ERROR] rsync returned code 10: (20151010 18:08:06.147)
Oct 10 18:08:06 mx02-2 mysqld: 151010 18:08:06 [ERROR] WSREP: Failed to read from: wsrep_sst_rsync --role 'donor' --address '
192.168.1.220:4444/rsync_sst' --auth '(null)' --socket '/var/run/mysqld/mysqld.sock' --datadir '/var/lib/mysql/' --defaults-file '/etc/mysql/
my.cnf' --defaults-group-suffix '' --binlog '/var/log/mysql/mariadb-bin' --gtid '6efb46cc-565b-11e5-af41-33af6c7758d0:8765'
Oct 10 18:08:06 mx02-2 mysqld: 151010 18:08:06 [ERROR] WSREP: Process completed with error: wsrep_sst_rsync --role 'donor' --address '
192.168.1.220:4444/rsync_sst' --auth '(null)' --socket '/var/run/mysqld/mysqld.sock' --datadir '/var/lib/mysql/' --defaults-file '/etc/my
sql/my.cnf' --defaults-group-suffix '' --binlog '/var/log/mysql/mariadb-bin' --gtid '6efb46cc-565b-11e5-af41-33af6c7758d0:8765': 255 (Unknown error 255)
And my configuration on node 2 :
wsrep_cluster_address="gcomm://dbcluster1,dbcluster2,dbcluster3,dbcluster4"
wsrep_sst_method=rsync
wsrep_provider_options = "gmcast.listen_addr=tcp://[::]:4567;"
wsrep_node_name="dbcluster1"
Do you have any ideas ?
Regards,
bbcorp