Detailed explanation of mysql filtering replication ideas

#Add binlog-do-db=db_name in the configuration file #Define a whitelist and only record operations related to the specified database in the binary log. If the main database crashes, only the contents of the specified database will be restored. This is not recommended on the main server, as it will result in incomplete logs.
binlog-ignore-db=db_name #Define a blacklist. Write operations on the database defined as ignore will not be recorded in the binary log.

REPLICATE_DO_DB = (db_list) #Filter which libraries to copyREPLICATE_IGNORE_DB = (db_list) #Which libraries not to copyREPLICATE_DO_TABLE = (tbl_list) #Filter tableREPLICATE_IGNORE_TABLE = (tbl_list) #Ignore filtered tableREPLICATE_WILD_DO_TABLE = (wild_tbl_list) #Filter table according to regular matchREPLICATE_WILD_IGNORE_TABLE = (wild_tbl_list) #Ignore filtering these tables according to regular matchREPLICATE_REWRITE_DB = (db_pair_list)
#Rewrite the statements in db1 of the source database to db2 of the slave database
CHANGE REPLICATION FILTER REPLICATE_REWRITE_DB = ((db1, db2));

CHANGE REPLICATION FILTER filter[, filter][, ...]

filter: {
    REPLICATE_DO_DB = (db_list)
  | REPLICATE_IGNORE_DB = (db_list)
  | REPLICATE_DO_TABLE = (tbl_list)
  | REPLICATE_IGNORE_TABLE = (tbl_list)
  | REPLICATE_WILD_DO_TABLE = (wild_tbl_list)
  | REPLICATE_WILD_IGNORE_TABLE = (wild_tbl_list)
  | REPLICATE_REWRITE_DB = (db_pair_list)
}

# Implement filtered replication from the library stop slave sql_thread;
​ change replication filter replicate_do_db=(db);
​ start slave sql_thread;

#Cancel filtered replication stop slave sql_thread;
​ change replication filter replicate_do_db=();
​ start slave sql_thread;

Solution: Skip the erroneous operation step of the slave sql thread stop slave sql_thread;

#Find Executed_Gtid_Set and execute to 19
set gtid_next='94fc1fbe-b7a0-11eb-b0a0-000c2969aba1:20'; assign gtid to the next transaction begin; commit;
set gtid_next=automatic; the system automatically assigns gtid
start slave sql_thread;