Percona Live: Data Performance Conference 2016 Logo

April 18-21, 2016

Santa Clara, California

MySQL 5.7 and MongoDB: Geospatial Introduction

MySQL 5.7 and MongoDB: Geospatial Introduction

 19 April 3:50 PM - 04:40 PM @ Ballroom B
Experience level: 
50 minutes conference


The goal of the talk is to review the GIS improvements in MySQL 5.7, provide some general review of the functionality, as well as some working demos. We'll also have a high-level review of MongoDB's GIS functionality, and discuss the pros/cons between MySQL and MongoDB and how you can use them in conjunction. Attendee takeaway: - 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 a new functions to calculate the distance between points. MongoDB also support GIS functions and spatial indexes. In our talk we will also show the real world examples of using open source GIS data (open street map, zip codes, etc.) with MySQL and MongoDB and demo some common queries.


Alexander Rubin's picture

Alexander Rubin

Principal Consultant, Percona


Alexander joined Percona in 2013. Alexander worked with MySQL since 2000 as DBA and Application Developer. Before joining Percona he was doing MySQL consulting as a principal consultant for over 7 years (started with MySQL AB in 2006, then Sun Microsystems and then Oracle). He helped many customers design large, scalable and highly available MySQL systems and optimize MySQL performance. Alexander also helped customers design Big Data stores with Apache Hadoop and related technologies.

Michael Benshoof's picture

Michael Benshoof

Technical Account Manager, Percona


Mike is a Technical Account Manager with Percona and specializes in performance tuning and architecture/application design leveraging open source systems. His background is in the web development space, but he has several years of experience as a MySQL DBA and consultant as well. Mike founded and continues to lead the Oklahoma City MySQL User Group (h​ttp:// ​and loves to expose people to the power of Open Source software.

Share this talk