1 Answer
- Newest
- Most votes
- Most comments
0
Hi Gabriel.
Is your current MySQL instance larger than the Aurora one? If so, that might be the reason you see the difference. To run a fair comparison you should have equivalent instances.
Alternatively, you might want to try Aurora Serverless.
I hope this helps.
We're trying AURORA SERVERLESS. It is a 4 core with 6gb RAM server that runs both app and DB on the same machine. We've created a AURORA SERVERLESS with a t4g Medium machine, that should've been more than enough on my perception.
If you run the page queries directly to the databases, can you compare the performance of each and determine that the Aurora queries are slower? If so, can you check for missing indexes?
Relevant content
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated a year ago
Hi Gabriel,
I am a bit confused with the current status of the application and the tests. As of now production runs completely outside AWS (DB and server on same or different hosts)? And your goal is to move the DB to AWS, server as well? Then you mentioned that you have created a dev env on AWS, this means app is on EC2 and DB on Aurora? Just to understand the current test dev env versus what is running in production. Thanks.
Currently the server runs on another host provider outside AWS, both DB and app. Now we want to migrate the DB only, keeping the App on the server we already have. The server is located at North Carolina. We created our DB instance in OHIO region and tried in OREGON as well with same result, it is not possible that this delay is being caused only by the distance between servers. It can have a higher overhead connection time, but I assume this would be something inside the miliseconds, not almost a second, since the difference on speed is visible without any test needed.