> 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 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
