Link to home
Start Free TrialLog in
Avatar of Cobraiti
Cobraiti

asked on

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

ASKER CERTIFIED SOLUTION
Avatar of Cory Hanson
Cory Hanson
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Cobraiti
Cobraiti

ASKER

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
That is correct.
Thanks for clarifying.

Much appreciated :)