这一段时间一直在docker里搭建mysql的主从复制和读写分离,本来想着充分利用自己电脑的内存,在win10里搭,结果遇到如下错误,mysql不管主从服务器,动不动就报错。

2019-11-28T13:10:42.164408Z 0 [Warning] InnoDB: Retry attempts for writing partial data failed.
2019-11-28T13:10:42.164480Z 0 [ERROR] InnoDB: Write to file ./ibdata1failed at offset 1048576, 1048576 bytes should have been written, only 0 were written. Operating system error number 13. Check that your OS and file system support files of this size. Check also that the disk is not full or a disk quota exceeded.
2019-11-28T13:10:42.164669Z 0 [ERROR] InnoDB: Error number 13 means 'Permission denied'

从mysql5.7.24升级到mysql5.7.28不行,启动mysql容器时加上 --privileged=true也不行,卡了快一周时间,就要放弃了,突然想到之前在win10里搭redis集群也遇到了奇怪的问题,后来移到阿里云上就没问题了。于是就把mysql主从的docker镜像放到了阿里云上,正常运行了一天了,没有再出现上述错误。

能力有限,只能这么解决了,给后来者提供参考吧。谢谢观看。

 

最后修改于 2019-12-01 10:43:49
如果觉得我的文章对你有用,请随意赞赏
扫一扫支付
上一篇