[ale] PostgreSQL question

[Scott Plante]

We use Slony for replication, and route all writes to the master. We are able to tell a given box in our application to stop taking new connections but continue processing existing ones. New connections are then routed to other boxes. Once all existing connections have finished, we can do maintenance/upgrades on that box, bring it back up, and continue the process with another box. 


This particular application is architected such that updates on each box are written to a queue, which is processed on the master and written to the database. 


Scott 

----- Original Message -----

From: "Preston" <preston.lists at gmail.com> 
To: "Atlanta Linux Enthusiasts" <ale at ale.org> 
Sent: Monday, March 24, 2014 4:42:39 PM 
Subject: [ale] PostgreSQL question 

Hey folks, what are you doing for some kind of load balancing with PostgreSQL ? How do you handle live migration with PostgreSQL? 

thoughts? pointers? 

Preston 
-- 
Be who you are and say what you feel, because those who mind don’t matter and those who matter don’t mind.
-Dr. Seuss 
_______________________________________________ 
Ale mailing list 
Ale at ale.org 
http://mail.ale.org/mailman/listinfo/ale 
See JOBS, ANNOUNCE and SCHOOLS lists at 
http://mail.ale.org/mailman/listinfo 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ale.org/pipermail/ale/attachments/20140325/5f9ee448/attachment.html>