Affects Version/s: None
Fix Version/s: None
**Reported in Launchpad by Mario Splivalo last update 22-09-2016 10:51:08
I have three nodes configured on a ipv4+ipv6 mixed network. Both of my nodes have ipv4 and ipv6 addresses, however I have configured percona to use only ipv6. I am able to connect to 3306 port from/to each of the machines using only ipv6.
Due to issues with having IPv6 addresses in the configuration file I added the hostnames of the participating nodes in /etc/hosts file, with accompanying IPv6 addresses so that I'm sure that all the traffic goes over IPv6.
However, joiners can't receive data from donor because 'socat' on joiner is only listeninig on ipv4:
mysql 20553 20394 0 18:17 pts/1 00:00:00 socat -u TCP-LISTEN:4444,reuseaddr stdio
If, using the hostname, I try to connect, from donnor node to joiner node, I can't connect:
root@machine-1:/var/lib/mysql# telnet machine-2 4444
telnet: Unable to connect to remote host: Connection refused
When I use ipv4 address, all is good:
root@machine-1:/var/lib/mysql# host machine-2
machine-2.openstacklocal has address 10.5.19.139
root@machine-1:/var/lib/mysql# telnet 10.5.19.139 4444
Connected to 10.5.19.139.
Escape character is '^]'.
Of course, when I force socat to use TCP6-LISTEN (by hacking into the /usr/bin/wsrep_sst_xtrabackup-v2) SST finishes fine.
(As a workaround, when using rsync as a wsrep_sst_method, I am able to complete the SST, regardless of the issue mentioned in bug #1315528).