evolix/ansible-roles
22
2
Fork 2
Code Issues 61 Pull requests 18 Releases 33 Wiki Activity
3624 commits 76 branches 57 tags 129 MiB
Commit graph

173 commits

Author SHA1 Message Date
Jérémy Lecour 2ed77c60f0 Improve Ansible syntax 
replace « x | changed » by « x is changed »
add explicit « bool » filter
use « length » filter instead of string comparison
 2021-05-09 23:06:42 +02:00
Jérémy Lecour 485ec39674 Use 'loop' syntax instead of 'with_nested' 2021-05-04 14:29:50 +02:00
Jérémy Lecour 5138065059 Use 'loop' syntax instead of 'with_items' 2021-05-04 14:19:18 +02:00
Jérémy Lecour 94a5d7daa2 mysql: variable to disable myadd script overwrite (default: True)
All checks were successful
continuous-integration/drone/push Build is passing
Details
2021-04-23 14:59:29 +02:00
Jérémy Lecour 86d59cbb5f mysql: install save_mysql_processlist script 2020-11-24 13:59:04 +01:00
Ludovic Poujol 7a37167e20 mysql: fix typo in restart handler
All checks were successful
continuous-integration/drone/push Build is passing
Details
2020-10-29 10:42:57 +01:00
Ludovic Poujol 4de33e41b5 mysql: fix typo in restart handler
All checks were successful
continuous-integration/drone/push Build is passing
Details
2020-10-29 10:41:33 +01:00
Patrick Marchand 0fee07f47e Fix variable par défaut manquante dans mysql
All checks were successful
continuous-integration/drone/push Build is passing
Details 
Le lower_case_table_names doit être mis à Null pour que le check marche.
 2020-06-10 10:37:36 -04:00
Patrick Marchand 8c1e40c1a9 Add option to make a mysql install read only
Some checks failed
continuous-integration/drone/push Build is passing
Details
continuous-integration/drone/pr Build is failing
Details 
Rebased on unstable
 2020-06-01 12:03:23 -04:00
Patrick Marchand 5b9cc3af31 Added mysql_innodb_log_file_size option to the mysql role 
Makes it possible to have larger binary entries when replicating.
 2020-06-01 12:01:01 -04:00
Patrick Marchand 1a96616f42 Fix right problem in mysql replication 
The configuration file was not set to 0644, which caused the file
to be ignored by mysql and it's configuration not to be set.
 2020-06-01 12:01:01 -04:00
Patrick Marchand b80f3993ae Added some mysql variables and allowed forcing config update 
The default behaviour is kept, but this way we can manage a mysql
installation from ansible.
 2020-06-01 12:01:01 -04:00
Patrick Marchand d15819fb04 Replication should set a binlog format 
This could possible be better served in the base config file, but
for now I'll keep it here.
 2020-06-01 12:01:01 -04:00
Patrick Marchand 6289c7fe1c Removed redundant nagios checks 
They are already installed by the base roles.
 2020-06-01 12:01:01 -04:00
Patrick Marchand 45fba1f878 Removed useless dbadmin script from mysql replication tasks 
It was used by a very specific client case and is not needed for a
general role.
 2020-06-01 12:01:01 -04:00
Patrick Marchand c319be2542 Make it possible for mysql role to copy evolix scripts 
Based myself off of the webapps/evoadmin-web role, but I'm not sure
we still consider this a hack or not. We use a read only /usr fs,
so we need to remount it to add scripts in /usr/local/share.
 2020-06-01 12:01:01 -04:00
Patrick Marchand 31f002f9d9 Added option to prepare mysql servers for replication 2020-06-01 12:01:01 -04:00
Jérémy Lecour 1e3ac40167 mysql: Munin must use the debian-sys-maint user
All checks were successful
continuous-integration/drone/push Build is passing
Details
2020-03-08 22:15:06 +01:00
Jérémy Lecour ddef475778 mysql: add a missing name to a task 2020-03-08 22:14:40 +01:00
Jérémy Lecour 7283e34077 Replace version_compare() with version() 2020-02-25 10:45:35 +01:00
Jérémy Lecour eded11f88f Change "|search" with "is search" 2019-12-31 16:18:56 +01:00
Jérémy Lecour e04d881988 replace "with_items" in apt modules 2019-12-31 16:18:56 +01:00
Jérémy Lecour 79bb6103b8 Change "|version_compare" with "is version_compare" 2019-12-31 10:18:19 +01:00
Victor LABORIE 6f5e13f8b8 Add evolix prefix to include_role 2019-11-29 14:00:25 +01:00
Jérémy Lecour a9b61161e0 fix typos
All checks were successful
continuous-integration/drone/push Build is passing
Details
2019-10-24 15:55:40 +02:00
Jérémy Lecour bea11352be Merge branch 'buster' into unstable 2019-09-23 18:34:35 +02:00
Patrick Marchand 0009272462 Allow setting a custom mysql server_id 2019-09-12 11:46:12 -04:00
Patrick Marchand cf83732946 The mysql readme had an erroneous line removal 2019-09-12 08:59:04 -04:00
Patrick Marchand 109191ccd8 Added mysql_log_bin variable to enable binary logs 2019-09-12 08:54:18 -04:00
Benoît S. 771c75c1de all-roles: Dot not use ansible_lsb as it is deprecated
Some checks reported errors
continuous-integration/drone/push Build encountered an error
Details
continuous-integration/drone/pr Build is passing
Details 
We move from `ansible_lsb.codename` to `ansible_distribution_release`.
 2019-07-03 09:41:35 +02:00
Jérémy Lecour f5ad70a2e4 Merge branch 'unstable' into buster
Some checks reported errors
continuous-integration/drone/push Build encountered an error
Details
continuous-integration/drone/pr Build is passing
Details
2019-07-01 17:19:35 +02:00
Eric Morino 1b972caa83 Add install package percona-toolkit by default
Some checks reported errors
continuous-integration/drone/push Build encountered an error
Details
2019-06-26 18:12:39 +02:00
Jérémy Lecour c147a4674d mysql : mytop dependencies for buster
All checks were successful
continuous-integration/drone/push Build is passing
Details
continuous-integration/drone/pr Build is passing
Details
2019-06-26 17:46:36 +02:00
Jérémy Lecour bee57a0b3c change distribution release codename
Some checks reported errors
continuous-integration/drone/push Build encountered an error
Details
continuous-integration/drone/pr Build is failing
Details 
Ansible 2.2 is too old to know about buster.
Let's use LSB for that.
 2019-06-18 17:35:28 +02:00
Jérémy Lecour aa28e9c1b8 change repositories URL 2019-03-21 15:31:58 +01:00
Jérémy Lecour 5056f93283 mysql: logdir can be customized 2018-11-14 16:13:06 +01:00
Jérémy Lecour 6b769f5d77 mysql: restart MySQL if systemd unit has changed 2018-11-14 16:13:06 +01:00
Jérémy Lecour 98a0893f43 mysql: update README 2018-09-14 11:45:57 +02:00
Jérémy Lecour b2596aad2a mysql: add a variable to prevent mysql from restarting 2018-09-13 18:32:23 +02:00
Jérémy Lecour d09fd169b3 mysql: default values should stay in the proper file 
Default values are set in z-evolinux-defaults.cnf and should be added in 
zzz-evolinux-custom.cnf only if the value differs from the default.
 2018-08-23 12:17:13 +02:00
Tristan PILAT 01ae7b0e31 Add some new customisable configuration parameters 2018-08-23 09:31:04 +02:00
Jérémy Lecour ec12948398 mysql: add quotes in a few tasks 2018-07-10 16:27:10 +02:00
Jérémy Lecour 03431fc116 mysql: add an option to install the dev client libraries 2018-06-09 13:15:08 +02:00
Jérémy Lecour 15ebb84bb6 mysql/mysql-oracle: mysqltuner cron scripts is 0755 2018-04-22 17:32:23 +02:00
Jérémy Lecour 92bb60495d mysql: add a name attribute for systemd daemon-reload module 2018-04-19 15:44:05 +02:00
Jérémy Lecour b843a528be mysql: abort if MariaDB on Debian 8 
We can't create other users with 'debian-sys-maint' on Debian 8 with
MariaDB.
We must give it the GRANT privilege before continuing.
 2018-04-17 10:24:47 +02:00
Jérémy Lecour 602836a6e7 mysql: whitespaces 2018-04-17 10:24:12 +02:00
Jérémy Lecour ae6e376048 mysql: properly reload systemd 2018-04-15 23:58:31 +02:00
Victor LABORIE 81861bad80 mysql: use check_mode for apg command 
* Fix usage of mysql role with --check
 2018-04-13 12:08:58 +02:00
Jérémy Lecour a12dca0b70 mysql/mysql-oracle: mysqltuner cron task is executable 2018-03-14 09:35:26 +01:00
Jérémy Lecour b81ef36f92 mysql: remount /usr (if needed) before creating scripts directory 2018-03-14 09:33:14 +01:00
Benoît S. 7a6b8451a9 Added "The total blob data length" pattern 
This will detect this error:
[ERROR] InnoDB: The total blob data length (10066388) is greater than 10% of
the total redo log size (100663296). Please increase total redo log size.
 2017-12-04 11:22:03 +01:00
Jérémy Lecour 3d5c004d8a mysql: parameterize evolinux config files 
The tmpdir task was not using the right file.
We use a variable for those files, to hemp with maintenance ans
customization.
 2017-11-29 10:02:02 +01:00
Jérémy Lecour 690e44ac5d mysql: check_mode for nrpe password 2017-11-26 18:58:39 +01:00
Jérémy Lecour 1d68340b3b mysql: better support for check mode 2017-11-14 09:39:24 +01:00
Victor LABORIE 1c48df025c Move /usr rw remount into remount-usr role 2017-11-07 13:34:05 +01:00
Jérémy Lecour 172b21b613 mysql: add more Munin plugins 2017-10-20 10:25:34 +02:00
Ludovic Poujol 745c45f88d Fix remount_usr_rw/yml 2017-10-11 17:58:18 +02:00
Jérémy Lecour 95c34c5d88 MySQL: "REPLICATION CLIENT" privilege for nrpe 2017-09-20 11:33:27 +02:00
Gregory Colpart a5e76c5248 Fix error in handlers filename. 2017-09-18 21:46:27 +02:00
Jérémy Lecour accce99e05 mysql: fix slow_log config 2017-09-15 11:30:33 +02:00
Jérémy Lecour b41c4f1567 mysql: custom config file must be world readable 2017-09-15 11:30:08 +02:00
Gregory Colpart 0e89d5ea56 Add files for MariaDB 2017-09-14 22:04:33 +02:00
Gregory Colpart 8e4d7e484a wording 2017-09-14 19:34:04 +02:00
Gregory Colpart ba7c7e0927 add systemd override for MariaDB 2017-09-14 19:32:24 +02:00
Benoît.S dbbd0e1783 Patch MySQL 5.5.53, set secure-file-priv to empty value. 
Why? Because we want to do SELECT INTO OUTFILE.
 2017-09-14 15:19:26 +02:00
Gregory Colpart d4a47346ef In Stretch, we have now /etc/mysql/mariadb.conf.d/ dir then we need use it for our conf files 2017-09-01 04:00:51 +02:00
Gregory Colpart d1b290f864 Typos + add info 2017-09-01 04:00:13 +02:00
Gregory Colpart 64c1dc3d45 Fix mytop install with https://wiki.evolix.org/HowtoMySQL#mytop 2017-08-31 04:40:49 +02:00
Gregory Colpart f0ced31efa review default vars 2017-08-18 15:18:33 +02:00
Gregory Colpart 8dbe8bf4ac Quick fix because MySQL install doesn't work anymore on Stretch 2017-08-18 05:06:23 +02:00
Gregory Colpart 2bb7367edf standardization for Debian versions : we use "jessie" or "9 or later" to prepare buster smoothly as possible 2017-08-18 03:50:30 +02:00
Jérémy Lecour efa7e288dd mysql: install cron task for mysqltuer 2017-08-12 12:25:47 -04:00
Jérémy Lecour d15bcc168e mysql: fix mysql optimize tasks 2017-08-12 12:25:47 -04:00
Jérémy Lecour 574cf3ab44 mysql: install mysqltuner from packages 2017-08-12 12:25:47 -04:00
Jérémy Lecour 7d8c198849 mysql: split packages tasks by release 2017-08-12 12:25:47 -04:00
Jérémy Lecour a857045661 mysql: use apg for passwords 2017-08-12 12:25:47 -04:00
Jérémy Lecour 213ad5a606 mysql: log2mail config is owned by log2mail group 2017-08-12 12:25:47 -04:00
Jérémy Lecour 1b32be19c0 mysql script directory is a variable 2017-08-12 11:39:33 -04:00
Jérémy Lecour 9269f1e50d Merge branch 'mariadb-fix-munin-plugin' into unstable 2017-07-20 11:00:24 +02:00
Benoît S. 499b2c7def Added a perl mandatory package 
If not installed: install_driver(mysql) failed: Can't locate DBD/mysql.pm in
@INC (you may need to install the DBD::mysql module)
 2017-07-20 10:43:13 +02:00
Jérémy Lecour 927dbfa889 MySQL: adapt users on distribution 
For Jessie, there is a "debian-sys-maint", that we're using to create "mysqladmin" for root, then delete "root".

For Stretch, the is a "root" without assword, so we create both "mysqladmin" for root and "debian-sys-maint" for Debian scripts, then delete "root".
 2017-07-13 14:09:33 +02:00
Jérémy Lecour 0481c51a40 mysql: use /etc/mysql/debian.cnf for configuration 2017-06-12 15:11:40 +02:00
Jérémy Lecour 65f91f09b0 Disable warnings for mount commands related to /usr read-only 2017-06-12 15:11:40 +02:00
Jérémy Lecour be0fa9176b mysql: add some ansible tags 2017-06-09 09:06:33 +02:00
Gabriel Periard-Tremblay 87ebadcadd Kitchen: Change base image to evolix/ansible 2017-06-02 08:38:08 -04:00
Jérémy Lecour 37ef790d57 mysql: remount /usr if needed 2017-05-23 15:11:11 +02:00
Jérémy Lecour f45d7ded46 Mysql: cron frequency can be changed 2017-05-19 23:06:12 +02:00
Jérémy Lecour 9fae99f8dc Minor syntax and whitespaces fixes 2017-05-19 22:29:53 +02:00
Jérémy Lecour 033ebaa593 Add tests for many roles 2017-05-18 15:44:21 +02:00
Jérémy Lecour de9d4080cb whitespaces 2017-04-19 10:59:25 +02:00
Jérémy Lecour 68d9490fc0 MySQL: document missing variables in README 
* mysql_variant
* mysql_force_new_nrpe_password
 2017-04-05 12:14:30 +02:00
Jérémy Lecour b9172350ff Mysql: store NRPE credentials in secure file 2017-04-05 12:10:19 +02:00
Jérémy Lecour 5b2ab0d8d3 Ansible >= 2.2 supported 2017-03-24 14:15:09 +01:00
Jérémy Lecour 294cea44e8 Change mode with leading 0, but still as String 2017-03-23 16:59:43 +01:00
Jérémy Lecour 8920ff1ee4 Add "always_run: yes" where it's pertinent 
There is also the "check_mode: no", but commented,
for when we switch to Ansible 2.2
 2017-01-31 11:45:35 +01:00
Jérémy Lecour 478e9a8272 replace "state: installed" with "state: present" 2017-01-12 17:37:48 +01:00
Jérémy Lecour d91b317a50 Install "apg" package where needed 2017-01-12 17:36:59 +01:00
Victor LABORIE 095693582a mysql: fix my-add.sh when no password 2017-01-12 15:15:26 +01:00
Jérémy Lecour 61f5219f48 Improve documentation 
Each role has a README and a meta/main.yml file
 2017-01-05 18:22:06 +01:00