新配置 2个linux mysql (5.0.45) 做复制发现主机 死活
show master status \G
显示为空集。什么原因 ?? (这个主机 很古怪 , 他的my.cnf是不能存在, 只能用 my.cnf.old)
show master status \G
显示为空集。什么原因 ?? (这个主机 很古怪 , 他的my.cnf是不能存在, 只能用 my.cnf.old)
root登录
show master status \G
显示为空集
root@发给ktop mysql]# cat /var/log/mysqld.log
100526 14:58:14 mysqld started
InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 134217728 bytes!
100526 14:58:15 [ERROR] Default storage engine (InnoDB) is not available
100526 14:58:15 [ERROR] Aborting100526 14:58:15 [Note] /usr/sbin/mysqld: Shutdown complete100526 14:58:15 mysqld ended100526 14:58:43 mysqld started
InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 134217728 bytes!
100526 14:58:44 [ERROR] Default storage engine (InnoDB) is not available
100526 14:58:44 [ERROR] Aborting100526 14:58:44 [Note] /usr/sbin/mysqld: Shutdown complete100526 14:58:44 mysqld ended[root@spirit-desktop mysql]#
从机 show slave status \G
发现2个IO 只有1个成功
然后删除所有的日志文件,再启动服务。
InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 134217728 bytes!
100526 14:58:44 [ERROR] Default storage engine (InnoDB) is not available这里有问题。