MySQL : How to lock all write in all databases?

Question

I need to block all writes (insert , update, delete) on all databases. How can I do that ? Put all database in Read Only for a period time.

Answer 1

A quick search results in the correct chapter of the manual with:

mysql> FLUSH TABLES WITH READ LOCK;
mysql> SET GLOBAL read_only = ON;