<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; "><BR><DIV><DIV>On Jul 14, 2006, at 5:41 PM, Hugh Esco wrote:</DIV><BR class="Apple-interchange-newline"><BLOCKQUOTE type="cite"><P style="margin: 0.0px 0.0px 0.0px 0.0px"><FONT face="Helvetica" size="3" style="font: 12.0px Helvetica">I'm working with folks who would like to physically distribute their server load so that they might be prepared for peak demand as well as to provide for fail-over as part of a disaster recovery plan. </FONT></P> </BLOCKQUOTE></DIV><BR><DIV>You'll have to deploy different strategies for peak demand versus disaster recovery.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>For disaster recovery you can dedicate a server to slave replication. MySQL Lead Architect, Brian Aker, and MySQL senior performance engineer Peter Zaitev have been discussing in public.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Brian: <A href="http://krow.livejournal.com/434562.html">http://krow.livejournal.com/434562.html</A></DIV><DIV>Peter: <A href="http://www.mysqlperformanceblog.com/2006/07/07/thoughts-on-mysql-replication/">http://www.mysqlperformanceblog.com/2006/07/07/thoughts-on-mysql-replication/</A></DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>For peak load you'll want to do what Allie suggests which is multi-master replication.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>This is a good overview of MySQL replication. But be aware, drupal is not read versus write aware yet so typical slave configuration won't work.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV><A href="http://jcole.us/mysqluc/2006/MySQL%20UC%20-%20Replication%20for%20Scaling%20and%20High%20Availability.pdf">http://jcole.us/mysqluc/2006/MySQL%20UC%20-%20Replication%20for%20Scaling%20and%20High%20Availability.pdf</A></DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>There is a good article that details how to set auto increments between master slaves offset by 10 so that you can achieve MySQL master replication. I can't find it right now but will do so and post shortly.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Do you plan to have a lot of files as well?</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Cheers,</DIV><DIV>Kieran</DIV></BODY></HTML>