© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
1b1ed1a
(Get the code!)
Similar to mysqldump, XtraBackup can potentially lower the impact from FTWRL if an extra FLUSH TABLES is executed before executing FLUSH TABLES WITH READ LOCK. That is, first wait for all currently executing queries to complete without placing a global read lock (and thus, without block new queries). Then try to acquire the global read lock.
There is of course always a chance that another long-running query is started in between. If so, we are in the same situation as we were without the extra FLUSH TABLES. Otherwise we get less downtime due to FTWRL.