Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

We have an Amazon RDS small instance for a MySQL datawarehousing database. Database size will be around 400-500 GB very shortly. What is the best way to backup our database?

Can it be done efficiently with automatic backups and DB snapshots available with RDS?

Or should we consider some other options? What would those be? Using EC2, hosting in some other cloud, or using any other database?

share|improve this question
add comment

1 Answer

RDS provides automated backups as a feature. Those backups are system automated (persisting through the life of the RDS instance), or user initiated (persisting outside the life of the RDS instance). They also automate binlog backup for point-in-time restores. But you can't take those backups out of the RDS service, as it's all hooked together for automating restores, etc.

FAQ: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/RDSFAQ.Backup.html

I assume you want a backup outside of RDS. mysqldump would be the only way to do it, and unless you use some creative ETL to facilitate some sort of daily delta, you might save time. Otherwise, that's a good chunk of data to backup on a regular basis.

share|improve this answer
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.