Hi, From: Ow Mun Heng <[EMAIL PROTECTED]> Subject: [Pgpool-general] Master/Slave Load Balancing Configuration Date: Thu, 03 Jan 2008 11:40:54 +0800
> Setup : > Slony 1 master, 1 slave - pg8.2.5, slony 1.12 > pgpool - 2.01 > OS : centos 4 > Goal : SLony for replication > Pgpool for load balancing across multiple slaves+1master ... > listen_addresses = '*' > port = 9999 > replication_mode = true If you use Slony-I, you need to set replication_mode to false. > load_balance_mode = true > master_slave_mode = true > ignore_leading_white_space = true > backend_host_name = 'pgmaster' > backend_port = 5432 > weight_master = 0.2 > secondary_backend_host_name = 'pgslave1' > secondary_backend_port = 5432 > weight_secondary = 0.8 secondary_backend_host_name and secondary_backend_port is for pgpool. Can you set the following setting? replication_mode = false master_slave_mode = true load_balance_mode = true backend_hostname0 = 'pgmaster' backend_port0 = 5432 backend_weight0 = 0.2 backend_hostname1 = 'pgslave1' backend_port1 = 5432 backend_weight1 = 0.8 Regards, -- Yoshiyuki Asaba [EMAIL PROTECTED] > > > > If I were to use replication_mode = false (as in the docs) then all the > select queries will only hit the master DB and there's no note on the > debug logs saying "load balance on 1", "load balance on 0" or something > like that. > > I've tried to use > > backend_hostname0 > backend_hostname1 > backend_port0 > backend_port1 > etc also to no avail. > > I don't have pcp_* command as it's not included in the rpms > > I've googled and search through a _lot_ of archives and lists but found > no clue as to what is happening. > > Would really appreciate some help help.. > > > As of right now, the working config will give me 1 master + 1 slave in > load balance mode and ONLY if I put in replication_mode = true > > Thanks. > _______________________________________________ > Pgpool-general mailing list > Pgpool-general@pgfoundry.org > http://pgfoundry.org/mailman/listinfo/pgpool-general _______________________________________________ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general
