Help Center/ Huawei Cloud Flexus/ FAQs/ FlexusRDS/ Why Does FlexusRDS Not Support the MyISAM Storage Engine?
Updated on 2024-07-10 GMT+08:00

Why Does FlexusRDS Not Support the MyISAM Storage Engine?

The reasons are as follows:

  • MyISAM engine tables do not support transactions. They only support table-level locks. As a result, read and write operations conflict with each other.
  • MyISAM is not good at protecting data integrity. Data can be damaged or lost.
  • If data is damaged, MyISAM does not support data restoration provided by FlexusRDS. Data can only be restored manually.
  • Data can be transparently migrated from MyISAM to InnoDB without changing code.