In order to create a cross region setup for my craft website, I've created a read-only replica of my RDS DB from North Virginia region to Canada Central region.
I'm facing the internal server error every time Craft is trying to update the session related info in the read-only database.
I could have used the same DB of N.Virginia but, if the N.Virginia region is down, then there will be no DB to support the server in the Canada region.So for this reason I've created a read only replica of the RDS at N.Virginia.
Why I'm choosing read-replica? Because AWS updates it automatically if we update the master DB. So I'll have to update in only one place and the slave RDS across regions will be updated as well.
How can I resolve this? Or, what is the best approach to AWS cross region setup for Craft website?