[hodgesrm]

This is a very common solution. The biggest advantage is that it allows you to use read replicas which are there for HA and otherwise idle.