, 
CHANGE MASTER
MASTER_HOST=& # 39; 10.10.30.34& # 39;,,
MASTER_PORT=3306,
MASTER_USER=& # 39;奴隶# 39;
MASTER_PASSWORD=& # 39;奴隶# 39;
MASTER_LOG_FILE=& # 39; mysql-bin.000148& # 39;
MASTER_LOG_POS=154;
从数据库变为主库
stop 奴隶;
reset 奴隶;
reset 主;
从库变为刚才的主库(由从库变为主库的数据库)
。vim /etc/my . cnf中所做
log-bin=mysql-bin , #并重启数据库,主库开启binlog日志
主库操作:show master 状态
主库操作:scp -r /var/lib/mysql/*,,, 10.10.50.34:/var/lib/mysql/从库:chown , -R mysql.mysql ,/var/lib/mysql/从库:systemctl restart , mysqld
CHANGE MASTER
MASTER_HOST=& # 39; 172.16.1.51& # 39;,,
MASTER_PORT=3306,
MASTER_USER=& # 39;代表# 39;
MASTER_PASSWORD=& # 39; 123456 & # 39;
MASTER_LOG_FILE=& # 39; mysql-bin.000001& # 39;
MASTER_LOG_POS=335;
进入数据:start 奴隶;
中间报错:
1. io进程一直处于connnecting中
slave 才能用户的密码写错
2. show slave ,地位,报的错
Last_IO_Error: Got fatal error 1236年,得到master when reading data 得到binary 日志:,& # 39;Could not find first log file name binary log index 拷贝文件# 39;
解决办法:
主库:flush 原木;
从库:
stop 奴隶;
CHANGE MASTER 用MASTER_LOG_FILE=& # 39; mysqld-bin.000011& # 39;, MASTER_LOG_POS=106;
start 奴隶;
