I have been given a task to design a MySQL Backup server on which the client
requests should fall back in case the main MySQL Server is either busy, the
network connection to MySQL Server has broken. I can imagine this should be
possible only if a proxy server is in between the Clients and the "
> On Wednesday 22 May 2002 18:44, Dave Watkins wrote:
> > 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
On Wednesday 22 May 2002 18:44, Dave Watkins wrote:
> 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 s
7;; [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.
slas
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. I
wish to keep 1 copy of the shared raw data in a storage device and
forget circular master-slave replication. If ther
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, Pat
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 wrote you have to take
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
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-tracki
