Thanks. I got excited when I saw LOCK BINLOG FOR BACKUP (thinking I could run that, note the coordinates, take the snap, and release the lock) but it disappeared in 8.0.
mysql> select version();
±----------+
| version() |
±----------+
| 8.0.22-13 |
±----------+
1 row in set (0.00 sec)
mysql> lock binlog for backup;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘binlog for backup’ at line 1
There has to be a way to do this.
Do you know of any plans to make XtraBackup work with snapshots? That would be killer. Instead of copying nTB of data, just note the coordinates and snapshot the filesystem.