Running a query without affecting slave

Some times, you might want to run a query without slave updating with that query. In that case, you would have to avoid writing the query to the binary log , to do that, you would have to turn off binary logging for the current session. Login to the mysql and run the following query. Remember, you have to have SUPER privilege to do that :

SET sql_log_bin = 0;

Now any query you run will not be logged, however, this is true only for your current logged in session. If you want to turn the binary logging back on , set it back to 1.

SET sql_log_bin = 1;

You may also like...