P016C

Database Bin Logs

Description

This patch fixes two database reliability and storage problems on the database node. First, MariaDB's binary logs were not being purged, so they accumulated over time and could eventually fill up the volume. This patch enables purging so old binary logs are cleaned up automatically going forward. Second, the binary logs were being written to network storage instead of the database node's local disk. This patch moves them onto the local EBS data volume, which is faster and more reliable for this kind of write-heavy log. The existing binary log directory on network storage is preserved as a backup rather than deleted, and the change is made to persist across instance replacements.

Impact

There is a short database interruption on the database node. The database is restarted once to move the binary logs onto local disk and apply the new purge setting, so the site is briefly unavailable while the database comes back up.

Changes

• Enables binary log purging so old logs are cleaned up automatically.
• Moves the database binary logs from network storage onto the database node's local disk.
• Keeps the previous binary logs as a backup instead of deleting them.
• Persists both changes so they stay in place across instance replacements.

If You Accept

Binary log purging is enabled and the logs no longer accumulate without bound. The binary logs live on faster, more reliable local disk, and the log volume stops filling up.

If You Reject

Binary logs keep accumulating without being purged and remain on network storage, so the volume can continue to fill and there is a risk of running out of space.