A
A
Aleks3052015-05-19 10:08:51
MySQL
Aleks305, 2015-05-19 10:08:51

Binary log format for mysql replication?

Good afternoon, colleagues.
Please advise on this situation. There are three sites on Bitrix and three databases, respectively. Set up mysql replication with MIXED binary log format. Everything worked but replication fell down on the delete request. I showed it to the developers - they shrug their shoulders. I read that the STATEMENT binary log format (more ancient, so to speak) is "tolerant" to such deletes. Decided to reconfigure it. After the rebuild, on the master server, to my amazement, Bitrix for two of the three sites began to show db query error. Returned MIXED - everything is ok. Put STATEMENT back, two sites are ok, the third one is db query error.
There are no errors in the mysql logs.
Friends, do not tell me if anyone has experienced this. If not, where to move on this task in order to solve the problem.
It is clear that in the first place you need to look at query optimization, but, unfortunately, this is apparently impossible.
Thanks to all!

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question