Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Advanced Search Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Mastering Geoserver
  • Table Of Contents Toc
  • Feedback & Rating feedback
Mastering Geoserver

Mastering Geoserver

By : Henderson
4.6 (7)
Buy this Book
close
close
Mastering Geoserver

Mastering Geoserver

4.6 (7)
By: Henderson
Buy this Book

Overview of this book

If you are a GIS professional who intends to explore advanced techniques and get more out of GeoServer deployment rather than simply delivering good looking maps, then this book is for you.
Table of Contents (14 chapters)
close
close
close
Preface
Icon
Preface
Icon
What this book covers
Icon
What you need for this book
Icon
Who this book is for
Icon
Conventions
Icon
Reader feedback
Icon
Customer support
Lock Free Chapter
1
1. Installing GeoServer for Production
Icon
1. Installing GeoServer for Production
Icon
Java requirements
Icon
Installing Apache Tomcat
Icon
Deploying GeoServer to Apache Tomcat
Icon
Configuring GeoServer for maximum performance and availability
Icon
Configuring multiple GeoServer instances on a single server
Icon
Summary
2
2. Working with Raster Data
Icon
2. Working with Raster Data
Icon
Increasing the raster formats supported by GeoServer
Icon
How to optimize raster data for better performance
Icon
How to serve very large raster datasets
Icon
Summary
3
3. Working with Vector Data in Spatial Databases
chevron up
Icon
3. Working with Vector Data in Spatial Databases
Icon
Database connection pooling
Icon
JNDI connection or JDBC
Icon
General database connection parameters
Icon
Serving data from PostGIS
Icon
Serving data from Oracle
Icon
Serving data from Microsoft SQL Server and SQL Azure
Icon
Creating SQL View layers
Icon
Summary
4
4. Using GeoServer to Serve Complex Features
Icon
4. Using GeoServer to Serve Complex Features
Icon
The difference between simple and complex features
Icon
Using GeoServer application schemas
Icon
Publishing data with an application schema
Icon
Summary
5
5. Using GeoServer as a Proxy
Icon
5. Using GeoServer as a Proxy
Icon
Defining cascaded services
Icon
Using cascaded services
Icon
Creating a cascaded WMS connection
Icon
Connecting to a cascaded WFS
Icon
Extending server capabilities
Icon
Summary
6
6. Controlling the Output of GeoServer
Icon
6. Controlling the Output of GeoServer
Icon
Styling data with Styled Layer Descriptor
Icon
Styling data using Cascaded Style Sheets
Icon
Per-request styling of map features
Icon
Per-request filtering of data
Icon
Using Freemarker templates to change WMS responses
Icon
Summary
7
7. Using GeoServer to Print Maps
Icon
7. Using GeoServer to Print Maps
Icon
The GeoServer print extension
Icon
Installing the print extension
Icon
Configuring the print extension
Icon
Defining print layouts
Icon
Making print requests
Icon
An example OpenLayers application
Icon
Summary
8
8. Integrating GeoServer in a Spatial Data Infrastructure
Icon
8. Integrating GeoServer in a Spatial Data Infrastructure
Icon
Definition of a spatial data infrastructure
Icon
User perspective – editing data through WFS-T
Icon
User perspective – consuming data
Icon
Summary
9
9. GeoServer as a Spatial Analysis Platform
Icon
9. GeoServer as a Spatial Analysis Platform
Icon
Understanding Web Processing Services
Icon
Installing the WPS extension
Icon
Using WPS to perform spatial analysis
Icon
Understanding GeoScript
Icon
Installing the GeoScript extension
Icon
Scripting GeoServer
Icon
Summary
10
10. Enterprise Security and GeoServer
Icon
10. Enterprise Security and GeoServer
Icon
Authentication and authorization
Icon
Using Active Directory for user authentication and authorization
Icon
Using Digest for user authentication
Icon
Using HTTP Header for user authentication
Icon
Summary
11
11. Monitoring the Performance and Health of GeoServer
Icon
11. Monitoring the Performance and Health of GeoServer
Icon
The importance of monitoring GeoServer
Icon
The GeoServer monitor extension
Icon
Stress testing GeoServer
Icon
Analyzing the results of the stress test
Icon
Summary
12
12. Optimizing GeoServer for Production
Icon
12. Optimizing GeoServer for Production
Icon
Deploying GeoServer in a cluster
Icon
Optimizing GeoServer
Icon
Automatic recovery from service failures
Icon
Summary
13
Index
Icon
Index

Database connection pooling

Before we get into the details of setting up specific database platforms, it is worth having a conversation about database connection pooling, what it is, and why we should care about it.

Understanding database connection pools

If database connection pooling was not utilized, every time GeoServer receives a request for the data stored in a spatial database, the following sequence of events occurs:

  • A connection to the database is made
  • SQL commands are executed to select data
  • The results from the query are read and processed
  • The database connection is closed

A lot of things happen to fetch some data to be rendered (WMS) or processed and streamed (WFS). Consider this happening for a lot of requests, and you can imagine things getting very busy with connections being opened and closed all the time. A lot of the connections from GeoServer to spatial databases are short-lived; in most cases, they might only need to gather a few hundred features. This means that the opening...

Visually different images
CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Mastering Geoserver
End of Section 3
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon