I have an aws ec2 instance in N.Virginia, an Ubuntu machine with everything inside (mysql as well as apache).
Basically all these while, I'm running it on one instance alone, with just image backups and sql backups, but no extra instances nor ELB/ALB/NLB. I am using cloudfront for images, and the rest will be from my server itself (some javascript files and css files for example, as well as mysql queries).
I noticed that, around 30% of my users are from Asia (Singapore, Malaysia, Indonesia).
With this being said, I stumbled into Route 53, and my initial/current plan would be
Transfer N.Virginia instance's domain (currently from GoDaddy) to aws, and enable Route53 for it (is the transfer a must? Or can i just enable route53 and update the 4 addresses in Godaddy?)
Start another ec2 instance in Singapore (the nearest)
Enable geographic routing for N.Virginia instance to Singapore instance
That being said, based on what i know, this should only change for the loading of files (javascript/css files etc..) and not affect mysql (still based on N.Virginia).
I was hoping this approach could slightly speed up my system, but how do i measure the change? And is it possible to measure or get a confirmed answer before implementing it.
Thanks.