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 instead.

Baron

C K wrote:
> 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/active and how it could be
> implemented?
> It can be possible to update the data to both servers and keep another for
> reporting only purpose.
> Is it possible to make HO as Master and Reporting as Slave and Site Server
> as another master and same Reporting as Slave. i.e. Reporting will be
> the salve for both masters in Replication?
> Thanks again
> CPK
>
> On 8/26/07, Gary W. Smith <gary@primeexalia.com> wrote:
>>> for generating Statutory reports. Also cluster can not be a solution
>> as
>>> it
>>> requires min. 100 MB network.
>> Says who?
>>
>> But clustering won't . 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 same record.
>>
>> You've also failed to mention the speed you are talking about. My home
>> office is a replication point for our large database at our CO. I do
>> this over Cable.
>>
>> You could try active/active, assuming you work out some type of conflict
>> resolution plan. If each site will generally be editing their own data,
>> but combined for reporting only, then active/active should be fine, even
>> if you are talking about 20KB/s.
>>
>>
>>
>>> Can we generate scripts on windows to sync them manually?
>>> Thanks
>>> CPK
>>>
>>> On 8/25/07, Craig Huffstetler <craig.huffstetler@gmail.com> wrote:
>>>> 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 to disable to VPN between the two D.B.
>>> servers?
>>>> Perhaps a firewall in between is in use and you can simply setup
>>> access
>>>> rules for both to talk to each other? The VPN tunnel is most likely
>> a
>>> big
>>>> slow down.
>>>>
>>>> On 8/25/07, C K <shreeseva.it@gmail.com> wrote:
>>>>> Hi,
>>>>> I have a problem as below-
>>>>> We have a MySQL server for our ERP database. Now we have to
>>> implement
>>>>> the
>>>>> ERP for Head office. HO is away from the current setup and
>>> connection
>>>>> between the two is through VPN at slow speed. How can we
>>> synchronize the
>>>>> two
>>>>> MySQL servers?
>>>>> Replication,
>>>>> Cluster, or manually?
>>>>> Thanks for your replies.
>>>>> CPK
>>>>>
>>>>> --
>>>>> Keep your Environment clean and green.
>>>>>
>>>>
>>>
>>> --
>>> Keep your Environment clean and green.
>
>
>