Bristol's free PHP meetup. Talks, pizza & pub, every second Wednesday.

← All talks

Given at PHPSW · October 2025

Scaling Writes on MySQL

As your PHP application grows, database performance can become a bottleneck. While adding read replicas, copies of your database that handle read-only queries, can help with scaling reads, they don’t solve issues with too many writes.

That’s where write-sharding comes in. This technique distributes data across multiple databases, reducing both the write load and the amount of data on each node. In this talk, we’ll break down what write-sharding is, when to use it, and how to implement it effectively in a PHP application.

If you’re looking to scale beyond read replicas and handle high write loads, this session will give you the tools to do it, and how I implemented this at SMS Marketing SaaS Voxie, allowing them to service large new customers sending more in two hours than every other customer combined in a week!