Hi, *Problem:* Cannot find resources to implement database pooling for a clustered Geoserver configuration.
*Background:* I have a Geoserver (2.10) cluster (4 x) using Tomcat 7 containers (4 x) and using apache2 as a front-end proxy/load balancer on Ubuntu 16.04.1 LTS. All Geoservers can be used by the apache2 load balancer and one shared data directory is used for all of them. The master Geoserver GUI is used for administration & WFS/WMS services while the remaining three Geoservers are used only for WFS/WMS services. The Geoserver stores are connecting to a PSQL database (located in another server located in the same network with same OS - Ubuntu 16.04.1 LTS) to collect the data before publication using WFS & WMS. *Question:* I would like to implement a database pooling strategy to gain the benefit of performance using the database pooling technique; however I am not sure that I understand whether I need to add the necessary drivers in all tomcat containers or only the master container, and whether I need to customize all the containers or only the master one. I have read the instructions at Advanced Database Connection Pooling Configuration <http://geoserver.geo-solutions.it/edu/en/adv_gsconfig/db_pooling.html> by GeoSolutions. I would appreciate some knowledge sharing & experiences with this. Regards, D. -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Database-pooling-for-clustered-Geoserver-configuration-tp5306937.html Sent from the GeoServer - User mailing list archive at Nabble.com. ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot _______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
