ansible mysql安装,Ansible批量部署MySQL

1.1 将mysql软件包同步到客户端服务器，做安装前期准备

首先将mysql安装包拖到ansible服务端的/ansible/roles/mysql/files目录下

vim /ansible/roles/mysql/tasks/main.yml

- name: copy mysql_tar_gz to client

copy: src=mysql-5.6.35.tar.gz dest=/tmp/mysql-5.6.35.tar.gz

- name: copy install_script to client

copy: src=mysql_install.sh dest=/tmp/mysql_install.sh owner=root group=root mode=755

- name: install mysql

shell: /bin/bash /tmp/mysql_install.sh

1.2 创建mysql 安装脚本

/ansible/roles/mysql/files/mysql_install.sh

#!/bin/bash

####定义mysql数据库路径，和mysql登录密码

DBDIR='/application/mysql/data'

PASSWD='bingoclo123'

####判断数据目录是否存在如果不存在递归创建目录

[ -d $DBDIR ] || mkdir $DBDIR -p

####安装mysql组件

yum install cmake make gcc-c++ bison-devel ncurses-devel -y

id mysql &> /dev/null

####如果执行id mysql输出为0 那么就是执行正确创建mysql用户

if [ $? -ne 0 ];then

useradd m