使用 AWS re:Post 即表示您同意 AWS re:Post 使用條款
AWS re:Postre:Post

Is Aurora sure distribution Reader request across the entire Reader instance?

0

I have a cluster of 3 instances (1 master Writer instance and 2 Reader instances db.r5.large), recently due to running a promotion for a short time. so I added 1 Reader instance db.r5.4xlarge for a short time (4h) for each campaign announcement. I noticed that the Reader request is only going to the 2 previously existing Reader instances and the request is not being loaded to the Reader instance db.r5.4xlarge for a long time. I'm wondering why and is there something missing in the configuration when adding the Reader instance?

主題
分析資料庫
標籤
Amazon AuroraAurora MySQL
語言
English
iamnick
已提問 2 年前檢視次數 577 次
1 個回答
0
已接受的答案

According to the documentation, Using the reader endpoint:

"The reader endpoint load-balances connections to available Aurora Replicas in an Aurora DB cluster. It doesn't load-balance individual queries. If you want to load-balance each query to distribute the read workload for a DB cluster, open a new connection to the reader endpoint for each query."

profile pictureAWS
專家
kentrad
已回答 2 年前
  • iamnick
    2 年前

    yes, thank for you comment. I connect using Reader endpoint of Cluster. but i see when 2 Reader instances db.r5.large are available before,that CPU reaches >99%, the request is still not being loaded to the Reader instance db.r5.4xlarge I just added.

  • kentrad 專家
    2 年前

    So, new connections are not being load balanced?

  • iamnick
    2 年前

    Yes, That's right. I noticed the request pointed to the old instance instead of the new instance. so my system was paralyzed because the request didn't reach the new instance. What do you think about this, do I need to open case support with AWS Support?

  • kentrad 專家
    2 年前

    Yes, if new connections are not being balanced correctly, I would open a support case.

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋，同時有助於提問者的專業成長。

回答問題指南

相關內容