Parent comment already mentioned read-replicas. The main problem I've seen is companies allowing tables to grow enormous because they never partition (by year,

Parent comment already mentioned read-replicas. The main problem I've seen is companies allowing tables to grow enormous because they never partition (by year, for instance) or archive out old stale data.