[JCR-1435] Choose the MySQL engine for database storage (default to MyISAM)

• Type: Improvement
• Status: Patch Available
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: core 1.4.1
• Component/s: jackrabbit-core
• Environment: MySQL with NDB Cluster engine
• Assignee: Unassigned
• Reporter: Sébastien Launay
• Created: 28/Feb/08 10:59
• Updated: 07/Aug/09 13:10

Description

The MySQL scripts embedded into Jackrabbit does not specify the engine to use.
So by default MyISAM is used and we cannot change this.

But, depending on the environment we may want to use an alternate engine like
InnoDB (for transaction support) or in my case NDB Cluster (for high availability).

We can still manually created the tables and then set the wanted engine, but it would
be better if there was a parameter for the engine for component in the repository.xml
for automatic table creation.