question

RohanJones-0800 avatar image
0 Votes"
RohanJones-0800 asked ·

MySQL support in MyISAM format

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

azure-database-mysql
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

NavtejSaini-MSFT avatar image
0 Votes"
NavtejSaini-MSFT answered ·

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



·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.