wsrep_sst_method with IPv6

Performing SSTs with IPv6 Addresses

If you are performing Mariabackup SSTs with IPv6 addresses, then the socat utility needs to be passed the pf=ip6 option. This can be done by setting the sockopt option in the [sst] option group in an option file. For example:

 

[sst]

sockopt=",pf=ip6"

 

 

See MDEV-18797 for more information.

 

https://mariadb.com/kb/en/library/mariabackup-sst-method/

mariabackup SST Method

https://mariadb.com/kb/en/library/xtrabackup-v2-sst-method/

xtrabackup-v2 SST Method

 

 

 

1st solution - (not good, need edit the script):
edit /usr/bin/wsrep_sst_xtrabackup-v2(or wsrep_sst_mariabackup), 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.(or mariabackup)