> - you need a clusterable database (For 2.0 you should be able > to write a oracle driver in about 4 hours). > (real clustered databases partition automatically).
Heard scary things about Oracle from an admin point-of-view, but expect unfortuantely I'll need to look at that in the future. Figured it would be relatively trivial to do (write driver).. Keep hoping MySQL will have two-way replication soon with write locks and then it's all solved :o) Just done a bit more about database partitioning (oracle, db2) and looks quite good. Does anyone know of an easy-to-manage (like MySQL) and cheap database that does two-way replication and partioning? > - you'll need the LMTP daemon, not dbmail-smtp (increase in speed and handling is about 1000%). I've just checked 1.x cvs and 2.0 cvs and can't find anything (except in the TODO list) about LMTP. Can you advise when this is planned for? > - Dbmail 2.0 will have a lot of imap optimalization which > will increase performance a lot. My main stress for scalability is the database load -- I don't care how many front-end servers I have, so if the front-end servers have to grind away that's fine. > - use a native webmail like webDBmail. Yep, we've written one already which works nicely -- I think that's what's helping us scale at the moment - as we don't have heaps of imap webmail clients hammering away at the database. I'd love to use one-way replication with MySQL and point the webmail at that, but I got told about the issues with writes being delayed, etc so gave up on that -- but otherwise it would be perfect. > We currently have a db2 licence laying around. We might write > a driver for that and test for speed. Anyone know what the cost is for DB2 (real cost) for a 2-4 server system? Ideally 2 partitioned main servers which are replicated for backup to second two servers? > You could also hire us to tune a monsterous dbmail system for you. > We're already doing some very big dbmail setups. ;) > I once started dbmail with the thought of a multi-million > based e-mail system with super ease of use and maintenance. That would actually be great, as I've been thinking that my current setup is not tuned very well. Been looking around for a local (New Zealand) MySQL expert, that would come in a cheaper than the MySQL.com's $3,500+ offering :( Get in touch and let me know your rates, estimated cost, etc. /Mark
