By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Ensure Quicksight always connects to Read replica

0

Hi, I would like to ensure that my quicksight connects to RDS read replica after failover scenario.I have noticed that after fail ovev (where read replica is promoted to writer instance) - Quicksight connects to Writer instance instead of read replica and I have to manually change the connection

Topics
Migration & ModernizationAnalyticsDatabase
Tags
Amazon Relational Database ServiceAmazon AuroraAurora MySQLAmazon QuickSight Paginated Reports
Language
English
AWS
rePost-User-5835927
asked 8 months ago270 views
1 Answer
0

Hello,

If you're using Amazon RDS for MySQL, PostgreSQL, or MariaDB, use the Read Replica Endpoint. This endpoint always points to a read replica and will automatically switch to another read replica if the current one fails or is promoted.

If you're using Amazon Aurora, use the Reader Endpoint. It automatically load-balances read-only connections to the DB cluster across multiple read replicas.

profile picture
Vitor Castellani
answered 8 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

Relevant content