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 --------------------------------------------------- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
