I was wondering where things were on replacing auto incrementing message id's with a GUID [unique_id].
I have been reading through the archives and found a thread from a year ago that seems to touch on it. [Dbmail] MySQL Load Balancing & Failover http://tinyurl.com/3m6mf The advantage of course would be non-colliding message id's in a server cluster with mysql multi-master replication. I guess I'm curious how difficult it would be to patch the system for it. I haven't spent much time with the code, but couldn't the unique_id be used instead of the existing ID. We are setting up failover to a "hot backup" for now, but am really interested in the multi-master loadbalancing... Thanks, Kevin
