Export RDS data to S3/Glacier

Question

I want to export data from Oracle RDS to S3 and then move it to Glacier. My end goal is to take the backup of the data stored in RDS to S3 and Glacier to meet compliance requirements. Could anyone please suggest the best approach to achieve it.

Answer 1

RDS snapshots are stored in s3, but you are not able to download them or set policies on them that would back them up to glacier.

So, you will have to do this manually. Set up an instance with enough disk space to store a dump of your database. Write a script that connects to your RDS instance (preferably some kind of replica, instead of master) and dumps all the data. Compress it, and then upload it to your backup bucket in s3.

You can set a lifecycle policy s3 bucket which will then store the backup within glacier. If the object is set to glacier storage, it wont be available immediately for download.