Hi Lukas, > 2) maybe you can create something out of MySQL Proxy that splits out > a single query into multiple queries and then rejoins them > 3) since MySQL AB is actively developing a new libmysql replacement > for PHP only, you might want to talk to them about implementing > something like this
Spot on! What you're suggesting, splitting queries and combining the results, is exactly the direction I'm thinking about. We had a short look though at MySQL Proxy, and basically it does not seem to cut the job for us. We want to avoid adding another proxy layer between our webservers and the database servers as it would just mean additional overhead and possible bottlenecks and points of failure. This is why I want to move this functionality onto the webservers themselves, to achieve minimum overhead and to guarantee it will scale with the number of webservers. Nevertheless, MySQL Proxy does appear to provide some of the functionality we will be needing and it might indeed be a good idea to contact MySQL and try to reuse some of Proxy's components if possible. Thanks! Arend.
