martin sperl wrote:
Hi!
We just came accross DBMAIL because we require for a new application of
ours an IMAP server that scales well.
We were already thinking along simmilar lines regarding an IMAP frontend
to mysql, but as our requirements are outside the "25000" account range
given in the readme I am not sure, if the solution would scale to our
requirements!
So I am asking for input for if a setup like this would be feasable:
* Users: 200000
* Messages/User: 80
* Avereage Message size: 100k
* 1 new Mail/second
So that would sum up to 1.6TB of storage of storage-requirements.
Currently we are planing for 3x overcommit, so this would reduce to
0.5TB of actual storage.
That is why I am a little bit sceptic if the "one" table
storage-solution that dbmail provides (dbmail_messageblks) would scale
that well.
Another thing that I am a little bit scared, is that 0.5TB in one table
might become a bottleneck in the end...
The other thing ist that for performance reasons we definitely would
like to split the data over several disks...
Any ideas, if such a setup is feasable with dbmail and if it would scale?
Input would be greately appreciated...
Cheers,
Martin
We use dbmail to mysql on software raid-5. We receive 100+ messages per
minute, but our user/storage patterns are almost inverse of yours: 100
users with 30 to 40 MB modal storage per user, some users in the GB
range. We are using one dual AMD-64 box, which barely blips up to .20
load average when busy.
--
Dominic Amann, Linux Based Solutions Ltd., <http://www.lbs.ca/>
18 Candlewood Cr, Toronto, ON M3J 1G8
Tel: (416) 678-2297