与MyISAM有关的数字海洋数据库问题 [英] Digital Ocean Database Issue related to MyISAM

问题描述

我们的Laravel应用程序使用InnoDB以及MyISAM表，并且一直运行良好，直到最近服务器已移至Digital Ocean以使用其分布式数据库系统".

Our Laravel app uses InnoDB as well as MyISAM tables and it was working fine until recently the Servers have been moved to Digital Ocean in order to use their "Distributed Database System".

现在，当我运行迁移时，它可以正常工作，直到找到试图创建MyISAM表的第一个表迁移，并且脚本崩溃时出现以下错误:

Now when I run the migrations, it works fine until it finds the first table migration which tries to create MyISAM table and script crashes giving following error:

Storage engine MyISAM is disabled (Table creation is disallowed)

谁能告诉我如何在Digital Ocean中启用存储引擎MyISAM?

Could anyone tell me how can I ENABLE the Storage engine MyISAM in Digital Ocean?

我搜索了很多东西，却找不到有用的线程.

I searched a lot and couldn't find any useful thread.

======

大多数评论建议我应该切换到InnoDB，这将是最终解决方案，但是如果有任何方法可以启用MyISAM存储引擎以实现数字海洋，我想知道这一点.

Most of the comments suggest that I should just switch to InnoDB which is going to be the ultimate solution but IF there is any way to enable MyISAM storage engine for digital ocean, I would like to know that.

推荐答案

任何人在这里想知道同样的事情.根本不可能. MyISAM并没有提供您无法使用InnoDB做的任何事情，因此唯一的方法就是将您的MyISAM迁移转换为InnoDB.同样在我的情况下，我们使用的是托管数据库，它肯定在数字海洋中不支持MyISAM.

Anyone wondering the same thing here. It is simply not possible. There is nothing MyISAM provides in plus which you cant do with InnoDB so the only way is to convert your MyISAM migrations to InnoDB. Also in my case, we are using managed DB which for sure does not support MyISAM in the digital ocean.

这篇关于与MyISAM有关的数字海洋数据库问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！