Re: [AzPHP] Tuning MySQL DB server

Top Page
Attachments:
Message as email
+ (text/plain)
Delete this message
Reply to this message
Author: Ed
Date:  
To: Main PLUG discussion list
Subject: Re: [AzPHP] Tuning MySQL DB server
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 -
To subscribe, unsubscribe, or to change your mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss