全局锁
FLUSH TABLES WITH READ LOCK
# 只读
lock tables test read;
制锁定某一个表,不影响其他表的写操作
主从复制 - 上只读库
/etc/my.cnf
read_only=1
# slave主机上操作
GRANT SElECT ON *.* TO 'username'@'%' IDENTIFIED BY "password";
# master主机上建立普通用户
FLUSH TABLES WITH READ LOCK
# 只读
lock tables test read;
制锁定某一个表,不影响其他表的写操作
/etc/my.cnf
read_only=1
# slave主机上操作
GRANT SElECT ON *.* TO 'username'@'%' IDENTIFIED BY "password";
# master主机上建立普通用户
转载于:https://my.oschina.net/attacker/blog/3053710