[Geoserver-users] Geoserver with Postgres clustering solutions

Hi All -

I am just wondering whether anyone has experience with Postgres clustering solutions and Geoserver. I am currently looking at the following clustering solutions:
Sequoia - http://sequoia.continuent.org
PgCluster / PgCluster II - http://pgfoundry.org/projects/pgcluster
Postgres-R - http://www.postgres-r.org
Bucardo - http://bucardo.org

Some in this list like the PgCluster and Sequoia use its own driver and they act like a DB proxy to forward requests to different nodes. Hence my guess is Geoserver is to be updated so that it can use Sequoia driver. Again I am skeptical on Sequoia’s capability to forward Geospatial queries to the nodes. Comments and recommendations are highly appreciated.

Thanks in advance.
– Hari Gangadharan


Climb to the top of the charts! Play Star Shuffle: the word scramble challenge with star power. Play Now!

Hi Hari,

Unfortunately GeoServer is not currently set up to do clustering nicely.
I believe there have been those that have hacked some stuff up using
multiple geosrever instances pointing at a single network drive or
something like that... but its far from a true clustering solution.

There was some R&D experimental work that went on a while back which
involved storing goeserver configuration in a database like postgis. The
results were quite good, unfortunately it will require a quite a bit of
work to implement so its something that is still quite far off afaik.

If you just want to cluster data and dont care about maintaining
multiple geoserver instances separately then one of the solution you
listed may very well work nicely.

-Justin

Hari G wrote:

Hi All -

I am just wondering whether anyone has experience with Postgres
clustering solutions and Geoserver. I am currently looking at the
following clustering solutions:
Sequoia - http://sequoia.continuent.org
PgCluster / PgCluster II - http://pgfoundry.org/projects/pgcluster
Postgres-R - http://www.postgres-r.org
Bucardo - http://bucardo.org

Some in this list like the PgCluster and Sequoia use its own driver and
they act like a DB proxy to forward requests to different nodes. Hence
my guess is Geoserver is to be updated so that it can use Sequoia
driver. Again I am skeptical on Sequoia's capability to forward
Geospatial queries to the nodes. Comments and recommendations are highly
appreciated.

Thanks in advance.
-- Hari Gangadharan

Climb to the top of the charts! Play Star Shuffle: the word scramble
challenge with star power. Play Now!
<http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_oct&gt;
!DSPAM:4007,473dd13e318005210051143!

------------------------------------------------------------------------

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

!DSPAM:4007,473dd13e318005210051143!

------------------------------------------------------------------------

_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:4007,473dd13e318005210051143!

--
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org