ipv6 support

[Tom Atkinson]

Would be nice to support ipv6 addresses for wsrep_cluster_address and wsrep_node_address

[Alex Yurchenko (ayurchen)]

Specifically the following seems to be a problem:

130915 21:09:10 [ERROR] WSREP: failed to open gcomm backend connection: 255: getaddrinfo failed with error 'Name or service not known' (-2) for tcp://xxxx:xxxx:xxxx:xx::7: 255 (Unknown error 255)
         at galerautils/src/gu_resolver.cpp:resolve():491

[Xiang Hui (xianghui)]

Hey, I have the same issue, is there any latest update for this bug? Thanks.

[Alex Yurchenko (ayurchen)]

I think some people managed to get it working over IPv6 just by using hostnames instead of IP addresses.

[Xiang Hui (xianghui)]

Thanks Alex for your response, but I am still hitting error even using the hostname, the problems could be separated into two types, one is sometimes it can't resolve the hostname or ip even thoug they are written in the /etc/hosts, and another one is connection timeout, I have added these kind of info to https://groups.google.com/forum/#!topic/codership-team/ERsd_-9YLr0, any you could know about that is really helpful.

[Sergey (sergeymishine)]

Actually, i got Galera working over IPv6-only network.

To get Galera working over IPv6 you need add following line to your my.cnf(or replace if you already have the same one) _across all your nodes_:

wsrep_provider_options = "gmcast.listen_addr=tcp://[::]:4567;"

Also, i'm using Percona version of Galera cluster(XtraDB cluster), so there is included script for SST transfer /usr/bin/wsrep_sst_xtrabackup-v2. To make it working over IPv6 you need apply following sed:

# sed -i -e 's/socat -u/socat -6 -u/' /usr/bin/wsrep_sst_xtrabackup-v2

After that just run /etc/init.d/mysql start and node should get the SST.

[Pavel Safronov (pv-safronov)]

One small addition to Sergey answer:

You also have to set wsrep_cluster_address with port like this (with port number and without braces)

wsrep_cluster_address="gcomm://2b02:4c3:0:1126::1:8a:4567,2b02:4c3:0:1126::1:10:4567,2b02:4c3:0:1126::1:45:4567"

[Mario Splivalo (mariosplivalo)]

I've just verified what Pavel said in both percona-xtradb-cluster 5.5 and 5.6 (which are using galera 2.x and 3.x, respectively), and it works. No need to use hostnames, just add the port after the ipv4/ipv6 address.