Query: Show global cluster members

Description

Inspect the primary and secondary clusters that make up each global cluster to understand its cross-Region topology and identify which member is the writer. This is useful when planning failover or reviewing read replica placement.

Query

Tables used in this query:

• aws_rds_global_cluster

SQL