Since 1997, the APRS Internet System has been collecting APRS data from around the world. The purpose behind this system was to link all the various local RF networks into a single real-time wide area network. The system has been successful beyond my wildest dreams, with hundreds of simultaneous users and thousands of stations reporting, the system handles about one million packets a day. While the original design for this system stored a single position and weather report for each station, there was no provision for any longer-term storage of the data.
The findU system adresses this shortcoming. Each incoming packet is parsed by a Perl script and stored in a MySQL database, currently occupying over 77 GB. Perl CGI's are used to access the database and dynamically generate web pages.
This web site uses a loaded Dell PowerEdge 2650 Dual Xeon computer hosted at a colocation site in New Jersey, with a similar live backup server hosted in Texas.
email questions and comments to Steve Dimse steve@dimse.com.