Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I'm investigating running regular MySQL dumps to an S3 bucket as part of a disaster recovery strategy (partly spurred by the current zero cost of inbound data transfer!). In the event of a disaster, I would want to restore the dump file from S3 to a new RDS instance. Despite extensive searching, I can't find any examples of this. Does anyone know if this is possible?

To give a bit of context, it's a 500GB write-heavy read-light 24x7 MySQL database. I'm planning to use MySQL replication to a slave, which we can then take dumps from to send to S3 in case of a host failure (we use the same hosting provider for the replication master and slave, although they are in different data centres).

share|improve this question
add comment

2 Answers

Currently there's not such feature in RDS, as explained in:

https://forums.aws.amazon.com/message.jspa?messageID=213853

But AWS guys recommend this procedure:

http://aws.amazon.com/articles/2933

share|improve this answer
add comment

It worked for me when I tried to backup a mysql server running in my machine to RDS mysql. (my machine was running windows, but it should work for linux mysql dump as well)

mysqldump -u root -p --databases 'mydatabase' > dump.sql

then, just upload to the RDS instance:

mysql -h myrds.com -u myuser -p < dump.sql

share|improve this answer
1  
Thanks for the suggestion, but I'm not sure that really helps. This will push the data from your local machine using your MySQL client to the RDS instance. I need to get the data from an S3 bucket straight into RDS. As I said in the question, the database is pretty big - our zipped dump files are around 25GB, so I can't wait several hours for them to download to a local machine and then transfer up to RDS. –  Mark B Sep 16 '11 at 7:18
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.