[PLUG] Fishing for suggestions - Syncing multiple servers?

[ed at alcpress.com]

For scenario 1, I use rsync over ssh.

For scenario 2, it seems that more frequent synchronization
would require the cooperation of your application program(s).
I have the same need and I intend on implementing
transaction files at each site for times when the sites can't
communicate with one another. Periodically, a housekeeping
program will sync both sites to one another - again over a
SSH link. Note that this synchronization is syncing database
tables (records) - not syncing database files. If there's a better
way, I'd like to hear it.

Ed


On 24 Mar 2002, at 14:09, Sean, Sharon and Kyle Harbour wrote:

> 
>  Got a couple of scenarios here:
> Scenario 1: I have x number of servers. Some of them are on the local trusted
> network, some of them are not. The flat text configuration files for one of
> the services are kept in a consistant location on the file system, but each
> server may or may not have it's own uniquely named config files mixed in with
> other config files that we would like to keep loosely synced up among all the
> servers. Plus or minus 5 minutes in the sync would be okay. I've got several
> possibilities, and I was hoping for some more suggestions. Rsync scripts
> customized to glue everything together. Exporting part of the filesystem to
> NFS and syncing each servers local files with the NFS mount. (Not really
> secure). Intermezzo file system mounting all of the config files and letting
> Intermezzo handle everything. (Still not really secure, but it sounds like it
> would be pretty much maintenance free if it doesn't corrupt) Using a built in
> distro utility to automatically handle 2 way syncing (Mandrake DrakSync? Does
> Redhat have anything to compare?) What would be the simple and elegant
> solution I am missing here? Scenario #2 : Keeping a backup webserver with
> MySQL databases synced up with a production webserver. Right now I'm thinking
> we could just script the production web server to shutdown the databases at
> midnight and rsync everything over. I'm not a database guy, so how would we do
> it for a live MySQL database to keep the backup server closer than 24 hours
> behind? Anybody know of any good tutorials on this type of setup? Thanks! Sean
> Harbour
> 
> 
> 
> 
> ---------------------------------
> Do You Yahoo!?
> Yahoo! Movies - coverage of the 74th Academy Awards®