tabris wrote: > On 05/19/2010 10:19 AM, N Sj wrote: >> I've asked the DBA to review to see if this would be feasible and I've >> received the following response, he is speaking based on mysql he is not >> familiar with dbmail architecture, so I'm asking whether this is true. >> >> "multi-master would be very difficult to be supported on mail servers as >> MySQL is running on Innodb engine and it would have problem with foreign key >> constraints as it supports row level locking so there might be conflicts of >> the primary key" >> >> > > It only works b/c it's InnoDB. If done with MyISAM it'd be hell on > wheels. And yes, it _really_ does work, if done as I described earlier.
Well, I think mentioned DBA might be talking about mysql-nbd not being supported because of the use of foreign key-constraints. Of course it *is* possible to enforce transactional consistency at the application level. That is pretty much what dbmail upto including 2.0 where about, since myisam was the original platform. Being able to rely on key-constraints made several important things _very_ much easier to achieve. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
