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.
I am AWS Solution Architect & SysOps Administrator Certified and had a good hands on experience on various AWS services. I have worked on similar kind of requirement and it's pretty much doable.
Solution would be like Certainly We can create the main RDS DB(MySQL, PostgreSQL, Maria DB or Arora DB) in one region (ex: EU-east-1) then We will create the snapshot of the DB and certainly create the read replica of the main DB in the other two region (Singapore), (USA) and (Japan) And then We can create a route53 DNS entry based on latency or Geo-location and failover.
There are few limitations that, We should understand. That I can explain while the call.