[Geoserver-users] JDBCConfig in the cluster

Dear List,
we’ve planned to configure a cluster of geoserver in the cloud and we’d like to evaluate all the possible solutions.
We already know something about JMSClustering and the classic shared data directory configuration.

So, what about the JDBCConfig module (community)?
Is it up and running in any production environment?
Known issues?
How it solves concurrent modifications problem?

Any help or details on that would be appreciated.
Best regards,
Carlo

···

Mr. Carlo Cancellieri
skype: ccancellieri
Twitter: @cancellieric
LinkedIn: http://it.linkedin.com/in/ccancellieri/

Hello Carlo,

We use jdbcconfig in combination with jdbcstore and hzcluster in a production environment.

I have been doing several improvements in the last few years in terms of efficiency, bugs and concurrency as well (using semaphores).

Do you have any more specific questions?

Kind Regards

Niels

···

On 27/04/2020 11:21, carlo cancellieri wrote:

Dear List,
we’ve planned to configure a cluster of geoserver in the cloud and we’d like to evaluate all the possible solutions.
We already know something about JMSClustering and the classic shared data directory configuration.

So, what about the JDBCConfig module (community)?
Is it up and running in any production environment?
Known issues?
How it solves concurrent modifications problem?

Any help or details on that would be appreciated.
Best regards,
Carlo

Mr. Carlo Cancellieri
skype: ccancellieri
Twitter: @cancellieric
LinkedIn: http://it.linkedin.com/in/ccancellieri/

_______________________________________________
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:
- Earning your support instead of buying it, but Ian Turton: [http://www.ianturton.com/talks/foss4g.html#/](http://www.ianturton.com/talks/foss4g.html#/)
- The GeoServer user list posting guidelines: [http://geoserver.org/comm/userlist-guidelines.html](http://geoserver.org/comm/userlist-guidelines.html)

If you want to request a feature or an improvement, also see this: [https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer](https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer)

[Geoserver-users@lists.sourceforge.net](mailto:Geoserver-users@lists.sourceforge.net)
[https://lists.sourceforge.net/lists/listinfo/geoserver-users](https://lists.sourceforge.net/lists/listinfo/geoserver-users)

As I am sure you are aware no group has contributed a clustering solution to the core geoserver product yet (but I am glad such are being shared as community modules for RnD).

Another one you may wish to check out is https://github.com/planetlabs/stratus

···


Jody Garnett

Dear Niels,
We’re currently testing JDBCConfig and Hazelcast (which does not appear on the documentation page list but we’ve found that into the extension download page) and they are working quite well.
What is still unclear is the need to use JDBCStore… what can you say about that.

Dear List,
I know it’s unmantained so this is just to keep you informed that JMS module is not working anymore on 2.17.x it fail to start throwing exception cause:

Multiple beans of type org.geoserver.config.GeoServerLoader

···

Mr. Carlo Cancellieri
skype: ccancellieri
Twitter: @cancellieric
LinkedIn: http://it.linkedin.com/in/ccancellieri/

Dear Jody,
thank you for pointing this out to me!
It looks very interesting specially for the redis integration, we will try to check it out but looks also very young so I’m afraid it could be not very well tested.
Have you tryied that in a production environment?
Regards,
Carlo

···

Mr. Carlo Cancellieri
skype: ccancellieri
Twitter: @cancellieric
LinkedIn: http://it.linkedin.com/in/ccancellieri/

Helllo Carlo,

JDBCStore allows all config files that are not part of the catalog and the services to be stored into the database and automatically synced between nodes.

A good example are the style SLD files.

Kind Regards

Niels

···

On 29/04/2020 16:13, carlo cancellieri wrote:

Dear Niels,
We’re currently testing JDBCConfig and Hazelcast (which does not appear on the documentation page list but we’ve found that into the extension download page) and they are working quite well.
What is still unclear is the need to use JDBCStore… what can you say about that.

Dear List,
I know it’s unmantained so this is just to keep you informed that JMS module is not working anymore on 2.17.x it fail to start throwing exception cause:

Multiple beans of type org.geoserver.config.GeoServerLoader

Il giorno lun 27 apr 2020 alle ore 13:51 Niels Charlier via Geoserver-users <geoserver-users@lists.sourceforge.net> ha scritto:

Hello Carlo,

We use jdbcconfig in combination with jdbcstore and hzcluster in a production environment.

I have been doing several improvements in the last few years in terms of efficiency, bugs and concurrency as well (using semaphores).

Do you have any more specific questions?

Kind Regards

Niels

On 27/04/2020 11:21, carlo cancellieri wrote:

Dear List,
we’ve planned to configure a cluster of geoserver in the cloud and we’d like to evaluate all the possible solutions.
We already know something about JMSClustering and the classic shared data directory configuration.

So, what about the JDBCConfig module (community)?
Is it up and running in any production environment?
Known issues?
How it solves concurrent modifications problem?

Any help or details on that would be appreciated.
Best regards,
Carlo

Mr. Carlo Cancellieri
skype: ccancellieri
Twitter: @cancellieric
LinkedIn: http://it.linkedin.com/in/ccancellieri/

_______________________________________________
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:
- Earning your support instead of buying it, but Ian Turton: [http://www.ianturton.com/talks/foss4g.html#/](http://www.ianturton.com/talks/foss4g.html#/)
- The GeoServer user list posting guidelines: [http://geoserver.org/comm/userlist-guidelines.html](http://geoserver.org/comm/userlist-guidelines.html)

If you want to request a feature or an improvement, also see this: [https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer](https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer)

[Geoserver-users@lists.sourceforge.net](mailto:Geoserver-users@lists.sourceforge.net)
[https://lists.sourceforge.net/lists/listinfo/geoserver-users](https://lists.sourceforge.net/lists/listinfo/geoserver-users)


Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:

If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer

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

Mr. Carlo Cancellieri
skype: ccancellieri
Twitter: @cancellieric
LinkedIn: http://it.linkedin.com/in/ccancellieri/

That is odd, I recently did a performance test comparing JMS config, JDBCConfig and Stratus, they all started correctly.
Maybe you had multiple clustering solutions in the same GeoServer?

Cheers
Andrea

···

== GeoServer Professional Services from the experts! Visit http://goo.gl/it488V for more information. == Ing. Andrea Aime @geowolf Technical Lead GeoSolutions S.A.S. Via di Montramito 3/A 55054 Massarosa (LU) phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339 8844549 http://www.geo-solutions.it http://twitter.com/geosolutions_it ------------------------------------------------------- Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni circostanza inerente alla presente email (il suo contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le sarei comunque grato se potesse darmene notizia. This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. We remind that - as provided by European Regulation 2016/679 “GDPR” - copying, dissemination or use of this e-mail or the information herein by anyone other than the intended recipient is prohibited. If you have received this email by mistake, please notify us immediately by telephone or e-mail.

I’ll let u know, let me Ask for confirmation to the tester.

C

···

Mr. Carlo Cancellieri
skype: ccancellieri
Twitter: @cancellieric
LinkedIn: http://it.linkedin.com/in/ccancellieri/

Dear Andrea,
Following up your mail, yes, probably you where right about multiple jars into lib/ folder, so we decided to perform a clean test from scratch.

I’ve asked to perform a clean test with the geoserver-2.17.0, we are over windows10 with oracle jdk8 and tomcat-8 (but also tested with tomcat-9).

We are able to start geoserver without that plugin.

If we install JMS Cluster plugin we drop into missing library as shown in the attached logs (and below):

java.lang.NoClassDefFoundError: org/apache/commons/pool2/KeyedPooledObjectFactory

Not sure why but maybe something has changed in the dependency tree or in the default ActiveMQ configurations.

I apologize but we could not perfom other tests over this issue.

Cheers,
C.

Il giorno mer 29 apr 2020 alle ore 18:17 carlo cancellieri <carlo.cancellieri@anonymised.com> ha scritto:

I’ll let u know, let me Ask for confirmation to the tester.

C

Il giorno mer 29 apr 2020 alle 17:19 Andrea Aime <andrea.aime@anonymised.com> ha scritto:

On Wed, Apr 29, 2020 at 4:38 PM carlo cancellieri <carlo.cancellieri@anonymised.com> wrote:

Dear List,

I know it’s unmantained so this is just to keep you informed that JMS module is not working anymore on 2.17.x it fail to start throwing exception cause:

Multiple beans of type org.geoserver.config.GeoServerLoader

That is odd, I recently did a performance test comparing JMS config, JDBCConfig and Stratus, they all started correctly.
Maybe you had multiple clustering solutions in the same GeoServer?

Cheers
Andrea

== GeoServer Professional Services from the experts! Visit http://goo.gl/it488V for more information. == Ing. Andrea Aime @geowolf Technical Lead GeoSolutions S.A.S. Via di Montramito 3/A 55054 Massarosa (LU) phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339 8844549 http://www.geo-solutions.it http://twitter.com/geosolutions_it ------------------------------------------------------- Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni circostanza inerente alla presente email (il suo contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le sarei comunque grato se potesse darmene notizia. This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. We remind that - as provided by European Regulation 2016/679 “GDPR” - copying, dissemination or use of this e-mail or the information herein by anyone other than the intended recipient is prohibited. If you have received this email by mistake, please notify us immediately by telephone or e-mail.


Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:

If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer

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

Mr. Carlo Cancellieri
skype: ccancellieri
Twitter: @cancellieric
LinkedIn: http://it.linkedin.com/in/ccancellieri/

Mr. Carlo Cancellieri
skype: ccancellieri
Twitter: @cancellieric
LinkedIn: http://it.linkedin.com/in/ccancellieri/

tomcat-9-geoserver.log (20.2 KB)

tomcat-9-catalina.2020-04-30.log (64.5 KB)

Hi Carlo,
for a totally different issue on another project (not even related to JMS) I had similar exception in the past.
If memory serves me correctly the fix was in adding commons-pool2-2.8.0.jar to the classpath.

(Probably JMS is still inheriting an older one from the parent poms?)

Cheers,
Daniele

···

Regards,
Daniele Romagnoli

GeoServer Professional Services from the experts! Visit http://goo.gl/it488V for more information.

Ing. Daniele Romagnoli
Senior Software Engineer

GeoSolutions S.A.S.
Via di Montramito 3/A
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272

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


Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni circostanza inerente alla presente email (il suo contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le sarei comunque grato se potesse darmene notizia.

This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. We remind that - as provided by European Regulation 2016/679 “GDPR” - copying, dissemination or use of this e-mail or the information herein by anyone other than the intended recipient is prohibited. If you have received this email by mistake, please notify us immediately by telephone or e-mail.