Goodday
This is exactly what I have had problems with, and in the manual it tells
you that autoincrement fields are not supported in circular replication. I
posted a MSG on this group asking for feedback from the developers but got
nothing.
You have to dump he autoincrement, and do it manually in your problem. I
have a table called "sbcontrol" and in it I have columns for each table that
I HAVE to have to have an autoincrement number for, and the rows are my
branches. So when I save a record Ijust update this table and use the number
as my "increment", works fine. Each branch starts generating at different
places, one is 10 billion, the second starts at 20 billion and so on.
BYe bye
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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 Fabien Balageas
> Sent: 14 June 2001 13:59
> To: '[EMAIL PROTECTED]'
> Subject: Replication and primary key autoinc issue
>
>
> Hello!
>
> I have two databases that i want to replicate: each database
> should contain
> the same information. That's why i have set a circular
> replication relation.
> All works fine, except that one of the table is filled in
> real-time; this
> table has a primary key with autoinc type. When a new record
> is inserted in
> database 1, and simultaneously a new record is also inserted
> in database 2,
> they managed to have the same value for the primary key. So
> replication is
> no more possible.
>
> Any idea?
>
> Thanks in advance,
> Fabien Balageas
>
---------------------------------------------------------------------
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
