[pgpool-general: 5109] Re: About SELECT load balancing in master/slave mode

[Tatsuo Ishii]

I'm too lazy to read HTML emails. So I answer to this message.

> There plenty of write conditions that will require a read first.
> 
> On Nov 6, 2016 4:13 AM, <erdenebat at skysys.mn> wrote:
> 
>> I'm testing pgpool-II 3.5.4. While load balancing is turned off, pgpool-II
>> gives a following error:
>>
>>
>> LOG: pool_read_kind: error message from 1 th kind backend:database "mydb"
>> does not exist
>>
>> ERROR: unable to read message kind
>>
>> DETAIL: kind does not match between master(53) slot[1] (45)

45 = ASCII 'E', which means node 1 returns an error. Probably "mydb"
does not exist on node 1 (yet).

>> backend1 is standby server. I don't understand why pgpool-II tries to read
>> from standby while load balancing is off.

That's an expected behavior. Pgpool-II tries to connects to all
healthy db nodes even load balancing is off.

>> Regards,
>> Erdenebat
>>
>>
>> 06.11.2016, 19:31, "erdenebat at skysys.mn" <erdenebat at skysys.mn>:
>>
>> I turned off load balancing. But it seems that load balancing is still
>> working.
>> On the standby, it gives an error 'database does not exist'.
>> I understand that pgpool-II does not access standby while load balancing
>> is off.
>>
>>
>> 02.11.2016, 17:57, "erdenebat at skysys.mn" <erdenebat at skysys.mn>:
>>
>> Hello guys,
>>
>> In pgpool-II FAQ
>> <http://www.pgpool.net/mediawiki/index.php/FAQ#It_seems_my_pgpool-II_does_not_do_load_balancing._Why.3F>,
>> it states that "SELECT will be load balanced even in a transaction if
>> operated in the master/slave mode".
>> Is there any way to do it in reverse? Is there any configuration not to
>> load balance SELECT statement if a transaction is in the master/slave mode?
>>
>> Thanks in advance,
>> Erdenebat Oyungerel
>>
>> ,
>>
>> _______________________________________________
>> pgpool-general mailing list
>> pgpool-general at pgpool.net
>> http://www.pgpool.net/mailman/listinfo/pgpool-general
>>
>>
>> _______________________________________________
>> pgpool-general mailing list
>> pgpool-general at pgpool.net
>> http://www.pgpool.net/mailman/listinfo/pgpool-general
>>
>>