cancel
Showing results for 
Search instead for 
Did you mean: 

MySQL Ring Buffer Best Practice!!

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). 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.

opleinew
Member
1 REPLY 1

Awesome.

Thanks.

liteblue

 

opleinew
Member