[Mailman-Users] Does mailman support a MySQL backend?

[Angel Gabriel]

Version 2.1? Okay, what I'm going to do is have a look around the net for
more info on this. Having a MySQL backend should ease a few performance
issues. Also I got a mail from someone saying that sending out about 100k
mails with a few bad ones would bring my server to it's knees... hmm... that
is SO not good! But it has one function, yep you guessed it, it's my mail
server, and that's all it does. It runs a samba client, but that's just so
that my windows boxes can see it. What would be a better MTA to use? Any
recommendations?

-----Original Message-----
From: Harold Paulson [mailto:haroldp at sierraweb.com]
Sent: Friday, September 20, 2002 12:20 AM
To: mailman-users-admin at python.org
Cc: Angel Gabriel
Subject: RE: [Mailman-Users] Does mailman support a MySQL backend?


Angel,

For what it's worth...

Mailman 2.1 is supposed to be able to use alternative backends (such
as MySQL) to store user information.  However, I haven't actually
seen this working yet.

Personally, I have given up on using Mailman for large broadcast-only
lists.  Mailman seems to do a lot of things based on the assumption
that it's being used for an interactive list.  Configuring it for
broadcasting tends to be a lot of work.  I use a custom-built
Perl+PHP+MySQL thingy I wrote, for large broadcast lists these days.

On a side note, if you are planning to send to a list of 100k+
addresses with a large number of bad ones, you had better be using
something other than Sendmail.  It *will* bring your machine to it's
knees spawning a limitless number of queue running processes[1].

Good luck!  :)

	- H

Note:
[1] If someone would like to contradict me on this point, I'd love to
hear your argument, and see what config you suggest.  Seriously, I
really would like to see a solution.  Please include more than
MAX_DAEMON_CHILDREN, QUEUE_LA, or REFUSE_LA in your answer, since
they do not seem affect queue runs.



>I'm using RH 7.3 and I have a DSL line @ 256k upload - I havn't even
>attempted to send messages to list anymore, because I can't even get the
web
>interface to come up, it times out. I adjusted the cf files manually to
show
>3000 addresses per page, and STILL the pages time out. I'm thinking of
using
>a diffrent application to send out my email. I know a lot of the addresses
>are going to bounce, and that is REALLY going to mess up performance, it's
>such a shame, we've spent FOUR years collecting these addreses, from 16
>diffrenct universities up and down England. The thing that worries me, is
>the bouncing mail, I don't mind if my server takes three days to send all
>the mail, it's a one way list, I just want to increase performance when it
>comes to admin tasks.
>
>-----Original Message-----
>From: mailman-users-admin at python.org
>[mailto:mailman-users-admin at python.org]On Behalf Of Dan Wilder
>Sent: Thursday, September 19, 2002 6:17 PM
>To: Mailman (E-mail)
>Subject: Re: [Mailman-Users] Does mailman support a MySQL backend?
>
>
>On Thu, Sep 19, 2002 at 05:35:19PM +0100, Angel Gabriel wrote:
>>  I was wondering if mailman supports a MySQL backend, because one of my
>lists
>>  has hit over 100k addresses, and performance is REALLY bad. If mailman
>>  doesn't support a MySQL backend, does anyone know of any mailing list
>>  managers that do?? Any help would be appreciated. Thanks in adance.
>
>Do you know whether it's mailman, or your MUA that's the sticky
>wicket?
>
>We have one list with 20,000 subscribers.  It used to take several
>days to get everybody out.  Inspection revealed it was the MTA,
>Postfix, which needed load tuning, and also the Linux kernel,
>which needed some kernel parameters bumped up to allow Postfix
>the elbow room to run 150 concurrent delivery processes.
>
>Now it takes about three hours for most of the good addresses
>on the list to get delivered.  The sticky wicket is the internet
>connection, which also supports telecommuters, so we've had
>to tune the mailserver to stop short of saturating the connection.
>
>--
>-----------------------------------------------------------------
>  Dan Wilder <dan at ssc.com>   Technical Manager
>  SSC, Inc. P.O. Box 55549   Phone:  206-782-8808
>  Seattle, WA  98155-0549    URL http://www.linuxjournal.com/
>-----------------------------------------------------------------
>
>------------------------------------------------------
>Mailman-Users mailing list
>Mailman-Users at python.org
>http://mail.python.org/mailman/listinfo/mailman-users
>Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py
>Searchable Archives:
http://www.mail-archive.com/mailman-users%40python.org/


--

Harold Paulson                  Sierra Web Design
haroldp at sierraweb.com           http://www.sierraweb.com
VOICE: 775.833.9500             FAX:ÊÊ 775-201-4458