MySQL support in MyISAM format

Question

Why doesn’t MySQL Database on Azure support databases in MyISAM format?

Answer 1

Hi RohanJones

As our Product team has indicated on the product feedback page as well as several other sites that Azure DB for MySQL doesn't support MyISAM. Here is their reasoning:

MYISAM is not supported in Azure Database for MySQL, primarily due to the lack of transaction support which can potentially lead to data loss. This is one of the reasons MySQL switched over to InnoDB as the default.

Here are documents for the same:

1. MyISAM Support
2. Product Feedback Link

Hope this helps.

Thanks
Navtej S