Oranges and Apples, I agree to that. I happily use dbmail as well as my qmail/vpopmail setup. Every system has it quirks and shortcommings.
> To address your two points though: > > I have found that since linux kernel 2.6 series, LVM snapshots have > caused system lockups. I used it happily in the 2.4 series. Besides > that, I did mention *impact-free*. Adding a snapshot and reading > from a > snapshot severely impacts the speed of the running system. Yes you > get a > clean backup, but the hard disk is being placed under a huge read > strain, not to mention the extra COW load for every write to the > filesystem. Yes, but after backing to the snapshot to some place one can remove it and the speed will be back to normal. So, running a db slave and using mysqldump for backups is not much different. > I believe that dbmail on MySQL requires the use of InnoDB, which I > believe (or has this recently changed?) does not support Full Text > Index. Maybe using something like Sphinx as a bolt-on would be handy > for > doing IMAP searches. I generally sync all my emails to my desktop > machine and do any searches on the local copies. Then searches don't > impact the servers :) > > On Fri, 2009-12-11 at 01:00 +0100, Daniel Urstöger wrote: >> I do not want to add to this quite "hot" situation, but there are >> two things worth mentioning: >> >>> * I'd like to see impact-free daily backups for filesystem-based >>> systems. With dbmail, just have a slave replica you can pause >>> replication on to get a perfect snapshot, with no impact on the live >>> database during the backup duration. >> >> That is actually possible, not with the same features, but one >> could use the snapshot features from LVM to achieve that. >> Create and mount that snapshot on your backup box and well, do with >> it whatever you like. >> >> The other thing I think is worth mentioning is especially about >> MySQL: the Full Text Index ( FTI ) is quite bad for searches, >> if you reach a certain amount of data, also looking through all the >> records without any index is quite slow. >> I have no comparison of flat file storage compared with database >> stored messages, but for MySQL there is soon to be a new search / >> index technology available, >> which hopefully will also get implemented in dbmail (?), called >> sphinx search. >> I have used it lately (beta version) in a project and the speed >> compared to MySQL with FTI was quite remarkable. > > > _______________________________________________ > DBmail mailing list > DBmail@dbmail.org > http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail _______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
