[pgpool-general: 644] Re: Replication/Load balancing not working as expected

Mon Jun 18 09:37:35 JST 2012

Set this properties in your pgpool configuration file, and run pgpool in debug mode (-d option)

log_destination = 'stderr'
print_timestamp = on
log_connections = on
log_hostname = on
log_statement = on
log_per_node_statement = on

With this properties you can see the queries sent to each node, and what is realy happen.

Opss!!!

I think you are connecting to the database directly, because you are using only these parameters "psql -h node2"

Are you connecting to postgresql through pgpool like this:

psql -U database_user -h ip_pgpool_host -p pgpool_port -d database_name ?

The efects of the load balancing funtion take place when there are many users connecting to pgpool concurrently.

I recomend you reading the pgpool FAQ page, in it there is a topic related with your load balancing question.

Regards.
________________________________________
From: pgpool-general-bounces at pgpool.net [pgpool-general-bounces at pgpool.net] On Behalf Of Theodotos Andreou [theo at ubuntucy.org]
Sent: Sunday, June 17, 2012 3:19 AM
To: pgpool-general at pgpool.net
Subject: [pgpool-general: 643] Replication/Load balancing not working as        expected

Hi all,

I am a newbie to pgpool-II. I want to use replication/load-balancing and
I use the latest pgpoll-II (3.1.3) compiled from source. I have two
postgresql nodes (node1, node2) and a loadbalancer (loadb) all on the
same subnet.

I can connect from the load balancer to the backends using the command
"psql -h node1" and "psql -h node2". So no network issues here:

I am using this config:

http://pastebin.com/EnVKgLD4

But when I use the "createdb testing" command on load balancer the
database is created on node1 only. Is this normal with this setup?
Replication does not imply that all write commands are propagated to
both backends?

Load balancing also appers to work correctly because when using twice
the "psql" command on load balancer it first opens a session with node1
and then again on node1. On all my tests I get no postgres traffic to my
second node.

Is this expected? Is my config wrong or the way I test? Ideas?

Regards
Theo
_______________________________________________
pgpool-general mailing list
pgpool-general at pgpool.net
http://www.pgpool.net/mailman/listinfo/pgpool-general

Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!
http://www.antiterroristas.cu
http://justiciaparaloscinco.wordpress.com