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
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 w
