AnsweredAssumed Answered

Migrating from InnoDB to MyIsam for MySQL

Question asked by hailpam on Mar 4, 2010
Latest reply on Mar 12, 2010 by hailpam
Hi all,

I want to use MySQL Cluster in Production Environment for an Alfresco Customization.

The problem is: for Alfresco 3.2 Community, the datasource for MySQL is InnoDB and InnoDB supports Foreign Keys but the Foreign Keys, currently, are not supported by NDBCluster datasource. For this reason I would create on the Alfresco DB the tables with MyIsam Engine instead of InnoDB, in order to use a SQL script with a series of ALTER TABLE for modifying of Engine for every table in DB.

My question is: how can I modify the engine from InnoDB to MyIsam in Alfresco 3.2 Community at installation time, delegating the management of Foreign Keys to Hibernate Persistence Layer?

Thanks in advance. Best Regards,

– Paolo


P.S.: Alfresco uses hdb2ddl to create its own tables at the first startup, for this reason I write here now to understand what files I  must modify to change the database engine at first startup time.

Outcomes