Multi-Location + Multi-Tenant Read Replica
So we have a fairly complex requirement that we are hoping to solve via schema-based multi-tenancy and PG read replicas. As you can see from the diagram, we want to host the app in the cloud + 2 onsite locations matched to tenants. We would like to leverage read replicas to enable shared reads & local tenant writes in the event of internet/power outages at one of the on-site locations.
Are there any immediately obvious problems with this idea, or does it seem feasible?
Are there any immediately obvious problems with this idea, or does it seem feasible?
