mysql5.7 迁移以及从库提升为主库CHANGEMASTERTOMASTER_HOST='10.10.30.34',MASTER_PORT=3306,MASTER_USER='slave',MASTER_PASSWORD='slave',MASTER_LOG_FILE='mysql-bin.0001

MYSQL 主从添加新从库MySQL 主从复制，不停机添加新从节点1、主库创建账号：show master status;GRANT REPLICATION SLAVE ON . to 'reader'@'%' identified by 'readerpwd';flush privilegs2、从库