58 lines
1.3 KiB
YAML
58 lines
1.3 KiB
YAML
- name: Install mysql community repo
|
|
yum:
|
|
name: https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
|
|
state: installed
|
|
|
|
- name: Install mysql server, default 8.0
|
|
yum:
|
|
name:
|
|
- mysql-community-server
|
|
- mysql-community-libs-compat
|
|
state: present
|
|
|
|
- name: Tune mysql with baseline
|
|
blockinfile:
|
|
path: /etc/my.cnf
|
|
backup: yes
|
|
insertafter: '\[mysqld\]'
|
|
block: |
|
|
open_files_limit=8192
|
|
max_connections = 200
|
|
wait_timeout=180
|
|
innodb_file_per_table
|
|
innodb_log_file_size=64M
|
|
innodb_log_files_in_group=3
|
|
innodb_log_buffer_size=8M
|
|
default_storage_engine = innodb
|
|
|
|
- name: Start up mysql
|
|
service:
|
|
name: mysqld
|
|
state: started
|
|
enabled: yes
|
|
|
|
- name: Grep mysql cred
|
|
shell: awk '/temporary password is generated/ {print $NF}' /var/log/mysqld.log
|
|
register: mysqlRoot
|
|
|
|
- name: Set mysql cred in /root/my.cnf
|
|
blockinfile:
|
|
path: /root/.my.cnf
|
|
mode: 0600
|
|
block: |
|
|
[client]
|
|
password = {{ mysqlRoot.stdout }}
|
|
|
|
- name: Create db-dumps directory
|
|
file:
|
|
path: /db-dumps
|
|
state: directory
|
|
mode: 0700
|
|
|
|
- name: Schedule daily db dump
|
|
lineinfile:
|
|
path: /etc/crontab
|
|
line: '@daily root mysqldump --opt --all-databases | gzip -c > /db-dumps/alldb-$(date +%w).sql.gz'
|
|
state: present
|
|
|