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