mysql - 定期将数据从AWS RDS(MySQL)复制到另一台服务器(EC2实例)

Question

我们有一个大型 AWS RDS(MySQL) 实例，我们需要每天在特定时间将数据从它复制到另一个 Ec2 实例，以用于报告和分析目的。

目前我们正在使用 mysqldump 创建转储文件，然后复制整个架构，这需要花费大量时间。有没有更快的方法来做到这一点，如果只复制新记录会好得多。

我们如何复制数据而不每次都复制整个架构？

Answer 1

您应该查看Database Migration Service 。不要被名字迷惑了。它可以进行连续或一次性复制。来自常见问题解答:

Q. In addition to one-time data migration, can I use AWS Database Migration Service for continuous data replication?

Yes, you can use AWS Database Migration Service for both one-time data migration into RDS and EC2-based databases as well as for continuous data replication. AWS Database Migration Service will capture changes on the source database and apply them in a transactionally-consistent way to the target. Continuous replication can be done from your data center to the databases in AWS or in the reverse, replicating to a database in your datacenter from a database in AWS. Ongoing continuous replication can also be done between homogeneous or heterogeneous databases. For ongoing replication it would be preferable to use Multi-AZ for high-availability.