Reply
Highlighted
Member
Posts: 1
Registered: ‎01-01-2020

MySQL Ring Buffer Best Practice!!

[ Edited ]

Hello,

 

I have just installed MySQL Community Server on a windows machine, I’ve created a table and I am inserting a row every second. At this stage I have not gone live so I can still change pretty much anything I need to. One of the requirements is that I retain the last 14 days of data so I believe I want to implement a ring buffer, ideally the database would look after the ring buffer itself(i.e the removal of ‘old’ rows Liteblue). After the ring buffer it’s implemented I intend to replicate my database in azure so that I have both local and cloud versions.

 

Regards.