Commit graph

89 commits

Author SHA1 Message Date
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