All geek questions in one place

How to change the storage engine from InnoDB to MyISAM using RightScale

I am trying to change the default storage engine from InnoDB to MyISAM in the 5.5 DB parameter group (for an RDS instance hosted on Amazon). But I can’t change, because the property is displayed as unchangeable. How to achieve this with RightScale or Amazon RDS

Line

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

+4
source share
1 answer

There are 3 ways to fix this. 2 set it for all sessions at server startup, and a third for the current session.

  • When starting MySQL, use the --default-storage-engine=MYISAM startup --default-storage-engine=MYISAM
  • In the my.cnf file, set the default-storage-engine=MYISAM
  • In the current session, SET storage_engine=MYISAM;

I suspect that one of the first two is the best, so you will not accidentally end without setting up one session. On Amazon RDS, you need to install this using the DB parameter group .

In RightScale, you need to set up a Chef Cookbook . You just need to set the default storage engine in my.cnf.erb.

+3
source

Source: https://habr.com/ru/post/1389405/

More articles:


All Articles