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

1 回答
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
已回答 8 个月前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则