ansible 自动化安装 mysql

098098

ansible 安装mysql
一、首先下载mysql二进制安装包（我使用的是二进制包安装的mysql）
下载地址；http://dev.mysql.com/downloads/mysql/
我使用的是mysql-5.6.19-linux-glibc2.5-x86_64.tar.gz
1、整合
#cd /usr/local/src
#tar xf mysql-5.6.19-linux-glibc2.5-x86_64.tar.gz
#mv mysql-5.6.19-linux-glibc2.5-x86_64 mysql
再次打包
#tar -zcf mysql-5.6.19.tar.gz mysql/
#mv mysql-5.6.19.tar.gz /tmp
2、创建目录并配置yml文件：
#cd /etc/ansible/roles
#mkdir -pv mysql_install/{files,meta,tasks,templates,vars}
#cd mysql_install
#mv /tmp/mysql-5.6.19.tar.gz  files/

meta目录：
#cat meta/main.yml
galaxy_info:
  author: liguang xing
  description: Install Mysql
  license: MIT
  min_ansible_version: 1.9.4
  platforms:
  - name: CentOS
    versions:
    - 6
  categories:
  - Service
dependencies: []

tasks目录：
# cat tasks/copy.yml
- name: copy mysql software to in client
  copy: src=mysql-5.6.19.tar.gz dest=/tmp/mysql-5.6.19.tar.gz owner=root group=root
  when: ansible_os_family == "RedHat" and ansible_distribution_version|int >=6
- name: create mysql user In  client
  user: name={{ mysql_user }} state=present createhome=no shell=/sbin/nologin
  when: ansible_os_family == "RedHat" and ansible_distribution_version|int >=6 and ansible_distribution_version|int >=6
- name: Copy Mysql Start Script To Redhat Client
  template: src=mysqld dest=/etc/init.d/mysqld owner=root group=root mode=0755
  when: ansible_os_family == "RedHat" and ansible_distribution_version|int >=6
- name: Copy Install Mysql Script  To Redhat Client
  template: src=install_mysql.sh dest=/tmp/ owner=root group=root mode=0755
  when: ansible_os_family == "RedHat" and ansible_distribution_version|int >=6
- name: Copy Mysql Config To Redhat Client
  template: src=my.cnf dest=/tmp/ owner=root group=root mode=0644
  when: ansible_os_family == "RedHat" and ansible_distribution_version|int >=6
- name: Copy Mysql Security Script To Redhat Client
  template: src=mysql_security.sh dest=/tmp/ owner=root group=root mode=0755
  when: ansible_os_family == "RedHat" and ansible_distribution_version|int >=6
# cat tasks/delete.yml
- name: Delete Mysql compression Software In Redhat Client
  shell: rm -f /tmp/mysql-5.6.19.tar.gz /tmp/mysql_security.sh
  when: ansible_os_family == "RedHat" and ansible_distribution_version|int >=6
# cat tasks/install.yml
- name: Create Mysql Install Dir
  file: dest=/data/mysql state=directory
  when: ansible_os_family == "RedHat" and ansible_distribution_version|int >=6
- name: Uncompression Mysql Software To Redhat Client
  shell: tar zxf /tmp/mysql-5.6.19.tar.gz -C /usr/local/
  when: ansible_os_family == "RedHat" and ansible_distribution_version|int >=6
- name: Modify Mysql Dir Permission In Redhat Client
  file: path={{ item }} owner={{ mysql_user }} group={{ mysql_user }} mode=0755
  with_items:
    - "{{ mysql_datadir }}"
    - "{{ mysql_basedir }}"
  when: ansible_os_family == "RedHat" and ansible_distribution_version|int >=6
- name: Install Mysql Script In Redhat Client
  shell: /bin/bash /tmp/install_mysql.sh
  when: ansible_os_family == "RedHat" and ansible_distribution_version|int >=6
- name: Start Myql Security Script In Redhat Client
  shell: /bin/bash /tmp/mysql_security.sh
  when: ansible_os_family == "RedHat" and ansible_distribution_version|int >=6
- name: Add Boot Start Mysql Service In Redhat Client
  shell: chkconfig --add mysqld;chkconfig mysqld on
  when: ansible_os_family == "RedHat" and ansible_distribution_version|int >=6
# cat tasks/main.yml
- include: copy.yml
- include: install.yml
- include: delete.yml

templates目录：
#cat templates/install_mysql.sh
#!/bin/bash
mv /tmp/my.cnf /etc/my.cnf
chown -R {{ mysql_user }}:{{ mysql_user }} {{ mysql_datadir }} {{ mysql_basedir }}
####init mysql DB##
cd {{ mysql_basedir }}
./scripts/mysql_install_db --defaults-file=/etc/my.cnf --datadir={{ mysql_datadir }} --user={{ mysql_user }} >> /dev/null 2>&1 &

sleep 3
service mysqld start
##add mysql env##
echo 'MANPATH  /usr/local/mysql/man' >> /etc/man.config
ln -sv /usr/local/mysql/include /usr/include/mysql
echo '/usr/local/mysql/lib' > /etc/ld.so.conf.d/mysql.conf
ldconfig

chkconfig --add mysqld
chkconfig mysqld on
rm -f /tmp/$(basename $0)

mysql的配置文件my.cnf:
# cat templates/my.cnf
[client]
port    = {{ mysql_port }}
socket  = {{ mysql_sock }}

[mysqld]
character-set-server = utf8
port      = {{ mysql_port }}
socket    = {{ mysql_sock }}
datadir   = {{ mysql_datadir }}
log-error = {{ mysql_datadir }}/mysql-error.log
pid-file  = {{ mysql_datadir }}/mysql.pid
log-bin   = {{ mysql_datadir }}/mysql-bin
skip-external-locking
skip-name-resolve
skip-symbolic-links
server-id = 123
binlog_format=mixed
binlog_cache_size=8M
max_binlog_cache_size=24M
max_binlog_size=1G
expire_logs_days=7
default_storage_engine = innodb
key_buffer_size = 384M
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 16M
join_buffer_size = 2M
thread_cache_size = 32
thread_concurrency = 16
explicit_defaults_for_timestamp=true
interactive_timeout = 120
wait_timeout = 120
table_open_cache = 4096
open_files_limit = 10240
back_log=600
max_connections = 5000
max_connect_errors = 5000
max_allowed_packet = 16M
tmp_table_size = 256M
max_heap_table_size = 512M
bulk_insert_buffer_size = 64M
myisam_sort_buffer_size = 64M
myisam_repair_threads =1
myisam-recover-options
long_query_time = 2
slow_query_log
slow_query_log_file = {{ mysql_datadir }}/slow.log
innodb_buffer_pool_size = 1G
innodb_data_file_path = ibdata1:1G:autoextend
innodb_data_home_dir = {{ mysql_datadir }}
innodb_log_group_home_dir = {{ mysql_datadir }}
innodb_file_io_threads = 4
innodb_thread_concurrency = 8
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 256M
innodb_log_file_size = 512M
innodb_log_files_in_group = 3
innodb_max_dirty_pages_pct = 90
innodb_lock_wait_timeout = 120
innodb_file_per_table = 1
innodb_support_xa=0  
innodb_flush_method = O_DIRECT
[mysqldump]
quick
max_allowed_packet = 32M
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size = 512M
sort_buffer_size = 512M
read_buffer = 8M
write_buffer = 8M
[mysqlhotcopy]
interactive-timeout

拷贝mysqld启动脚本：
#cp /usr/local/src/mysql/support-files/mysql.server templates/
设置密码脚本：
# cat templates/mysql_security.sh
#!/bin/bash
{{ mysql_basedir }}/bin/mysql -h localhost -u root -e "set password for 'root'@'localhost' = password('mima');"

vars 目录：
# cat vars/main.yml
mysql_basedir: /usr/local/mysql
mysql_datadir: /data/mysql
mysql_user: mysql
mysql_database_user: root
mysql_passwd: 'mima'
mysql_port: 3306
mysql_sock: /data/mysql/mysql.sock
mysql_charset: utf8
mysql_collation: utf8_general_ci
mysql_version: mysql-5.6.19-linux-glibc2.5-x86_64.tar.gz

3、创建安装yml脚本
#cd /etc/ansible/roles
#mkdir -pv common/{meta,tasks}
#cat common/meta/main.yml
galaxy_info:
  author: liguang xing
  description: Install initializtion Software
  license: MIT
  min_ansible_version: 1.9.4
  platforms:
  - name: CentOS
    versions:
    - 5
    - 6
  - name: Ubuntu
    versions:
    - precise
  categories:
  - system
dependencies: []
# cat common/tasks/main.yml
- name: install initializtion require software
  shell: yum -y install make cmake bc man* gcc gcc-c++ autoconf libjpeg libjpeg-devel libpng libpng-devel freetype freetype-devel libxml2 libxml2-devel zlib zlib-devel glibc glibc-devel glib2 glib2-devel bzip2 bzip2-devel ncurses ncurses-devel curl curl-devel e2fsprogs e2fsprogs-devel krb5-devel libidn libidn-devel openssl openssl-devel nss_ldap openldap openldap-devel openldap-clients libxslt-devel libevent-devel ntp libtool-ltdl bison libaio libtool vim-enhanced wget readline-devel libyaml-devel  patch telnet dmidecode pcre pcre-devel
  poll: 0
注：libaio rpm包一定要安装，mysql启动要依赖着包
# cat mysql_install.yml
---
- hosts: "{{host}}"
  remote_user: "{{user}}"
  gather_facts: True
  roles:
    - common
    - mysql_install
4、开始执行
#ansible-playbook mysql_install.yml --syntax-check   --检测语法
playbook: mysql_install.yml
没错误开始执行：
# ansible-playbook mysql_install.yml --extra-vars "host=web user=root"
PLAY [web] ********************************************************************
GATHERING FACTS ***************************************************************
ok: [10.0.90.24]
TASK: [common | install initializtion require software] ***********************
changed: [10.0.90.24]
TASK: [mysql_install | copy mysql software to in client] **********************
ok: [10.0.90.24]
TASK: [mysql_install | create mysql user In  client] **************************
changed: [10.0.90.24]
TASK: [mysql_install | Copy Mysql Start Script To Redhat Client] **************
changed: [10.0.90.24]
TASK: [mysql_install | Copy Install Mysql Script  To Redhat Client] ***********
changed: [10.0.90.24]
TASK: [mysql_install | Copy Mysql Config To Redhat Client] ********************
changed: [10.0.90.24]
TASK: [mysql_install | Copy Mysql Security Script To Redhat Client] ***********
changed: [10.0.90.24]
TASK: [mysql_install | Create Mysql Install Dir] ******************************
changed: [10.0.90.24]
TASK: [mysql_install | Uncompression Mysql Software To Redhat Client] *********
changed: [10.0.90.24]
TASK: [mysql_install | Modify Mysql Dir Permission In Redhat Client] **********
changed: [10.0.90.24] => (item=/data/mysql)
changed: [10.0.90.24] => (item=/usr/local/mysql)
TASK: [mysql_install | Install Mysql Script In Redhat Client] *****************
changed: [10.0.90.24]
TASK: [mysql_install | Start Myql Security Script In Redhat Client] ***********
changed: [10.0.90.24]
TASK: [mysql_install | Add Boot Start Mysql Service In Redhat Client] *********
changed: [10.0.90.24]
TASK: [mysql_install | Delete Mysql compression Software In Redhat Client] ****
changed: [10.0.90.24]
PLAY RECAP ********************************************************************
10.0.90.24                 : ok=15   changed=13   unreachable=0    failed=0   

成功之后到90.24服务器上查看mysql是否安装成功！我测试没问题
二、删除mysql
1、创建目录：
#cd /etc/ansible/roes
#mkdir -pv mysql_delete/{meta,tasks,vars}
# cat meta/main.yml
galaxy_info:
  author: liguang xing
  description: Delete Mysql
  license: MIT
  min_ansible_version: 1.9.4
  platforms:
  - name: CentOS
    versions:
    - 6
  categories:
  - Service
dependencies: []
# cat tasks/delete.yml
- name: Stop Mysql Service
  service: name=mysqld state=stopped
  ignore_errors: yes
  when: ansible_os_family == "RedHat" and ansible_distribution_version|int >=6
- name: Delete Mysql Boot Start Script
  shell: chkconfig --del mysqld
  ignore_errors: yes
  when: ansible_os_family == "RedHat" and ansible_distribution_version|int >=6
- name: Delete Mysql Dir And Socket
  shell: rm -rf {{ mysql_basedir }} {{ mysql_datadir }}
  when: ansible_os_family == "RedHat" and ansible_distribution_version|int >=6
- name: Delete Mysql User
  shell: userdel {{ mysql_user }}
  ignore_errors: yes
  when: ansible_os_family == "RedHat" and ansible_distribution_version|int >=6
- name: Delete Mysql Service Start Script
  shell: rm -f /etc/init.d/mysqld
  when: ansible_os_family == "RedHat" and ansible_distribution_version|int >=6
- name: Delete Mysql lib
  shell: rm -f /etc/ld.so.conf.d/mysql.conf
  when: ansible_os_family == "RedHat" and ansible_distribution_version|int >=6
- name: Delete Mysql include file
  shell: rm -f /usr/include/mysql
  when: ansible_os_family == "RedHat" and ansible_distribution_version|int >=6
- name: Delete Mysql config file
  shell: rm -f /etc/my.cnf
  when: ansible_os_family == "RedHat" and ansible_distribution_version|int >=6
# cat tasks/main.yml
- include: delete.yml
# cat vars/main.yml
mysql_basedir: /usr/local/mysql
mysql_datadir: /data/mysql
mysql_user: mysql

2、创建删除mysql的yml文件：
#cd /etc/ansible/roles
# cat mysql_delete.yml
---
- hosts: "{{host}}"
  remote_user: "{{user}}"
  gather_facts: True
  roles:
    - mysql_delete
3、检测语法并执行：
# ansible-playbook mysql_delete.yml --syntax-check
playbook: mysql_delete.yml  
无报错，开始执行
# ansible-playbook mysql_delete.yml --extra-vars "host=web user=root"
PLAY [web] ********************************************************************
GATHERING FACTS ***************************************************************
ok: [10.0.90.24]
TASK: [mysql_delete | Stop Mysql Service] *************************************
changed: [10.0.90.24]
TASK: [mysql_delete | Delete Mysql Boot Start Script] *************************
changed: [10.0.90.24]
TASK: [mysql_delete | Delete Mysql Dir And Socket] ****************************
changed: [10.0.90.24]
TASK: [mysql_delete | Delete Mysql User] **************************************
changed: [10.0.90.24]
TASK: [mysql_delete | Delete Mysql Service Start Script] **********************
changed: [10.0.90.24]
TASK: [mysql_delete | Delete Mysql lib] ***************************************
changed: [10.0.90.24]
TASK: [mysql_delete | Delete Mysql include file] ******************************
changed: [10.0.90.24]
TASK: [mysql_delete | Delete Mysql config file] *******************************
changed: [10.0.90.24]
PLAY RECAP ********************************************************************
10.0.90.24                 : ok=9    changed=8    unreachable=0    failed=0   
执行成功，无报错！