CHANGEMASTERTOMASTER_HOST='10.10.30.34',MASTER_PORT=3306,MASTER_USER='slave',MASTER_PASSWORD='slave',MASTER_LOG_FILE='mysql-bin.000148',MASTER_LOG_POS=154;从数据库变为主库stopslave;resetslave;resetmaster;从库变为刚才的主库（由从库变为主库的数据库）vim/etc/my.cnflog-bin=mysql-bin#并重启数据库，主库开启binlog日志主库操作:showmasterstatus主库操作:scp-r/var/lib/mysql/*10.10.50.34:/var/lib/mysql/从库:chown-Rmysql.mysql/var/lib/mysql/从库:systemctlrestartmysqldCHANGEMASTERTOMASTER_HOST='172.16.1.51',MASTER_PORT=3306,MASTER_USER='rep',MASTER_PASSWORD='123456',MASTER_LOG_FILE='mysql-bin.000001',MASTER_LOG_POS=335;进入数据:startslave;中间报错：1.IO进程一直处于connnecting中slave用户的密码写错2.showslavestatus;报错Last_IO_Error:Gotfatalerror1236frommasterwhenreadingdatafrombinarylog:'Couldnotfindfirstlogfilenameinbinarylogindexfile'解决办法：主库：flushlogs；从库：stopslave；CHANGEMASTERTOMASTER_LOG_FILE='mysqld-bin.000011',MASTER_LOG_POS=106;startslave；