AWS re:Post을(를) 사용하면 다음에 동의하게 됩니다. AWS re:Post 이용 약관

Cross-account and cross region read replica for Amazon Aurora PostgreSQL

0

How to create cross-account and cross-region read replicas for Amazon Aurora PostgreSQL?
Any reference to documentation or a blog will be helpful. Thanks

2개 답변
0

Hello.

It seems that cross-region replication is not possible with Aurora PostgreSQL.
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Replication.html

Aurora PostgreSQL DB clusters don't support Aurora Replicas in different AWS Regions, so you can't use Aurora Replicas for cross-Region replication.

Why not consider global databases instead?
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-global-database.html

I can't find much information about cross-account, and I'm not sure if it's possible, but it may be possible to perform cross-account replication by setting up continuous replication using something like AWS DMS.
The AWS blog below explains Aurora MySQL rather than Aurora PostgreSQL, but I thought it could be used as a configuration.
https://aws.amazon.com/jp/blogs/database/perform-cross-account-amazon-aurora-mysql-migration-with-minimal-downtime/

profile picture
전문가
답변함 9달 전
0

Hi Deepak

Let me clarify the answer above.... Aurora MySQL has a deployment option that was built prior to Global Databases to place a read replica in another region (but not another account) and uses binlog replication to keep it in sync with the primary writer instance. This approach was never implemented by Aurora PostgreSQL because Global Database models for multi-region support is far superior. This is what the initial doc reference in the answer above is describing. I think the public docs could use some clarification because this really is trying to say that Aurora PostgreSQL's create / modify APIs and its' control plane automation do not support creating and managing native PostgreSQL replication either across regions or across accounts. However, if a customer wants to implement it on their own using native PostgreSQL replication or the pglogical extension, this is certainly possible and would support cross-region and cross-account models. The caveat is obviously that you will have to build it and manage yourself. See the documentation for this at https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Appendix.PostgreSQL.CommonDBATasks.pglogical.html.

Aurora Global Databases automate this for you and because its implemented within the Aurora Storage layer of the architecture, replication has dramatically less impact on the performance of the primary writer instance and much lower replication lag between regions. The doc link in the above answer is a good place to start.... Currently, Global Databases do not support cross-account models but that is something we are considering in the future.

Hope this helps...

AWS
답변함 9달 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인