Creating Geo Enabled Applications with MySQL 5.6

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

Experience level: 
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


Principal Architect, Percona
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.