Can Magnolia create InnoDB-Tables?

[rainer]

Hi,

sometimes we delete the publish DB and let Magnolia re-instantiate the DB - afterwards we always have ISAM Tables and have to change it to InnoDB...

Is there a configuration to let Magnolia create InnoDB?

thx a lot
Rainer

[Jan Haderka-2]

AFAIK since JR 1.4.1 there is an issue [1] with patches to allow
settings the engine by setting the value in repo configuration file
using
      <param name="mysqlEngine" value="InnoDB" />

... but since the issue is still open, my guess is the patch is not
applied yet. So your only options are either to set it globally in
my.cnf or create the tables yourself and take care that the right engine
is used.

[1] http://issues.apache.org/jira/browse/JCR-1435

-  
Best regards,

Jan Haderka
Magnolia International Ltd.

Meet us at the Magnolia Conference
http:/www.magnolia-cms.com/conference

Magnolia®  - Simple Open Source Content Management


On Wed, 2009-11-04 at 10:58 -0800, rainer wrote:

>
> Hi,
>
> sometimes we delete the publish DB and let Magnolia re-instantiate the DB -
> afterwards we always have ISAM Tables and have to change it to InnoDB...
>
> Is there a configuration to let Magnolia create InnoDB?
>
> thx a lot
> Rainer

----------------------------------------------------------------
For list details see
http://www.magnolia-cms.com/home/community/mailing-lists.html
To unsubscribe, E-mail to: <user-list-unsubscribe@...>
----------------------------------------------------------------

[rainer]

i heard it is possible to give the DB user a default setting...

so you could set the magnolia DB User to InnoDB - but i couldn't try it out - till now ;)

thx
rainer

Jan Haderka-2 wrote:

AFAIK since JR 1.4.1 there is an issue [1] with patches to allow
settings the engine by setting the value in repo configuration file
using
     

... but since the issue is still open, my guess is the patch is not
applied yet. So your only options are either to set it globally in
my.cnf or create the tables yourself and take care that the right engine
is used.

[1] http://issues.apache.org/jira/browse/JCR-1435

-  
Best regards,

Jan Haderka
Magnolia International Ltd.

Meet us at the Magnolia Conference
http:/www.magnolia-cms.com/conference

Magnolia®  - Simple Open Source Content Management


On Wed, 2009-11-04 at 10:58 -0800, rainer wrote:
>
> Hi,
>
> sometimes we delete the publish DB and let Magnolia re-instantiate the DB -
> afterwards we always have ISAM Tables and have to change it to InnoDB...
>
> Is there a configuration to let Magnolia create InnoDB?
>
> thx a lot
> Rainer


----------------------------------------------------------------
For list details see
http://www.magnolia-cms.com/home/community/mailing-lists.html
To unsubscribe, E-mail to: <[e-mail]>
----------------------------------------------------------------