Amazon RDS stop instance

amazon-web-services amazon-rds
bukk530 picture bukk530 · Apr 27, 2014 · Viewed 21k times · Source

I am working on Amazon RDS, but I don't need instances to run all the day 24/7, as I'm only developing right now. Is there any way to stop an RDS instance when I don't need it? I don't want to pay what I don't use!

Answer

Julio Faerman picture Julio Faerman · Apr 27, 2014

There is no "stop/start" actions for RDS databases, currently you'd have to terminate the database taking a final snapshot and restore from that snapshot.

UPDATE: Now supported (thanks @venkata-mutyala): https://aws.amazon.com/about-aws/whats-new/2017/06/amazon-rds-supports-stopping-and-starting-of-database-instances/

Related questions

Access denied; you need (at least one of) the SUPER privilege(s) for this operation

So I try to import sql file into rds (1G MEM, 1 CPU). The sql file is like 1.4G mysql -h xxxx.rds.amazonaws.com -u user -ppass --max-allowed-packet=33554432 db < db.sql It got stuck at: ERROR 1227 (42000) at line 374: Access …

Read More
MySQL/Amazon RDS error: "you do not have SUPER privileges..."

I'm attempting to copy my mysql database from an Amazon EC2 to an RDS: I successfully did a mysqldump of my database into my root folder using this: root@ip-xx-xx-xx-xx:~# mysqldump my_database -u my_username -p > my_database.…

Read More
Creating A New MySQL User In Amazon RDS Environment

I need to create a new MySQL user with limited permission on an existing Amazon RDS instance. After encountering a couple error messages I was sort of able to do this using the official MySQL Administrator tool and the user …

Read More