Skip error replica Master to Master

 STOP REPLICA;

STOP REPLICA SQL_THREAD;
SET @@SESSION.sql_log_bin = 0;
SET GLOBAL sql_replica_skip_counter = 1;
START REPLICA;
SHOW REPLICA STATUS\G


SELECT * FROM performance_schema.replication_applier_status_by_worker;

STOP SLAVE;
RESET SLAVE ALL;
CHANGE MASTER TO
  MASTER_HOST='10.207.7.1',
  MASTER_USER='mirror',
  MASTER_PASSWORD='J1d8$9Ym8tSkOQPE2',
  MASTER_AUTO_POSITION=1;
START SLAVE;
SHOW REPLICA STATUS\G


STOP SLAVE;
CHANGE MASTER TO
  MASTER_HOST='10.211.1.1',
  MASTER_USER='mirror',
  MASTER_PASSWORD='J1d8$9Ym8tSkOQPE2',
  MASTER_LOG_FILE='mysql-bin.000236',
  MASTER_LOG_POS=15192461;
START SLAVE;

RESET MASTER;    //untuk membuat mysql-bin.xx mulai dari 1 (mysql-bin.000001)

##
STOP REPLICA;
RESET SLAVE ALL;
CHANGE MASTER TO
  MASTER_HOST='10.211.11.1',
  MASTER_USER='mirror',
  MASTER_PASSWORD='J1d8$9Ym8tSkOQPE2',
  MASTER_AUTO_POSITION=1;
START REPLICA;
SHOW REPLICA STATUS\G

STOP REPLICA;
RESET SLAVE ALL;
CHANGE MASTER TO
  MASTER_HOST='10.207.7.1',
  MASTER_USER='mirror',
  MASTER_PASSWORD='J1d8$9Ym8tSkOQPE2',
  MASTER_AUTO_POSITION=1;
START REPLICA;
SHOW REPLICA STATUS\G
##

STOP REPLICA SQL_THREAD;
SET @@SESSION.sql_log_bin = 0;
SET gtid_next = 'bcdceaeb-cd5e-11ee-a729-1402ec32de48:1318256';
START TRANSACTION;
COMMIT;
SET gtid_next = 'AUTOMATIC';
START REPLICA;
SHOW REPLICA STATUS\G


STOP REPLICA;
CHANGE REPLICATION SOURCE TO
  SOURCE_HOST='17.5.16.100',
  SOURCE_USER='mirror',
  SOURCE_PASSWORD='J1d8$9Ym8tSkOQPE95',
START SLAVE;


### 
STOP REPLICA FOR CHANNEL 'master1';
CHANGE REPLICATION SOURCE TO
  SOURCE_HOST='17.5.16.100',
  SOURCE_USER='mirror',
  SOURCE_PASSWORD='J1d8$9Ym8tSkOQPE95',
  SOURCE_LOG_FILE='mysql-bin.000001',
  SOURCE_LOG_POS=485
FOR CHANNEL 'master1';

CHANGE REPLICATION SOURCE TO
  SOURCE_HOST='17.5.16.100',
  SOURCE_USER='mirror',
  SOURCE_PASSWORD='J1d8$9Ym8tSkOQPE95',
  SOURCE_AUTO_POSITION=1
FOR CHANNEL 'master1';

CHANGE REPLICATION FILTER
REPLICATE_REWRITE_DB = ((coba, coba1))
FOR CHANNEL 'master1';

START REPLICA FOR CHANNEL 'master1';
SHOW REPLICA STATUS FOR CHANNEL 'master1'\G


STOP REPLICA FOR CHANNEL 'master2';
CHANGE REPLICATION SOURCE TO
  SOURCE_HOST='17.5.16.102',
  SOURCE_USER='mirror',
  SOURCE_PASSWORD='J1d8$9Ym8tSkOQPE95',
  SOURCE_LOG_FILE='mysql-bin.000001',
  SOURCE_LOG_POS=157
FOR CHANNEL 'master2';

CHANGE REPLICATION SOURCE TO
  SOURCE_HOST='17.5.16.102',
  SOURCE_USER='mirror',
  SOURCE_PASSWORD='J1d8$9Ym8tSkOQPE95',
  SOURCE_AUTO_POSITION=1
FOR CHANNEL 'master2';

CHANGE REPLICATION FILTER
REPLICATE_REWRITE_DB = ((coba, coba2))
FOR CHANNEL 'master2';

START REPLICA FOR CHANNEL 'master2';

SHOW REPLICA STATUS FOR CHANNEL 'master2'\G