{{tag>[centos 6.5 mysql powerdns]}}

=====PowerDNS crashing - binary logging not possible=====

If PowerDNS is crashing with the following message
<code>
Exiting because communicator thread died with error: 
GSQLBackend unable to refresh domain_id 3: 
Failed to execute mysql_query, perhaps connection died? 
Err=1: Binary logging not possible. 
Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'
</code>

You can fix this with:
   mysql> SET GLOBAL binlog_format = 'ROW';
   
The error arises only if the binary logging option, which is required for the replication, is turned on for the MySQL server.