MySQL Forums
Forum List  »  Replication

define replication filter rule for each slave thread.
Posted by: MiskoLee Lee
Date: May 05, 2022 01:45AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
define replication filter rule for each slave thread.
118
May 05, 2022 01:45AM


Sorry, only registered users may post in this forum.

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.