Geo Distance Search with MySQL

Architecture and Technology
Location: Ballroom H Level: Intermediate

Geo distance / proximity search is a very common task in social networking (and other Web 2.0) applications. An examples of geo distance search can be:

  • For the given user, find all users that have the similar interests and live near by (in 50 miles radius)
  • For the given user, find show times in all theaters in the 20 miles radius
  • Find the list of shops near the given zip code

And much more.

From this presentation you will know:

  1. How to perform geo distance searches with MySQL
  2. How to tune you geo distance query
  3. An example of stored procedure in MySQL that can perform quick geo distance search
  4. What is Haversine formula and how to use it with Geo Search
  5. How to use spartial indexes (RTREE) to store geo data in MySQL
  6. How to use sphinx search to perform Geo Distance search

Alexander Rubin


Alexander Rubin is a Principle MySQL Consultant Oracle.
Alexander has over 10 years industry experience with the MySQL database, and specializes in performance tuning, full text search, high availability and the scale-out of database infrastructures.

  • Kickfire
  • Zmanda, Inc.
  • Continuent
  • EDS
  • JasperSoft
  • Sun Microsystems
  • Symantec Anti-Virus Software
  • XAware
  • Data Direct Technologies
  • Dolphin Interconnect Solutions
  • Hewlett Packard
  • Infobright, Inc
  • Linagora
  • Microsoft
  • OpSource
  • Oracle
  • Pentaho
  • R1Soft
  • Red Hat
  • Ticketmaster
  • TechRepublic

Contact Us

View a complete list of MySQL contacts.