Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
03-07-2020 06:09 AM
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-09-2020 07:53 AM

