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'
find /data/3307/ -type f -name 'mysqld.pid'|xargs rm
show master status
位置变化对主从无影响内容来源于网络,如有侵权,请联系作者删除!