MySQL Forums
Forum List  »  Replication

Advanced Search
New Topic

Re: Replication sql errors
Posted by: Peter Brawley
Date: May 06, 2021 11:17AM

Yes that can be a problem.

Also with row-based replication, 'making and restoring a backup can require more time. In addition, the binary log is locked for a longer time to write the data, which may cause concurrency problems [emphasis added]. Use binlog_row_image=minimal to reduce the disadvantage considerably." (https://dev.mysql.com/doc/refman/8.0/en/replication-sbr-rbr.html#replication-sbr-rbr-rbr-disadvantages). Did you choose row-based for a reason?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Replication sql errors
881
sharath s
May 01, 2021 06:47AM
Re: Replication sql errors
384
Peter Brawley
May 01, 2021 09:28AM
Re: Replication sql errors
472
sharath s
May 03, 2021 01:51AM
Re: Replication sql errors
410
Peter Brawley
May 03, 2021 11:07AM
Re: Replication sql errors
1102
sharath s
May 06, 2021 12:08AM
Re: Replication sql errors
556
Peter Brawley
May 06, 2021 11:17AM
Re: Replication sql errors
494
sharath s
May 07, 2021 04:25AM
Re: Replication sql errors
531
Peter Brawley
May 06, 2021 11:20AM
Re: Replication sql errors
484
sharath s
May 06, 2021 06:59AM


Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.