Scaling a MySQL Geospatial Database
Storing and retrieving GPS tracks on the web.
Join the Garmin guys in a discussion about how they are using MySQL to store loads of GPS tracks sent by customers around the world. Talk about the possibilities of using the MySQL spatial extensions and the need for a more robust implementation.
MotionBased is currently running on a single MySQL database that has grown to 1/2 terabyte and needs to be clustered/partitioned for better scalability. Discuss possible criteria for partitioning the data and how to best run geospatial queries across partitions.
The problem goes beyond just geospatial information since many GPS devices are now recording much more than just location, elevation and time. Review the proposed schema that will handle varying types of data that is optionally provided by the portable hardware.
Participants
*Aaron Roller
*Brad Scheppler
*Jason Holmes
Sources
Comments (0)
You don't have permission to comment on this page.