Posted by JurgenHeiman on October 21, 2010 at 12:34am
Has anybody tried clustering OP? I want to build a high-availability cluster with it, but I'm curious if anybody has any experience in doing this.
Basically I want to achieve the following:
* load-balancing
* high-availability in case one or more servers go down (crash, maintenance etc)
After some research I want to give the procedure described in http://www.coderintherye.com/drupal-mysql-cluster-ndbcluster-high-availa... a go, but maybe there are better alternatives?
Comments
OpenPublish clustering has
OpenPublish clustering has all the same characteristics that Drupal clustering does, because... well, OpenPublish id Drupal :) That said, I don't think the link you posted has enough information and I am not sure it's a best-practice way of achieving high availability.
Typically, in a high-load Drupal setyp you would have:
The bet in such cases is on two main factors:
1. Most traffic is anonymous so front-end cache should take large portion of traffic on itself (at least with the help of edge-side-includes (ESI)).
2. Requests are predominantly "read" requests with very small portion being "write" requests. Hence having multiple read-only slave MySQL servers can ease the burden significantly.
Trying to build a high-TPS, truly clustered multi-master setup is not what Drupal on MySQL is best suited for.
.............................................
http://twitter.com/inadarei