mysql主从切换

1.停止原来从库的复制，创建用户准备给新从库用

SHOW SLAVE STATUS;
STOP REPLICA;
SET GLOBAL read_only = OFF;
CREATE USER 'slave'@'%' IDENTIFIED BY '123456';GRANT REPLICATION SLAVE ON *.* TO 'slave'@'%';
show master status;

2.在新从库（原主库），指定复制模式

RESET REPLICA;

-- 配置指向新主库
CHANGE MASTER TO
  MASTER_HOST='192.168.31.253',
  MASTER_USER='slave',
  MASTER_PASSWORD='123456',
  MASTER_LOG_FILE='slave-mysql-bin.000003',
  MASTER_LOG_POS=163395;

START REPLICA;

SHOW REPLICA STATUS;