Migration of MyISAM tables to InnoDB engine?

(Ralf Lukner MD PhD) #1

Amazon support: “…Based on the best practice…, we recommend that you may consider migrating MyISAM tables to InnoDB engine, which is ACID compliant and fully supported by Amazon RDS.”

The issue here is that it may not be possible to restore the database tables point-in-time due to the MyISAM tables and potential data corruption. Had anyone in the OpenEMR community looked into this? Also, I am unsure if altering these tables to migrate them to InnoDB could create problems with future OpenEMR updates.