mysqlamazon-rdsrightscale

How to modify a storage engine from InnoDB to MyISAM using RightScale


I'm tring to modify the default storage engine from InnoDB to MyISAM on a 5.5 DB Parameter Group (for a RDS instance hosted in Amazon). But I am unable to change, since the property shows up as non modifiable. How do I achieve this via RightScale or Amazon RDS

default_storage_engine string dynamic system InnoDB The default storage engine (table type).


Solution

  • There's 3 ways to set this. 2 set it for all sessions on server start-up and the third sets it for the current session.

    1. When starting MySQL use the --default-storage-engine=MYISAM startup option
    2. In the my.cnf file set the default-storage-engine=MYISAM option
    3. In your current session SET storage_engine=MYISAM;

    I suspect one of the first two are the best so you don't accidentally end up without it set one session. On Amazon RDS you need to set this via a DB Parameter Group.

    On RightScale you need to tune the Chef Cookbook. You should just need to set the default-storage-engine in my.cnf.erb.