Request for Assistance: rdsadmin (Superuser) Access and Multi-Region RDS Sync Setup

0

I hope this message finds you well. I am writing to seek your assistance in a critical matter related to our AWS infrastructure.

We are currently in the process of setting up a multi-region synchronization for a database in our AWS account. To ensure the seamless deployment and effective management of this solution, we require access to the rdsadmin superuser account.

Here are the essential details related to our AWS environment:

Additionally, we are facing challenges in creating a replication user and subscription for our multi-region RDS synchronization setup. We kindly request your guidance and assistance in this matter. If there are specific steps, best practices, or permissions required to create the replication user and subscription, please provide detailed instructions.

Access to the rdsadmin superuser account is crucial for executing certain administrative tasks, and your assistance in resolving any challenges in creating the replication user and subscription is highly appreciated.

We understand the importance of security and compliance and assure you that this access will be used exclusively for the purpose of configuring and managing the multi-region RDS synchronization.

If there is any additional information required from our end or if you have specific recommendations, please let us know.

Thank you for your prompt attention to this matter. We appreciate your ongoing support and guidance.

Best regards, Bibek

  • why NOT AWS Aurora MySQL Global database?

bibek
asked 6 months ago175 views
1 Answer
0

hello

I recommend using Amazon Aurora global databases

An Aurora global database consists of one primary AWS Region where your data is written, and up to five read-only secondary AWS Regions. You issue write operations directly to the primary DB cluster in the primary AWS Region. Aurora replicates data to the secondary AWS Regions using dedicated infrastructure, with latency typically under a second. Enter image description here

With write forwarding enabled, secondary clusters in an Aurora global database forward SQL statements that perform write operations to the primary cluster. The primary cluster updates the source and then propagates resulting changes back to all secondary AWS Regions


If you decide to continue using RDS MySQL, maybe Cross-Region read replicas and RDS - Cross-Region Replication can help you

profile pictureAWS
answered 6 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions