[PLUG] Fishing for suggestions - Syncing multiple servers?

[David Bridges]

Take a look here to read about replication of mysql databases.  Maybe it
will give you guys some additional ideas.

http://www.dnaco.net/mysql/manual_Replication.html

-- 
David

> 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