Actually, in my humble opinion, autoincrements need to have
a host component, so each autoincrement is unique on each
machine. Also you could have the master negotiate
discrepencies, but this is far more complicated.
Mike
On Wed, 6 Jun 2001 12:25:16 +0200
"Warren van der Merwe" <[EMAIL PROTECTED]> wrote:
> 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
