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.

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

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.
accounting will carried out at both, but only HO database will be considered
for generating Statutory reports. Also cluster can not be a solution as it
requires min. 100 MB network.
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.

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

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



--
Keep your Environment clean and green.

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