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 <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED] > >