https://community.developer.cybersource.com/t5/Integration-and-Testing/MySQL-Ring-Buffer-Best-Practice/m-p/69503#M42509 <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> Thu, 24 Oct 2019 12:59:28 GMT liamgasoline 2019-10-24T12:59:28Z https://community.developer.cybersource.com/t5/Integration-and-Testing/MySQL-Ring-Buffer-Best-Practice/m-p/69503#M42509 <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> Thu, 24 Oct 2019 12:59:28 GMT https://community.developer.cybersource.com/t5/Integration-and-Testing/MySQL-Ring-Buffer-Best-Practice/m-p/69503#M42509 liamgasoline 2019-10-24T12:59:28Z