List:General Discussion« Previous MessageNext Message »
From:Kishore Jalleda Date:March 13 2006 4:27pm
Subject:Re: Auto increment Primary Index fields in replicated db
View as plain text  
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
>
>

Thread
Auto increment Primary Index fields in replicated dbJeff13 Mar
  • Re: Auto increment Primary Index fields in replicated dbKishore Jalleda13 Mar