Eric, you are in the same boat I am in. I also have satellite offices across WAN links that should keep functioning even if the WAN is down.
My , yet to be tested due to "office politics", workaround design was to have each office (satellite and main) have their own "mini-master" that replicated to a central location. At the central location I will be running a daemon or cron task (the actual design of which is on hold) to collect the new records/updates and merge them into a new "mega-master" database. The megamaster will contain the combined records of all of my locations. Each remote office will get a read-only replica of the megamaster (thus enforcing one-way replication)
That looks a bit like the old PostgreSQL Replicator project: http://pgreplicator.sourceforge.net/
Jochem
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
