Menu
Currently the database on Amazon RDS is automatically backed up once a day - that seems to be a default behavior.
When I look on the "Backup retention period", 1 day is the smallest option. How do I do an hourly (or every 30 minutes) backup and (ideally) save the backup to my Amazon S3? Is this supported by Amazon RDS or do I need to do a manual mysqldump and upload the backup to S3 through my own script?
I haven't found any 2016 answer.
589
Automated Backups Amazon RDS automatically creates a storage volume snapshot of your DB instance, backing up the entire DB instance and not just individual databases. This backup occurs during a daily user-configurable 30 minute period known as the backup window.
Amazon RDS provides two different methods for backing up and restoring your DB instance(s) automated backups and database snapshots (DB Snapshots).
There isn't any need. From Backing up and restoring an Amazon RDS DB instance:
In addition to the daily automated backup, Amazon RDS archives database change logs. This enables you to recover your database to any point in time during the backup retention period, up to the last five minutes of database usage.
In short, RDS already has this covered.
147
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
