Can we set Replication Filters per channel in MySQL Multi-Source Replication?

Can we set Replication Filters per channel in MySQL Multi-Source Replication?


Yes, it is possible to set replication filters per channel in MySQL Multi-Source Replication. Replication filters allow you to specify which data should be replicated and which should not be replicated. This feature can be useful when you want to replicate a subset of data from a specific source and exclude certain data. In MySQL Multi-Source Replication, you can set replication filters per channel by using the REPLICATE_DO_TABLE, REPLICATE_IGNORE_TABLE, REPLICATE_DO_DB, and REPLICATE_IGNORE_DB options. These options allow you to specify which tables and databases should be replicated and which should not be replicated. For example, to replicate only certain tables from a specific source, you can use the REPLICATE_DO_TABLE option. You can specify the name of the table you want to replicate and the channel name. Similarly, to exclude certain tables from replication, you can use the REPLICATE_IGNORE_TABLE option. You can also set replication filters for databases using the REPLICATE_DO_DB and REPLICATE_IGNORE_DB options. It's worth noting that these filters can be set on the slave side, the master side, or both. The syntax would be different if you want to set it on the master side. Additionally, it's important to note that these options are mutually exclusive, i.e., you can't set REPLICATE_DO_TABLE and REPLICATE_IGNORE_TABLE for the same channel at the same time.
About Shiv Iyer 72 Articles
Open Source Database Systems Engineer with a deep understanding of Optimizer Internals, Performance Engineering, Scalability and Data SRE. Shiv currently is the Founder, Investor, Board Member and CEO of multiple Database Systems Infrastructure Operations companies in the Transaction Processing Computing and ColumnStores ecosystem. He is also a frequent speaker in open source software conferences globally.

Be the first to comment

Leave a Reply