Scaling MySQL for transactional platforms: indexes, replicas and partitioning
MySQL can carry serious transactional workloads when it is used well. A practical sequence for scaling: query and index design, connection management, read replicas, safe schema changes, partitioning and archiving.