Hello,
As per your suggestions I tried to get some correct solution for the
problem, but there is a big problem for replication and it is network
connection. Though Internet is available to the Mfg. Site, it is not having
good speed and continuous. So that replication may not be a good choice. As
Sorry maybe this is completly out of topic, but why do you need it to
synchronise in two locations, can't you just get both servers to connect
to the same database?
And then if you need you can set a cron to backup your database hourly
or daily to the other server using mysql dump and scp.
I
immediately by telephone or email and destroy the original
message without making a copy. Thank you.
- Original Message -
From: Richard [EMAIL PROTECTED]
To: C K [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Sunday, August 05, 2007 4:01 AM
Subject: Re: MySQL database synchronizing from 2
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).
Hi,
Set up two-way replication between Corporate and Manufacturing. As long
as a live network connection is available between the two sites,
replication will carry on. Make sure that all your hardware is able to
handle the peak I/O loads, in order to keep replication humming along
seamlessly.
If