[AzPHP] Tuning MySQL DB server

[Ed]

Hi Vimal - a bit OT as you're on Linode, but the best tuning I have
ever seen on a database was putting it on a SSD. If you go the cluster
route by keeping the master on Linode and using EC2 to serve capacity
peaks when they come in, the a CFEngine config tool might have get you
the dynamic capacity that you're looking for:
http://cfengine.com/demos/cfengine-amazon-ec2

since cfengine is loosly coupled, you could have load on the webserver
cluster drive the database cluster size - or time of day, or database
loads - lots of options.

Since the EC2 instances can be driven by load, you don't need to keep
extra resources around that you aren't using - glad to hear your
having deployment fun! ;)  Ed