Skip to content

Aurora PostgreSQL Writer and Reader Region & AZ both shows as being at ap-southeast-2b. Is this an issue that has to be corrected?

0

Hi,

For some reason, we have an Aurora PostgreSQL where the Writer and the Reader has Region & AZ showing both at ap-southeast-2b, Multi-AZ is No. Not sure how this has happened. Is this an issue?

Anyway, how do we fix the current issue so that they are NOT on the same ap-southeast-2b/Regione-AZ? Do we just create another Reader that will hopefully be in another AZ and then delete the other Reader?

asked a year ago500 views

2 Answers
1

Having both the Writer and Reader instances of an Aurora PostgreSQL cluster in the same Availability Zone (AZ) is not ideal for high availability and fault tolerance. This configuration does not provide the benefits of Multi-AZ deployment, which is designed to improve database availability.

In a typical Multi-AZ setup for Aurora, the Writer and Reader instances should be in different AZs within the same region. This arrangement helps ensure that your database remains accessible even if one AZ experiences an outage.

To address this issue, you can take the following steps:

  1. Add a new Reader instance to your Aurora cluster. When you do this, Aurora should automatically place it in a different AZ from your existing instances.

  2. Once the new Reader is fully operational and in sync with the Writer, you can initiate a failover to promote this new Reader to become the Writer. This will effectively move your Writer instance to a different AZ.

  3. After the failover is complete, you can delete the original Reader instance that was in the same AZ as the old Writer.

This process will result in your Writer and Reader instances being in different AZs, improving the fault tolerance of your Aurora cluster. It's important to note that while you're making these changes, there may be a brief period of downtime during the failover process.

For future reference, when creating a new Aurora cluster or adding instances, Aurora typically tries to distribute instances across different AZs automatically to enhance availability. If you're consistently seeing instances being created in the same AZ, it might be worth checking your subnet group configuration to ensure it includes subnets from multiple AZs.

Remember to monitor your cluster's performance and availability during and after these changes to ensure everything is functioning as expected.
Sources
Can I fail over a writer instance to a new and scaled up reader instance in an Single-AZ Aurora cluster? | AWS re:Post
Move an Amazon RDS instance to a different Availability Zone | AWS re:Post
High availability for Amazon Aurora - Amazon Aurora

answered a year ago

  • This is a good answer until I realize I can actually do a Modify to rename the Reader :-)

0
Accepted Answer

FYI, just realized I can do a Modify to rename a Reader so I ended up doing as below instead.

  • Modify/RENAME the Reader that is on the 'wrong' Region & AZ
  • Create a new Reader in the 'right' Region & AZ, the default appears to be it will be created in a different Region & AZ as the Writer
  • Delete the Reader that is on the 'wrong' Region & AZ. This is the one that is Modify/Rename earlier

answered a year ago

EXPERT

reviewed a year 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.