Обсуждение: pgpoolAdmin handling several pgpool-II clusters
Can pgpoolAdmin utility handle(administer) more than one pgpool-II custer? We have a need of setting up 3 independent postgres clusters. One cluster handling cadastral maps, one handling raster maps and one handling vector maps. Each of these clusters must have a load balancer - EG pgpool-II. Internally in each cluster we plan to (and have tested) PostgreSQL(9.03)'s own streaming replication. We have installed pgpool-II, and are now confronted with the complicated installation of pgpoolAdmin web-app. Hence we would very much like to have only one pgpoolAdmin instance to govern all 3 pgpool-II clusters. (Alternatively we will go for a more complex configuration with PostgresXC.) (Have tried to post to http://pgsqlpgpool.blogspot.com - with no success) Kindest regards Jørgen Münster-Swendsen www.kms.dk-- View this message in context: http://postgresql.1045698.n5.nabble.com/pgpoolAdmin-handling-several-pgpool-II-clusters-tp4358647p4358647.html Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
> Can pgpoolAdmin utility handle(administer) more than one pgpool-II custer? No. pgpoolAdmin only supports one pgpool-II server. > We have a need of setting up 3 independent postgres clusters. One cluster > handling cadastral maps, one handling raster maps and one handling vector > maps. Each of these clusters must have a load balancer - EG pgpool-II. > Internally in each cluster we plan to (and have tested) PostgreSQL(9.03)'s > own streaming replication. We have installed pgpool-II, and are now > confronted with the complicated installation of pgpoolAdmin web-app. Hence > we would very much like to have only one pgpoolAdmin instance to govern all > 3 pgpool-II clusters. > > (Alternatively we will go for a more complex configuration with PostgresXC.) Becase pgpoolAdmin is a web application, you could assign a tab to a pgpoolAdmin. > (Have tried to post to http://pgsqlpgpool.blogspot.com - with no success) It's my personal blog:-) Please post to pgpool-geneal mailing list. You can subscribe it from: http://lists.pgfoundry.org/mailman/listinfo/pgpool-general -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp
> Can pgpoolAdmin utility handle(administer) more than one pgpool-II custer? No. pgpoolAdmin only supports one pgpool-II server. > We have a need of setting up 3 independent postgres clusters. One cluster > handling cadastral maps, one handling raster maps and one handling vector > maps. Each of these clusters must have a load balancer - EG pgpool-II. > Internally in each cluster we plan to (and have tested) PostgreSQL(9.03)'s > own streaming replication. We have installed pgpool-II, and are now > confronted with the complicated installation of pgpoolAdmin web-app. Hence > we would very much like to have only one pgpoolAdmin instance to govern all > 3 pgpool-II clusters. > > (Alternatively we will go for a more complex configuration with PostgresXC.) Becase pgpoolAdmin is a web application, you could assign a tab to a pgpoolAdmin. > (Have tried to post to http://pgsqlpgpool.blogspot.com - with no success) It's my personal blog:-) Please post to pgpool-geneal mailing list. You can subscribe it from: http://lists.pgfoundry.org/mailman/listinfo/pgpool-general -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp
>No. pgpoolAdmin only supports one pgpool-II server. We have installed pgpoolAdmin, and it is a good and easy to use web app. So we now have to choose between 3 x pgpoolAdmin or go for PostgresXC. Jørgen Münster-Swendsen www.kms.dk -- View this message in context: http://postgresql.1045698.n5.nabble.com/pgpoolAdmin-handling-several-pgpool-II-clusters-tp4358647p4366411.html Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
On Tue, May 3, 2011 at 07:32, Jorgen <jrm@kms.dk> wrote: >>No. pgpoolAdmin only supports one pgpool-II server. > > We have installed pgpoolAdmin, and it is a good and easy to use web app. So > we now have to choose between 3 x pgpoolAdmin or go for PostgresXC. It's probably not a good idea to choose your clustering technology based on the web interfaces... Running 3 pgpooladmin doesn't seem like a huge thing. And you should note that PostgresXC is nowhere near production ready. It'll get there, but it's pretty far away. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/
>It's probably not a good idea to choose your clustering technology >based on the web interfaces... Running 3 pgpooladmin doesn't seem like >a huge thing. No - our choice will be made based on the performance of the cluster, the scalability and finally the amount of work involved in configuration, upgrading and administration. Jørgen Münster-Swendsen www.kms.dk -- View this message in context: http://postgresql.1045698.n5.nabble.com/pgpoolAdmin-handling-several-pgpool-II-clusters-tp4358647p4366664.html Sent from the PostgreSQL - performance mailing list archive at Nabble.com.