Creating Geo Enabled Applications with MySQL 5.6

Developing Applications
3 April 2:00PM - 2:50PM @ Ballroom B

Experience level: 
Intermediate
Duration: 
50 minutes conference
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 point of interests (i.e. coffee shops) around (i.e. 10 miles radius) the given location (latitude and longitude). * Find a ZIP code (US Postal Address) for the given location or determine if this location is within the given area. In this talk I will show how to: * Use MySQL 5.6 new features to store location information (latitude/longitude, polygons, etc) * Perform effective geo search with MySQL 5.6 * Use Spatial (RTREE) indexes as well as utilize normal indexes for the effective spatial search on Earth surface * Difference between old spatial functions (based on minimum bounding rectangle) and the new spatial functions (based on exact shape calculations) * Using Sphinx Search for geo spatial search


Speakers

Principal Consultant, 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, reporting, database infrastructure scale-outs and datawarehouses. He has helped many MySQL customers design extremely high performance databases with optimized schema and queries.

Slides