The modern way is to sidestep the issue altogether and use Kubernetes with a database designed to run on Kubernetes. You can get sharding, replication and leader election essentially for free - you can concentrate on using the database instead of running the database.
Compute is really cheap compared to engineering man-hours.
Compute is really cheap compared to engineering man-hours.