3 messages in com.mysql.lists.clusterIs cluster a good choice?
FromSent OnAttachments
Brian Klug08 Apr 2005 12:12 
Jean-Max Reymond08 Apr 2005 12:37 
Ted Schundler08 Apr 2005 12:46 
Subject:Is cluster a good choice?
From:Brian Klug (bria@gmail.com)
Date:04/08/2005 12:12:28 PM
List:com.mysql.lists.cluster

I have a typical web application, consisting of mostly reads (still a healthy number of writes, however). It connects to a single database server, whose CPU loads goes up a little each day due to the growing popularity of the site. When CPU usage grows too high, we purchase faster hardware, or re-write parts of the application (to cache more, for example). This can't last forever. Would MySQL Cluster work for us? Does performance scale linearly? I.e. if I add an 11th server, will the CPU load on the other machines drop by 10%?

I know the network will become a bottleneck, but this seems like a very distant and acceptable limitation. -B