pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedpgpoolAdmin handling several pgpool-II clusters
6+ messages / 4 participants
[nested] [flat]
* pgpoolAdmin handling several pgpool-II clusters
@ 2011-04-29 12:46 Jorgen <jrm@kms.dk>
2011-04-30 01:27 ` Re: pgpoolAdmin handling several pgpool-II clusters Tatsuo Ishii <ishii@sraoss.co.jp>
2011-04-30 01:28 ` Re: pgpoolAdmin handling several pgpool-II clusters Tatsuo Ishii <ishii@postgresql.org>
0 siblings, 2 replies; 6+ messages in thread
From: Jorgen @ 2011-04-29 12:46 UTC (permalink / raw)
To: pgsql-performance
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-tp4358647p43...
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: pgpoolAdmin handling several pgpool-II clusters
2011-04-29 12:46 pgpoolAdmin handling several pgpool-II clusters Jorgen <jrm@kms.dk>
@ 2011-04-30 01:27 ` Tatsuo Ishii <ishii@sraoss.co.jp>
2011-05-03 05:32 ` Re: pgpoolAdmin handling several pgpool-II clusters Jorgen <jrm@kms.dk>
1 sibling, 1 reply; 6+ messages in thread
From: Tatsuo Ishii @ 2011-04-30 01:27 UTC (permalink / raw)
To: jrm@kms.dk; +Cc: pgsql-performance
> 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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: pgpoolAdmin handling several pgpool-II clusters
2011-04-29 12:46 pgpoolAdmin handling several pgpool-II clusters Jorgen <jrm@kms.dk>
2011-04-30 01:27 ` Re: pgpoolAdmin handling several pgpool-II clusters Tatsuo Ishii <ishii@sraoss.co.jp>
@ 2011-05-03 05:32 ` Jorgen <jrm@kms.dk>
2011-05-03 07:29 ` Re: pgpoolAdmin handling several pgpool-II clusters Magnus Hagander <magnus@hagander.net>
0 siblings, 1 reply; 6+ messages in thread
From: Jorgen @ 2011-05-03 05:32 UTC (permalink / raw)
To: pgsql-performance
>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-tp4358647p43...
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: pgpoolAdmin handling several pgpool-II clusters
2011-04-29 12:46 pgpoolAdmin handling several pgpool-II clusters Jorgen <jrm@kms.dk>
2011-04-30 01:27 ` Re: pgpoolAdmin handling several pgpool-II clusters Tatsuo Ishii <ishii@sraoss.co.jp>
2011-05-03 05:32 ` Re: pgpoolAdmin handling several pgpool-II clusters Jorgen <jrm@kms.dk>
@ 2011-05-03 07:29 ` Magnus Hagander <magnus@hagander.net>
2011-05-03 08:16 ` Re: pgpoolAdmin handling several pgpool-II clusters Jorgen <jrm@kms.dk>
0 siblings, 1 reply; 6+ messages in thread
From: Magnus Hagander @ 2011-05-03 07:29 UTC (permalink / raw)
To: Jorgen <jrm@kms.dk>; +Cc: pgsql-performance
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/
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: pgpoolAdmin handling several pgpool-II clusters
2011-04-29 12:46 pgpoolAdmin handling several pgpool-II clusters Jorgen <jrm@kms.dk>
2011-04-30 01:27 ` Re: pgpoolAdmin handling several pgpool-II clusters Tatsuo Ishii <ishii@sraoss.co.jp>
2011-05-03 05:32 ` Re: pgpoolAdmin handling several pgpool-II clusters Jorgen <jrm@kms.dk>
2011-05-03 07:29 ` Re: pgpoolAdmin handling several pgpool-II clusters Magnus Hagander <magnus@hagander.net>
@ 2011-05-03 08:16 ` Jorgen <jrm@kms.dk>
0 siblings, 0 replies; 6+ messages in thread
From: Jorgen @ 2011-05-03 08:16 UTC (permalink / raw)
To: pgsql-performance
>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-tp4358647p43...
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: pgpoolAdmin handling several pgpool-II clusters
2011-04-29 12:46 pgpoolAdmin handling several pgpool-II clusters Jorgen <jrm@kms.dk>
@ 2011-04-30 01:28 ` Tatsuo Ishii <ishii@postgresql.org>
1 sibling, 0 replies; 6+ messages in thread
From: Tatsuo Ishii @ 2011-04-30 01:28 UTC (permalink / raw)
To: jrm@kms.dk; +Cc: pgsql-performance
> 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
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2011-05-03 08:16 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-04-29 12:46 pgpoolAdmin handling several pgpool-II clusters Jorgen <jrm@kms.dk>
2011-04-30 01:27 ` Tatsuo Ishii <ishii@sraoss.co.jp>
2011-05-03 05:32 ` Jorgen <jrm@kms.dk>
2011-05-03 07:29 ` Magnus Hagander <magnus@hagander.net>
2011-05-03 08:16 ` Jorgen <jrm@kms.dk>
2011-04-30 01:28 ` Tatsuo Ishii <ishii@postgresql.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox