Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
From: C K (shreeseva.itgmail.com)
Date: Sat Aug 25 2007 - 13:30:12 CDT
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?
On 8/25/07, Craig Huffstetler <craig.huffstetlergmail.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.itgmail.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.