https://www.percona.com/blog/how-to-store-mysql-audit-logs-in-mongodb-in-a-maintenance-free-setup/ Sat, 17 Feb 2024 01:08:31 +0000 hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/how-to-store-mysql-audit-logs-in-mongodb-in-a-maintenance-free-setup/#comment-10972952 Fri, 15 Jan 2021 14:04:44 +0000 https://www.percona.com/blog/?p=73560#comment-10972952 A very good point Kay, thanks for the feedback!

]]> https://www.percona.com/blog/how-to-store-mysql-audit-logs-in-mongodb-in-a-maintenance-free-setup/#comment-10972951 Fri, 15 Jan 2021 09:48:38 +0000 https://www.percona.com/blog/?p=73560#comment-10972951 Smart workaround by using FluentD, thanks for the tip! 🙂
However, be aware that the max size of your mongodb capped collection is based on *uncompressed* data. So, if you have calculated to use 80% of your available hard disk, your disk may run out of space in case your log data becomes less compressible. We encountered such an issue in production recently. I wrote a blog post how we could avert the imminent disaster without downtime: https://medium.com/idealo-tech-blog/mission-possible-resize-mongodb-capped-collections-without-downtime-ec8aada2223f

]]>