The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

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.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.