Hi,
I'll soon run in a probaply pretty common problem with 2 site replication.
We currently hold our customer and buisiness data in one mysql server.
Soon we'll get another site which basically will work on a regional
separate project. While the set of potential costomers that overlap will
be limited, there still will be customers that are related to both sites.
The new site will only mind operational acquisition stuff and project
related PR. Invoice management will be on the main site.
While doing that, the 2nd site will report incoming orders to the main
site and of course there will be additions and changes to shared
costomer records - like adresses, contact person, phone numbers - that
have to be synchronized both ways.
There is no online-connection planned. The synchronisation should be
made via queries that extract the changed recorddata that'll be
transfered perhaps by email or via ssh remote login.
How could I identify, ex- and import such changed data ?
Maybe there are concurrent changes to be catched ? Like site1 changes
field1 and site2 field2 of the same record.
The whole point is to share as much data as possible so both sites
profit on additions or corrections.
Any pointer to documentation in that matter would be appreciated.
regards ... Andreas
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
