Ensure Quicksight always connects to Read replica

Question

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

Answer

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.

Ensure Quicksight always connects to Read replica

Relevanter Inhalt