[pgpool-general: 7902] Re: PGPool Load Balancing [EXTERNAL] [SEC=UNOFFICIAL]
Tatsuo Ishii
ishii at sraoss.co.jp
Fri Nov 26 17:14:38 JST 2021
Glad to hear that. Thanks for the feedback.
Best reagards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
> UNOFFICIAL
> Hi Luca and Tatsuo,
>
> Thank you both for your replies. pcp_attach_node resolved the issue. I wasn't aware the node state was recorded in the status file - the first time I started the 4.2 configuration I had a mistake in the config file in that the standby server details were commented. I thought uncommenting would be enough - lesson learnt!.
>
> Regards
>
> Mark
>
>
> UNOFFICIAL
>
> -----Original Message-----
> From: Tatsuo Ishii <ishii at sraoss.co.jp>
> Sent: Thursday, 25 November 2021 4:34 PM
> To: Mark Schloss <Mark.Schloss at austrac.gov.au>
> Cc: pgpool-general at pgpool.net
> Subject: Re: [pgpool-general: 7892] PGPool Load Balancing [SEC=UNOFFICIAL] [EXTERNAL]
>
>> UNOFFICIAL
>>
>> Hi,
>>
>> I am preparing for an upgrade from 4.1.4 to 4.2.5 and have installed
>> the new version in our test environment. After making the necessary
>> configuration changes required for the upgrade I am finding the load
>> balancing does not seem to be working - the standby database is not
>> shown as the load balance node and queries are all serviced by the
>> primary. Our setup is one primary database and one standby with
>> streaming replication. I have set the following -
>>
>> load_balance_mode = on
>> disable_load_balance_on_write = 'transaction'
>>
>> The output of show pool_nodes is
>>
>> node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change
>> ---------+----------+------+--------+-----------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------
>> 0 | xxxx | 5432 | up | 0.500000 | primary | 18 | true | 0 | | | 2021-11-24 15:33:12
>> 1 | xxxxxxx | 5432 | unused | 0.500000 | standby | 0 | false | 0 | | | 2021-11-24 15:33:12
>> (2 rows)
>
> Looks like the initial pgpool_status for node 1 is down or unused, and pgpool was started without -D option. You can try pcp_attach_node command to let pgpool recognize node 1 is working.
>
> Best reagards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
>
> **********************************************************************
> Please note that your email address is known to AUSTRAC for the
> purposes of communicating with you. The information transmitted in
> this e-mail is for the use of the intended recipient only and may
> contain confidential and/or legally privileged material. If you have
> received this information in error you must not disseminate, copy or
> take any action on it and we request that you delete all copies of
> this transmission together with attachments and notify the sender.
>
> This footnote also confirms that this email message has been swept for
> the presence of computer viruses.
> **********************************************************************
More information about the pgpool-general
mailing list