Storing list information in a SQL database
![](https://secure.gravatar.com/avatar/ab6d0485042a44803b00ffdf878ae5b6.jpg?s=120&d=mm&r=g)
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
![](https://secure.gravatar.com/avatar/746f7519ba02fb0d815e59f305c53fa2.jpg?s=120&d=mm&r=g)
Matt Doughty wrote
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 <msapiro@value.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan
![](https://secure.gravatar.com/avatar/746f7519ba02fb0d815e59f305c53fa2.jpg?s=120&d=mm&r=g)
Matt Doughty wrote
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 <msapiro@value.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan
participants (2)
-
Mark Sapiro
-
Matt Doughty