MySQL Read Only
If you need to perform backup or replicate a database, you can lock up the database by doing a global read block to make it read-only.
The process is:
- Make the server read-only, so that it processes only retrievals and blocks updates.
- You can then perform the backup.
- Change the server back to its normal read/write state.
Read only.
<pre lang="bash">FLUSH TABLES WITH READ LOCK;
SET GLOBAL read_only = ON;
Back to normal mode.
<pre lang="bash">SET GLOBAL read_only = OFF;
UNLOCK TABLES;
You can run these MySQL commands within MySQL or via a bash terminal. Check out my previous post.