Quote:
|
Originally Posted by Cameron Gray
Learn how routers and transports work and what they are for. The advantage from my point of view is that I bridgehead the POP/IMAP connections which a MySQL mailstore so apart from multiple people accessing the same row (header, content or attachment) it scales rather well.
Also included some rudimentary attachment minimisation on storage, i.e. if the attachments MD5 matches one already stored, just include a pointer rather than store the whole attachment again.
|
Interesting idea, although rather too far from KISS for my liking. When you say 'scales rather well' how many messages/second are we talking? I've set up small clusters (5 nodes) that can comfortably handle 50 messages/second (and probably more, that's as much as the spec required) using the more traditional Maildir on an NFS mount. I've not really done much in the way of writing large blobs to MySQL databases, so it'd be interesting to see how it compares.
In the event of data corruption I know I'd much rather be dealing with some missing files from a Maildir spool than missing parts of a MySQL database too..
All sounds very interesting though, if only as a technical exercise.