amazon-web-services - 将 Aurora DB 从一个 VPC 迁移到另一个

Question

我们在一个 VPC 中有 4 个独立的非多可用区极光数据库实例，我们想将它们移动到另一个 VPC 中的极光实例。

据我所知，有 3 种迁移数据库实例的方法:

1) 修改数据库实例的子网组以更改VPC。

However this is not supported for Aurora instances yet.

2) 创建只读副本，当从属 catch 时，停止从属并拍摄快照以在不同的 VPC 中创建数据库实例并使用外部从属然后再次恢复复制。

I have a few question around this second method. As Aurora is using some different
replication method, the result of show slave status; command is empty.
Also by default the binlog_format is OFF so not sure if I have to modify it and
then restart the instance to take note of the binlog etc.

Have anyone done this before and can guide me? I don't want to restart the instance
to later find out that it is not working, as it is a very critical DB and I want to 
minimize the downtime.

3) 使用 Amazon DMS 服务，但是我在文档中找不到 Aurora 的源数据库详细信息 here .

I need to find out what all permissions to give to the replication user
I'll create for this. This command in aurora is not working,
GRANT REPLICATION CLIENT, REPLICATION SLAVE ON . TO 'replication_user'@'%'
IDENTIFIED BY 'aaaaaa';

如有任何帮助，我们将不胜感激。

Answer 1

您应该能够从快照中恢复。我使用这种方法跨 VPC 迁移了 aurora。我希望我们可以在不同的 VPC 中创建一个只读副本，但目前我认为你只能在不同的区域中创建一个。

我发现了一个奇怪的副作用，我不确定为什么会发生这种情况，即在原始集群 multi-az 中是 2 Zones 而在恢复的集群中multi-az 是No。这并没有影响我能看到的东西。我仍然有一个包含 writer 和 reader

的集群