[Geoserver-users] jdbcconfig module

GeoServer GeoServer User
1

Hello List,

I tried to configure jdbcconfig extension for GeoServer. It works good – saves settings to PosgreSQL and all 3 clusters can successfully Access it.

But I notice one thing – jdbcconfig has no impact for TileCaching ( Tile Layers) – changes on master GeoServer instance for Tile Layers were not sinchronized between instances.

Does jdbcconfig module supports GeoWebCache settings? Or maybe it is just for GeoServer settings?

I am using geoserver 2.4.war on Windows Server 2008R2 X64 on Tomcat6 + jdk1.6 x64.

Sincerely,

Paul

2

Hi Paulius,

I’m not sure to understand exactly what do you mean with impact on TileCaching, what exactly you want to do?

GeoWebCache saves the tiles on the mass storage, if you change the layer you have to invalidate the cache in order to regenerate the new tiles. The jdbcconfig module has no effect on this behavior.

-A.

···

==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for
more information.

Ing. Alessio Fabiani
@alfa7691
Founder/Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 331 6233686

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

On Mon, Sep 30, 2013 at 9:36 AM, Paulius Litvinas <paulius@anonymised.com> wrote:

Hello List,

I tried to configure jdbcconfig extension for GeoServer. It works good – saves settings to PosgreSQL and all 3 clusters can successfully Access it.

But I notice one thing – jdbcconfig has no impact for TileCaching ( Tile Layers) – changes on master GeoServer instance for Tile Layers were not sinchronized between instances.

Does jdbcconfig module supports GeoWebCache settings? Or maybe it is just for GeoServer settings?

I am using geoserver 2.4.war on Windows Server 2008R2 X64 on Tomcat6 + jdk1.6 x64.

Sincerely,

Paul

October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg.clktrk

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

3

Hi Alessio,

I have 3 GeoServer clustered instances with load balancing.

After I installed jdbcconfig module I added new layer on one GeoServer instance. I understand that with jdbcconfig module settings are stored on PostgreSQL and sinchronized between other instances (using same data dir). The same new layer appeared automaticaly on other GeoServer instances without restarting (reload config).

Also on one GeoServer instance I created tile cache for this layer, but unfortunately this tile cache did not appeared on other GeoServer instances. I had to reload config, so I gues settings for GeoWebCache is stored in files.

I expected that GeoWebCache settings also are stored in same database using jdbcconfig module and they will be sinchonized automaticaly on all GeoServer instances.

Paul

From: alessio.fabiani@anonymised.com [mailto:alessio.fabiani@anonymised.com] On Behalf Of Alessio Fabiani
Sent: Monday, September 30, 2013 10:44 AM
To: Paulius Litvinas
Cc: geoserver-users
Subject: Re: [Geoserver-users] jdbcconfig module

Hi Paulius,

I’m not sure to understand exactly what do you mean with impact on TileCaching, what exactly you want to do?

GeoWebCache saves the tiles on the mass storage, if you change the layer you have to invalidate the cache in order to regenerate the new tiles. The jdbcconfig module has no effect on this behavior.

-A.

==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for
more information.

Ing. Alessio Fabiani

@alfa7691

Founder/Technical Lead

GeoSolutions S.A.S.

Via Poggio alle Viti 1187

55054 Massarosa (LU)

Italy

phone: +39 0584 962313

fax: +39 0584 1660272

mob: +39 331 6233686

http://www.geo-solutions.it

http://twitter.com/geosolutions_it

On Mon, Sep 30, 2013 at 9:36 AM, Paulius Litvinas <paulius@anonymised.com> wrote:

Hello List,

I tried to configure jdbcconfig extension for GeoServer. It works good – saves settings to PosgreSQL and all 3 clusters can successfully Access it.

But I notice one thing – jdbcconfig has no impact for TileCaching ( Tile Layers) – changes on master GeoServer instance for Tile Layers were not sinchronized between instances.

Does jdbcconfig module supports GeoWebCache settings? Or maybe it is just for GeoServer settings?

I am using geoserver 2.4.war on Windows Server 2008R2 X64 on Tomcat6 + jdk1.6 x64.

Sincerely,

Paul

October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg.clktrk

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

4

On Mon, Sep 30, 2013 at 10:01 AM, Paulius Litvinas <paulius@anonymised.com>wrote:

Hi Alessio,****

** **

I have 3 GeoServer clustered instances with load balancing.****

After I installed jdbcconfig module I added new layer on one GeoServer
instance. I understand that with jdbcconfig module settings are stored on
PostgreSQL and sinchronized between other instances (using same data dir).
The same new layer appeared automaticaly on other GeoServer instances
without restarting (reload config).****

** **

Also on one GeoServer instance I created tile cache for this layer, but
unfortunately this tile cache did not appeared on other GeoServer
instances. I had to reload config, so I gues settings for GeoWebCache is
stored in files.****

** **

I expected that GeoWebCache settings also are stored in same database
using jdbcconfig module and they will be sinchonized automaticaly on all
GeoServer instances.

Nope, you're right, GeoWebCache uses a separate set of xml files to store
its configuration, which makes it
unreachable for the jdbcconfig module.
This is true for a number of other extensions and subsystem, there was a
question about which config elements
are actually stored in the db, and which not, some time ago on this list,
have a look in the archives, I've tried
to list things that cannot be stored in the dbms without also changing the
way those GeoServer modules work

Cheers
Andrea

--

Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

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

5

Ok. I got it. Thanks for the help

From: andrea.aime@anonymised.com [mailto:andrea.aime@anonymised.com] On Behalf Of Andrea Aime
Sent: Monday, September 30, 2013 11:10 AM
To: Paulius Litvinas
Cc: Alessio Fabiani; geoserver-users
Subject: Re: [Geoserver-users] jdbcconfig module

On Mon, Sep 30, 2013 at 10:01 AM, Paulius Litvinas <paulius@anonymised.com> wrote:

Hi Alessio,

I have 3 GeoServer clustered instances with load balancing.

After I installed jdbcconfig module I added new layer on one GeoServer instance. I understand that with jdbcconfig module settings are stored on PostgreSQL and sinchronized between other instances (using same data dir). The same new layer appeared automaticaly on other GeoServer instances without restarting (reload config).

Also on one GeoServer instance I created tile cache for this layer, but unfortunately this tile cache did not appeared on other GeoServer instances. I had to reload config, so I gues settings for GeoWebCache is stored in files.

I expected that GeoWebCache settings also are stored in same database using jdbcconfig module and they will be sinchonized automaticaly on all GeoServer instances.

Nope, you’re right, GeoWebCache uses a separate set of xml files to store its configuration, which makes it

unreachable for the jdbcconfig module.

This is true for a number of other extensions and subsystem, there was a question about which config elements

are actually stored in the db, and which not, some time ago on this list, have a look in the archives, I’ve tried

to list things that cannot be stored in the dbms without also changing the way those GeoServer modules work

Cheers

Andrea

–

==

Our support, Your Success! Visit http://opensdi.geo-solutions.it for more information.

==

Ing. Andrea Aime

@geowolf

Technical Lead

GeoSolutions S.A.S.

Via Poggio alle Viti 1187

55054 Massarosa (LU)

Italy

phone: +39 0584 962313

fax: +39 0584 1660272

mob: +39 339 8844549

http://www.geo-solutions.it

http://twitter.com/geosolutions_it

6

Chiming in late on this one.

When it comes to cluster synchronization the jdbconfig module only solves part of the problem, and the synchronization problem pops up elsewhere, most notably in the ResourcePool. It is not a problem for adding new configuration objects but is a problem for updating existing ones.

For instance consider changing the configuration of an existing data store. Even though every node in the cluster will see the changed configuration the next time they access that store they won’t know it changed so won’t know to expire the cached resource for it.

The only way I have seen this effectively solved is with the addition of a messaging/synchronization component that nodes in the cluster use to broadcast change events to the rest of the cluster.

···

On Mon, Sep 30, 2013 at 2:12 AM, Paulius Litvinas <paulius@anonymised.com> wrote:

Ok. I got it. Thanks for the help

From: andrea.aime@anonymised.com [mailto:andrea.aime@anonymised.com] On Behalf Of Andrea Aime
Sent: Monday, September 30, 2013 11:10 AM
To: Paulius Litvinas
Cc: Alessio Fabiani; geoserver-users

Subject: Re: [Geoserver-users] jdbcconfig module

On Mon, Sep 30, 2013 at 10:01 AM, Paulius Litvinas <paulius@anonymised.com> wrote:

Hi Alessio,

I have 3 GeoServer clustered instances with load balancing.

After I installed jdbcconfig module I added new layer on one GeoServer instance. I understand that with jdbcconfig module settings are stored on PostgreSQL and sinchronized between other instances (using same data dir). The same new layer appeared automaticaly on other GeoServer instances without restarting (reload config).

Also on one GeoServer instance I created tile cache for this layer, but unfortunately this tile cache did not appeared on other GeoServer instances. I had to reload config, so I gues settings for GeoWebCache is stored in files.

I expected that GeoWebCache settings also are stored in same database using jdbcconfig module and they will be sinchonized automaticaly on all GeoServer instances.

Nope, you’re right, GeoWebCache uses a separate set of xml files to store its configuration, which makes it

unreachable for the jdbcconfig module.

This is true for a number of other extensions and subsystem, there was a question about which config elements

are actually stored in the db, and which not, some time ago on this list, have a look in the archives, I’ve tried

to list things that cannot be stored in the dbms without also changing the way those GeoServer modules work

Cheers

Andrea

–

==

Our support, Your Success! Visit http://opensdi.geo-solutions.it for more information.

==

Ing. Andrea Aime

@geowolf

Technical Lead

GeoSolutions S.A.S.

Via Poggio alle Viti 1187

55054 Massarosa (LU)

Italy

phone: +39 0584 962313

fax: +39 0584 1660272

mob: +39 339 8844549

http://www.geo-solutions.it

http://twitter.com/geosolutions_it

October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg.clktrk

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

–

Justin Deoliveira
Vice President, Engineering | Boundless
jdeolive@anonymised.com
@j_deolive