Hi Gavin

Only comment I can add is regarding the use of oracle to store your spatial 
data.

I serve up mastermap data for the Merseyside area . I had a lot of complaints 
from my users about the speed of the maps loading

I had all the mastermap data in an oracle 11 database. I switched to Postgis 
and the map tile loading time decreased significantly

Feedback from my users was that the maps loaded "instantly" after the change.

Mark Ismail

-----Original Message-----
From: gavin.montgomery [mailto:[email protected]]
Sent: 30 June 2015 11:53
To: [email protected]
Subject: [Geoserver-users] OS Mastermap in Production 1000's of users

Hi All,

We are developing a map application which is aiming to serve 1000's of users 
Ordnance Survey Master Map data at various scales.
We have scaled our geoserver solution to provide the following:

24 instances of geoserver running 4 instances on 6 VMs 8x 2.7 CPUs 64GB RAM each

2 instances of Geowebcache - 128GB RAM available on each GWC serves pre-built 
cache at levels 0-10 (1:2m - 1:3100) on British national Grid.
(Level 10 consists of approx 8 million tiles) Any further levels are cached 
dynamically As it is OS Mastermap we are required to update our data every 6 
weeks hence a full recache at that time.

We have an Oracle Node with 12 cores serving our GeoServers as well as a number 
of other applications. Nonetheless OSMM requests are responsible for the 
majority of CPU usage.

We are using spatial partitions, up to date statistics as well as appropriate 
columns indexing for the WMS queries to take place.

We request tiles on 256x256 pixels - it has been suggested by our DBAs to 
increase this request size - does anybody agree/disagree with this? I would 
just expect this increases the size of the request and increase rendering time. 
OSMM is quite a complex SLD though is still rather performant.

Has anybody had experience with full national coverage of OSMM on Oracle?
Did you encounter performance issues at high user load? Did you do anything to 
rectify the solution or was it a matter of hardware required to deal with the 
demand?

Any insights appreciated, happy to answer any further questions.

Regards





--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/OS-Mastermap-in-Production-1000-s-of-users-tp5213560.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that you need 
to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
This e-mail and any attachments are confidential. It may contain privileged 
information and is intended for the named recipient(s) only. It must not be 
distributed without consent. If you are not one of the intended recipients, 
please notify the sender immediately and do not disclose, distribute, or retain 
this email or any part of it and do not take any action based on it.

Unless expressly stated, opinions in this email are those of the individual 
sender, and not of Knowsley MBC. Legally binding obligations can only be 
created for, or be entered into on behalf of, Knowsley MBC by duly authorised 
officers or representatives.

Knowsley MBC excludes any liability whatsoever for any offence caused, any 
direct or consequential loss arising from the use, or reliance on, this e-mail 
or its contents. We believe but do not warrant that this e-mail and any 
attachments are virus free. You must therefore take full responsibility for 
virus checking and no responsibility is accepted for loss or damage arising 
from viruses or changes made to this message after it was sent. Knowsley MBC 
reserves the right to monitor and/or record all e-mail communications through 
its network in accordance with relevant legislation.

------------------------------------------------------------------------------
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that
you need to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to