Okay, do not do this. When your replication takes place, Site A adjusts Site
B autoincrement number. ANd so this principle does not work!!!!!
I really think this replication could be very good if you could specify not
to replicate a particular column, or some better way of handling auto
numbering.
Comments from the MYSQL dev team?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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 Warren van der Merwe
> Sent: 06 June 2001 11:11
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: Replication out of sync
>
>
> Hi
>
> Well, what I did was dump my structure to file, then I went
> an manually
> added a line to the end of each table saying
> "AUTO_INCREMENT=100000000" for
> Site A, Site B was set to 200000000 and so on, obviously
> there is a chance
> one day of Site A's auto_increment reaching 200000000 but it
> won't happen
> for many many many years in my environment.
>
>
> Regards
>
>
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> 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: Michael Eklund [mailto:[EMAIL PROTECTED]]
> > Sent: 05 June 2001 23:18
> > To: [EMAIL PROTECTED]; 'Warren van der Merwe'
> > Subject: RE: Replication out of sync
> >
> >
> > How did you work out the auto-ids on different servers issue?
> >
> > Mike
> >
> > -----Original Message-----
> > From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, June 05, 2001 2:16 PM
> > To: Warren van der Merwe
> > Cc: [EMAIL PROTECTED]
> > Subject: Re: Replication out of sync
> >
> >
> > On Mon, Jun 04, 2001 at 05:45:44PM +0200, Warren van der
> Merwe wrote:
> > > Hello
> > >
> > > Firstly, big thank you to all who helped me get my
> > replication going.
> > >
> > > When I was playing around, I managed to get one of my table out of
> > > sync, on the one server I have 8 records and on the other
> 9. I know
> > > exactly what happened, it was when server B was not replicating to
> > > the correct address. Now the question is, what is the easiest way
> > > of getting them in sync? Do I delete the table from the one server
> > > reload it?
> >
> > Run a LOAD TABLE <table> FROM MASTER on the slave to bring
> an updated
> > copy of the table to the slave.
> >
> > 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 11 days, processed 68,268,148 queries
> (71/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
---------------------------------------------------------------------
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
