Al usar AWS re:Post, aceptas las AWS re:Post Términos de uso
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?

Temas
AnálisisBase de datos
Etiquetas
Amazon AuroraAurora MySQL
Idioma
English
iamnick
preguntada hace 2 años577 visualizaciones
1 Respuesta
0
Respuesta aceptada

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
EXPERTO
kentrad
respondido hace 2 años
  • iamnick
    hace 2 años

    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 EXPERTO
    hace 2 años

    So, new connections are not being load balanced?

  • iamnick
    hace 2 años

    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 EXPERTO
    hace 2 años

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

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas

Contenido relevante