If you must manually sync, MySQL Table Sync is designed for efficient
syncing over a slow network.
http://mysqltoolkit.sourceforge.net/
It's still not finished, but I use it in production all the time.
If there's any way you can possibly do this via replication, I would
recommend you do that
Thank you very much.
The VPN bandwidth will be 128/256 kbps. Also we have to make updates to both
locations simultaneously and our application is provided with locking
mechanism for updating records and resolving conflicts to update same
record.
Also please give the details about term active/activ
> for generating Statutory reports. Also cluster can not be a solution
as
> it
> requires min. 100 MB network.
Says who?
But clustering won't help. You are looking for active/active, which
could be accomplished but this would possibly lead to specific conflicts
if people are trying to edit the s
We are using ODBC and Win Server 2K3. Also the database size is not so big (
i.e. upto 300 MB). The major problem is that both the databases at two
servers will be same in structure and will be used by local group of users
for daily operations. One of them must be treated as a MASTER for data. i.e.
I would probably recommend replication. It's not that bad to setup and once
it catches up on the slave then it will continue to be an easy sync in the
future as long as both are running. How big is the database you wish to
synchronize? What connection are both servers on?
Is there anyway possible
