Skip to content

Changing the storage engine of a MySQL table

To dispatch a recovery, DBOD uses binary logs to replay operations and bring the database back to a point in time. To guarantee a consistent state of the database after a recovery, we strongly recommend the use of the InnoDB storage engine. Users having MyISAM tables in their databases will receive a weekly email warning them about the situation and advising them to change the engine to InnoDB. To do this, the following query must be executed per table:

ALTER TABLE table_name ENGINE = InnoDB;

For more information, please refer to the official MySQL documentation