Kevin Baker wrote:
I was hoping to peak some new interest in using GUID's in
place of the incrementing unique_id's in the current code
base.
This would be the key to non-colliding id's for a
loadbalanced/failover system on a master-master mysql.
Since GUIDs can be generated by the application before
inserting new records to the database (as opposed to
reading back an autogenerated nmber after insert), more
than one DBMail servers could use a single RDBMS backend.
This, when viewed in the light of RDBMS clusters would make
a formidable (/w loadbalance + failover) system.
