Hmm.. I am a bit worried about the CPU usage on the MySQL database!
It seems that the new sites have doubled the server traffic and the
processor load is now close to 95% during peak hours.
problem is that we are caching absolutely everything the only way to
scale now is by duplicating the database with a master-slave db
structure! This is something that I have been avoiding for a long time,
but it seems that there is no other option now. Time to pull the
sleeves up and do some hardcore DB programming