Bug #98823 incorrect documentation

• Submitted: 4 Mar 2020 7:42
• Modified: 6 Mar 2020 21:52
• Reporter: Timur Solodovnikov
• Status: Not a Bug
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 5.7
• OS: Any
• Assigned to: MySQL Verification Team
• CPU Architecture: Any
• Tags: mtr, replication

[4 Mar 2020 7:42] Timur Solodovnikov

Description:
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-adding-gtid-master.html

Example has "FOR CHANNEL" extension,

mysql> CHANGE REPLICATION FILTER REPLICATE_WILD_DO_TABLE = ('db1.%') FOR CHANNEL "master_1";
mysql> CHANGE REPLICATION FILTER REPLICATE_WILD_DO_TABLE = ('db2.%') FOR CHANNEL "master_2";

As I understand it is introduced on 8 and it doesn't work for 5.7

Please fix.

How to repeat:
N/A

Suggested fix:
Adjust documentation for 5.7

[6 Mar 2020 15:26] MySQL Verification Team

Hi,
It does work in latest 5.7 too 

slave1 [localhost:19530] {msandbox} ((none)) > set global gtid_mode=off_permissive;
Query OK, 0 rows affected (0.01 sec)

slave1 [localhost:19530] {msandbox} ((none)) > set global gtid_mode=on_permissive;
Query OK, 0 rows affected (0.00 sec)

slave1 [localhost:19530] {msandbox} ((none)) > set global ENFORCE_GTID_CONSISTENCY=on;
Query OK, 0 rows affected (0.00 sec)

slave1 [localhost:19530] {msandbox} ((none)) > set global gtid_mode=on;
Query OK, 0 rows affected (0.01 sec)

slave1 [localhost:19530] {msandbox} ((none)) > CHANGE MASTER TO MASTER_HOST="127.0.0.1", MASTER_PORT=19529, MASTER_USER="rsandbox", MASTER_PASSWORD="rsandbox", MASTER_AUTO_POSITION=1 FOR CHANNEL "master_1";
Query OK, 0 rows affected, 2 warnings (0.01 sec)

slave1 [localhost:19530] {msandbox} ((none)) > start slave
    -> ;
Query OK, 0 rows affected (0.00 sec)

slave1 [localhost:19530] {msandbox} ((none)) > select @@version;
+------------+
| @@version  |
+------------+
| 5.7.28-log |
+------------+
1 row in set (0.00 sec)

slave1 [localhost:19530] {msandbox} ((none)) >
slave1 [localhost:19530] {msandbox} (information_schema) > show slave status
...
                 Channel_Name: master_1
           Master_TLS_Version:
2 rows in set (0.00 sec)

[6 Mar 2020 21:52] Timur Solodovnikov

Can you run 

CHANGE REPLICATION FILTER REPLICATE_WILD_DO_TABLE = ('db1.%') FOR CHANNEL "master_1";

not "change master to" please?