• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 359
  • Last Modified:

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

0
Cobraiti
Asked:
Cobraiti
  • 2
  • 2
1 Solution
 
mykdeCommented:
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

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now