# MySQL主从复制部署配置问题汇总 [TOC] ### 主库`show master status`没结果 主库binlog功能开关没改或没生效 ``` [root@curder.centos5 /data/3308/data] # egrep "server-id|log-bin" /data/3307/my.cnf log-bin=mysql-bin server-id = 3307 mysql> 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`位置变化对主从无影响