将RDS数据导出到S3/冰川 [英] Export RDS data to S3/Glacier

问题描述

我想将数据从Oracle RDS导出到S3，然后将其移动到Glacier.我的最终目标是将RDS中存储的数据备份到S3和Glacier，以满足合规性要求.任何人都可以提出实现此目标的最佳方法.

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.

推荐答案

RDS快照存储在s3中，但是您无法下载它们或对其设置策略以将其备份到冰川中.

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.

因此，您将必须手动执行此操作.设置具有足够磁盘空间的实例以存储数据库的转储.编写一个脚本，该脚本连接到您的RDS实例(最好是某种副本，而不是主副本)并转储所有数据.压缩它，然后在s3中将其上传到您的备份存储桶.

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.

您可以设置生命周期策略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.

这篇关于将RDS数据导出到S3/冰川的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！