We have been using the Our Delta distribution of MariaDB (5.1.47), but recently decided to switch to Percona Server.
After switching to Percona Server when I try to access MyISAM tables that were created under the Our Delta MariaDB I receive this error message:
And if I try to repair the table it reports that it is corrupt.
This issue seems to be documented in this MariaDB bug report in https://bugs.launchpad.net/maria/+bug/534626
For the time being we have reverted back to OurDelta MariaDB.
It looks like MariaDB has a patch for that issue.
Is there a work around for this issue on the Percona side?
If not then these are the options I can think of:
• mysqldump those tables before the migration and re-import them after (this could mean many hours of down time)
• convert all of our tables to InnoDB before the migration (we still have some tables that have full text search enabled so they would still need to be exported and imported)
• or possibly upgrade to a version of MariaDB that has already been patched for this bug and run repairs on the tables to see if that fixes them
Is there a better way? Will this issue be fixed in a future Percona release? Are there other issues that I will run into switching from OurDelta to Percona Server?