Hello Everyone,
The running Galaxy in a production environment documentation states:
"If you are using MySQLhttp://dev.mysql.com/ with MyISAMhttp://dev.mysql.com/doc/refman/5.1/en/myisam-storage-engine.html table engine when Galaxy is in multiprocess configuration, workflow steps will get executed out of orderhttp://dev.list.galaxyproject.org/Job-execution-order-mixed-up-tt4662488.html and fail. Use InnoDBhttp://dev.mysql.com/doc/refman/5.1/en/innodb-storage-engine.html engine instead or switch to PostgreSQLhttp://www.postgresql.org/."
I've enabled InnoDB for my MySQL database via the my.cnf file but the default database and database to log all database transactions were created with MyISAM files. If this is normal, when will Galaxy create InnoDB tables? I don't believe you can create a database with InnoDB.
Dwayne