List:General Discussion« Previous MessageNext Message »
From:Timothy Little Date:August 2 2007 6:36pm
Subject:RE: MySQL database synchronizing from 2 locations
View as plain text  
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:shreeseva.it@stripped] 
Sent: Thursday, August 02, 2007 2:08 PM
To: mysql@stripped
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.
Thread
MySQL database synchronizing from 2 locationsC K2 Aug
  • RE: MySQL database synchronizing from 2 locationsTimothy Little2 Aug
RE: MySQL database synchronizing from 2 locationsRajesh Mehrotra2 Aug
  • Re: MySQL database synchronizing from 2 locationsC K5 Aug
    • Re: MySQL database synchronizing from 2 locationsRichard5 Aug
  • Re: MySQL database synchronizing from 2 locationsMartin Gainty5 Aug