How do I execute a command as and when a new mysql connection is established from php?
In the above example, I need to pass set sql command :
sql_log_bin = 0
This will make sure that the commands executed by this connection will not be written to binary log. I have another "normal" connection that will work as usual and write all the commands to binary log.
In other words I need 2 connections to mysql one with disabled binary logging. I should be able to decide which one to use. How is it done in PHP?