- 论坛徽章:
- 0
|
用drdb + gfs2进行了一下测试,同步都很正常,gfs2也正常工作,但是在第二个节点上启动mysql的时候总是报错:
InnoDB: Unable to lock /data/mysql/mysqldata/innodb/data/ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
连个几点使用不同的innodb数据和日志文件后,数据库能正常起来,但是读具体的表的时候报类似一下的错误:
120914 16:31:12 [ERROR] Cannot find or open table drbd/customer from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.
See http://dev.mysql.com/doc/refman/ ... roubleshooting.html
how you can resolve the problem.
这个是如何避免的呢?
mysql版本是5.1.50 |
|