Re: Pgpool Load Balancing

Поиск
Список
Период
Сортировка
От fahad basheer
Тема Re: Pgpool Load Balancing
Дата
Msg-id CAKk-ntz-7t-Z0BQO7twQwfMfk7eAOutj_26FpVz5dA5cvQJ1EQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Pgpool Load Balancing  (Tatsuo Ishii <ishii@postgresql.org>)
Ответы Re: Pgpool Load Balancing  (Tatsuo Ishii <ishii@postgresql.org>)
Список pgsql-cluster-hackers
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
>>

В списке pgsql-cluster-hackers по дате отправления:

Предыдущее
От: Tatsuo Ishii
Дата:
Сообщение: Re: Pgpool Load Balancing
Следующее
От: Tatsuo Ishii
Дата:
Сообщение: Re: Pgpool Load Balancing