Re: how to design mysql clusters with 30,000 clients?

2002-05-23 Thread Benjamin Pflugmann
Hi. On Thu, May 23, 2002 at 11:16:33PM +0800, [EMAIL PROTECTED] wrote: > Hello Benjamin Pflugmann <[EMAIL PROTECTED]>, > > This scenario is fine. But in real life, the circular master-slave > replication will probably cause inconsistency of data among them. That is why I wrot

Re: how to design mysql clusters with 30,000 clients?

2002-05-23 Thread Benjamin Pflugmann
Hi. On Thu, May 23, 2002 at 11:16:33PM +0800, [EMAIL PROTECTED] wrote: > Hello Benjamin Pflugmann <[EMAIL PROTECTED]>, > > This scenario is fine. But in real life, the circular master-slave > replication will probably cause inconsistency of data among them. That is why I wrot

Re: how to design mysql clusters with 30,000 clients?

2002-05-23 Thread Benjamin Pflugmann
Hi. On Thu, May 23, 2002 at 10:44:15AM +1200, [EMAIL PROTECTED] wrote: > At 16:02 22/05/2002 +0800, Patrick Hsieh wrote: [...] > >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 se

Re: how to design mysql clusters with 30,000 clients?

2002-05-23 Thread Benjamin Pflugmann
Hi. On Thu, May 23, 2002 at 10:44:15AM +1200, [EMAIL PROTECTED] wrote: > At 16:02 22/05/2002 +0800, Patrick Hsieh wrote: [...] > >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 s