Michael,

Thanks for the feedback. I think your idea of using a combined primary
key (an auto-incrementing field combined with a site specific field)
is a good one. We could certainly write some scripts (we work in
Python in the production facility) or do some MySQL magic to
periodically synchronize the databases. Once a record is entered at a
site, most of the write activity for that record would occur at that
site.

I also agree with what you said about the MySQL cluster, it's intended
for Active/Passive failover rather than synchronization. Plus, as the
quote you include shows, it's not recommended for anything other than
a local network.

I'll be talking with our DBA guy and see what we come up with.

Again, thanks for the feedback, very helpful!

Doug