roaned roaned - 2 years ago 138
SQL Question

OpenShift add cartridge MySQL 5.5 engine InnoDB

when i do

rhc cartridge add mysql-5.5 --app NameApp
the engine default of DB is MyISAM. But if i need engine InnoDB, how can i create db on OpenShift?

Tim Tim
Answer Source

The default storage engine for mysql is set with an environment variable. Add the cartridge, then run the below to use InnoDB:

$ rhc app-restart NameApp

See the mysql cartridge configuration where this is set:

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download