MySQL statements

I have a Master DB and slave DB setup for replication and came across one of these statements on a website
----------------------------------------------
SET SQL_LOG_BIN = 0;
This statement is generally used with conjunction with replication
----------------------------------------------

Our Master DB logs bin files for replication on the slave server. Does running the above statement stop creating binlogs in the current session ?  Does running this command break the replication process ?

Your input and advice would be most appreciated

Thanks

CobraitiAsked:
Who is Participating?
 
mykdeConnect With a Mentor Commented:
SET SQL_LOG_BIN = 0;

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.

If the statement fails with an error it could stop replication.
0
 
CobraitiAuthor Commented:
So I could run this statement while replication is still running and it won't break the process assuming there are no errors - Would this be correct  ?

Thanks
0
 
mykdeCommented:
That is correct.
0
 
CobraitiAuthor Commented:
Thanks for clarifying.

Much appreciated :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.