Auto Increment fields

[Jeff McKeon]

Using Version 5.0.22, RHEL3

We're at the point where we need to start archiving our data. It has been suggested that we use a combination of Repliation and Archive table types to accomplish this. So:

System A : DB A : Table A InnoDB

System B : DB B (replicated) : Table A Archive

The problem I see is that DB-A:Table-A uses a auto increment field for it's primary index column. Won't this cause a problem when a insert statement replicates down to DB-B:Table-A?

Futher, any update query run against DB-A:Table-A will be seen as an insert in DB-B:Table-A when it comes down through replication correct?

thanks,

Jeff