MyFirstPC:$ ssh db1108.eqiad.wmnet Linux db1108 4.19.0-9-amd64 #1 SMP Debian 4.19.118-2+deb10u1 (2020-06-07) x86_64 Debian GNU/Linux 10 (buster) db1108 is a Backup Analytics Multiinstance Databases (mariadb::misc::analytics::backup) The last Puppet run was at Fri Jul 31 08:44:01 UTC 2020 (11 minutes ago). Last puppet commit: (eb4ac7c5be) Jaime Crespo - mariadb: Increase analytics binlog retention time to 14 days Debian GNU/Linux 10 auto-installed on Wed Jun 24 16:23:57 UTC 2020. Last login: Fri Jul 31 08:44:15 2020 from 2620:0:862:1:91:198:174:60 jynus@db1108:~$ sudo -s root@db1108:~$ run-puppet-agent Info: Using configured environment 'production' Info: Retrieving pluginfacts Info: Retrieving plugin Info: Retrieving locales Info: Loading facts Info: Caching catalog for db1108.eqiad.wmnet Info: Applying configuration version '(b9f066737c) Jaime Crespo - mariadb: Increase misc db binlog retention to 14 days' Notice: /Stage[main]/Mariadb::Config/File[/etc/my.cnf]/content: --- /etc/my.cnf 2020-07-02 07:33:58.030362178 +0000 +++ /tmp/puppet-file20200731-16714-7yior1 2020-07-31 08:55:50.951563504 +0000 @@ -43,7 +43,7 @@ binlog_cache_size = 1M max_binlog_size = 1000M binlog_format = -expire_logs_days = 7 +expire_logs_days = 14 slave_transaction_retries = 4294967295 table_open_cache = 5000 Info: Computing checksum on file /etc/my.cnf Info: /Stage[main]/Mariadb::Config/File[/etc/my.cnf]: Filebucketed /etc/my.cnf to puppet with sum 3de49fae2016c9ef773fa4616cdd042f Notice: /Stage[main]/Mariadb::Config/File[/etc/my.cnf]/content: content changed '{md5}3de49fae2016c9ef773fa4616cdd042f' to '{md5}401fd5cfd3e47f42af1c570866061196' Notice: Applied catalog in 11.20 seconds root@db1108:~$ my matomo Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 564 Server version: 10.4.13-MariaDB-log MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. root@db1108[(none)]> SET GLOBAL expire_logs_days=14; Query OK, 0 rows affected (0.000 sec) root@db1108[(none)]> Bye root@db1108:~$ my analytics_meta Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 571 Server version: 10.4.13-MariaDB-log MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. root@db1108[(none)]> SET GLOBAL expire_logs_days=14; Query OK, 0 rows affected (0.000 sec)