[wp-hackers] Clustering WordPress

[Brian Layman]

You MAY need db slaves, yes, but before you start scaling with HyperDB 
and multiple slaves, make certain that you actually see the need.  You 
should only switch to multiple DB servers if you have a tuned MySQL 
server that is still being overwhelmed despite caching. Having a 
dedicated MySQL server will get you a long way.  Then the next step 
would likely be a separate write server and a single r/w slave.

You'll probably find Mark Jaquith's presentation on scalable WordPress 
from last year's WordCamp SF interesting.
Good stuff:
http://wordpress.tv/2011/08/20/mark-jaquith-scaling-servers-and-deploys-oh-my/

Brian Layman

On 8/20/2012 4:05 PM, Scott Taylor wrote:
> yes - but if you need many front end web servers, you may need MySQL slaves as well.
>
> Check out HyperDB when you do:
> http://wordpress.org/extend/plugins/hyperdb/
>
>
> The bread and butter of scaling WordPress:
> http://wordpress.org/extend/plugins/batcache/
> http://wordpress.org/extend/plugins/memcached/
>
>