MariaDB supports a table storage engine that writes a read-only copy of the table to s3. (I can’t add links because I’m a new user, but see “Using the S3 Storage Engine” on the MariaDB homepage). This seems like an ideal way to back up Matomo data and reports, freeing up space on the database server while still keeping the report data accessible.
First, what is the date cutoff where the matomo_archive_blob_ and matomo_archive_numeric_ tables are read-only (e.g. Matomo will no longer write to them)? Does the January table keep getting writes until the year 2025 is over?
Second, the big tables matomo_log_link_visit_action, matomo_log_visit and matomo_log_action could potentially be partitioned with old dates archived to s3. Is there any sort of script available to manage the partitioning of those tables? This seems like a useful thing to be included in the Matomo core.