Converting MyISAM tables safely.

[platform-stephanie]

Issue: Topic clarification/correction

Topic Link

https://support.magento.com/hc/en-us/articles/360048389631

Description

MyISAM tables should not be converted to InnoDB with ALTER TABLE on Pro clusters, as they will still lack replication, instead, they should be recreated as InnoDB tables by renaming and copying the data to ensure they will replicate properly:

Rename the existing table.

RENAME TABLE <existing_table> <table_old>;

Create a new table from the data in the existing table.

CREATE TABLE <existing_table> SELECT * from <table_old>;

Additional information

[jmenn]

Hi there @platform-stephanie!
Thank you for your submission!
We'll take a look!

[barnato-v]

@platform-stephanie Apologies Stephanie. This issue got lost I suspect in preparation for the migration of our content onto Adobe ExL.

I have been assigned to the Jira ticket here https://jira.corp.adobe.com/browse/MSKB-1841

I will creating the PR for this change in our new repo https://git.corp.adobe.com/AdobeDocs/commerce-knowledge-base.en