What is a way to handle database connection failure in Django 1.2?

Question

What is a way to handle database unavailability and redirect queries from unavailable slave to another one in Django 1.2?

Btw, i found out, that it was discussed: http://code.djangoproject.com/wiki/MultipleDatabaseSupport#Requirements (see "Transparently handling database failure")

UPD> I use PostgreSQL backend (probably will use pg pool or some other potgres cluster) under linux

Answer 1

If you are using a PostgreSQL backend and are on a Linux/BSD etc. system, consider using pgpool: http://www.pgpool.net/ This utility handles the connections to the DB server for you, so you only connect to pgpool. No need for you to implement any more logic. Just connect to pgpool, not to PostgreSQL itself.