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?