I need an ecommerce website built that will write+read to mysql database. This application should be able to connect the database using 2 endpoints, that is one endpoint is for writes and another endpoint is for reads. Application should be hosted in 2 different geographical locations.
mysql database is global - writes in one region will propagate to another region
app hosted in region 1 should read and write to region1 database
app hosted in region 2 should read and write to region2 database [all of the functional capabilities are not needed here, simple things like adding item to a cart or placing an item for order in region 2 should reflect for the same user in region 1]