项目中主从部署随着主库服务器日志越来越大,磁盘空间不够导致无法重启mysql,这时新挂载一块硬盘专用于存储日志,需要转移日志存储路径
1.mkdir /mnt/data/mysql-log && chown mysql:mysql -R /mnt/data/mysql-log ##建立目录并修改权限
2.修改主库my.cnf
#log_bin = /var/log/mysql/mysql-bin.log
log_bin = /mnt/data/mysql-log/mysql-bin.log # /mnt/data 新挂载硬盘500G
3. #:/etc/init.d/mysql restart ##重启mysql,bin-log日志从mysql-bin.000001开始
4.进入从库中.查看
show slave status; ##查看同步停止后的binlog日志为mysql-bin.000310, pos点在811011
5.进入主库导出日志
mysqlbinlog --start_position=811011 /var/log/mysql/mysql-bin.000310 > /home/vincent/logs/311.sql
6.推送日志sql到从库中
scp /home/vincent/logs/311.sql root@10.161.174.142:/data/logs/
7.进入从库中
stop slave; #停止slave
reset slave; #初始化
source /data/logs/311.sql # 执行最后的binlog日志
change master to master_host='10.161.130.230',master_user='test', master_password='1',master_log_file='mysql-bin.000001',master_log_pos=1; ##初始化master,重新同步
start slave; ##开启slave