https://community.developer.cybersource.com/t5/Integration-and-Testing/MySQL-Ring-Buffer-Best-Practice/m-p/70983#M43666 <P>Awesome.</P><P>Thanks.</P><P><FONT color="#000000"><A href="https://liteblue.guru/" target="_self">liteblue</A></FONT></P><P>&nbsp;</P> Mon, 09 Mar 2020 14:53:33 GMT opleinew 2020-03-09T14:53:33Z https://community.developer.cybersource.com/t5/Integration-and-Testing/MySQL-Ring-Buffer-Best-Practice/m-p/70951#M43635 <P>Hello,</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>Regards.</P> Sat, 07 Mar 2020 14:09:30 GMT https://community.developer.cybersource.com/t5/Integration-and-Testing/MySQL-Ring-Buffer-Best-Practice/m-p/70951#M43635 opleinew 2020-03-07T14:09:30Z https://community.developer.cybersource.com/t5/Integration-and-Testing/MySQL-Ring-Buffer-Best-Practice/m-p/70983#M43666 <P>Awesome.</P><P>Thanks.</P><P><FONT color="#000000"><A href="https://liteblue.guru/" target="_self">liteblue</A></FONT></P><P>&nbsp;</P> Mon, 09 Mar 2020 14:53:33 GMT https://community.developer.cybersource.com/t5/Integration-and-Testing/MySQL-Ring-Buffer-Best-Practice/m-p/70983#M43666 opleinew 2020-03-09T14:53:33Z