Hello.
I have found two solutions and I’m using the 2nd.
1st solution - (not good, need edit the script):
edit /usr/bin/wsrep_sst_xtrabackup-v2, line 532:
replace
tcmd=“socat -u TCP-LISTEN:${TSST_PORT},reuseaddr${sockopt} stdio”
to
tcmd=“socat -u TCP6-LISTEN:${TSST_PORT},reuseaddr${sockopt} stdio”
restart mysql and sst will work using xtrabackup-v2.
2nd solution: (good, edit the config file):
before any changes, check joiner log:
2018-01-25T15:23:38.623734Z WSREP_SST: [DEBUG] The xtrabackup version is 2.4.9
2018-01-25T15:23:38.941069Z WSREP_SST: [DEBUG] Streaming with xbstream
2018-01-25T15:23:38.942338Z WSREP_SST: [DEBUG] Using socat as streamer
2018-01-25T15:23:39.006472Z WSREP_SST: [DEBUG] Evaluating timeout -k 110 100 socat -u TCP-LISTEN:4444,reuseaddr,retry=30 stdio | pv -f -i 10 -N joiner -F ‘%N => Rate:%r Avg:%a Elapsed:%t %e Bytes: %b %p’ | xbstream $xbstreameopts -x; RC=( ${PIPESTATUS[@]} )
edit my.cnf and add parameter:
[sst]
sockopt=“pf=ip6”
save the file, restart mysql and sst will work using xtrabackup-v2.
after restart I see in joiner log:
2018-01-25T15:25:42.423590Z WSREP_SST: [DEBUG] The xtrabackup version is 2.4.9
2018-01-25T15:25:42.767761Z WSREP_SST: [DEBUG] Streaming with xbstream
2018-01-25T15:25:42.769007Z WSREP_SST: [DEBUG] Using socat as streamer
2018-01-25T15:25:42.836480Z WSREP_SST: [DEBUG] Evaluating timeout -k 110 100 socat -u TCP-LISTEN:4444,reuseaddr,pf=ip6,retry=30 stdio | pv -f -i 10 -N joiner -F ‘%N => Rate:%r Avg:%a Elapsed:%t %e Bytes: %b %p’ | xbstream $xbstreameopts -x; RC=( ${PIPESTATUS[@]} )
I found this parameter in socat docs, but nothing in the xtrabackup docs.
I believe socat is only accepting IPv4 connections by default, after adding the parameter sockopt=“pf=ip6” all works fine.
Now, I can stop mysql, erase the data folder and sst transfer all data from any donor.
If this solution is okay for the community, I will mark it as solved.
BR