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]
