content_image/753996.jpg content_image/753994.jpg content_image/753995.jpg content_image/753997.jpg
The source metadata repository and the output of SHOW REPLICA STATUS  provide the list of servers that are currently ignored. For more information, see Section 17.2.4.2, “Replication Metadata Repositories” , and Section 13.7.7.35, “SHOW REPLICA | SLAVE STATUS Statement” . 

If a CHANGE REPLICATION SOURCE TO  statement is issued without any IGNORE_SERVER_IDS  option, any existing list is preserved. To clear the list of ignored servers, it is necessary to use the option with an empty list: 

CHANGE REPLICATION SOURCE TO IGNORE_SERVER_IDS = (); 

RESET REPLICA ALL  clears IGNORE_SERVER_IDS . 

<img src='content_image/753996.jpg'>

<img src='content_image/753994.jpg'>

option in a CHANGE REPLICATION SOURCE TO statement. 

<img src='content_image/753995.jpg'>

## Note 

A deprecation warning is issued if SET GTID_MODE=ON  is issued when any channel has existing server IDs set with IGNORE_SERVER_IDS . Before starting GTID- based replication, check for and clear all ignored server ID lists on the servers involved. The SHOW REPLICA STATUS  statement displays the list of ignored IDs, if there is one. If you do receive the deprecation warning, you can still clear a list after gtid_mode=ON  is set by issuing a CHANGE REPLICATION SOURCE TO  statement containing the IGNORE_SERVER_IDS  option with an empty list. 

<img src='content_image/753997.jpg'>

The user name and host name for the user account must follow the syntax described in Section 6.2.4, “Specifying Account Names” , and the user must not be an anonymous user (with a blank user name) or the CURRENT_USER . The account must have the REPLICATION_APPLIER privilege, plus the required privileges to execute the transactions replicated on the channel. For details of the privileges required by the account, see Section 17.3.3, “Replication Privilege Checks” . When you restart the replication channel, the privilege checks are applied from that 

