I have a running web/api server on EC2 Instance and another instance for Database.
However, I would like to make this into a scale of worldwide region (Deploying a server in more AWS supported regions), however the database seems to be an issue here. We need the database to be sync with the others (for example if I make a change in EU Region, US Region database value will be updated as well).
I'm also looking into migrating to Amazon RDS but I'm not sure how good/bad is this to support what I want.
I need someone who can advice me (via remote desktop connection, preferably via teamviewer and walk me through the setup of the entire multi-region for my servers), such as VPC, Subnets, EC2, ELB, Route53.
This should take about 2 hours on remote support. I would prefer someone with better internet as this will be done remotely.
I have attached a demo scale of how the database/servers should talk to each other.