今天尝试进行备份还原,还原后节点无法启动,查看具体报错如下:
2019-08-12T08:08:16.201381Z 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2019-08-12T08:08:16.201422Z 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2019-08-12T08:08:16.201452Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2019-08-12T08:08:17.302297Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-08-12T08:08:17.302337Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-08-12T08:08:17.302352Z 0 [ERROR] Failed to initialize builtin plugins.
2019-08-12T08:08:17.302370Z 0 [ERROR] Aborting
发现是ibdata1没有写权限,进入节点对应的卷/_data下找到文件ibdata1执行命令:chmod -R -777 ibdata1
启动节点后又异常关闭,查看报错如下:
又是权限问题,发现这些文件都在数据卷的_data下,直接 找到_data 执行命令
chomd -R 777 mysql
重启,搞定!