Alexander Rubin

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.

Sessions

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.