I have recently installed DBMail and am interested in converting my machines to it.
Most of my other applications are based on a multi-master MySQL replication setup for redundancy. As I know has been discussed here before, the use of auto_increment poses a real problem for this, with key conflicts between masters. I have done a quick change to db.c to use appliation-generated primary keys based on the timestamp, a config-file based server id, the process id, and a serial number. The arrangement works out that key values are steadily increasing, but not directly sequential. Keys are values in the neighborhood of 2^62. I have found some bugs in other code where assumptions have been made that primary keys are relatively small numbers and are closely spaced, if not sequential. I have started working on fixing what I have found but thought it might be a good time to touch base with the developers and see if there is other work underway on this and whether my approach is agreed with or if there are better ideas. Also, are there other, bigger issues that I haven't thought of, either with replication in general or with the key scheme. Thanks, David ____________________________________________________________________________ This message is spam and virus free. Filtering solutions by http://omd3.com Expert computer system support and development by http://baysidenetworks.com
