How to disable innodb_doublewrite for MySQL at Amazon RDS?

Question

Please can anyone help me to disable "innodb_doublewrite" for my MySQL database hosted at Amazon RDS. I need this as we need to quickly update around 15 Million rows.

I know there is a startup option for this:

--skip-innodb_doublewrite

But how to use it?

Apart from that, Amazon RDS Parameters Group does not show the option of "innodb_doublewrite" for editing. Amazon does not also allow direct editing of my.cnf file.

I can access the MySQL through my Linux Server. But don't know exactly how to use the startup option for Amazon RDS. Please can any one help me to disable this option?

Answer 1

AWS support confirmed the following as of August 2, 2015:

"innodb_doublewrite can't be modified in RDS MySQL instances"

Answer 2

RDS is a managed database service that provides some abstractions to managing a database directly on EC2 but in exchange you lose some flexibility including what options you are able to apply to your database instance.

All start up parameters that would normally be specified in my.cnf should instead be applied via the RDS Parameter Groups but, as you mention in your question, innodb_doublewrite is not one of the configurable parameters.

If the data you are updating is not likely to be updated during normal operation you could always attempt to make the update on a read slave (SET GLOBAL READ_ONLY=0 first) and then promote the read replica and point your application at this instance.