Thread: Pgpool Load Balancing

More details, pgpool-II version and pgpool.conf please, PostgreSQL
version of S please.

Also you would want to move to pgpool mailing list.
(search on pgpool.net).

I'm not sure but this ML may not be appropriate for technical
discussions on pgpool-II.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> Hi,
>
>
> I am trying to load balance read queries using pgpool in aws,
> My database setup is like one postgres master rds  and two read replicas of
> the master
> But not able to load balance the read queries. All the queries are going to
>  node 0( host 0).
>
> Thanks in Advance
>
>
> Regards,
> Fahad

You need to change these:

master_slave_mode = off
master_slave_sub_mode = 'slony'

to:

master_slave_mode = on
master_slave_sub_mode = 'stream'

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> Hi,
>
> Thanks for the reply.
>
> I am using postgresql version 9.4 in aws rds and its read replicas
> pgpool-II version 3.1.
>
> and my pgpool.conf
> Please let me know if anything is wrong.
>
> Regards,
> Fahad
>
> On Wed, Jun 3, 2015 at 12:04 PM, Tatsuo Ishii <ishii@postgresql.org> wrote:
>
>> More details, pgpool-II version and pgpool.conf please, PostgreSQL
>> version of S please.
>>
>> Also you would want to move to pgpool mailing list.
>> (search on pgpool.net).
>>
>> I'm not sure but this ML may not be appropriate for technical
>> discussions on pgpool-II.
>>
>> Best regards,
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese:http://www.sraoss.co.jp
>>
>> > Hi,
>> >
>> >
>> > I am trying to load balance read queries using pgpool in aws,
>> > My database setup is like one postgres master rds  and two read replicas
>> of
>> > the master
>> > But not able to load balance the read queries. All the queries are going
>> to
>> >  node 0( host 0).
>> >
>> > Thanks in Advance
>> >
>> >
>> > Regards,
>> > Fahad
>>

Yes. By telling to pgpool-II so, pgpool-II recognizes that write
queries must go to master, and others should go to slaves.  With
master_slave_mode = on, pgpool-II does not do replication itself, but
let other software (in RDS, streaming reapplication), do the job.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> Hi,
>
> If we are using RDS with read replica, do we need to enable the above
> option.
>
>
> Regards,
> Fahad
>
> On Wed, Jun 3, 2015 at 12:34 PM, Tatsuo Ishii <ishii@postgresql.org> wrote:
>
>> You need to change these:
>>
>> master_slave_mode = off
>> master_slave_sub_mode = 'slony'
>>
>> to:
>>
>> master_slave_mode = on
>> master_slave_sub_mode = 'stream'
>>
>> Best regards,
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese:http://www.sraoss.co.jp
>>
>> > Hi,
>> >
>> > Thanks for the reply.
>> >
>> > I am using postgresql version 9.4 in aws rds and its read replicas
>> > pgpool-II version 3.1.
>> >
>> > and my pgpool.conf
>> > Please let me know if anything is wrong.
>> >
>> > Regards,
>> > Fahad
>> >
>> > On Wed, Jun 3, 2015 at 12:04 PM, Tatsuo Ishii <ishii@postgresql.org>
>> wrote:
>> >
>> >> More details, pgpool-II version and pgpool.conf please, PostgreSQL
>> >> version of S please.
>> >>
>> >> Also you would want to move to pgpool mailing list.
>> >> (search on pgpool.net).
>> >>
>> >> I'm not sure but this ML may not be appropriate for technical
>> >> discussions on pgpool-II.
>> >>
>> >> Best regards,
>> >> --
>> >> Tatsuo Ishii
>> >> SRA OSS, Inc. Japan
>> >> English: http://www.sraoss.co.jp/index_en.php
>> >> Japanese:http://www.sraoss.co.jp
>> >>
>> >> > Hi,
>> >> >
>> >> >
>> >> > I am trying to load balance read queries using pgpool in aws,
>> >> > My database setup is like one postgres master rds  and two read
>> replicas
>> >> of
>> >> > the master
>> >> > But not able to load balance the read queries. All the queries are
>> going
>> >> to
>> >> >  node 0( host 0).
>> >> >
>> >> > Thanks in Advance
>> >> >
>> >> >
>> >> > Regards,
>> >> > Fahad
>> >>
>>