<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Thanks for this. I'm going to take a
look Slony-l.<br>
<br>
Preston<br>
<br>
On 3/25/2014 4:37 PM, Scott Plante wrote:<br>
</div>
<blockquote
cite="mid:822660201.2598.1395783465032.JavaMail.root@insightsys.com"
type="cite">
<style type="text/css">p { margin: 0; }</style>
<div style="font-family: arial,helvetica,sans-serif; font-size:
12pt; color: #000000"><br>
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.
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>Scott</div>
<div><br>
<hr id="zwchr">
<div
style="color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;"><b>From:
</b>"Preston" <a class="moz-txt-link-rfc2396E" href="mailto:preston.lists@gmail.com"><preston.lists@gmail.com></a><br>
<b>To: </b>"Atlanta Linux Enthusiasts" <a class="moz-txt-link-rfc2396E" href="mailto:ale@ale.org"><ale@ale.org></a><br>
<b>Sent: </b>Monday, March 24, 2014 4:42:39 PM<br>
<b>Subject: </b>[ale] PostgreSQL question<br>
<br>
<font face="DejaVu Sans">Hey folks, what are you doing for
some kind of load balancing with PostgreSQL</font>? How
do you handle live migration with PostgreSQL?<br>
<br>
thoughts? pointers?<br>
<br>
Preston<br>
<pre class="moz-signature">--
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
</pre>
<br>
_______________________________________________<br>
Ale mailing list<br>
<a class="moz-txt-link-abbreviated" href="mailto:Ale@ale.org">Ale@ale.org</a><br>
<a class="moz-txt-link-freetext" href="http://mail.ale.org/mailman/listinfo/ale">http://mail.ale.org/mailman/listinfo/ale</a><br>
See JOBS, ANNOUNCE and SCHOOLS lists at<br>
<a class="moz-txt-link-freetext" href="http://mail.ale.org/mailman/listinfo">http://mail.ale.org/mailman/listinfo</a><br>
</div>
<br>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Ale mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Ale@ale.org">Ale@ale.org</a>
<a class="moz-txt-link-freetext" href="http://mail.ale.org/mailman/listinfo/ale">http://mail.ale.org/mailman/listinfo/ale</a>
See JOBS, ANNOUNCE and SCHOOLS lists at
<a class="moz-txt-link-freetext" href="http://mail.ale.org/mailman/listinfo">http://mail.ale.org/mailman/listinfo</a>
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
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
</pre>
</body>
</html>