拷贝或复制亚马逊RDS MYSQL周报 [英] Copying or Replicating Amazon RDS MYSQL weekly

问题描述

什么是保持一个Amazon RDS数据库UAT每周更新从该数据库的生产版本的最佳做法是什么？我们想RDS镜像制作，但我们不希望在用户验收测试的任何更改将反映在生产。采取生产的每周备份，它还原到UAT所以思想，但这是费时。我们可以将生产的快照到UAT如果UAT最初的一些时间点，从生产还原？

What is the best practice for keeping an Amazon RDS UAT database refreshed weekly from a Production version of that database? We were thinking of mirroring the production RDS, but we don't want any changes in UAT to be reflected in Production. So the thought of taking a weekly backup of production and restoring it to the UAT, but this is time consuming. Can we apply a snapshot of Production onto UAT if UAT is initially a restore of some point in time from Production?

推荐答案

RDS提供了两种机制，数据库备份/恢复。您可以利用自动备份，让时间点数据库恢复/创建。或者您可以利用数据库​​快照，使您可以使用它来创建新的RDS实例手动或自动快照。

RDS offers two mechanisms for database backup/recovery. You can utilize the automated backups to allow point in time database recovery/creation. Alternately you can utilize database snapshots to make manual or automated snapshots that you can use to create new RDS instances.

下面是从AWS RDS常见问题的一些详细信息： HTTP：//aws.amazon。 COM / RDS /常见问题/＃23

Here is some more information from the AWS RDS FAQ: http://aws.amazon.com/rds/faqs/#23

这篇关于拷贝或复制亚马逊RDS MYSQL周报的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！