March, 2008
Progress on MySQL Proxy Partitioning
As posted here I started to think about possible ways to implement database sharding/partitioning. I finally found the time to start prototyping a MySQL Proxy based solution that would allow you to analyze and rewrite queries to direct them to different databases. So this would going to be a nearly 100% transparent solution (some queries [...]
MySQL Partitioning on Application Side
After following the scale up path (i.e. buy bigger boxes) for a while now, we definitely need to scale out as things start to become “unhandy” and simply HUGE. (See small things are better) We are running an OLTP application with about 200 million transaction per month. Currently we have some very large tables with [...]