InnoDB is disabled on servers launched using the "MySQL-EBS" ServerTemplate, due to stale logfiles.
You need to delete or move the stale logfiles to allow InnoDB to regenerate them and restart mysql:
~# service mysqld stop ~# mv /var/lib/mysql/ib_logfile0 /var/lib/mysql/ib_logfile0.bak ~# mv /var/lib/mysql/ib_logfile1 /var/lib/mysql/ib_logfile1.bak ~# service mysqld start ~# echo 'show engines;' | mysql
The last step will display that InnoDB is enabled.
© 2006-2014 RightScale, Inc. All rights reserved.
RightScale is a registered trademark of RightScale, Inc. All other products and services may be trademarks or servicemarks of their respective owners.