Skip to content

Is this an AUrora cluster or are these AWS RDS PostgreSQL nodes

0

I have to upgrade an AWS RDS PostgreSQL instance. I am new to the environment. When I login to the console, I see both PostgreSQL and Aurora PostgreSQL under the Engine column. There is a Primary node with PostgreSQL as the Engine, a Replica with PostgreSQL as the engine, and 2 nodes under the primary which have Aurora PostgreSQL as the engine . Could someone please take a look and explain this? Enter image description here

2 Answers
1

Based on the description you've provided, it appears you are looking at a hybrid environment that includes both Amazon RDS for PostgreSQL instances and an Amazon Aurora PostgreSQL cluster. Here's an explanation of what you're seeing:

  1. The Primary node with PostgreSQL as the Engine is likely an Amazon RDS for PostgreSQL instance. This is your main RDS PostgreSQL database.

  2. The Replica with PostgreSQL as the engine is probably a read replica of your primary RDS PostgreSQL instance.

  3. The two nodes under the primary which have Aurora PostgreSQL as the engine are most likely part of an Amazon Aurora PostgreSQL cluster. This Aurora cluster appears to be set up as a read replica of your RDS PostgreSQL instance.

This configuration suggests that your environment is in a transition state or has been set up for migration purposes. It's possible that there's an ongoing process to migrate from the RDS PostgreSQL instance to an Aurora PostgreSQL cluster using the Aurora read replica method.

In this setup, the RDS PostgreSQL instance (the primary) is replicating data to both its RDS read replica and the Aurora PostgreSQL cluster. This allows for a smooth transition from RDS to Aurora while maintaining data consistency.

If you need to upgrade the RDS PostgreSQL instance, you should focus on the primary PostgreSQL node and its direct replica. However, given this complex setup, it's crucial to carefully plan any upgrades and consider how they might affect the Aurora cluster. You may want to consult with your database administration team or AWS support to understand the full implications and the best approach for upgrades in this environment.
Sources
Migrating data from an RDS for PostgreSQL DB instance to an Aurora PostgreSQL DB cluster using an Aurora read replica - Amazon Aurora

answered a year ago
EXPERT
reviewed a year ago
1

That environment looks like its half way migrating from a PostGres RDS instance to an Aurora Serverless cluster.

Migrating from an RDS for PostgreSQL DB instance to an Aurora PostgreSQL DB cluster is a multistep procedure. First, you create an Aurora read replica of your source RDS for PostgreSQL DB instance. That starts a replication process from your RDS for PostgreSQL DB instance to a special-purpose DB cluster known as a Replica cluster. The Replica cluster consists solely of an Aurora read replica (a reader instance).

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Migrating.RDSPostgreSQL.Replica.html#AuroraPostgreSQL.Migrating.RDSPostgreSQL.Replica.Intro

I recommend, you may want to finish off the migration at somepoint

EXPERT
answered 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.