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?
1 Reply
So, when you say "local tenant writes" what do you mean? Because reconciling that data is going to be... "a whole thing".
If you mean that in the case of a network outage the site keeps on working and then when its back online you write the data back to the parent
If its segmented by tenant in each one then I guess you could theoretically just overwrite the home-base data with the tenant data, but even still that sounds like it may come with some issues