Bug #101975 Add replication per-channel filters settings example to documenation.
Submitted: 11 Dec 2020 14:28 Modified: 14 Dec 2020 7:11
Reporter: lalit Choudhary Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:8.0 OS:Any
Assigned to: CPU Architecture:Any

[11 Dec 2020 14:28] lalit Choudhary
Description:
It will good and easy reference for the user if we have an example for replication per-channel filters settings in mysql configuration file.

https://dev.mysql.com/doc/refman/8.0/en/replication-rules-channel-based-filters.html

per-channel filters setting:

replicate-do-db=channel_name:test
replicate-do-db=channel_name:my_db2
replicate-do-db=channel_name:my_db3
replicate-ignore-db=channel_name:db1
replicate-ignore-db=channel_name:db11
replicate-ignore-db=channel_name:my_db6
replicate-do-table=channel_name:test.t1
replicate-do-table=channel_name:test.t2
replicate-ignore-table=channel_name:test.t11
replicate-ignore-table=channel_name:test.t22
replicate-wild-do-table=channel_name:test.t%
replicate-wild-do-table=channel_name:test.s%
replicate-wild-ignore-table=channel_name:test.m%
replicate-wild-ignore-table=channel_name:test.n%
replicate-rewrite-db=channel_name:my_db7->rewrite_db7
replicate-rewrite-db=channel_name:my_db8->rewrite_db8

How to repeat:
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-channel-based-filters.html
[14 Dec 2020 7:11] MySQL Verification Team
Hello lalit Choudhary,

Thank you for the doc enhancement request.

regards,
Umesh