Richard-
If you have 2 or more servers which you want to dedicate to MySQL you may
want to look into MySQL Clustering
To focus on sync'ing I would read about the the 'syncronisation replication'
vs 'asynchronous replication' that the Participating Nodes employ
http://www.mysql.com/news-and-events/newsletter/2003-02/a0000000125.html
HTH/
Martin--
This email message and any files transmitted with it contain confidential
information intended only for the person(s) to whom this email message is
addressed. If you have received this email message in error, please notify
the sender 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 locations
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 don't understand the need to always have the same in two locations as
this uses up twice the amount of ressources.
C K a écrit :
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
we are using Auto-increment fields for each table and it is Primary Key
and
also physical records are already marked with this PK. Is there any other
solution for this?
Please give the details.
Thanks
CPK
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
