Replication works with Windows (we do it extensively here at work). And
it's definitely one option. But if there are any problems, then without
some monitoring mechanism, you'll not be alerted if replication chokes
(all that will happen is that updates to the slave will seemingly just
stop). You can implement any of a bunch of alerting and self-repair
Other methods of transferring the data are similarly challenging.
You can do an automated MySQLDUMP on a periodic basis with with a
--master-data option (in case you do perform the replication) just to
"be sure" OR just do MySQLDumps each night (depending on the volume).
It all depends on the degree and need for whatever level of
From: C K [mailto:shreeseva.it@stripped]
Sent: Thursday, August 02, 2007 2:08 PM
Subject: MySQL database synchronizing from 2 locations
My client has a mfg. unit at 65 Km from a city in India. He wants to
to his corporate office in the city. Both offices will use same data and
same ERP system. He is using Win 2K3 server and MySQL 5.0.17. Is it
to make them synchronized at a particular or regular intervals?
How? Please give details.
Options I think - Replication (is it possible for Windows?)
Cluster (Is it possible?)
Manual Sync by using Navicat or any other tool
(other tools please)
Keep your Environment clean and green.