Very True... We discussed the GUID's being generated based on sync'ed datetime stamp with a unique ID per server. (NTP required)
My primary interest now is to create simple 2 machine clusters for each user segment. Each of the machines in the cluster would use guid's for unique_id values. Each cluster synced through master-master. DNS Round Robin for load "balance". Heartbeat for failover. This would give loadbalance and failover on commodity hardware. With guid unique_id's there would be no id collision so it should failover and sync well. Kevin > 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. > > _______________________________________________ > Dbmail-dev mailing list > Dbmail-dev@dbmail.org > http://twister.fastxs.net/mailman/listinfo/dbmail-dev >
