topic Migrating from InnoDB to MyIsam for MySQL in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/migrating-from-innodb-to-myisam-for-mysql/m-p/221535#M174665 <HTML><HEAD></HEAD><BODY><SPAN>Hi all,</SPAN><BR /><BR /><SPAN>I want to use MySQL Cluster in Production Environment for an Alfresco Customization.</SPAN><BR /><BR /><SPAN>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.</SPAN><BR /><BR /><SPAN>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? </SPAN><BR /><BR /><SPAN>Thanks in advance. Best Regards,</SPAN><BR /><BR /><SPAN>– Paolo</SPAN><BR /><BR /><BR /><SPAN>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&nbsp; must modify to change the database engine at first startup time.</SPAN></BODY></HTML> Thu, 04 Mar 2010 11:15:12 GMT hailpam 2010-03-04T11:15:12Z Migrating from InnoDB to MyIsam for MySQL https://connect.hyland.com/t5/alfresco-archive/migrating-from-innodb-to-myisam-for-mysql/m-p/221535#M174665 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 wo Thu, 04 Mar 2010 11:15:12 GMT https://connect.hyland.com/t5/alfresco-archive/migrating-from-innodb-to-myisam-for-mysql/m-p/221535#M174665 hailpam 2010-03-04T11:15:12Z Re: Migrating from InnoDB to MyIsam for MySQL https://connect.hyland.com/t5/alfresco-archive/migrating-from-innodb-to-myisam-for-mysql/m-p/221536#M174666 <HTML><HEAD></HEAD><BODY><SPAN>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?</SPAN><BR /><BR /><SPAN>Thanks in advance. Regards,</SPAN><BR /><BR /><SPAN>– Paolo</SPAN></BODY></HTML> Sat, 06 Mar 2010 17:16:45 GMT https://connect.hyland.com/t5/alfresco-archive/migrating-from-innodb-to-myisam-for-mysql/m-p/221536#M174666 hailpam 2010-03-06T17:16:45Z Re: Migrating from InnoDB to MyIsam for MySQL https://connect.hyland.com/t5/alfresco-archive/migrating-from-innodb-to-myisam-for-mysql/m-p/221537#M174667 <HTML><HEAD></HEAD><BODY><SPAN>Alfresco requires InnoDB on MySQL. MyIsam is not supported.</SPAN></BODY></HTML> Mon, 08 Mar 2010 10:22:05 GMT https://connect.hyland.com/t5/alfresco-archive/migrating-from-innodb-to-myisam-for-mysql/m-p/221537#M174667 dward 2010-03-08T10:22:05Z Re: Migrating from InnoDB to MyIsam for MySQL https://connect.hyland.com/t5/alfresco-archive/migrating-from-innodb-to-myisam-for-mysql/m-p/221538#M174668 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">Alfresco requires InnoDB on MySQL. MyIsam is not supported.</BLOCKQUOTE><BR /><SPAN>First of all, thanks for your answer.</SPAN><BR /><BR /><SPAN>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?</SPAN><BR /><BR /><SPAN>Thanks in advance.</SPAN><BR /><BR /><SPAN>- Paolo</SPAN></BODY></HTML> Tue, 09 Mar 2010 10:37:52 GMT https://connect.hyland.com/t5/alfresco-archive/migrating-from-innodb-to-myisam-for-mysql/m-p/221538#M174668 hailpam 2010-03-09T10:37:52Z Re: Migrating from InnoDB to MyIsam for MySQL https://connect.hyland.com/t5/alfresco-archive/migrating-from-innodb-to-myisam-for-mysql/m-p/221539#M174669 <HTML><HEAD></HEAD><BODY><SPAN>Alfresco needs a grown-up database that supports transactions and row-level locking. MyISAM does not provide this.</SPAN></BODY></HTML> Tue, 09 Mar 2010 12:48:20 GMT https://connect.hyland.com/t5/alfresco-archive/migrating-from-innodb-to-myisam-for-mysql/m-p/221539#M174669 dward 2010-03-09T12:48:20Z Re: Migrating from InnoDB to MyIsam for MySQL https://connect.hyland.com/t5/alfresco-archive/migrating-from-innodb-to-myisam-for-mysql/m-p/221540#M174670 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">Alfresco needs a grown-up database that supports transactions and row-level locking. MyISAM does not provide this.</BLOCKQUOTE><BR /><SPAN>Ok dward. Thanks for your replies!</SPAN><BR /><BR /><SPAN>Regards,</SPAN><BR /><BR /><SPAN>- Paolo</SPAN></BODY></HTML> Fri, 12 Mar 2010 10:34:35 GMT https://connect.hyland.com/t5/alfresco-archive/migrating-from-innodb-to-myisam-for-mysql/m-p/221540#M174670 hailpam 2010-03-12T10:34:35Z