开发者

Skip a sql statement from replication (Mysql) ? [ Disables or enables binary logging for the current session ]

开发者 https://www.devze.com 2023-03-04 06:58 出处:网络
I want to do some inserts on a table (master mys开发者_高级运维ql DB) but I dont want to replicate without effecting the replication process. SET sql_log_bin = {0|1} Disables or enables binary logging

I want to do some inserts on a table (master mys开发者_高级运维ql DB) but I dont want to replicate without effecting the replication process.


SET sql_log_bin = {0|1} Disables or enables binary logging for the current session (sql_log_bin is a session variable) if the client has the SUPER privilege. The statement fails with an error if the client does not have that privilege

0

精彩评论

暂无评论...
验证码 换一张
取 消