define replication filter rule for each slave thread.
since MySQL 5.7 supports dynamic change replication filter rule, details on
https://dev.mysql.com/doc/refman/5.7/en/change-replication-filter.html.
But looks like rules will be applied to all slaves if we have a user story:
1. Defined a slave to sync Table A, Table B.
2. Defined a slave to sync Table C, Table D.
all slaves need to receive all table events and filtering on the slave side in current. So, I am looking at how can we filter tables on the server side, it's very well to save network traffics.
Subject
Views
Written By
Posted
define replication filter rule for each slave thread.
546
May 05, 2022 01:45AM
Sorry, you can't reply to this topic. It has been closed.
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.