Answer the question
In order to leave comments, you need to log in
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 questionAsk a Question
731 491 924 answers to any question