主从复制部署配置问题汇总 - MySQL中文参考手册
2019-09-11 阅读 : 次
MySQL主从复制部署配置问题汇总MySQL主从复制部署配置问题汇总
主库show master status没结果
change master to 时多了空格错误
MySQL在多实例的情况下启动故障
由于切换binlog日志导致show master status位置变化对主从无影响
主库show master status没结果
MySQL主从复制部署配置问题汇总
主库
show master status没结果change master to 时多了空格错误MySQL在多实例的情况下启动故障
由于切换binlog日志导致
show master status位置变化对主从无影响
show master status没结果主库binlog功能开关没改或没生效
[root@curder.centos5 /data/3308/data]# egrep "server-id|log-bin" /data/3307/my.cnf log-bin=mysql-binserver-id = 3307mysql> show variables like "server_id";+---------------+-------+| Variable_name | Value |+---------------+-------+| server_id | 3307 |+---------------+-------+1 row in set (0.00 sec)mysql> show variables like "log_bin";+---------------+-------+| Variable_name | Value |+---------------+-------+| log_bin | ON |+---------------+-------+1 row in set (0.00 sec)提示：配置文件里的参数和show variables中的参数不一致，例如my.cnf里log-bin在show variables的时候看到的是log_bin
change master to 时多了空格错误
change master to master_host="192.168.0.15",master_port=3307,master_user='rep',master_password='reppasswd',master_log_file=' mysql-bin.000005 ',master_log_pos=344; Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file'
MySQL在多实例的情况下启动故障
find /data/3307/ -type f -name 'mysqld.pid'|xargs rm
由于切换binlog日志导致show master status位置变化对主从无影响
本文地址：https://www.helloaliyun.com/tutorial/512.html
