Geo Distance Search with MySQL

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