[Mailman-Users] Storing list information in a SQL database
I run a rather interesting mailman setup with a very large number of lists that have a lot of traffic. This has lead to a couple issues mostly tied to storing all the data in pickle files. If I could replace the pickle interface with something that stores to a SQL database I could load balance the service, and stick the web interface and cron jobs a box dedicated to that purpose. My question is: does anyone know of a plugin replacement to cpickle that will store data in a database (not as a blob), and has anyone created any sort of schema for storing list data in a database? I figured I would ask before recreating the wheel. thanks, -- --Matt -- Mailman-Users mailing list Mailman-Users@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/ Unsubscribe: http://mail.python.org/mailman/options/mailman-users/archive%40jab.org Security Policy: http://www.python.org/cgi-bin/faqw-mm.py?req=showamp;file=faq01.027.htp
Re: [Mailman-Users] Storing list information in a SQL database
On 6/30/06, Mark Sapiro [EMAIL PROTECTED] wrote: Matt Doughty wrote I run a rather interesting mailman setup with a very large number of lists that have a lot of traffic. This has lead to a couple issues mostly tied to storing all the data in pickle files. If I could replace the pickle interface with something that stores to a SQL database I could load balance the service, and stick the web interface and cron jobs a box dedicated to that purpose. My question is: does anyone know of a plugin replacement to cpickle that will store data in a database (not as a blob), and has anyone created any sort of schema for storing list data in a database? I figured I would ask before recreating the wheel. I don't know of any plugin replacement for cpickle or any current effort to store the entire list config in an SQL database (it's on the 'futures' list), but there are member adaptors for Mailman that will store the membership portion in the config in a mySQL database. It doesn't seem like that's what you're looking for, but see http://mail.python.org/pipermail/mailman-users/2006-June/051846.html. -- Mark Sapiro [EMAIL PROTECTED] The highway is for gamblers, San Francisco Bay Area, Californiabetter use your sense - B. Dylan I was aware of the membership adaptor. I guess I can create an interface that does more or less what I want. Thanks for the info. -- --Matt -- Mailman-Users mailing list Mailman-Users@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/ Unsubscribe: http://mail.python.org/mailman/options/mailman-users/archive%40jab.org Security Policy: http://www.python.org/cgi-bin/faqw-mm.py?req=showamp;file=faq01.027.htp
[Mailman-Users] question about web archives for a very large number of lists.
I am currently maintaining a mailman install that has 5000+ lists, many high volume. The archive volume is nearly 80GB in size between the archives and mboxes for the various lists. Even after doing acrobatics to only archive the lists that have changed within the last 24hours it is extremely time consuming to rebuild the archives from the cumulative mbox files. I am considering rotating the mbox daily, and only processing the the mbox for that day. This would mean using the arch without --wipe. My question is, what pitfalls do I need to lookout for with this approach? thanks, -- --Matt -- Mailman-Users mailing list Mailman-Users@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/ Unsubscribe: http://mail.python.org/mailman/options/mailman-users/archive%40jab.org Security Policy: http://www.python.org/cgi-bin/faqw-mm.py?req=showamp;file=faq01.027.htp
[Mailman-Users] subscribe silently fails to moderated list
I have a list where subscription fails if you use the email subscription interface. The list is moderated, but nothing shows up in the logs after the initial inject in the sendmail logs. There is nothing in vette or subscribe, the request just disappears into the ether. -- --Matt -- Mailman-Users mailing list Mailman-Users@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/ Unsubscribe: http://mail.python.org/mailman/options/mailman-users/archive%40jab.org Security Policy: http://www.python.org/cgi-bin/faqw-mm.py?req=showamp;file=faq01.027.htp
