Hyland Community
Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Migrating from InnoDB to MyIsam for MySQL

hailpam
Champ in-the-making
Champ in-the-making

‎03-04-2010 06:15 AM

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.
Labels:
0 Kudos
5 REPLIES 5

hailpam
Champ in-the-making
Champ in-the-making

‎03-06-2010 12:16 PM

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
0 Kudos

dward
Champ on-the-rise
Champ on-the-rise

‎03-08-2010 05:22 AM

Alfresco requires InnoDB on MySQL. MyIsam is not supported.
0 Kudos

hailpam
Champ in-the-making
Champ in-the-making

‎03-09-2010 05:37 AM

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
0 Kudos

dward
Champ on-the-rise
Champ on-the-rise

‎03-09-2010 07:48 AM

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

hailpam
Champ in-the-making
Champ in-the-making

‎03-12-2010 05:34 AM

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
0 Kudos
Getting started

Tags

Find what you came for

We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.

Copyright © 2024 Khoros, LLC