Does that solve the performance issues you're having, and make the cluster
performance comparable
to the single instance case?

​I have cloned the Deployment and I want to export the Database Catalog
back to XML first (I have to figure this out, I can't imaging creating the
catalog again). Then I'll perform the test and compare.

Meanwhile, comparing the Single Geoserver with XML Catalog versus 3
Clustered Geoservers with DB Catalog, and all other configurations
remainign the same (i.e. rules, AuthKey Filter, JDBC Group & Role Service),
the Single Geoserver is much faster (4-6 times)​.


It maybe important to mention that, I tried testing WMTS request with
(TileCol X TileRow) in two separate Geoserver Instances. One Geoserver with
Data Security Rules
​ set on workspaces ​
and another instance without Rules. Interestingly WMTS request took average
754ms to GetTile where there are no Rules compared to
2668
​ms with Rules. Both with JDBC Catalog. So I'm still not certain if it's
the JDBC Catalog my problem of the Data Security Authorization comined with
DB Catalog. Investigating further.



<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
Virus-free.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Kind regards,
Steve Omondi

On Thu, Nov 9, 2017 at 1:13 PM, Andrea Aime <andrea.a...@geo-solutions.it>
wrote:

> On Thu, Nov 9, 2017 at 11:06 AM, Steve Omondi <steve.omo...@ramani.co.ke>
> wrote:
>
>> Hi Andrea and team,
>>
>> After several tests using jmeter, I have resolved to move my Catalog from
>> DB to XML Catalog.
>>
>
> Does that solve the performance issues you're having, and make the cluster
> performance comparable
> to the single instance case?
>
> I've answered to the other mail
>
> 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
> <https://maps.google.com/?q=Via+di+Montramito+3/A+55054+%C2%A0Massarosa&entry=gmail&source=g>
> 55054  Massarosa
> <https://maps.google.com/?q=Via+di+Montramito+3/A+55054+%C2%A0Massarosa&entry=gmail&source=g>
> (LU)
> phone: +39 0584 962313 <+39%200584%20962313>
> fax: +39 0584 1660272 <+39%200584%20166%200272>
> mob: +39  339 8844549 <+39%20339%20884%204549>
>
> http://www.geo-solutions.it
> http://twitter.com/geosolutions_it
>
> AVVERTENZE AI SENSI DEL D.Lgs. 196/2003
>
> Le informazioni contenute in questo messaggio di posta elettronica e/o
> nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il
> loro utilizzo è consentito esclusivamente al destinatario del messaggio,
> per le finalità indicate nel messaggio stesso. Qualora riceviate questo
> messaggio senza esserne il destinatario, Vi preghiamo cortesemente di
> darcene notizia via e-mail e di procedere alla distruzione del messaggio
> stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso,
> divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od
> utilizzarlo per finalità diverse, costituisce comportamento contrario ai
> principi dettati dal D.Lgs. 196/2003.
>
> The information in this message and/or attachments, is intended solely for
> the attention and use of the named addressee(s) and may be confidential or
> proprietary in nature or covered by the provisions of privacy act
> (Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection
> Code).Any use not in accord with its purpose, any disclosure, reproduction,
> copying, distribution, or either dissemination, either whole or partial, is
> strictly forbidden except previous formal approval of the named
> addressee(s). If you are not the intended recipient, please contact
> immediately the sender by telephone, fax or e-mail and delete the
> information in this message that has been received in error. The sender
> does not give any warranty or accept liability as the content, accuracy or
> completeness of sent messages and accepts no responsibility  for changes
> made after they were sent or for other risks which arise as a result of
> e-mail transmission, viruses, etc.
>
>
------------------------------------------------------------------------------
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

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#/
- The GeoServer user list posting guidelines: 
http://geoserver.org/comm/userlist-guidelines.html

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

Reply via email to