Thursday, August 25, 2011

using postgresql 9 replication but want to balance to servers online only

Hi,

I've got a master and slave database setup working using Postgresql 9
Replication. I followed this guide quite strongly
http://brandonkonkle.com/blog/2010/oct/20/postgres-9-streaming-replication-and-django-balanc/

When the master is updated then the slave replicates the changes. The
requests are being balanced randomly using django-balancer.

The problem I'm having now is that I want to check if the database
server is online before it's eligible to be used. If I take down my
master the requests should still be pushed to the slave machine always
until the master is back online, even if it's only in read-only.

Any ideas or suggestions greatly appreciated.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.

No comments:

Post a Comment