Percona Live: Open Source Database Performance Conference - Amsterdam 2016 Logo

October 3-5, 2016

Amsterdam, Netherlands

MySQL 5.7 and MongoDB: Geospatial Introduction

MySQL 5.7 and MongoDB: Geospatial Introduction

 5 October 12:20 PM - 1:10 PM @ Matterhorn 3
Experience level: 
50 minutes conference


This talk reviews the GIS improvements in MySQL 5.7, provides some general review of the functionality, and walks through some working demos. We'll also perform a high-level review of MongoDB's GIS functionality, and discuss the pros and cons between MySQL and MongoDB (and how you can use them in conjunction). Attendee takeaways: - Overview of GIS functionality in MySQL (5.7) and MongoDB - High-level samples and potential use cases - Demo with Open Street Map in MySQL and MongoDB - This isn't meant as a deep dive, but rather an intro-level talk Additional description: Geo-enabled (or location-enabled) applications are very common nowadays, and many of them use MySQL. The common tasks for such applications are: -Find all points of interests (i.e., coffee shops) around (i.e., within a 10-mile radius) a given location (latitude and longitude). For example, we want to show this to a user of a mobile application when we know his/her approximate location. (This usually means we need to calculate a distance between two points on Earth.) -Find a ZIP code (U.S. postal address) for a given location, or determine if this location is within a given area. Another example is to find a school district for a given property. MySQL had spatial functions originally (implementation follows a subset of OpenGIS standard). MySQL 5.7 introduces spatial (R-Tree) indexes for InnoDB as well as new functions to calculate the distance between points. MongoDB also supports GIS functions and spatial indexes. In our talk, we will also show real world examples of using open source GIS data (open street map, zip codes, etc.) with MySQL and MongoDB, and demo some common queries.


Colin Charles's picture

Colin Charles

Chief Evangelist, Percona


Colin Charles is the Chief Evangelist at Percona. He was previously on the founding team of MariaDB Server in 2009, and had worked at MySQL since 2005, and been a MySQL user since 2000. Before joining MySQL, he worked actively on the Fedora and projects. He's well known within open source communities in APAC, and has spoken at many conferences.

Share this talk