Not the answer you need?
Register and ask your own question!

Percona and FTWRL

johntestjohntest ContributorInactive User Role Beginner
Hi there,

I am looking at couple of docs
https://www.percona.com/blog/2014/12/22/testing-backup-locks-during-xtrabackup-sst-on-percona-xtradb-cluster/
https://www.percona.com/doc/percona-xtradb-cluster/5.6/limitation.html

The first blog mentions that backup locks are preferable to FTWRL.

However, doc on limitations mentions

""" Backup locks used during SST or with Xtrabackup can crash, on donor, either use inno-backup-opts=’–no-backup-locks’ under [sst] in my.cnf or set FORCE_FTWRL=1 in /etc/sysconfig/mysql (or /etc/sysconfig/mysql.%i for corresponding unit/service) for CentOS/RHEL or /etc/default/mysql in debian/ubuntu. You can also use rsync as the alternate SST method if those don’t work. """

Is this still a limitation? If so, does it happen often under heavy load?


Thanks
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.