mysqldigital-oceanmyisam

Digital Ocean Database Issue related to MyISAM


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".

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)

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.

======

UPDATE

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.


Solution

  • 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.