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 mechanisms.
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 synchronicity. Tim... -----Original Message----- From: C K [mailto:[EMAIL PROTECTED] Sent: Thursday, August 02, 2007 2:08 PM To: mysql@lists.mysql.com Subject: MySQL database synchronizing from 2 locations Hello, My client has a mfg. unit at 65 Km from a city in India. He wants to connect 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 possible 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) Please help. Prior Thanks, CPK -- Keep your Environment clean and green. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
