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. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ Dbmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
