Alexander Rubin

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


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.