Migrating from InnoDB to MyIsam for MySQL

[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.

[hailpam]

Somewhere I've read that with Alfresco Community 3.0 the data tables were MyIsam. Can someone help me indicating what are the files to change in order to create MyIsam tables into Alfresco DB with Alfresco 3.2?

Thanks in advance. Regards,

– Paolo

[dward]

Alfresco requires InnoDB on MySQL. MyIsam is not supported.

[hailpam]

Alfresco requires InnoDB on MySQL. MyIsam is not supported.

First of all, thanks for your answer.

I understand that basically there an incompatibility/incongruence, but if I wanted to migrate to MyIsam from InnoDB delegating to Hibernate Persistence Layer the management of foreign keys and other stuff? In other words, if I wanted to inhibit the controls maked by hbm2ddl at every startup of Alfresco server?

Thanks in advance.

- Paolo

[dward]

Alfresco needs a grown-up database that supports transactions and row-level locking. MyISAM does not provide this.

[hailpam]

Alfresco needs a grown-up database that supports transactions and row-level locking. MyISAM does not provide this.

Ok dward. Thanks for your replies!

Regards,

- Paolo