Page MenuHomePhabricator
Paste P12131

update options in a hot way
ActivePublic

Authored by jcrespo on Fri, Jul 31, 8:57 AM.
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)

Event Timeline

jcrespo created this paste.Fri, Jul 31, 8:57 AM