By sghi on

Hi all,
to ensure referential integrity between tables of our db we have to leave the myIsam engine to meet a mysql engine that support referential integrity as innodb.
Do you know if are there any problems to use drupal on a mysql innodb engine?
Do you know if there is any specific hint/documentatio to follow? (i've fastly searched without find any)
Ciao

Comments

kbahey’s picture

kbahey commented

In theory, it should not matter. None of the features we use are MyISAM specific.

What you need to do is test it first.
Make sure your host does support Inno before you start.
Make sure that you change "Type=MyISAM" to InnoDB for every table before creating it.

Please report back what you found. It would be nice to do some benchmarks too.

--
Drupal development and customization: 2bits.com
Personal: Baheyeldin.com

--
Drupal performance tuning and optimization, hosting, development, and consulting: 2bits.com, Inc. and Twitter at: @2bits
Personal blog: Ba