Note: Please go to docs.rightscale.com to access the current RightScale documentation set. Also, feel free to Chat with us!
Home > Clouds > AWS > AWS FAQs > How do I enable InnoDB on a MySQL-EBS server?

How do I enable InnoDB on a MySQL-EBS server?

Table of Contents

Background Information

InnoDB is disabled on servers launched using the "MySQL-EBS" ServerTemplate, due to stale logfiles. 


Answer

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.

You must to post a comment.
Last modified
21:27, 16 May 2013

Tags

EBS

Classifications

This page has no classifications.

Announcements

None


© 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.