Round Robin Database with MySQL

posted in: database, mysql | 0

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.