b62982c927
mariadb: drop user parameter that was removed upstream in the collection
...
Signed-off-by: Kevin Fenzi <kevin@scrye.com>
2026-08-03 12:06:48 -07:00
b92f4ac4a3
fix mysql module path and drop mentions of retrace_stg which does not exist
...
Signed-off-by: Kevin Fenzi <kevin@scrye.com>
2026-07-23 12:26:58 -07:00
c51e04de81
Collectd: cleanup collectd everywhere except FMN
...
Signed-off-by: Greg Sutcliffe <fedora@emeraldreverie.org>
2026-07-09 11:01:41 +00:00
ef5567d8c0
Zabbix: add an hour to the MariaDB backup trigger to give the daily cron time to run
...
Signed-off-by: Greg Sutcliffe <fedora@emeraldreverie.org>
2026-06-19 11:42:15 +01:00
ca291c8669
Zabbix: Migrate MariaDB backup file-age check from Nagios
...
(also fix tags in the Sigul monitoring from earlier)
Signed-off-by: Greg Sutcliffe <fedora@emeraldreverie.org>
2026-06-08 16:17:13 +01:00
6c85fda0c9
Mass remove/replace iad2 -> rdu3, 10.3. -> 10.16.
...
Signed-off-by: Nils Philippsen <nils@redhat.com>
2025-07-03 20:05:02 +02:00
2c7461ef7f
mariadb: we are NOT replicating, so do not keep replciation logs
...
Signed-off-by: Kevin Fenzi <kevin@scrye.com>
2025-06-22 14:44:36 -07:00
f136cfec2a
mariadb: set single-transaction on backups
...
We are seeing the backups here cause the wiki to become unresponsive.
This might help it out and prevent it locking things while doing the
backups.
Signed-off-by: Kevin Fenzi <kevin@scrye.com>
2025-06-01 08:02:12 -07:00
2ec055db6f
Use first uppercase letter for all handlers
...
This will unify all the handlers to use first uppercase letter for
ansible-lint to stop complaining.
I went through all `notify:` occurrences and fixed them by running
```
set TEXT "text_to_replace"; set REPLACEMENT "replacement_text"; git grep
-rlz "$TEXT" . | xargs -0 sed -i "s/$TEXT/$REPLACEMENT/g"
```
Then I went through all the changes and removed the ones that wasn't
expected to be changed.
Fixes https://pagure.io/fedora-infrastructure/issue/12391
Signed-off-by: Michal Konecny <mkonecny@redhat.com>
2025-02-10 20:31:49 +00:00
0e815134b7
mariadb: use pxz with 2 threads for backups
...
This has anoyingly been alerting of late, so lets try and
see if we can get the backup to finish faster and avoid the
alerts on it.
Signed-off-by: Kevin Fenzi <kevin@scrye.com>
2025-01-20 12:49:47 -08:00
47c68f478d
ansiblelint fixes - fqcn[action-core] - template to ansible.builtin.template
...
Replaces references to template: with ansible.builtin.template
Signed-off-by: Ryan Lerch <rlerch@redhat.com>
2025-01-15 11:30:29 +10:00
25391e95b7
ansiblelint fixes - fqcn[action-core] - package to ansible.builtin.package
...
Replaces many references to package: with ansible.builtin.package
Signed-off-by: Ryan Lerch <rlerch@redhat.com>
2025-01-15 11:28:00 +10:00
6a3816dfdc
ansiblelint fixes-- fqcn[action-core] - copy to ansible.builtin.copy
...
Replaces many references to 'copy' with ansible.builtin.copy
Signed-off-by: Ryan Lerch <rlerch@redhat.com>
2025-01-15 10:43:31 +10:00
62952df107
ansiblelint fixes-- fqcn[action-core] - file to ansible.builtin.file
...
Replaces many references to file: with ansible.builtin.file
Signed-off-by: Ryan Lerch <rlerch@redhat.com>
2025-01-15 10:41:52 +10:00
691adee6ee
Fix name[casing] ansible-lint issues
...
fix 1900 failures of the following case issue:
`name[casing]: All names should start with an uppercase letter.`
Signed-off-by: Ryan Lerch <rlerch@redhat.com>
2025-01-14 20:20:07 +10:00
89f6f1fc32
Fix majority of remaining yamllint warnings and errors
...
Signed-off-by: Ryan Lerch <rlerch@redhat.com>
2024-11-28 17:31:45 +10:00
Stephen Smoogen
432a3a497b
Go through and remove entries for EL6 and EL7
...
Using `git grep el6` and `git grep el7` and variants like EL-7 or
el-7, I found various entries and files which were no longer needed
with the current ansible. I updated text or tests to later versions of
RHEL as needed.
found entries for the fedora ami's for the original cloud and removed
those entries also.
Signed-off-by: Stephen Smoogen <ssmoogen@redhat.com>
2024-07-03 22:20:30 +00:00
73a501a933
roles / mariadb: add boolean to allow nagios checks and collectd
...
Signed-off-by: Kevin Fenzi <kevin@scrye.com>
2020-10-05 16:38:36 -07:00
Stephen Smoogen
95954ae184
add in vars for db-qa boxes and fix fedmsg relay
2020-05-29 15:02:07 -04:00
8802fc1823
mariadb: adjust the setting of root password.
...
Signed-off-by: Kevin Fenzi <kevin@scrye.com>
2020-05-21 10:55:28 -07:00
d9cdb2583d
mariadb: turns out we do need python bindings, but they are called python3-PyMySQL on rhel8
...
Signed-off-by: Kevin Fenzi <kevin@scrye.com>
2020-05-21 10:35:04 -07:00
924325027c
mariadb: drop MySQL-python as it's not shipped in rhel8
...
Signed-off-by: Kevin Fenzi <kevin@scrye.com>
2020-05-21 10:12:33 -07:00
c6ba2b8333
no_log is a play task
...
Signed-off-by: Kevin Fenzi <kevin@scrye.com>
2020-04-24 21:34:15 +02:00
671db804b9
mariadb: Put check_implicit_admin back
...
Signed-off-by: Kevin Fenzi <kevin@scrye.com>
2020-04-24 21:34:15 +02:00
497f073060
mariadb: might be the check_implicit_admin is busted.
...
Signed-off-by: Kevin Fenzi <kevin@scrye.com>
2020-04-24 21:34:15 +02:00
2095f5afc1
mariadb: try local socket
...
Signed-off-by: Kevin Fenzi <kevin@scrye.com>
2020-04-24 21:34:15 +02:00
e56fa9edaf
mariadb: temp disable no log so I can see why the task is failing.
...
Signed-off-by: Kevin Fenzi <kevin@scrye.com>
2020-04-24 21:34:15 +02:00
e2523e235d
mysqld backup: try adding ionice into things.
...
Signed-off-by: Kevin Fenzi <kevin@scrye.com>
2020-04-24 21:34:11 +02:00
Karsten Hopp
c9ed62ac32
update ansible_distribution_major_version conditionals
...
Signed-off-by: Karsten Hopp <karsten@redhat.com>
2020-04-24 21:34:10 +02:00
Karsten Hopp
f40b0f0c30
mariadb_server: dnf -> package, with_item changes
2019-06-11 14:55:12 +00:00
aa337313be
Drop enabledrepos extra_repos for now.
2018-10-05 05:13:41 +00:00
Patrick Uiterwijk
adcbf72f03
Packageize this, packageize that, packageize the world
...
Signed-off-by: Patrick Uiterwijk <puiterwijk@redhat.com>
2017-10-08 22:25:52 +00:00
Tim Flink
cb0ef0b2fd
adding new qa-prod01.qa host to replace qadevel.qa
2016-12-15 18:02:29 +00:00
Tim Flink
7265a3e841
bumping buffer sizes for mariadb on qa-stg01.qa
2016-12-02 21:18:06 +00:00
Tim Flink
4f6005ad18
more mariadb tweaks for phab
2016-12-02 05:03:44 +00:00
Tim Flink
82d36431e8
tweaks in php and mariadb config for new phab version
2016-12-02 04:59:06 +00:00
Tim Flink
083d4f7940
forcing a non-default log location so that mariadb initializes
2016-11-30 18:05:46 +00:00
Tim Flink
2f7de0a5d3
creating a mysql config specifically for qa-stg01.qa
2016-11-30 09:12:00 +00:00
5c141640d9
switch mariadb backups to 5am for now
2016-10-13 00:38:37 +00:00
a32f8b9e4a
Change ansible_fqdn to inventory_hostname. This fixes some few hosts that have incorrect reverse dns
...
and shouldn't break any others since we always use fully qualified in our inventory.
2016-05-11 15:08:50 +00:00
Michael Scherer
856abe494e
Move a few handlers to the only role using them
2016-04-04 20:46:29 +00:00
62e16bb9a4
Switch all these places to use dnf/yum state=present instead of latest. This prevents showing changes on package updates.
2016-01-04 18:52:27 +00:00
Tim Flink
7bc29a7324
adding dnf support to mariadb_server
2015-11-23 23:48:07 +00:00
eedf88ae90
This is a module argument
2015-06-23 17:03:38 +00:00
fe3e1ec182
Lets try and set check_implicit_admin true here to see if that allows it to set the password correctly.
2015-06-23 17:01:29 +00:00
7fe5b0100e
Setup mariadb backup to make a latest link, make nrpe on db03 check that for backup age.
2015-06-08 21:14:36 +00:00
c517c48a21
Run this as root actually. It seems this may be needing to run as root.
2015-06-04 18:50:51 +00:00
140af2c7ac
This has to have a --user=root in order to be able to access the dbs
...
It runs as mysql user, but root when connecting to the db.
2015-06-04 18:37:12 +00:00
ef817b7d0c
Add backups for mariadb nightly like we do for postgres.
...
This allows us to back up /backups and get a good few days database
dumps on mariadb servers.
2015-06-04 17:29:16 +00:00
Tim Flink
f7a3d762cb
more mysql and phabricator tweaks
2015-05-13 20:46:36 +00:00
