Predictive caching in a MySQL-backed infrastructure

Sounds a bit far fetched (pun intended ;-), but we’re doing it. This is not inside of the MySQL server, but rather the overall application design. Let me run you through the logic… Some key aspects to scaling are: not doing unnecessary queries, and caching what you can. Just a quick baseline. The fastest query […]