Solved

MySQL statements

Posted on 2011-09-20
4
348 Views
Last Modified: 2012-05-12
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
Comment
Question by:Cobraiti
  • 2
  • 2
4 Comments
 
LVL 3

Accepted Solution

by:
mykde earned 500 total points
ID: 36571579
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
 

Author Comment

by:Cobraiti
ID: 36571832
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
 
LVL 3

Expert Comment

by:mykde
ID: 36571965
That is correct.
0
 

Author Comment

by:Cobraiti
ID: 36577987
Thanks for clarifying.

Much appreciated :)
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now