[ale] PostgreSQL question

[Preston]

Thanks for this.  I'm going to take a look Slony-l.

Preston

On 3/25/2014 4:37 PM, Scott Plante wrote:
>
> 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
>
> ------------------------------------------------------------------------
> *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
>
>
>
> _______________________________________________
> 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


-- 
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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ale.org/pipermail/ale/attachments/20140326/4c6744db/attachment.html>