Re: how to design mysql clusters with 30,000 clients?
Hi.
On Thu, May 23, 2002 at 11:16:33PM +0800, pahud@pahud.net wrote:
> Hello Benjamin Pflugmann <benjamin-mysql@pflugmann.de>,
>
> 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 care of the special properties
(e.g. unique keys will not assure uniqueness among all servers). If
you take care of such things, there should be no problem with data
consistency.
> I wish to keep 1 copy of the shared raw data in a storage device and
> forget circular master-slave replication. If there is no locking
> problem in this scenario, then I can balance the
> insert/delete/update load onto every mysql server attached on the
> shared storage device. Idea?
No comment, because I have no experience with that.
Bye,
Benjamin.
> On Thu, 23 May 2002 16:19:53 +0200
> Benjamin Pflugmann <benjamin-mysql@pflugmann.de> wrote:
[...]
> > I beg to differ. This kind of setting is doable since 3.23.26 and even
> > mentioned in the manual as circular master-slave relationship:
> >
> > http://www.mysql.com/doc/R/e/Replication_Features.html
> >
> > Of course you have to take care of the special properties of this
> > configuration.
--
benjamin-mysql@pflugmann.de
--
To UNSUBSCRIBE, email to debian-isp-request@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
Reply to: