Thanks Ming, Does MySQL support RAW device? I can use Oracle RAC 10g as my DBmail backend either, would you recommend it or not?
Regards Fatemeh Taj ----- Original Message ---- From: Ming-Wei Shih <[EMAIL PROTECTED]> To: DBMail mailinglist <[email protected]> Sent: Monday, October 9, 2006 7:28:07 PM Subject: Re: [Dbmail] DBmail in large scale. Please HELP! My experience tells me that the resource is not going to the POP3 clients but it goes to the MTA, antivirus, antispam. The biggest setup I had was 15K users with postfix + rav + dbmail all on E220 (2x450 US, 1,5 GB ram and 10K disks), and it would be on it's knees during spam/dictionary attack, but otherwise it does not have too much load. I would personally off-load MTA, antivirus and antispam to something like Ironport and use very speedy disks setup (i.e no raid5). Use raw device for your DB if you can and put your data and index on different spindles (maybe put some tables on different spindles too). Paul, with one master and many slaves option, is there a way to separate writes and reads in dbmail? E.g. all writes to the master and all reads from the slaves (with RR DNS and HB)? just my 2 cents Ming-Wei Fatemeh Taj wrote: > Here again I appriciate any idea about dbmail hardware estimation. > Regards > Fatemeh Taj > > ----- Forwarded Message ---- > From: Fatemeh Taj <[EMAIL PROTECTED]> > To: DBMail mailinglist <[email protected]> > Sent: Saturday, October 7, 2006 3:58:38 PM > Subject: Re: [Dbmail] DBmail in large scale > > > Thanks for your idea. If I use master-slave, how would be the scalibility ? > They run a hosting service and will have more and more email > subscribers[maybe 1 million at the end of second year] .Also I don't want to > have service interruption for a part of users if a server fails. I will have > quad 64 bit servers in backend. I assume that 50 % of users are active users > and 12% concurrency for them. Does it makes sense for a hosting service > provider? If yes, how can I estimate the hardware? > > Thanks in advanced > Fatemeh Taj > > > ----- Original Message ---- > From: Paul J Stevens <[EMAIL PROTECTED]> > To: DBMail mailinglist <[email protected]> > Sent: Thursday, October 5, 2006 7:35:55 PM > Subject: Re: [Dbmail] DBmail in large scale > > > Fatemeh Taj wrote: > >> Dear All >> > > >> I would like to know if dbmail could be used for large scale email >> environment. I know it is scalable as it uses mysql cluster. I am >> going to install it on redhat linux AS4. As I know mysql cluster >> loads the database engine in memory, now with 100,000 users which >> will have a maximum size of mailbox store , how mysql cluster can >> handle the load? What do you suggest for such scale? >> > > Why are you using nbd-cluster instead of a simple master-slave setup? > > Use a master-slave setup on fast iron hardware. With 100.000 users the > main metric is the query load generated by the active users, and the > total size of the email store. > > > >> My second >> question is that if it is possible to use Oracle as the backend >> database. >> > > Someone did a oracle driver for dbmail-1, but that tree hasn't been > updated since 2.0.0 afaik. > > Writing a new driver (or updating the existing one) is not that much > work. I'd be happy to do so ($$$), as would Aaron I guess. > > > _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
