<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Hi Fahad,<br>
<br>
I'm going to have to be general because you've provided very
little information, but I've used pgpool load balancing in AWS so
I'm sure it works there.<br>
<br>
Load balancing is connection based, not query based. If you only
have, say, one client then all the connections will go to one
node, especially if your client does its own connection pooling.<br>
<br>
Make sure you have "load_balance_mode = on" to make sure load
balancing is enabled. You can try changing the weights of the
read-only slaves to push more read queries to them --higher
numbers get more queries.<br>
<br>
Make sure pgpool thinks all the backends are healthy. It won't
send queries to nodes that are not passing the health check or
that have fallen behind in replication. Check the pgpool logs or
pcp_pool_status to find out (status "2" means "healthy").<br>
<br>
Hope that helps.<br>
<br>
<br>
alex<br>
<br>
<br>
On 6/3/15 00:21, Fahad Basheer wrote:<br>
</div>
<blockquote
cite="mid:CAHCKhC1ZcK+nZdsh=i+m=vsewNkVXQz=CDBXu6cd+e6xZkn+8A@mail.gmail.com"
type="cite">
<div dir="ltr">
<div style="font-size:13px">Hi,</div>
<div style="font-size:13px"><br>
</div>
<div style="font-size:13px"><br>
</div>
<div style="font-size:13px">I am trying to load balance read
queries using pgpool in aws, </div>
<div style="font-size:13px">My database setup is like one
postgres master rds and two read replicas of the master</div>
<div style="font-size:13px">But not able to load balance the
read queries. All the queries are going to node 0( host 0).</div>
<div style="font-size:13px"><br>
</div>
<div style="font-size:13px">Postgresql Version - 9.4</div>
<div style="font-size:13px">Pgpool Version - 3.1</div>
<div style="font-size:13px"><br>
</div>
<div style="font-size:13px"><br>
</div>
<div style="font-size:13px">Thanks in Advance</div>
<div style="font-size:13px"><br>
</div>
<div style="font-size:13px"><br>
</div>
<div style="font-size:13px">Regards,</div>
<div style="font-size:13px">Fahad</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
pgpool-general mailing list
<a class="moz-txt-link-abbreviated" href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a>
<a class="moz-txt-link-freetext" href="http://www.pgpool.net/mailman/listinfo/pgpool-general">http://www.pgpool.net/mailman/listinfo/pgpool-general</a>
</pre>
</blockquote>
<br>
</body>
</html>