Timeline for How to pause MySQL before taking an LVM/ZFS snapshot?
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 17, 2016 at 13:40 | vote | accept | fadedbee | ||
| Oct 10, 2016 at 14:31 | comment | added | Thomas | Adding, it does not stop any transactions, but waits for them to finish. You can do without the first command, it just waits for the transactions to finish. | |
| Oct 10, 2016 at 14:13 | comment | added | Thomas | The read lock is a global read lock: dev.mysql.com/doc/refman/5.7/en/flush.html " FLUSH TABLES WITH READ LOCK Closes all open tables and locks all tables for all databases with a global read lock. This is a very convenient way to get backups if you have a file system such as Veritas or ZFS that can take snapshots in time. Use UNLOCK TABLES to release the lock. " | |
| Oct 10, 2016 at 13:50 | comment | added | Rui F Ribeiro | how exactly in a multiuser system you gurantee the transsctions will stop? | |
| Oct 10, 2016 at 12:58 | history | answered | Thomas | CC BY-SA 3.0 |