Binlog->GTID

更换复制模式（此过程每条命令需要每个实例并行操作）
    SET @@GLOBAL.GTID_MODE = ON_PERMISSIVE;
    SET @@GLOBAL.GTID_MODE = OFF_PERMISSIVE;
    SELECT @@GLOBAL.GTID_OWNED;
    SET @@GLOBAL.GTID_MODE = OFF;

修改配置文件
    gtid_mode=ON
    enforce_gtid_consistency=ON
    master_info_repository=TABLE
    relay_log_info_repository=TABLE
    log_slave_updates=ON
    slave-parallel-workers=16
    slave-parallel-type=LOGICAL_CLOCK
    slave_preserve_commit_order=1
 
修改相关参数

    STOP SLAVE;
    SET  GLOBAL slave_parallel_type ='LOGICAL_CLOCK';
    SET  GLOBAL slave_parallel_workers = 16;
    START SLAVE;

GTID->Binlog

更换复制模式（此过程每条命令需要每个实例并行操作）
 
    SET @@GLOBAL.ENFORCE_GTID_CONSISTENCY = WARN;
    SET @@GLOBAL.ENFORCE_GTID_CONSISTENCY = ON;
    SET @@GLOBAL.GTID_MODE = OFF_PERMISSIVE;
    SET @@GLOBAL.GTID_MODE = ON_PERMISSIVE;
    SHOW STATUS LIKE 'ONGOING_ANONYMOUS_TRANSACTION_COUNT';(确保此值为0后执行下一步)
    SET @@GLOBAL.GTID_MODE = ON;
     
 
注销配置文件相关参数
    #gtid_mode=ON
    #enforce_gtid_consistency=ON
    #master_info_repository=TABLE
    #relay_log_info_repository=TABLE
    #log_slave_updates=ON
  
    #MUlti-thread
    #slave-parallel-workers=16
    #slave-parallel-type=LOGICAL_CLOCK
    #slave_preserve_commit_order=1