TL;DR version: The backup locks feature introduced in Percona
Server 5.6.16-64.0 is a lightweight alternative to
TABLES WITH READ LOCK and can be used to take both
physical and logical backups with less downtime on busy servers.
To employ the feature with
mysqldump --lock-for-backup --single-transaction.
The next release of Percona XtraBackup will also be using backup
locks automatically if the target server supports the
Now on to the gory details, but let’s start with some history.
In the beginning…
In the beginning there was …[Read more...]