# 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`位置變化對主從無影響