CODEWITHSUNDEEP
amazon-rds
Rob
Rob

Reputation: 1042

Amazon RDS Daily Snapshops without Automated Backups

We have set up Amazon RDS. Performance is a bit slower than previous shared system, but it gives us more control regarding users.

How can we get automated daily snapshots (e.g. during the stipulated window) without having point in time features? We dont need the latter and it apparently affects performance by 25%. However, getting an automated snapshop every night would be useful.

Changed retention period to 0 which did speed up everything, but as feared it didnt do any snapshop overnight. I am aware of the possibility of manual snapshots, but would much prefer scheduled ones.

Upvotes: 1

Views: 779

Answers (1)

Steffen Opel
Steffen Opel

Reputation: 64741

How can we get automated daily snapshots (e.g. during the stipulated window) without having point in time features?

You can't, these are tied together within their current design, i.e. there is no option to disable just the point-in-time recovery.

The reason likely is that the binary logs facilitated for this feature are required anyway as soon as you are using one of the replication options, e.g. Multi-AZ deployments and/or Read Replicas. These do require the very same binary logs used for the point-in-time recovery, which is why you can't set the retention period to 0 once they are enabled, see e.g. the parameter BackupRetentionPeriod for the ModifyDBInstance Action:

Constraints:

Accordingly you'll need to resort to a custom automation solution for the CreateDBSnapshot Action.

Upvotes: 1

Related Questions