How often did you download your production database to your development machine? And how often did you write a script for that? You’re first dumping your MySQL production database – easy. Then you download it with scp or ftp or … Continued
If you have loads of continuous data which you have to store and at the same time it is o.k. if old data gets removed after a while, a round robin database is your choice. Those databases allow the user to define a maximum number of records (or maximum number of storage space) and new data that would not fit into the allocated space, will simply overwrite the oldest record in the database. Basically a ring buffer on disk. The database won’t grow indefinitely and you don’t have to do extensive maintenance tasks.