Round Robin Data Storage in MySQL - Tilllate Techblog

If you want to store large amount of volatile data (e.g. log file entries) in a database with a constant storage memory footprint and no maintenance to purge the old entries, a round robin database is the best solution.

But how to implement it in MySQL?

Some of the heaviest tables in our database are tables which do some event logging.

Let’s look at a table which log the most recent visitors on a member profile. Look...