SST smethod: rsync_wan
I'm looking for an option to make my SST faster. I tried using xtrabackup-v2 but this currently doesn't support GTID clusters.
I read that there is a rsync SST method that is customized for WAN usage. It makes use of delta transfers to reduce the data that has to be send over the WAN.
I've tried: wsrep_sst_method=rsync-wan wsrep_sst_method=rsync_wan
But neither of them work, nor can I find any official documentation about this feature for MariaDB.
I did find: http://galeracluster.com/documentation-webpages/statetransfer.html http://galeracluster.com/documentation-webpages/sst.html http://galeracluster.com/documentation-webpages/mysqlwsrepoptions.html#wsrep-sst-method https://blog.adminfactory.net/mariadb-and-galera-on-aws-amazon-linux.html
My question is how can I enable the delta transfer for rsync with MariaDB 10.1.12?
If this is not possible with MariaDB I'd like to know if there are any plans to implement it and if there are any plans to make xtrabackup-v2 support GTID clusters.
Answer Answered by Alex yurchenko in this comment.
Just in case it still matters, to use rsync_wan method one needs to rename/copy/link the usual wsrep_sst_rsync script to wsrep_sst_rsync_wan. Note however, that it will reduce network traffic at the expense of extra IO and therefore may not provide the expected speed gain.