There is some info about slashdot and how they utilized MySQL here: http://www.mysql.com/articles/us/slashdot.html
Gurhan -----Original Message----- From: Adam Nelson [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 10:00 AM To: 'Dave Watkins'; 'Patrick Hsieh'; [EMAIL PROTECTED] Subject: RE: how to design mysql clusters with 30,000 clients? I believe slashdot uses one heavy duty database server (quad xeon) and a redundant one. This isn't an actual cluster, but I would have to assume that slashdot gets more that 30,000 clients at a time. slashcode.org has information (somewhere deep in there, I couldn't find it, but I remember being told about it). -----Original Message----- From: Dave Watkins [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 22, 2002 6:44 PM To: Patrick Hsieh; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: how to design mysql clusters with 30,000 clients? At 16:02 22/05/2002 +0800, Patrick Hsieh wrote: >Hello list, > >I am expecting to have 30,000 http clients visting my website at the >same time. To meet the HA requirement, we use dual firewall, dual >Layer-4 switch and multiple web servers in the backend. My problem is, >if we use the user-tracking system with apache, php and mysql, it will >surely brings a huge amount of database traffic. How can I balance mysql >load among multiple mysql server yet assure the data consistency among >them? My idea is: > >1. use 3 or more mysql servers for write/update and more than 5 mysql >servers for read-only. Native mysql replication is applied among them. >In the mysql write servers, use 1 way replication like A->B->C->A to >keep the data consistency. But I am afraid the loss of data, since we >can't take the risk on it, especially when we are relying our billing >system on it. This will not work. MySQL replication does not work like that. With MySQL replication you have one master and all others replicate from it. It is also the only server that can write to the DB. Your options for following this route would be to either use the experimantal 2 way replication support in the beta of MySQL4. Or use a different DB Dave --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
