MySQL replication - independent data update on slave I have an unusual situation where I am migrating websites and their corresponding databases from one server to another.

I have a database that is hosted on one server, A, where new records are created, and these are accessed and modified on the second server B (but no new records are created).

I have set up A as master, and B as slave to ensure that B has access to new records created by A, but A does not need access to the amended record data that are changed on B.

I know there are lots of warnings about not changing data on the slave, but it seems to me that this should work OK (until I finish the migration, at which point I will move the record creation facilities to server B and break the slave link).

Any thoughts?
On this scenario replication should not face any issues. 

MASTER (A): INSERT

SLAVE (B): UPDATE,DELETE

The only issue i can think is to change a unique constraint on B and try to insert the same record on A.