CODEWITHSUNDEEP
amazon-web-servicesamazon-aurora
Pradeep Bisht
Pradeep Bisht

Reputation: 31

AWS Aurora timeouts due to 100% cpu utilization

I am trying to do load testing on AWS aurora, i am hitting 20k request in 2mins. When database endpoints are pointing to mysql server(non-aws) everything is running smooth, but when I change database endpoint to point to AWS aurora , connections are timing out after about 20-30secs and in dashes I can see 100% cpu utilization during the run.

AWS support people are saying to optimize your query and use select on specific fields rather than select *. But my question is, If in mysql server everything is running good. Then Why aurora cant perform similar way?

Upvotes: 0

Views: 2751

Answers (1)

Pradeep Bisht
Pradeep Bisht

Reputation: 31

As Aurora has one master and multiple read replicas for read operations. Eariler all read/write was being handled by master instance only and read replica nodes were not at all used. So, when we changed the behaviour such that read requests will go to read replicas and write requests to master, issue got resolved.

Upvotes: 1

Related Questions