Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

MySQL 5.7, 8.0 and MongoDB: Geospatial Introduction

MySQL 5.7, 8.0 and MongoDB: Geospatial Introduction

 26 April - 11:10 AM - 12:00 PM @ Ballroom H
Experience level: 
Intermediate
Duration: 
50 minutes conference
Tracks:
Developer
Wildcard
Topics:
MySQL
MongoDB

Description

The goal of the talk is to review the GIS improvements in MySQL 5.7 and new additions in MySQL 8.0 (new this year!), 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 8.0) 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.

Speakers

Alexander Rubin's picture

Alexander Rubin

Principal Architect, Percona

Biography:

Alexander has over 10 years industry experience with the MySQL database and related technologies. His specialties are performance tuning, full text search, high availability, database infrastructure architecture and data warehouses. He has helped many MySQL customers design extremely high performance databases with optimized schema and queries.

Michael Benshoof's picture

Michael Benshoof

Technical Account Manager, Percona

Biography:

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://okcmysql.org) ​and loves to expose people to the power of Open Source software.

Share this talk