Round-Robin DB with MySQL?

[Jan Lemmermann]

Hi MySQL Friends,

I'm not sure if the NEWBIE forum is the best for this topic but since I feel like
a MySQL Newbie I suppose it fits.

I have a To-Do on my worklist where I have to setup some kind of Round-Robin DB with
MySQL. The database should consist of 3x tables (tbl_today, tbl_today-1 and tbl_today-2). Every day an application on another machine will insert fresh new data into tbl_today (STEP 4).

I would like to setup the following procedure now:

STEP 1: All the data within tbl_today-2 gets purged. The table is empty.
STEP 2: All the data from tbl_today-1 gets moved to tbl_today-2.
tbl_today-1 is now empty.
STEP 3: All the data from tbl_today gets moved to tbl_today.
tbl_today is now empty.
STEP 4: The application inserts new data to tbl_today.

Has anyone setup something like this or ever had to build-up such a configuration?
What would be the basis for such a (let's call it Round-Robin because it reminds me of a RR-Database) DB? Triggers, Scheduled Events, Something-Completely-Different?

Any help is appreciated.
Thanks and bye
Lemmy