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?
The Elixir backend framework for unparalleled productivity. Declarative tools that let you stop wasting time. Use with Phoenix LiveView or build APIs in minutes for your front-end of choice.
2,193Members
Resources
Recent Announcements
Similar Threads
Was this page helpful?
