Have y’all looked at containerization coupled with something like postgres-orchestrator? The problem is at the end of the day you still need the storage and still need the load balancer but it might help with some of the horizontal scaling growing pains.