[Django]-Advice on Python/Django and message queues

In your specific case, where it’s just an email queue, I wold take the easy way out and use django-mailer. As a nice side bonues there are other pluggable projects that are smart enough to take advantage of django-mailer when they see it in the stack.

As for more general queue solutions, I haven’t been able to try any of these yet, but here’s a list of ones that look more interesting to me:

1. pybeanstalk/beanstalkd
2. python interface to gearman (which is probably much more interesting now with the release of the C version of gearman)
3. memcacheQ
4. stomp
5. Celery

Stompserver is a good option. It’s lightweight, easy to install and easy to use from Django/python.

We have a system using stompserver in production for sending out emails and processing other jobs asynchronously.

Django saves the emails to the database, a model.post_save handler in Django sends an event to stompserver and stompserver passes the event to a consumer process which does the asynchronous task (sends the email).

It scales up quite nicely because you can add consumer processes at runtime – two consumers can send twice as many emails, and the consumers can be on seperate machines. One slight complication is that each consumer needs its own named queue so Django needs to know how many consumers are available and send events to each queue in a round-robin way. (Two consumers listening on the same queue will both get each message = duplication). If you only want one consumer process then this isn’t an issue.

We previously had processes which polled the database continuously for jobs but found that it was adding a lot of load to the system, even when nothing needed to be processed.

Just add the emails to a database, and then write another script ran by some task scheduler utility (cron comes to mind) to send the emails.

You might want to have a look at pymq. It’s written in python, talks HTTP with it’s clients and allows a host of monitoring and management options for queues.

Is there anything wrong is solving this using the mail infrastructure? Like, every app server running their own mail daemons which will queue any locally submitted mail, which forward to a centralized mail server which can do the mail heavy lifting?

If you already have MySQL installed, you could create a table to use as a “todo list” of sorts.

Threads synchronously add jobs to the table, and a batched task removes jobs as they’re completed.

That way, there’s no need to install and learn more software, and it should work fine as a persistent job store so long as you’re not sending lots of email (like >10/sec).

Here’s a lazy but correct and adequate solution. Use the following database table as a queue.

drop table if exists mailqueue;
create table mailqueue (
    id bigint primary key,
    subject text not null,
    body mediumtext not null,
    from varchar(255) not null,
    to varchar(255) not null
);

Senders should insert new rows to the end of this table.

Setup worker threads to pop mails one at a time from the other end (lowest id) and try to send them.