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
• Status: Verified
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 8.0
• OS: Any
• 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