search

chusiang / mysql-master-master

Automatically exported from code.google.com/p/mysql-master-master
GNU General Public License v2.0
1 stars 1 forks source link

Maybe obtain a global read lock before setting read_only=1 #20

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
Maybe mysql_deny_write should obtain a global read lock before setting
read_only=1

FLUSH TABLES WITH READ LOCK;
SET GLOBAL read_only = ON;
UNLOCK TABLES;

See http://bugs.mysql.com/22009 and http://bugs.mysql.com/bug.php?id=11733

Original issue reported on code.google.com by m...@pascalhofmann.de on 2 Nov 2008 at 10:59

GoogleCodeExporter commented 9 years ago 
If we implement this, the agent user needs RELOAD privileges.

Original comment by m...@pascalhofmann.de on 4 Nov 2008 at 10:14

GoogleCodeExporter commented 9 years ago

Original comment by baron.schwartz on 15 Jan 2009 at 2:05