---
- name: install mysql
hosts: all
vars:
mysql: mysql-8.0.28-linux-glibc2.12-x86_64
tasks:
- name: install package
yum:
name:
- libaio
- numactl-libs
state: present
when: ansible_distribution == "CentOS" or ansible_distribution == "Rocky"
- name: apt package
apt:
name: libtinfo5
update_cache: yes
state: present
when: ansible_distribution == "Ubuntu"
- name: create group
group:
name: mysql
system: yes
gid: 336
state: present
- name: create user
user:
name: mysql
group: mysql
system: yes
uid: 336
create_home: no
shell: /sbin/nologin
state: present
- name: copy package to remote
unarchive:
src: /data/ansible/files/{{ mysql }}.tar.xz
dest: /usr/local
owner: mysql
group: mysql
- name: create link
file:
src: /usr/local/{{ mysql }}
dest: /usr/local/mysql
state: link
owner: mysql
group: mysql
- name: path
copy:
content: "PATH=/usr/local/mysql/bin:$PATH"
dest: /etc/profile.d/mysql.sh
- name: copy configfile to remote
copy:
src: /data/ansible/files/my.cnf
dest: /etc/my.cnf
- name: create datadir
file:
path: /data/mysql
state: directory
owner: mysql
group: mysql
- name: data
shell: rm -rf /data/mysql/* ; /usr/local/mysql/bin/mysqld --initialize-insecure --user=mysql --datadir=/data/mysql
- name: copy service to remote
copy:
src: /data/ansible/files/mysql.server
dest: /etc/init.d/mysqld
mode: '755'
- name: centos service
shell: "chkconfig --add mysqld ; systemctl start mysqld"
when: ansible_distribution == "CentOS" or ansible_distribution == "Rocky"
- name: ubuntu service
shell: "systemctl enable mysqld ; systemctl start mysqld"
when: ansible_distribution == "Ubuntu"
