Hi
How would you set it up so that each server uses different auto numbers?
Could I do it so that server A's auto numbers start with A, and B's with B,
etc etc etc?
Thanks
Warren
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Warren van der Merwe
Software Director
PRT Trading (Pty) Ltd t/a RedTie
Durban, South Africa
Cell (+27-83) 262-9163
Office (+27-31) 767-0249
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> ]On Behalf
> Of Jeremy Zawodny
> Sent: 01 June 2001 08:34
> To: Warren van der Merwe
> Cc: [EMAIL PROTECTED]
> Subject: Re: Replication
>
>
> On Thu, May 31, 2001 at 09:18:48PM +0200, Warren van der Merwe wrote:
> > Hi there
> >
> > I have three sites, each runnin MYSQL. I want to replicate the data
> > between all three. I know I cannot do this with the standard
> > replication in MYSQL, because all three sites will add their own
> > records and the manual says the slave cannot insert entries it's
> > self.
>
> Actually, you can do that with replication. You just have to get it
> right. :-)
>
> Think of it as a replication ring. Imagine 3 servers: A, B, and C.
>
> B is a slave of A.
> C is a slave of B.
> A is a slave of C.
>
> You can insert a record into one, and it will make it to the other
> two. The server-id in the binary log prevents this setup from causing
> an infinite loop.
>
> The trick is making sure that you don't have inserts which try to
> stomp on each other. Generally this means that you can't use
> AUTO_INCREMENT columns without taking extra precautions. You need to
> ensure that server A can't generate the same ID that any other server
> would generate.
>
> If this isn't obvious (not sure how much you already know about
> replication), just say so. We can go into more detail.
>
> Jeremy
> --
> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 439-9951
>
> MySQL 3.23.29: up 6 days, processed 41,479,099 queries (73/sec. avg)
>
> ---------------------------------------------------------------------
> 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
