https://community.developer.cybersource.com/t5/Integration-and-Testing/MySQL-Ring-Buffer-Best-Practice/m-p/70178#M43043 <P><SPAN>Hello, </SPAN></P><P>&nbsp;</P><P><SPAN>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 <A href="https://www.liteblue.buzz" target="_self">Liteblue</A>). After the ring buffer it’s implemented I intend to replicate my database in azure so that I have both local and cloud versions.</SPAN></P><P>&nbsp;</P><P><SPAN>Regards.</SPAN></P> Thu, 02 Jan 2020 05:40:42 GMT Elizabeth_D 2020-01-02T05:40:42Z https://community.developer.cybersource.com/t5/Integration-and-Testing/MySQL-Ring-Buffer-Best-Practice/m-p/70178#M43043 <P><SPAN>Hello, </SPAN></P><P>&nbsp;</P><P><SPAN>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 <A href="https://www.liteblue.buzz" target="_self">Liteblue</A>). After the ring buffer it’s implemented I intend to replicate my database in azure so that I have both local and cloud versions.</SPAN></P><P>&nbsp;</P><P><SPAN>Regards.</SPAN></P> Thu, 02 Jan 2020 05:40:42 GMT https://community.developer.cybersource.com/t5/Integration-and-Testing/MySQL-Ring-Buffer-Best-Practice/m-p/70178#M43043 Elizabeth_D 2020-01-02T05:40:42Z