CentOS 7使用ansible批量部署mysql-5.7

1.环境准备
准备3台新装的虚拟机，部署服务器的内存至少大于2G，否则编译时可能会报错。

HostName	IP
Ansible	192.168.55.105
Master	192.168.55.171
Slave	192.168.55.102

2.Ansible-Playbook配置思路

1. files中的mysql_install.sh为源码安装mysql的执行脚本

2. tasks中的copy.yml为复制所需文件至目标服务器上

3. tasks中的install.yml调用mysql_install.sh脚本来执行，将mysql安装到变量定义中的路径下

4. tasks中的main.yml调用copy模块和install模块

5. templates中的my.cnf.j2为mysql的主配置文件

6. mysql_install.yml调用剧本:mysql_install

目录结构
├── hosts
├── mysql_install.yml
└── roles
└── mysql_install
├── default
├── files
│ ├── mysql-boost-5.7.30.tar.gz
│ └── mysql_install.sh
├── handlers
├── meta
├── tasks
│ ├── copy.yml
│ ├── install.yml
│ └── main.yml
├── templates
│ └── my.cnf.j2
└── vars
└── main.yml

3.关闭防火墙和selinux

~]# systemctl stop firewalld
~]# systemctl disable firewalld
~]# setenforce 0
~]# vi /etc/selinux/config
	SELINUX=disabled

4.安装Ansible
更换yum源，安装ansible

 ~]# yum -y install wget
 ~]# rm -rf /etc/yum.repo.d/*
 ~]# wget -O /etc/yum.repos.d/CentOS-Base.repo https://mirrors.aliyun.com/repo/Centos-7.repo

 ~]# yum -y install ansible

5.下载带有boost的mysql-5.7.30.tar.gz

 ~]# wget -P /tmp https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-boost-5.7.30.tar.gz

6.设置hosts解析,并复制给其它服务器

~]# vi /etc/hosts
	192.168.55.105 ansible
	192.168.55.171 master
	192.168.55.102 slave
~]# scp /etc/hosts root@192.168.55.171:/etc
~]# scp /etc/hosts root@192.168.55.102:/etc

7.修改hosts