Autoincrement Pk With Data Sync

[peterlaursen]

http://dev.mysql.com/doc/refman/5.0/en/rep…-increment.html

http://dev.mysql.com/doc/refman/5.0/en/ser…-variables.html

Now set

auto_increment_increment to 2

auto_increment_offset to 1

on one server and

auto_increment_increment to 2

auto_increment_offset to 2

on the other

… and it is possible to use a plain autoincrement integer as a PK with SJA DATA SYNC and even insert and update records on both servers between syncs.

I described another trick here

http://webyog.com/articles/Using_SQLyog_En…L_Databases.pdf

but this is simpler if you have acces to both server configurations.

.. but still if you want to delete records you will have to do so on both servers, if data exist on both.

[Ritesh]

Thanks. Will look into it once I am back.

[Author]

Posts