Compilation results for db2250.codfw.wmnet: System changes detected
You can retrieve this result from host.json.Catalog differences
Summary
| Total Resources: | 2810 |
|---|---|
| Resources added: | 253 |
| Resources removed: | 5 |
| Resources modified: | 258 |
| Change percentage: | 18.36% |
Resources only in the new catalog
- Concat_file[/etc/mysql/ssl/cert.pem]
- Class[Mariadb::Monitor_disk]
- File[/etc/rsyslog.d/25-nrpe2nodexp-mariadb-replica-io-state-s1.conf]
- File[/etc/wmfmariadbpy]
- Package[mariadb-backup]
- Systemd::Unit[nrpe2nodexp-mariadb_replica_io_state_s1.service]
- File[/lib/systemd/system/nrpe2nodexp-mariadb_read_only_s1.timer]
- Systemd::Unit[nrpe2nodexp-mariadb_disk_space.service]
- File[/var/lib/prometheus/node.d/check_mariadb_replica_sql_state_s1.prom]
- Sudo::User[nrpe-check_mysqld]
- File[/etc/systemd/system/mariadb.service.d]
- Class[Mariadb::Service]
- Monitoring::Service[mariadb_memory]
- Mariadb::Monitor_readonly[s1]
- Concat::Fragment[/etc/mysql_puppet_agent_cert]
- File[/lib/systemd/system/nrpe2nodexp-mariadb_memory.timer]
- File[/lib/systemd/system/nrpe2nodexp-mariadb_replica_io_state_s1.service]
- Systemd::Timer[nrpe2nodexp-mariadb_disk_space]
- Concat_fragment[/etc/mysql_puppet_ca_chain]
- File[/etc/mysql/ssl/server.key]
- Prometheus::Alert::Rule[check_mariadb_disk_space_d2aae7bfec5549be1a8b9413215bd86c]
- Monitoring::Service[mysqld]
- Systemd::Timer::Job[nrpe2nodexp-mariadb_replica_io_state_s1]
- Systemd::Unit[wmf_auto_restart_prometheus-mysqld-exporter@s1.service]
- File[/usr/local/etc/my.cnf]
- Nrpe::Monitor_service[mariadb_replica_sql_lag_s1]
- Systemd::Unit[nrpe2nodexp-mariadb_replica_io_state_s1.timer]
- Systemd::Timer::Job[nrpe2nodexp-mariadb_replica_sql_lag_s1]
- Monitoring::Exported_nagios_service[db2250 mariadb_replica_sql_lag_s1]
- Systemd::Service[nrpe2nodexp-mariadb_read_only_s1]
- Exec[systemd daemon-reload for nrpe2nodexp-mariadb_replica_io_state_s1.service (nrpe2nodexp-mariadb_replica_io_state_s1.service)]
- Monitoring::Service[mariadb_replica_io_state_s1]
- File[/etc/sudoers.d/nrpe-check_mariadb_read_only_s1]
- Systemd::Timer[nrpe2nodexp-mariadb_replica_io_state_s1]
- Service[nrpe2nodexp-mariadb_replica_sql_lag_s1.timer]
- Rsyslog::Conf[nrpe2nodexp-mariadb_replica_sql_lag_s1]
- Exec[systemd daemon-reload for nrpe2nodexp-mariadb_disk_space.timer (nrpe2nodexp-mariadb_disk_space.timer)]
- Exec[systemd daemon-reload for nrpe2nodexp-mariadb_memory.service (nrpe2nodexp-mariadb_memory.service)]
- Package[wmf-mariadb1011]
- File[/etc/nagios/nrpe.d/check_mariadb_read_only_s1.cfg]
- File[/etc/nagios/nrpe.d/check_mysqld.cfg]
- Systemd::Unit[nrpe2nodexp-mariadb_replica_sql_lag_s1.service]
- Sudo::User[nrpe-check_mariadb_memory]
- Systemd::Timer[nrpe2nodexp-mariadb_read_only_s1]
- File[/etc/rsyslog.d/25-nrpe2nodexp-mariadb-read-only-s1.conf]
- File[/lib/systemd/system/nrpe2nodexp-mariadb_memory.service]
- Exec[systemd daemon-reload for wmf_auto_restart_prometheus-mysqld-exporter@s1.service (wmf_auto_restart_prometheus-mysqld-exporter@s1.service)]
- Sudo::User[nrpe-check_mariadb_disk_space]
- File[/lib/systemd/system/nrpe2nodexp-mariadb_replica_sql_state_s1.service]
- Systemd::Timer[nrpe2nodexp-mariadb_memory]
- Exec[systemctl try-restart prometheus-mysqld-exporter@s1]
- Rsyslog::Conf[wmf_auto_restart_prometheus-mysqld-exporter_s1]
- Systemd::Timer::Job[nrpe2nodexp-mariadb_read_only_s1]
- Exec[systemd daemon-reload for nrpe2nodexp-mariadb_read_only_s1.service (nrpe2nodexp-mariadb_read_only_s1.service)]
- Mariadb::Monitor_replication[s1]
- Motd::Message[mariadb::backup_source]
- Systemd::Unit[nrpe2nodexp-mysqld.service]
- Concat::Fragment[/etc/mysql_puppet_ca_chain]
- Nrpe::Check[check_mariadb_replica_sql_state_s1]
- Exec[systemd daemon-reload for nrpe2nodexp-mariadb_replica_sql_state_s1.timer (nrpe2nodexp-mariadb_replica_sql_state_s1.timer)]
- Rsyslog::Conf[nrpe2nodexp-mariadb_read_only_s1]
- File[/var/lib/prometheus/node.d/check_mariadb_replica_sql_lag_s1.prom]
- File[/etc/rsyslog.d/25-nrpe2nodexp-mariadb-memory.conf]
- User[mysql]
- Systemd::Timer::Job[nrpe2nodexp-mariadb_memory]
- File[/lib/systemd/system/nrpe2nodexp-mariadb_read_only_s1.service]
- File[/etc/update-motd.d/06-db-section-s1]
- Service[nrpe2nodexp-mariadb_disk_space.timer]
- Exec[systemd daemon-reload for nrpe2nodexp-mysqld.timer (nrpe2nodexp-mysqld.timer)]
- File[/var/lib/prometheus/node.d/check_mariadb_read_only_s1.prom]
- Prometheus::Alert::Rule[check_mariadb_replica_sql_state_s1_3f927914a18db09399b7fff42858d634]
- File[/etc/mysql/ssl/server-cert.pem]
- File[/etc/rsyslog.d/25-nrpe2nodexp-mariadb-replica-sql-lag-s1.conf]
- Systemd::Service[nrpe2nodexp-mariadb_replica_io_state_s1]
- Nrpe::Check[check_mariadb_replica_io_state_s1]
- Nrpe::Monitor_service[mariadb_replica_sql_state_s1]
- Ferm::Service[s1_orchestrator]
- Class[Profile::Mariadb::Dbstore_multiinstance]
- Monitoring::Service[mariadb_replica_sql_lag_s1]
- Package[percona-toolkit]
- Prometheus::Alert::Rule[check_mysqld_ca81db2c9e98d408f9f65c79817da116]
- Exec[systemd daemon-reload for nrpe2nodexp-mariadb_replica_sql_state_s1.service (nrpe2nodexp-mariadb_replica_sql_state_s1.service)]
- File[/etc/update-motd.d/05-mariadb--backup-source]
- Systemd::Syslog[wmf_auto_restart_prometheus-mysqld-exporter_s1]
- Exec[systemd daemon-reload for nrpe2nodexp-mariadb_disk_space.service (nrpe2nodexp-mariadb_disk_space.service)]
- File[/etc/sudoers.d/nrpe-check_mariadb_memory]
- Systemd::Service[nrpe2nodexp-mysqld]
- Rsyslog::Conf[nrpe2nodexp-mysqld]
- Systemd::Timer[wmf_auto_restart_prometheus-mysqld-exporter@s1]
- Prometheus::Mysqld_exporter::Instance[s1]
- Service[nrpe2nodexp-mariadb_read_only_s1.timer]
- Nrpe::Monitor_service[mariadb_read_only_s1]
- File[/usr/local/bin/mbstream]
- File[/lib/systemd/system/nrpe2nodexp-mysqld.timer]
- Systemd::Timer::Job[nrpe2nodexp-mariadb_disk_space]
- Systemd::Timer::Job[wmf_auto_restart_prometheus-mysqld-exporter@s1]
- File[/etc/rsyslog.d/25-nrpe2nodexp-mariadb-replica-sql-state-s1.conf]
- File[/etc/mysql/ssl/cacert.pem]
- Rsyslog::Conf[nrpe2nodexp-mariadb_disk_space]
- Rsyslog::Conf[nrpe2nodexp-mariadb_replica_sql_state_s1]
- Systemd::Timer::Job[nrpe2nodexp-mysqld]
- Systemd::Timer[nrpe2nodexp-mariadb_replica_sql_state_s1]
- Package[wmfmariadbpy-common]
- Node[__node_regexp__db2250.codfw.]
- Package[prometheus-mysqld-exporter]
- File[/etc/mysql/ssl/client-cert.pem]
- File[/etc/mysql/mysqld.conf.d/s1.cnf]
- Class[Mariadb::Monitor_memory]
- Service[nrpe2nodexp-mariadb_replica_io_state_s1.timer]
- File[/var/lib/prometheus/.my.s1.cnf]
- File[/etc/mysql]
- Nrpe::Monitor_service[mysqld]
- File[/etc/nagios/nrpe.d/check_mariadb_replica_sql_state_s1.cfg]
- Systemd::Service[nrpe2nodexp-mariadb_disk_space]
- File[/var/lib/prometheus/node.d/check_mysqld.prom]
- File[/etc/rsyslog.d/25-nrpe2nodexp-mariadb-disk-space.conf]
- Concat[/etc/mysql/ssl/cert.pem]
- Prometheus::Alert::Rule[check_mariadb_replica_sql_lag_s1_8ec9d6c1155ae60699aaf9dfd1fa339b]
- File[/usr/local/lib/nagios/plugins/check_mariadb]
- File[/srv/sqldata.s1]
- File[/usr/lib/nagios/plugins/check_mariadb.pl]
- File[/var/lib/prometheus/node.d/check_mariadb_disk_space.prom]
- Nrpe::Check[check_mariadb_memory]
- Package[monitoring-plugins-contrib]
- File[/etc/mysql/ssl/server-keypair.pem]
- Systemd::Unit[nrpe2nodexp-mariadb_memory.timer]
- Monitoring::Exported_nagios_service[db2250 mariadb_replica_sql_state_s1]
- Service[nrpe2nodexp-mariadb_replica_sql_state_s1.timer]
- File_line[auto_restart_file_presence_prometheus-mysqld-exporter@s1]
- File[/lib/systemd/system/nrpe2nodexp-mariadb_replica_sql_state_s1.timer]
- File[/lib/systemd/system/nrpe2nodexp-mariadb_disk_space.service]
- Nrpe::Check[check_mariadb_read_only_s1]
- Systemd::Service[nrpe2nodexp-mariadb_replica_sql_lag_s1]
- Monitoring::Exported_nagios_service[db2250 mariadb_memory]
- Systemd::Unit[nrpe2nodexp-mysqld.timer]
- Prometheus::Alert::Rule[check_mariadb_replica_io_state_s1_0d5979f7abbb49256cfedd70a646784e]
- File[/etc/default/prometheus-mysqld-exporter@s1]
- File[/etc/rsyslog.d/40-wmf-auto-restart-prometheus-mysqld-exporter-s1.conf]
- File[/usr/local/bin/mysql.s1]
- Systemd::Timer[nrpe2nodexp-mariadb_replica_sql_lag_s1]
- File[/srv/tmp.s1]
- Exec[systemd daemon-reload for nrpe2nodexp-mariadb_replica_sql_lag_s1.service (nrpe2nodexp-mariadb_replica_sql_lag_s1.service)]
- Class[Prometheus::Mysqld_exporter::Common]
- Nrpe::Check[check_mysqld]
- Nrpe::Check[check_mariadb_disk_space]
- Systemd::Unit[nrpe2nodexp-mariadb_replica_sql_lag_s1.timer]
- Prometheus::Alert::Rule[check_mariadb_read_only_s1_42baf529e0f3bfca391aca0a24c880e9]
- Exec[systemd daemon-reload for nrpe2nodexp-mariadb_replica_io_state_s1.timer (nrpe2nodexp-mariadb_replica_io_state_s1.timer)]
- File[/etc/wmfmariadbpy/section_ports.csv]
- Logrotate::Conf[wmf_auto_restart_prometheus-mysqld-exporter_s1]
- File[/lib/systemd/system/prometheus-mysqld-exporter@.service]
- Systemd::Unit[nrpe2nodexp-mariadb_replica_sql_state_s1.service]
- File[/var/lib/prometheus/node.d/check_mariadb_replica_io_state_s1.prom]
- Systemd::Unit[wmf_auto_restart_prometheus-mysqld-exporter@s1.timer]
- Class[Mariadb::Config]
- Sudo::User[nrpe-check_mariadb_replica_sql_state_s1]
- File[/etc/sudoers.d/nrpe-check_mariadb_replica_io_state_s1]
- Monitoring::Exported_nagios_service[db2250 mariadb_disk_space]
- File[/etc/sudoers.d/nrpe-check_mysqld]
- File[/etc/mysql/ssl/server.p12]
- Mariadb::Instance[s1]
- Systemd::Service[wmf_auto_restart_prometheus-mysqld-exporter@s1]
- Rsyslog::Conf[nrpe2nodexp-mariadb_memory]
- File[/etc/sudoers.d/nrpe-check_mariadb_replica_sql_state_s1]
- Class[Profile::Mariadb::Mysql_role]
- File[/etc/ferm/conf.d/10_s1_mariadb_dba]
- File[/etc/nagios/nrpe.d/check_mariadb_disk_space.cfg]
- File[/etc/rsyslog.d/25-nrpe2nodexp-mysqld.conf]
- File[/etc/my.cnf]
- Package[grc]
- Exec[systemd daemon-reload for nrpe2nodexp-mariadb_replica_sql_lag_s1.timer (nrpe2nodexp-mariadb_replica_sql_lag_s1.timer)]
- Service[wmf_auto_restart_prometheus-mysqld-exporter@s1.timer]
- Systemd::Timer[nrpe2nodexp-mysqld]
- File[/etc/systemd/system/mariadb.service.d/override.conf]
- Nrpe::Plugin[check_mariadb]
- Profile::Mariadb::Ferm[s1]
- Sudo::User[nrpe-check_mariadb_read_only_s1]
- File[/lib/systemd/system/nrpe2nodexp-mysqld.service]
- Monitoring::Exported_nagios_service[db2250 mariadb_replica_io_state_s1]
- File[/etc/mysql/grcat.config]
- Systemd::Service[nrpe2nodexp-mariadb_memory]
- File[/lib/systemd/system/nrpe2nodexp-mariadb_replica_io_state_s1.timer]
- File[/lib/systemd/system/wmf_auto_restart_prometheus-mysqld-exporter@s1.service]
- Exec[systemd daemon-reload for nrpe2nodexp-mariadb_memory.timer (nrpe2nodexp-mariadb_memory.timer)]
- File[/etc/sudoers.d/nrpe-check_mariadb_replica_sql_lag_s1]
- Class[Passwords::Nagios::Mysql]
- File[/opt/wmf-mariadb1011/my.cnf]
- File[/etc/ferm/conf.d/10_s1_mariadb_internal]
- Motd::Script[mariadb::backup_source]
- Exec[systemd daemon-reload for prometheus-mysqld-exporter@.service (prometheus-mysqld-exporter@)]
- File[/etc/mysql/my.cnf]
- Monitoring::Service[mariadb_read_only_s1]
- Nrpe::Monitor_service[mariadb_memory]
- File[/etc/nagios/nrpe.d/check_mariadb_replica_sql_lag_s1.cfg]
- File[/etc/mysql/mysqld.conf.d]
- Systemd::Unit[nrpe2nodexp-mariadb_disk_space.timer]
- File[/lib/systemd/system/nrpe2nodexp-mariadb_replica_sql_lag_s1.timer]
- Monitoring::Service[mariadb_replica_sql_state_s1]
- Group[mysql]
- File[/lib/systemd/system/nrpe2nodexp-mariadb_disk_space.timer]
- Monitoring::Exported_nagios_service[db2250 mysqld]
- File[/var/lib/prometheus/node.d/check_mariadb_memory.prom]
- Class[Mariadb::Monitor_process]
- Exec[systemd daemon-reload for nrpe2nodexp-mysqld.service (nrpe2nodexp-mysqld.service)]
- Service[nrpe2nodexp-mysqld.timer]
- Class[Mariadb::Packages_wmf]
- Nrpe::Monitor_service[mariadb_disk_space]
- Class[Profile::Mariadb::Packages_wmf]
- Monitoring::Exported_nagios_service[db2250 mariadb_read_only_s1]
- File[/etc/ferm/conf.d/10_s1_orchestrator]
- Class[Wmfmariadbpy]
- Systemd::Unit[nrpe2nodexp-mariadb_memory.service]
- Monitoring::Service[mariadb_disk_space]
- File[/var/log/wmf_auto_restart_prometheus-mysqld-exporter_s1]
- Ferm::Service[s1_mariadb_internal]
- Prometheus::Alert::Rule[check_mariadb_memory_b5a92c72542d5f0c031014e7a8db014e]
- Rsyslog::Conf[nrpe2nodexp-mariadb_replica_io_state_s1]
- Class[Role::Mariadb::Backup_source]
- File[/lib/systemd/system/wmf_auto_restart_prometheus-mysqld-exporter@s1.timer]
- Puppet::Expose_agent_certs[/etc/mysql]
- Profile::Auto_restarts::Service[prometheus-mysqld-exporter@s1]
- Sudo::User[nrpe-check_mariadb_replica_sql_lag_s1]
- Systemd::Unit[nrpe2nodexp-mariadb_read_only_s1.timer]
- File[/etc/mysql/ssl/server-key.pem]
- Motd::Script[db-section-s1]
- Systemd::Service[nrpe2nodexp-mariadb_replica_sql_state_s1]
- File[/etc/nagios/nrpe.d/check_mariadb_replica_io_state_s1.cfg]
- Class[Profile::Mariadb::Wmfmariadbpy]
- Systemd::Unit[prometheus-mysqld-exporter@]
- Nrpe::Monitor_service[mariadb_replica_io_state_s1]
- Firewall::Service[s1_orchestrator]
- Systemd::Timer::Job[nrpe2nodexp-mariadb_replica_sql_state_s1]
- Systemd::Unit[nrpe2nodexp-mariadb_read_only_s1.service]
- File[/etc/mysql/ssl/client-key.pem]
- Exec[systemctl-daemon-reload]
- Profile::Mariadb::Section[s1]
- Profile::Prometheus::Mysqld_exporter_instance[s1]
- Ferm::Service[s1_mariadb_dba]
- File[/etc/nagios/nrpe.d/check_mariadb_memory.cfg]
- File[/lib/systemd/system/nrpe2nodexp-mariadb_replica_sql_lag_s1.service]
- Service[nrpe2nodexp-mariadb_memory.timer]
- Exec[systemd daemon-reload for nrpe2nodexp-mariadb_read_only_s1.timer (nrpe2nodexp-mariadb_read_only_s1.timer)]
- Sudo::User[nrpe-check_mariadb_replica_io_state_s1]
- File[/etc/sudoers.d/nrpe-check_mariadb_disk_space]
- Nrpe::Check[check_mariadb_replica_sql_lag_s1]
- Systemd::Unit[nrpe2nodexp-mariadb_replica_sql_state_s1.timer]
- File[/etc/logrotate.d/wmf_auto_restart_prometheus-mysqld-exporter_s1]
- Concat_fragment[/etc/mysql_puppet_agent_cert]
- File[/etc/mysql/ssl]
- Sslcert::X509_to_pkcs12[puppet::expose_agent_cert: /etc/mysql]
- Exec[systemd daemon-reload for wmf_auto_restart_prometheus-mysqld-exporter@s1.timer (wmf_auto_restart_prometheus-mysqld-exporter@s1.timer)]
- File[/etc/default/prometheus]
- Package[python3-wmfmariadbpy]
Resources only in the old catalog
- Motd::Script[insetup::data_persistence_ferm]
- Motd::Message[insetup::data_persistence_ferm]
- Node[__node_regexp__db22505253.codfw.]
- Class[Role::Insetup::Data_persistence_ferm]
- File[/etc/update-motd.d/05-insetup--data-persistence-ferm]
Resources modified
- File[/lib/systemd/system/nrpe2nodexp-mariadb_read_only_s1.timer]
- Parameters differences:
--- File[/lib/systemd/system/nrpe2nodexp-mariadb_read_only_s1.timer].orig +++ File[/lib/systemd/system/nrpe2nodexp-mariadb_read_only_s1.timer] + group => root + notify => Exec[systemd daemon-reload for nrpe2nodexp-mariadb_read_only_s1.timer (nrpe2nodexp-mariadb_read_only_s1.timer)] + owner => root + mode => 0444 + ensure => absent
- Content differences:
--- /lib/systemd/system/nrpe2nodexp-mariadb_read_only_s1.timer.orig +++ /lib/systemd/system/nrpe2nodexp-mariadb_read_only_s1.timer @@ -0,0 +1,14 @@ +[Unit] +Description=Periodic execution of nrpe2nodexp-mariadb_read_only_s1.service + +[Timer] +Unit=nrpe2nodexp-mariadb_read_only_s1.service +# Accuracy sets the maximum time interval around the execution time we want to allow +AccuracySec=15sec +OnUnitInactiveSec=1min +OnActiveSec=1s +RandomizedDelaySec=60 +FixedRandomDelay=true + +[Install] +WantedBy=multi-user.target
- Mariadb::Monitor_readonly[s1]
- Parameters differences:
--- Mariadb::Monitor_readonly[s1].orig +++ Mariadb::Monitor_readonly[s1] + port => 3311 + read_only => 1 + is_critical => False + contact_group => admins
- Package[wmf-mariadb1011]
- Parameters differences:
--- Package[wmf-mariadb1011].orig +++ Package[wmf-mariadb1011] + ensure => installed + provider => apt
- Sudo::User[nrpe-check_mariadb_disk_space]
- Parameters differences:
--- Sudo::User[nrpe-check_mariadb_disk_space].orig +++ Sudo::User[nrpe-check_mariadb_disk_space] + privileges => [] + require => ['Class[Sudo]'] + ensure => absent + user => nagios + tag => nrpe::check
- File[/lib/systemd/system/nrpe2nodexp-mariadb_replica_sql_state_s1.service]
- Parameters differences:
--- File[/lib/systemd/system/nrpe2nodexp-mariadb_replica_sql_state_s1.service].orig +++ File[/lib/systemd/system/nrpe2nodexp-mariadb_replica_sql_state_s1.service] + group => root + notify => Exec[systemd daemon-reload for nrpe2nodexp-mariadb_replica_sql_state_s1.service (nrpe2nodexp-mariadb_replica_sql_state_s1.service)] + owner => root + mode => 0444 + ensure => absent
- Content differences:
--- /lib/systemd/system/nrpe2nodexp-mariadb_replica_sql_state_s1.service.orig +++ /lib/systemd/system/nrpe2nodexp-mariadb_replica_sql_state_s1.service @@ -0,0 +1,11 @@ +[Unit] +Description=execution of nrpe2nodexp for the check_mariadb_replica_sql_state_s1 command. +Documentation=https://wikitech.wikimedia.org/wiki/Monitoring/systemd_unit_state + +[Service] +Type=oneshot +User=nagios + +Group=prometheus-node-exporter +SyslogIdentifier=nrpe2nodexp-mariadb_replica_sql_state_s1 +ExecStart=-/usr/local/bin/nrpe2nodexp --alert-rule-hash "3f927914a18db09399b7fff42858d634" --timeout 10 --check-command "check_mariadb_replica_sql_state_s1"
- Rsyslog::Conf[wmf_auto_restart_prometheus-mysqld-exporter_s1]
- Parameters differences:
--- Rsyslog::Conf[wmf_auto_restart_prometheus-mysqld-exporter_s1].orig +++ Rsyslog::Conf[wmf_auto_restart_prometheus-mysqld-exporter_s1] + priority => 40 + require => File[/var/log/wmf_auto_restart_prometheus-mysqld-exporter_s1] + ensure => present + mode => 0444
- File[/etc/update-motd.d/06-db-section-s1]
- Parameters differences:
--- File[/etc/update-motd.d/06-db-section-s1].orig +++ File[/etc/update-motd.d/06-db-section-s1] + group => root + ensure => present + mode => 0555 + owner => root
- Content differences:
--- /etc/update-motd.d/06-db-section-s1.orig +++ /etc/update-motd.d/06-db-section-s1 @@ -0,0 +1,2 @@ +#!/bin/sh +echo 'DB section s1 (alias: mysql.s1)'
- Prometheus::Alert::Rule[check_mariadb_replica_sql_lag_s1_8ec9d6c1155ae60699aaf9dfd1fa339b]
- Parameters differences:
--- Prometheus::Alert::Rule[check_mariadb_replica_sql_lag_s1_8ec9d6c1155ae60699aaf9dfd1fa339b].orig +++ Prometheus::Alert::Rule[check_mariadb_replica_sql_lag_s1_8ec9d6c1155ae60699aaf9dfd1fa339b] + group => nrpechecks + summary => NRPE CHECK: MariaDB Replica Lag: s1 + severity => info + def_label_whitelst => ['team', 'severity'] + logs => https://logstash.wikimedia.org/app/dashboards#/view/2d343ac0-6df8-11f0-8e08-7fab0da52b33?_g=(filters:!((query:(match_phrase:(event.module:check_mariadb_replica_sql_lag_s1))),(query:(match_phrase:(host.name:{{$labels.instance|stripPort}}))))) + site => codfw + instance => ops + expr => (nagios_nrpe_check_result{alert_rule_hash="8ec9d6c1155ae60699aaf9dfd1fa339b",check_name="check_mariadb_replica_sql_lag_s1", status=~"(WARNING|CRITICAL)", severity=~"(warning|critical)"} > 0) * on (instance) group_left (team) role_owner + description => NRPE CHECK: MariaDB Replica Lag: s1 + dashboard => TODO + alert_name => nrpe_MariaDB_Replica_Lag__s1 + team => observability + ensure => absent + runbook => https://wikitech.wikimedia.org/wiki/MariaDB/troubleshooting#Depooling_a_replica + for => 10m- File[/srv/sqldata.s1]
- Parameters differences:
--- File[/srv/sqldata.s1].orig +++ File[/srv/sqldata.s1] + group => mysql + ensure => directory + mode => 0755 + owner => mysql
- Systemd::Unit[nrpe2nodexp-mariadb_memory.timer]
- Parameters differences:
--- Systemd::Unit[nrpe2nodexp-mariadb_memory.timer].orig +++ Systemd::Unit[nrpe2nodexp-mariadb_memory.timer] + require => ['Class[Systemd]'] + override_filename => puppet-override.conf + override => False + unit => nrpe2nodexp-mariadb_memory.timer + restart => False + ensure => absent
- Nrpe::Check[check_mariadb_read_only_s1]
- Parameters differences:
--- Nrpe::Check[check_mariadb_read_only_s1].orig +++ Nrpe::Check[check_mariadb_read_only_s1] + before => Monitoring::Service[mariadb_read_only_s1] + ensure => present + command => db-check-health --port=3311 --icinga --check_read_only=1 --process
- File[/etc/sudoers.d/nrpe-check_mariadb_replica_io_state_s1]
- Parameters differences:
--- File[/etc/sudoers.d/nrpe-check_mariadb_replica_io_state_s1].orig +++ File[/etc/sudoers.d/nrpe-check_mariadb_replica_io_state_s1] + group => root + require => Package[nagios-nrpe-server] + ensure => absent + owner => root
- File[/etc/nagios/nrpe.d/check_mariadb_disk_space.cfg]
- Parameters differences:
--- File[/etc/nagios/nrpe.d/check_mariadb_disk_space.cfg].orig +++ File[/etc/nagios/nrpe.d/check_mariadb_disk_space.cfg] + group => root + require => Package[nagios-nrpe-server] + notify => Service[nagios-nrpe-server] + owner => root + mode => 0444 + ensure => present + tag => nrpe::check
- Content differences:
--- /etc/nagios/nrpe.d/check_mariadb_disk_space.cfg.orig +++ /etc/nagios/nrpe.d/check_mariadb_disk_space.cfg @@ -0,0 +1,2 @@ +# File generated by puppet. DO NOT edit by hand +command[check_mariadb_disk_space]=/usr/lib/nagios/plugins/check_disk -w 10% -c 5% -l -e --exclude-type=tracefs --exclude-type=tmpfs --exclude-type=ramfs --exclude-type=devtmpfs
- Nrpe::Plugin[check_mariadb]
- Parameters differences:
--- Nrpe::Plugin[check_mariadb].orig +++ Nrpe::Plugin[check_mariadb] + source => puppet:///modules/icinga/check_mariadb.pl + ensure => present
- Exec[systemd daemon-reload for nrpe2nodexp-mysqld.service (nrpe2nodexp-mysqld.service)]
- Parameters differences:
--- Exec[systemd daemon-reload for nrpe2nodexp-mysqld.service (nrpe2nodexp-mysqld.service)].orig +++ Exec[systemd daemon-reload for nrpe2nodexp-mysqld.service (nrpe2nodexp-mysqld.service)] + command => /bin/systemctl daemon-reload + refreshonly => True
- Firewall::Service[s1_orchestrator]
- Parameters differences:
--- Firewall::Service[s1_orchestrator].orig +++ Firewall::Service[s1_orchestrator] + proto => tcp + srange => ['dborch1001.wikimedia.org', 'dborch1002.wikimedia.org', 'dborch1003.eqiad.wmnet'] + ensure => present + port => [3311] + prio => 10 + notrack => True + desc =>
- Systemd::Timer::Job[nrpe2nodexp-mariadb_replica_sql_state_s1]
- Parameters differences:
--- Systemd::Timer::Job[nrpe2nodexp-mariadb_replica_sql_state_s1].orig +++ Systemd::Timer::Job[nrpe2nodexp-mariadb_replica_sql_state_s1] + logging_enabled => False + success_exit_status => [] + send_mail_only_on_error => True + description => execution of nrpe2nodexp for the check_mariadb_replica_sql_state_s1 command. + send_mail => False + user => nagios + monitoring_contact_groups => admins + monitoring_notes_url => https://wikitech.wikimedia.org/wiki/Monitoring/systemd_unit_state + private_tmp => False + splay => 60 + logfile_perms => all + environment => {} + syslog_force_stop => True + ensure => absent + monitoring_enabled => False + group => prometheus-node-exporter + logfile_name => syslog.log + interval => [{'start': 'OnUnitInactiveSec', 'interval': '1min'}] + logfile_basedir => /var/log + ignore_errors => True + syslog_identifier => nrpe2nodexp-mariadb_replica_sql_state_s1 + logfile_group => root + syslog_match_startswith => True + fixed_random_delay => True + command => /usr/local/bin/nrpe2nodexp --alert-rule-hash "3f927914a18db09399b7fff42858d634" --timeout 10 --check-command "check_mariadb_replica_sql_state_s1" + send_mail_to => root@db2250.codfw.wmnet- Prometheus::Mysqld_exporter::Instance[s1]
- Parameters differences:
--- Prometheus::Mysqld_exporter::Instance[s1].orig +++ Prometheus::Mysqld_exporter::Instance[s1] + listen_address => :13311 + client_password => This is a fake passsword, but cannot be empty due to Debian #953040 + client_user => prometheus + client_socket => /run/mysqld/mysqld.s1.sock
- Nrpe::Monitor_service[mariadb_read_only_s1]
- Parameters differences:
--- Nrpe::Monitor_service[mariadb_read_only_s1].orig +++ Nrpe::Monitor_service[mariadb_read_only_s1] + alertmanager_team => observability + description => MariaDB read only s1 + enable_icinga_check => True + retry_interval => 1 + ensure => present + check_interval => 1 + critical => False + migration_task => T315866 + enable_nrpe2nodexp => False + contact_group => admins + retries => 3 + nrpe2nodexp_parse_perf_data => False + timeout => 10 + require => Package[wmfmariadbpy-common] + notes_url => https://wikitech.wikimedia.org/wiki/MariaDB/troubleshooting#Master_comes_back_in_read_only + nrpe_command => db-check-health --port=3311 --icinga --check_read_only=1 --process
- Monitoring::Exported_nagios_service[db2250 mariadb_disk_space]
- Parameters differences:
--- Monitoring::Exported_nagios_service[db2250 mariadb_disk_space].orig +++ Monitoring::Exported_nagios_service[db2250 mariadb_disk_space] + notifications_enabled => 0 + passive_checks_enabled => 1 + servicegroups => mysql_codfw + check_command => nrpe_check!check_mariadb_disk_space!10 + notification_options => c,r,f + notification_interval => 0 + contact_groups => admins + is_volatile => 0 + retry_interval => 1 + ensure => present + check_freshness => 0 + notification_period => 24x7 + check_interval => 1 + check_period => 24x7 + active_checks_enabled => 1 + notes_url => https://wikitech.wikimedia.org/wiki/MariaDB/troubleshooting + max_check_attempts => 3 + host_name => db2250 + service_description => MariaDB disk space
- File[/etc/my.cnf]
- Parameters differences:
--- File[/etc/my.cnf].orig +++ File[/etc/my.cnf] + group => root + owner => root + mode => 0644
- Content differences:
--- /etc/my.cnf.orig +++ /etc/my.cnf @@ -0,0 +1,128 @@ +# replicas for backup sources and analytics + +# Please use separate .cnf templates for each type of server. + +[client] + +[mysqld] + +skip-external-locking +skip-name-resolve +temp-pool + +user = mysql +basedir = /opt/wmf-mariadb1011 +server_id = 180356362 +report_host = db2250.codfw.wmnet +wsrep_cluster_name = codfw # For orchestrator. T266635 + +# gtid_domain_id flag is needed for multisource replication and GTID. +# Strictly it is only needed on masters or servers that can potentially be +# masters but for consistency it should be set in all of them. +# https://mariadb.com/kb/en/mariadb/gtid/ +gtid_domain_id = 180356362 + +read_only = 1 +key_buffer_size = 1048576 + +secure_file_priv = /dev/null +max_connections = 250 +max_allowed_packet = 32M +connect_timeout = 3 +query_cache_size = 0 +query_cache_type = 0 +event_scheduler = 1 + +table_open_cache = 50000 +table_definition_cache = 50000 + +# binary log and replication options +# We are temporarily enabling the binlogs on these servers to evaluate +# CDC functionality with paimon/flink. +# +# We will revert this change once the evaluation is complete. +# See #T258511 for a discussion about the long-term aim and #T358373. +log-bin +log-slave-updates +binlog-format = ROW +sync-binlog = 1 +binlog_cache_size = 10M +max-binlog_size = 1000M +expire-logs-days = 7 + +# InnoDB file-per-table + TokuDB love those file descriptors +open-files-limit = 200000 + +character_set_server = binary +character_set_filesystem = binary +collation_server = binary + +innodb_file_per_table = 1 +# this can get overiden by per-instance configuration +innodb_buffer_pool_size = 15G +innodb_log_file_size = 4G +innodb_flush_log_at_trx_commit = 0 +innodb_flush_method = O_DIRECT +innodb_io_capacity = 1000 +innodb_stats_method = nulls_unequal +innodb_purge_threads = 1 +# Changed because of https://jira.mariadb.org/browse/MDEV-22373 +innodb_change_buffering = none + +innodb_strict_mode = 1 + +# T287244 +innodb_checksum_algorithm = full_crc32 + +# T268869 +innodb_adaptive_hash_index=OFF + +# In 10.6 the default is 90%, 75% worked fine for us. +innodb_max_dirty_pages_pct = 75 + +# don't dump and load innodb buffer at start and stop +# these servers will have the buffer pool in a bad state due to dumps +# so not sure if these will be useful, but we leave them here for now +innodb_buffer_pool_load_at_startup = 1 +innodb_buffer_pool_dump_at_shutdown = 1 + +optimizer_switch='engine_condition_pushdown=on,optimize_join_buffer_size=on' +join_cache_level = 8 + +skip-slave-start +slave_transaction_retries = 4294967295 + + +# ssl +ssl-ca=/etc/ssl/certs/wmf-ca-certificates.crt +ssl-cert=/etc/mysql/ssl/cert.pem +ssl-key=/etc/mysql/ssl/server.key +ssl-cipher=TLSv1.2 + + +# Enabling performance_schema (disabled by default in MariaDB10) +performance_schema = 1 +# downsizing performance schema memory usage: T99485 +performance_schema_digests_size = -1 +performance_schema_max_thread_instances = 500 +performance_schema_max_cond_instances = 1000 +performance_schema_accounts_size = 300 +performance_schema_hosts_size = 300 +performance_schema_events_statements_history_size = 10 +performance_schema_events_statements_history_long_size = 1000 +performance_schema_events_waits_history_size = 10 +performance_schema_events_waits_history_long_size = 1000 +performance_schema_events_stages_history_size = 10 +performance_schema_events_stages_history_long_size = 1000 +performance_schema_max_mutex_instances = 5000 +performance_schema_max_rwlock_instances = 2000 +performance_schema_max_socket_instances = 500 +performance_schema_max_table_instances = 1000 + + +[mysqldump] + +quick +max_allowed_packet = 32M + +!includedir /etc/mysql/mysqld.conf.d/
- File[/etc/ferm/conf.d/10_s1_orchestrator]
- Parameters differences:
--- File[/etc/ferm/conf.d/10_s1_orchestrator].orig +++ File[/etc/ferm/conf.d/10_s1_orchestrator] + group => root + require => File[/etc/ferm/conf.d] + notify => Service[ferm] + owner => root + mode => 0400 + ensure => present + tag => ferm
- Content differences:
--- /etc/ferm/conf.d/10_s1_orchestrator.orig +++ /etc/ferm/conf.d/10_s1_orchestrator @@ -0,0 +1,8 @@ +# Autogenerated by puppet. DO NOT EDIT BY HAND! +# +# +&R_SERVICE(tcp, 3311, (10.64.0.20 208.80.154.9 208.80.155.103 2620:0:861:4:208:80:155:103)); + + + +&NO_TRACK(tcp, 3311);
- Profile::Mariadb::Section[s1]
- Parameters differences:
--- Profile::Mariadb::Section[s1].orig +++ Profile::Mariadb::Section[s1] + mention_alias => True + section => s1
- File[/etc/mysql/ssl/server.key]
- Parameters differences:
--- File[/etc/mysql/ssl/server.key].orig +++ File[/etc/mysql/ssl/server.key] + group => mysql + source => /var/lib/puppet/ssl/private_keys/db2250.codfw.wmnet.pem + owner => mysql + mode => 0400 + show_diff => False + ensure => present
- Exec[systemd daemon-reload for nrpe2nodexp-mariadb_replica_io_state_s1.service (nrpe2nodexp-mariadb_replica_io_state_s1.service)]
- Parameters differences:
--- Exec[systemd daemon-reload for nrpe2nodexp-mariadb_replica_io_state_s1.service (nrpe2nodexp-mariadb_replica_io_state_s1.service)].orig +++ Exec[systemd daemon-reload for nrpe2nodexp-mariadb_replica_io_state_s1.service (nrpe2nodexp-mariadb_replica_io_state_s1.service)] + command => /bin/systemctl daemon-reload + refreshonly => True
- File[/lib/systemd/system/nrpe2nodexp-mariadb_read_only_s1.service]
- Parameters differences:
--- File[/lib/systemd/system/nrpe2nodexp-mariadb_read_only_s1.service].orig +++ File[/lib/systemd/system/nrpe2nodexp-mariadb_read_only_s1.service] + group => root + notify => Exec[systemd daemon-reload for nrpe2nodexp-mariadb_read_only_s1.service (nrpe2nodexp-mariadb_read_only_s1.service)] + owner => root + mode => 0444 + ensure => absent
- Content differences:
--- /lib/systemd/system/nrpe2nodexp-mariadb_read_only_s1.service.orig +++ /lib/systemd/system/nrpe2nodexp-mariadb_read_only_s1.service @@ -0,0 +1,11 @@ +[Unit] +Description=execution of nrpe2nodexp for the check_mariadb_read_only_s1 command. +Documentation=https://wikitech.wikimedia.org/wiki/Monitoring/systemd_unit_state + +[Service] +Type=oneshot +User=nagios + +Group=prometheus-node-exporter +SyslogIdentifier=nrpe2nodexp-mariadb_read_only_s1 +ExecStart=-/usr/local/bin/nrpe2nodexp --alert-rule-hash "42baf529e0f3bfca391aca0a24c880e9" --timeout 10 --check-command "check_mariadb_read_only_s1"
- Package[percona-toolkit]
- Parameters differences:
--- Package[percona-toolkit].orig +++ Package[percona-toolkit] + ensure => installed + provider => apt
- Systemd::Unit[nrpe2nodexp-mysqld.timer]
- Parameters differences:
--- Systemd::Unit[nrpe2nodexp-mysqld.timer].orig +++ Systemd::Unit[nrpe2nodexp-mysqld.timer] + require => ['Class[Systemd]'] + override_filename => puppet-override.conf + override => False + unit => nrpe2nodexp-mysqld.timer + restart => False + ensure => absent
- Logrotate::Conf[wmf_auto_restart_prometheus-mysqld-exporter_s1]
- Parameters differences:
--- Logrotate::Conf[wmf_auto_restart_prometheus-mysqld-exporter_s1].orig +++ Logrotate::Conf[wmf_auto_restart_prometheus-mysqld-exporter_s1] + ensure => present
- File[/etc/systemd/system/mariadb.service.d]
- Parameters differences:
--- File[/etc/systemd/system/mariadb.service.d].orig +++ File[/etc/systemd/system/mariadb.service.d] + group => root + ensure => directory + mode => 0755 + owner => root
- Systemd::Unit[nrpe2nodexp-mariadb_replica_io_state_s1.timer]
- Parameters differences:
--- Systemd::Unit[nrpe2nodexp-mariadb_replica_io_state_s1.timer].orig +++ Systemd::Unit[nrpe2nodexp-mariadb_replica_io_state_s1.timer] + require => ['Class[Systemd]'] + override_filename => puppet-override.conf + override => False + unit => nrpe2nodexp-mariadb_replica_io_state_s1.timer + restart => False + ensure => absent
- Rsyslog::Conf[nrpe2nodexp-mariadb_read_only_s1]
- Parameters differences:
--- Rsyslog::Conf[nrpe2nodexp-mariadb_read_only_s1].orig +++ Rsyslog::Conf[nrpe2nodexp-mariadb_read_only_s1] + priority => 25 + ensure => absent + mode => 0444
- Exec[systemd daemon-reload for nrpe2nodexp-mariadb_replica_sql_state_s1.service (nrpe2nodexp-mariadb_replica_sql_state_s1.service)]
- Parameters differences:
--- Exec[systemd daemon-reload for nrpe2nodexp-mariadb_replica_sql_state_s1.service (nrpe2nodexp-mariadb_replica_sql_state_s1.service)].orig +++ Exec[systemd daemon-reload for nrpe2nodexp-mariadb_replica_sql_state_s1.service (nrpe2nodexp-mariadb_replica_sql_state_s1.service)] + command => /bin/systemctl daemon-reload + refreshonly => True
- Concat[/etc/mysql/ssl/cert.pem]
- Parameters differences:
--- Concat[/etc/mysql/ssl/cert.pem].orig +++ Concat[/etc/mysql/ssl/cert.pem] + format => plain + warn => False + path => /etc/mysql/ssl/cert.pem + replace => True + force => False + order => alpha + backup => puppet + ensure => present + mode => 0644 + show_diff => True + ensure_newline => False
- File[/var/lib/prometheus/node.d/check_mariadb_replica_io_state_s1.prom]
- Parameters differences:
--- File[/var/lib/prometheus/node.d/check_mariadb_replica_io_state_s1.prom].orig +++ File[/var/lib/prometheus/node.d/check_mariadb_replica_io_state_s1.prom] + group => root + ensure => absent + owner => root
- File[/etc/systemd/system/mariadb.service.d/override.conf]
- Parameters differences:
--- File[/etc/systemd/system/mariadb.service.d/override.conf].orig +++ File[/etc/systemd/system/mariadb.service.d/override.conf] + group => root + notify => Exec[systemctl-daemon-reload] + owner => root + mode => 0644 + ensure => present
- Content differences:
--- /etc/systemd/system/mariadb.service.d/override.conf.orig +++ /etc/systemd/system/mariadb.service.d/override.conf @@ -0,0 +1,2 @@ +[Service] +ExecStartPre=/bin/sh -c "echo 'mariadb main service is disabled, use mariadb@<instance_name> instead'; exit 1"
- Class[Profile::Mariadb::Packages_wmf]
- Parameters differences:
--- Class[Profile::Mariadb::Packages_wmf].orig +++ Class[Profile::Mariadb::Packages_wmf] + package => wmf-mariadb1011
- Systemd::Unit[wmf_auto_restart_prometheus-mysqld-exporter@s1.service]
- Parameters differences:
--- Systemd::Unit[wmf_auto_restart_prometheus-mysqld-exporter@s1.service].orig +++ Systemd::Unit[wmf_auto_restart_prometheus-mysqld-exporter@s1.service] + require => ['Class[Systemd]'] + override_filename => puppet-override.conf + override => False + unit => wmf_auto_restart_prometheus-mysqld-exporter@s1.service + restart => False + ensure => present
- Exec[systemctl try-restart prometheus-mysqld-exporter@s1]
- Parameters differences:
--- Exec[systemctl try-restart prometheus-mysqld-exporter@s1].orig +++ Exec[systemctl try-restart prometheus-mysqld-exporter@s1] + refreshonly => True + path => /usr/bin
- Motd::Message[insetup::data_persistence_ferm]
- Parameters differences:
--- Motd::Message[insetup::data_persistence_ferm].orig +++ Motd::Message[insetup::data_persistence_ferm] - priority => 5 - ensure => present - message => db2250 is a Host being setup by Data Persistence SREs (insetup::data_persistence_ferm)
- File[/etc/update-motd.d/05-insetup--data-persistence-ferm]
- Parameters differences:
--- File[/etc/update-motd.d/05-insetup--data-persistence-ferm].orig +++ File[/etc/update-motd.d/05-insetup--data-persistence-ferm] - group => root - ensure => present - mode => 0555 - owner => root
- Content differences:
--- /etc/update-motd.d/05-insetup--data-persistence-ferm.orig +++ /etc/update-motd.d/05-insetup--data-persistence-ferm @@ -1,2 +0,0 @@ -#!/bin/sh -printf "%s\n" "db2250 is a Host being setup by Data Persistence SREs (insetup::data_persistence_ferm)"
- File[/lib/systemd/system/nrpe2nodexp-mariadb_replica_sql_state_s1.timer]
- Parameters differences:
--- File[/lib/systemd/system/nrpe2nodexp-mariadb_replica_sql_state_s1.timer].orig +++ File[/lib/systemd/system/nrpe2nodexp-mariadb_replica_sql_state_s1.timer] + group => root + notify => Exec[systemd daemon-reload for nrpe2nodexp-mariadb_replica_sql_state_s1.timer (nrpe2nodexp-mariadb_replica_sql_state_s1.timer)] + owner => root + mode => 0444 + ensure => absent
- Content differences:
--- /lib/systemd/system/nrpe2nodexp-mariadb_replica_sql_state_s1.timer.orig +++ /lib/systemd/system/nrpe2nodexp-mariadb_replica_sql_state_s1.timer @@ -0,0 +1,14 @@ +[Unit] +Description=Periodic execution of nrpe2nodexp-mariadb_replica_sql_state_s1.service + +[Timer] +Unit=nrpe2nodexp-mariadb_replica_sql_state_s1.service +# Accuracy sets the maximum time interval around the execution time we want to allow +AccuracySec=15sec +OnUnitInactiveSec=1min +OnActiveSec=1s +RandomizedDelaySec=60 +FixedRandomDelay=true + +[Install] +WantedBy=multi-user.target
- Service[nrpe2nodexp-mariadb_replica_sql_lag_s1.timer]
- Parameters differences:
--- Service[nrpe2nodexp-mariadb_replica_sql_lag_s1.timer].orig +++ Service[nrpe2nodexp-mariadb_replica_sql_lag_s1.timer] + before => ['Exec[systemd daemon-reload for nrpe2nodexp-mariadb_replica_sql_lag_s1.timer (nrpe2nodexp-mariadb_replica_sql_lag_s1.timer)]'] + ensure => stopped + provider => systemd + enable => False
- File[/etc/mysql/ssl/server-cert.pem]
- Parameters differences:
--- File[/etc/mysql/ssl/server-cert.pem].orig +++ File[/etc/mysql/ssl/server-cert.pem] + group => root + ensure => absent + owner => root
- Class[Profile::Mariadb::Dbstore_multiinstance]
- Parameters differences:
--- Class[Profile::Mariadb::Dbstore_multiinstance].orig +++ Class[Profile::Mariadb::Dbstore_multiinstance] + section_ports => {'s1': 3311, 's2': 3312, 's3': 3313, 's4': 3314, 's5': 3315, 's6': 3316, 's7': 3317, 's8': 3318, 'x1': 3320, 'x3': 3363, 'm1': 3321, 'm2': 3322, 'm3': 3323, 'm5': 3325, 'staging': 3350, 'matomo': 3351, 'analytics_meta': 3352, 'backup1-eqiad': 3360, 'backup1-codfw': 3361} + require => ['Class[Profile::Mariadb::Packages_wmf]'] + instances => {'s1': '192G'}- File[/etc/mysql/mysqld.conf.d/s1.cnf]
- Parameters differences:
--- File[/etc/mysql/mysqld.conf.d/s1.cnf].orig +++ File[/etc/mysql/mysqld.conf.d/s1.cnf] + group => root + owner => root + mode => 0644
- Content differences:
--- /etc/mysql/mysqld.conf.d/s1.cnf.orig +++ /etc/mysql/mysqld.conf.d/s1.cnf @@ -0,0 +1,9 @@ +[mysqld@s1] +datadir = /srv/sqldata.s1 +tmpdir = /srv/tmp.s1 +socket = /run/mysqld/mysqld.s1.sock +port = 3311 +extra-port = 3331 +innodb_buffer_pool_size = 192G +read-only = 1 +
- Systemd::Service[nrpe2nodexp-mariadb_replica_sql_lag_s1]
- Parameters differences:
--- Systemd::Service[nrpe2nodexp-mariadb_replica_sql_lag_s1].orig +++ Systemd::Service[nrpe2nodexp-mariadb_replica_sql_lag_s1] + monitoring_critical => False + migration_task => T407130 + unit_type => timer + restart => False + require => Systemd::Unit[nrpe2nodexp-mariadb_replica_sql_lag_s1.service] + monitoring_contact_group => admins + override => False + service_params => {} + ensure => absent + monitoring_enabled => False- File[/etc/default/prometheus-mysqld-exporter@s1]
- Parameters differences:
--- File[/etc/default/prometheus-mysqld-exporter@s1].orig +++ File[/etc/default/prometheus-mysqld-exporter@s1] + group => root + notify => Exec[systemctl try-restart prometheus-mysqld-exporter@s1] + owner => root + mode => 0444 + ensure => present
- Content differences:
--- /etc/default/prometheus-mysqld-exporter@s1.orig +++ /etc/default/prometheus-mysqld-exporter@s1 @@ -0,0 +1 @@ +ARGS='--web.listen-address ":13311" --config.my-cnf "/var/lib/prometheus/.my.s1.cnf" --collect.global_status --collect.global_variables --collect.info_schema.processlist --collect.slave_status --collect.heartbeat --collect.heartbeat.utc --no-collect.info_schema.tables'
- File[/srv/tmp.s1]
- Parameters differences:
--- File[/srv/tmp.s1].orig +++ File[/srv/tmp.s1] + group => mysql + ensure => directory + mode => 0755 + owner => mysql
- Concat_fragment[main contacts]
- Content differences:
--- main contacts.orig +++ main contacts @@ -1,3 +1,3 @@ --- -role::insetup::data_persistence_ferm: +role::mariadb::backup_source: - Data Persistence
- Systemd::Unit[nrpe2nodexp-mariadb_replica_sql_lag_s1.service]
- Parameters differences:
--- Systemd::Unit[nrpe2nodexp-mariadb_replica_sql_lag_s1.service].orig +++ Systemd::Unit[nrpe2nodexp-mariadb_replica_sql_lag_s1.service] + require => ['Class[Systemd]'] + override_filename => puppet-override.conf + override => False + unit => nrpe2nodexp-mariadb_replica_sql_lag_s1.service + restart => False + ensure => absent
- File[/usr/local/lib/nagios/plugins/check_mariadb]
- File[/usr/local/lib/nagios/plugins/check_mariadb]
- Concat_fragment[main contacts]
- Content differences:
- File[/etc/default/prometheus-mysqld-exporter@s1]
- Content differences:
- File[/etc/mysql/mysqld.conf.d/s1.cnf]
- Class[Profile::Mariadb::Dbstore_multiinstance]
- File[/etc/mysql/ssl/server-cert.pem]
- Content differences:
- Content differences:
- File[/etc/update-motd.d/05-insetup--data-persistence-ferm]
- Motd::Message[insetup::data_persistence_ferm]
- Exec[systemctl try-restart prometheus-mysqld-exporter@s1]
- Systemd::Unit[wmf_auto_restart_prometheus-mysqld-exporter@s1.service]
- Content differences:
- File[/etc/systemd/system/mariadb.service.d/override.conf]
- File[/var/lib/prometheus/node.d/check_mariadb_replica_io_state_s1.prom]
- Concat[/etc/mysql/ssl/cert.pem]
- Exec[systemd daemon-reload for nrpe2nodexp-mariadb_replica_sql_state_s1.service (nrpe2nodexp-mariadb_replica_sql_state_s1.service)]
- Rsyslog::Conf[nrpe2nodexp-mariadb_read_only_s1]
- Systemd::Unit[nrpe2nodexp-mariadb_replica_io_state_s1.timer]
- File[/etc/systemd/system/mariadb.service.d]
- Logrotate::Conf[wmf_auto_restart_prometheus-mysqld-exporter_s1]
- Systemd::Unit[nrpe2nodexp-mysqld.timer]
- Content differences:
- File[/lib/systemd/system/nrpe2nodexp-mariadb_read_only_s1.service]
- Exec[systemd daemon-reload for nrpe2nodexp-mariadb_replica_io_state_s1.service (nrpe2nodexp-mariadb_replica_io_state_s1.service)]
- File[/etc/mysql/ssl/server.key]
- Content differences:
- Content differences:
- File[/etc/my.cnf]
- Monitoring::Exported_nagios_service[db2250 mariadb_disk_space]
- Nrpe::Monitor_service[mariadb_read_only_s1]
- Prometheus::Mysqld_exporter::Instance[s1]
- Systemd::Timer::Job[nrpe2nodexp-mariadb_replica_sql_state_s1]
- Firewall::Service[s1_orchestrator]
- Exec[systemd daemon-reload for nrpe2nodexp-mysqld.service (nrpe2nodexp-mysqld.service)]
- Content differences:
- File[/etc/nagios/nrpe.d/check_mariadb_disk_space.cfg]
- File[/etc/sudoers.d/nrpe-check_mariadb_replica_io_state_s1]
- Nrpe::Check[check_mariadb_read_only_s1]
- Systemd::Unit[nrpe2nodexp-mariadb_memory.timer]
- File[/srv/sqldata.s1]
- Content differences:
- File[/etc/update-motd.d/06-db-section-s1]
- Content differences:
- File[/lib/systemd/system/nrpe2nodexp-mariadb_replica_sql_state_s1.service]
- Sudo::User[nrpe-check_mariadb_disk_space]
- Package[wmf-mariadb1011]
- Content differences:
- Parameters differences: