https://community.developer.cybersource.com/t5/Integration-and-Testing/MySQL-Ring-Buffer-Best-Practice/m-p/69187#M42264 <DIV class="_3xX726aBn29LDbsDtzr_6E _1Ap4F5maDtT1E1YuCiaO0r D3IL3FD0RFy_mkKLPwL4"><DIV class="_292iotee39Lmt0MkQZ2hPV RichTextJSON-root"><P class="_1qeIAgB0cPwnLhDF9XSiJM">Hi Everyone, 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></DIV></DIV><DIV class="_1hwEKkB_38tIoal6fcdrt9 "><DIV class="_3-miAEojrCvx_4FQ8x3P-s">&nbsp;</DIV></DIV> Sat, 21 Sep 2019 21:17:33 GMT LarianBretto 2019-09-21T21:17:33Z https://community.developer.cybersource.com/t5/Integration-and-Testing/MySQL-Ring-Buffer-Best-Practice/m-p/69187#M42264 <DIV class="_3xX726aBn29LDbsDtzr_6E _1Ap4F5maDtT1E1YuCiaO0r D3IL3FD0RFy_mkKLPwL4"><DIV class="_292iotee39Lmt0MkQZ2hPV RichTextJSON-root"><P class="_1qeIAgB0cPwnLhDF9XSiJM">Hi Everyone, 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></DIV></DIV><DIV class="_1hwEKkB_38tIoal6fcdrt9 "><DIV class="_3-miAEojrCvx_4FQ8x3P-s">&nbsp;</DIV></DIV> Sat, 21 Sep 2019 21:17:33 GMT https://community.developer.cybersource.com/t5/Integration-and-Testing/MySQL-Ring-Buffer-Best-Practice/m-p/69187#M42264 LarianBretto 2019-09-21T21:17:33Z