evolix
/
ansible-roles
16
2
Fork 2
Code Issues 61 Pull Requests 18 Releases 28 Wiki Activity
You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
emorino/patroni-etcd
unstable
jitsimeet
jitsimeet_docker
ssh-split
peertube
hedgedoc
etherpad
privatebin
mattermost
gitea
stable
p10166-mastodon
etcd
patroni
replace_include
when-not-check
fix_lxc_php56_debian10
debian12
boost-proxy
debian12-keyring
evodomains
vrrp-addresses
lxc_etc-git
lxc_etc-commit
evoacme-v2
sshd_modular_config
exclusion_images_evobackup
rotate_elasticsearch_logs
evobackup_tags_redux
log2mail-beats
T47076
kvm-guest
lpoujol/fpm-php
lxc-php-buster
simplify-evolinux-users
openvpn
newkernel
etc-git-status-script
itk-add-EnableCapabilities-off
ubuntu
nagios-sudoers
configurable-swapiness
alert5-minifirewall-restart
fail2ban_ips_tag
audit-ftpadmin
projet6062
whitelisting-changes
uvrrpd
packweb-apache-lxc
backup/jlecour/ssh-groups
nextcloud
backup/jlecour/nextcloud
evoadmin-mail
haproxy_munin
evolinux-users
ansible-log
ansible-managed
apache-fix-default-vhost
ipsec
courier
spamassassin
samba
munin-openbsd
23.04
23.03.1
23.03
22.12
22.09
22.07.1
22.07
22.06.3
22.06.2
22.06.1
22.06
22.05.1
22.05
22.01.2
10.5.1
9.0.1
9.0.0
1.2
1.2.3
10.0.0
10.1.0
10.2.0
10.3.0
10.4.0
10.5.0
10.6.0
22.01
22.01.1
22.01.3
22.03
9.1.0
9.1.1
9.1.2
9.1.3
9.1.4
9.1.5
9.1.6
9.1.7
9.1.8
9.1.9
9.10.0
9.10.1
9.2.0
9.3.0
9.3.1
9.3.2
9.4.0
9.4.1
9.4.2
9.5.0
9.6.0
9.7.0
9.8.0
9.9.0
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'stable'
${ noResults }
ansible-roles/mysql-oracle
History
Jérémy Lecour ee21973371
Ansible Lint |Total|New|Outstanding|Fixed|Trend |:-:|:-:|:-:|:-:|:-: |2777|524|2253|2462|:+1: Reference build: <a href="https://jenkins.evolix.org/job/gitea/job/ansible-roles/job/unstable/223//ansiblelint">Evolix » ansible-roles » unstable #223</a> Details
gitea/ansible-roles/pipeline/head This commit looks good Details
Use FQCN 
Fully Qualified Collection Name
 		3 months ago
..
defaults mysql-oracle: backport tasks from mysql role 4 years ago
files add set crypt_use_gpgme=no Mutt option 1 year ago
handlers Use FQCN 3 months ago
meta Update Galaxy metadata (company, platforms and galaxy_tags) 2 years ago
tasks Use FQCN 3 months ago
templates Add mysql-oracle role 5 years ago
tests Add mysql-oracle role 5 years ago
.kitchen.yml Add mysql-oracle role 5 years ago
README.md mysql-oracle: backport tasks from mysql role 4 years ago

README.md

mysql

Install MySQL (from Oracle)

Tasks

Tasks are extracted in several files, included in tasks/main.yml :

  • packages.yml : packages installation ;
  • users.yml : replacement of root user by mysqladmin user ;
  • config.yml : configurations ;
  • datadir.yml : data directory customization ;
  • tmpdir.yml : temporary directory customization ;
  • nrpe.yml : nrpe user for Nagios checks ;
  • munin.yml : Munin plugins ;
  • log2mail.yml : log2mail patterns ;
  • utils.yml : useful tools.

Available variables

  • mysql_replace_root_with_mysqladmin: switch from root to mysqladmin user or not ;
  • mysql_thread_cache_size: number of threads for the cache ;
  • mysql_innodb_buffer_pool_size: amount of RAM dedicated to InnoDB ;
  • mysql_log_bin: (default: Null, activates binlogs if used) ;
  • mysql_server_id: (default: Null, MySQL version default is then used) ;
  • mysql_custom_datadir: custom datadir
  • mysql_custom_tmpdir: custom tmpdir.
  • general_alert_email: email address to send various alert messages (default: root@localhost).
  • log2mail_alert_email: email address to send Log2mail messages to (default: general_alert_email).
  • general_scripts_dir: general directory for scripts installation (default: /usr/local/bin).
  • mysql_scripts_dir: email address to send Log2mail messages to (default: general_scripts_dir).
  • mysql_force_new_nrpe_password : change the password for NRPE even if it exists already (default: False).
  • mysql_restart_if_needed : should the restart handler be executed (default: True)

NB : changing the datadir location can be done multiple times, as long as it is not restored to the default initial location, (because a symlink is created and can't be switched back, yet).

Misc

We use the mysql-apt-config package from Oracle to configure APT sources. It is used right from the role since there is no apparent stable URL to download it from Oracle servers. We should verify from time to time if a new version is available to update the .deb in the role.

The MySQL debian package made by Oracle doesn't work with systemd out of the box. We've used the mysql-systemd-start script and the systemd unit made by Debian for the "mysql-5.7" package (currently only available for Sid).

On Stretch, "mytop" is not packages anymore (only provided by "mariadb-client-10.1"). We're using the version from the "mytop" package (currently only available for Sid).