Hi, I need some help here. We have application that running online, that everybody can access and add new customer data there ...

Now because of one of our branch office is located in remote area with limited internet access, we are planning to develop a local server there, with the web application installed on the local web server.

We are trying to use SQLyog to synchronize 2 of the databases ( one in our public server and one in local server in remote area )

The problem is :
becase there are 2 database with open access, when we synchronize the data ... the auto increment table id will be double and it will cause the system not running well ...

Is there any MySQL Database solution that can help us synchronize 2 databse with same name and auto increment table PKEY, with no collision ?

is there any synchronizer software better than sqlyog ?

If you have problems with SQLyog why do you not visit our Forums (www.webyog.com/forums) or use our support ticket system?

Anyway this problem "the auto increment table id will be double and it will cause the system not running well ..." can be solved in at least 3 different ways.

1) Have a two-column PK where one column is an autoincrement integer and the other a constant different on either server (this I consider the most simple aand most reliable solution)

2) Use autoincrement_increment and atoincrement_offset in server config so that one server will generate even numbers and the other odd numbers

3) Start incrementing from 1 on one server and a hig number (like '10000000') on the other

Regards
Peter Laursen
Webyog