MySQL Error: impossible to write to binary log
There are 3 methods that MySQL can use to write to the binary logs:

STATEMENT
This means that every SQL statement on the master is recorded in the log, and executed on the slave.  This can cause problems if the SQL statement contains statements such as &quot;NOW()&quot;, &quot;RAND()&quot; and anything non-deterministic.  This also requires support from the storage engine in use.

ROW
This means that every row that is changed by a statement is individually recorded in the binary log.  This gives larger binary logs (generally) than statement based logging, but is almost always guaranteed to give the exact replication needed.

MIXED
This allows MySQL to choose between binary and row based logging as required.


If you're getting this error, one suggestion is to change the BINLOG_FORMAT variable to MIXED.  This allows MySQL to automatically switch between ROW and STATEMENT based logging as required.