Re: [Dbmail] New user, questions, scalability, etc.

2004-08-31 Thread Forrest Aldrich
I'm going to guess that DBMail isn't yet ready for prime-time. It doesn't appear to have the benefit (yet) of wide-spread exposure to Enterprise-scale environments. It's an approach I had been considering, as a possible solution to the many issues I find myself facing with a "standard" confi

Re: [Dbmail] New user, questions, scalability, etc.

2004-08-31 Thread Kevin Baker
Forrest, (Long reply) I am also a new dbmail user and testing options. We are definitely moving forward with an implementation of dbmail with similar requirements. We are just now setting up our test environment. Basically my major concerns with a solution are fail over and scalability. We explor

Re: [Dbmail] New user, questions, scalability, etc.

2004-08-31 Thread Forrest Aldrich
We also want to take the Google approach, where use of commodity hardware could be a win-win situation. When you crunch the numbers, you don't need the latest-and-greatest processor -- you need ones that will do an adequate job, at the right price, from which you can scale at low cost. Simpl

Re: [Dbmail] New user, questions, scalability, etc.

2004-08-31 Thread Jacques Beaudoin
I have dbmail setup for 1800 users. Mandrake 9.2 Dbmail 1.2 (latest release) Postfix Amavis-new Fprot antivirus Horde imp webmail Mysql 4 with innodb Running on a dell 6400 dual xeon 2.0 ghz 4gig/ram and dual raid controller 4 40gig drives as raid 5 for linux 4 40gig drives as raid 5 for mysql an

Re[2]: [Dbmail] New user, questions, scalability, etc.

2004-08-31 Thread Jeff Brenton
Hello Forrest, FA> Frankly, I'm also concerned about MySQL's performance under such FA> potentially harsh conditions. That remains to be seen. MySQL isn't really the limitation - ask the people at YAHOO, who happily put more load on MySQL than dbmail for a hundred thousand workers. The new O'Reil

[Dbmail] New user, questions, scalability, etc.

2004-08-31 Thread [EMAIL PROTECTED]
I have been working on a little PERL project that takes from a list of 550,000 email addresses and generates an SQL statement foreach to create an entry into a DbMail MySQL database. This will be my new test database. Too bad numerous things arose in August and I have had to put dev resources

Re: [Dbmail] New user, questions, scalability, etc.

2004-08-31 Thread Thomas Mueller
> I have used DbMail on both pgsql and mysql with much the same results > except as the user numbers grow mysql begins to outperform pgsql in > speed. That could be me. I am not as adept with PostgreSQL. One thing is > for sure, whatever lags there may be, pgsql always holds up and all > queue

Re: [Dbmail] New user, questions, scalability, etc.

2004-08-31 Thread M. J. [Mike] O'Brien
Good point. - Original Message - From: "Thomas Mueller" <[EMAIL PROTECTED]> To: "DBMail mailinglist" Sent: Tuesday, August 31, 2004 2:45 AM Subject: Re: [Dbmail] New user, questions, scalability, etc. > > I have used DbMail on both pgsql and mysql with much the same results > > except

Re: [Dbmail] New user, questions, scalability, etc.

2004-08-31 Thread Ilja Booij
Thomas Mueller wrote: I have used DbMail on both pgsql and mysql with much the same results except as the user numbers grow mysql begins to outperform pgsql in speed. That could be me. I am not as adept with PostgreSQL. One thing is for sure, whatever lags there may be, pgsql always holds up a

[Dbmail] Re: SV: Web interface for dbmail

2004-08-31 Thread Robert Tom
> > Hello, > > Can anybody recommend a php base web interface to dbmail??? > I use http://www.squirrelmail.org its work great, but I know there are > someone who has made a webinterface that looks directly in the MySQL > database if you use that. > > // OuT > // Mikael Syska > > > Best Regard

RE: [Dbmail] New user, questions, scalability, etc.

2004-08-31 Thread Sumbry][
Thomas Mueller wrote: >> I have used DbMail on both pgsql and mysql with much the same results >> except as the user numbers grow mysql begins to outperform pgsql in >> speed. That could be me. I am not as adept with PostgreSQL. One >> thing is for sure, whatever lags there may be, pgsql always hol

[Dbmail] GUID vs Auto-incrementing...

2004-08-31 Thread Kevin Baker
I was wondering where things were on replacing auto incrementing message id's with a GUID [unique_id]. I have been reading through the archives and found a thread from a year ago that seems to touch on it. [Dbmail] MySQL Load Balancing & Failover http://tinyurl.com/3m6mf The advantage of course

Re: [Dbmail] New user, questions, scalability, etc.

2004-08-31 Thread Forrest Aldrich
It sounds like what we need to happen here is to fine-tune a DBMail configuration on a private LAN (somewhat easy to do, if you have spare hardware) and pound it with all sorts of traffic, tuning as necessary. Apart from real-world use, this is the only way we're going to break beyond the hypo

Re: [Dbmail] New user, questions, scalability, etc.

2004-08-31 Thread Thomas Mueller
> > The problem with PostgreSQL are missing transactions in dbmail. > > Because of that AutoCommit is used leading to 11 single transactions > > because of one inserted message. > > Very very true. If we implemented transactions for at least message > delivery (for begginers), we'd get a huge pe