Please refer to these two links, they would give you a clear explaination.
there is also an example in the second link which you can easily test .....
http://dev.mysql.com/doc/refman/5.0/en/replication-auto-increment.html
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html ( scroll
down for variables auto_increment_*)
Kishore Jalleda
On 3/13/06, Jeff <jsmforum@stripped> wrote:
>
> All,
>
> We are using circular replication now on db's that were originally stand
> alone. One problem we have is that all the primary index fields for
> most of the tables are auto increment fields. This prevents us from
> writing to both db servers because of confilicting INDEX entries. Is
> there some way to have this work? Someone on another msg board told me
> to look at Auto_increment_increment and Auto_increment_offset to
> accompish this but I don't see anything like that in the MySQL docs.
>
> Thanks,
>
> Jeff
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>
>
