526互联

ansible-playbook实现MySQL的二进制部署

发布时间 2023-10-07 15:08:56作者: 小糊涂90

 

#安装mysql5.6
[root@ansible ~]#ls -l /data/ansible/files/mysql-5.6.46-linux-glibc2.12-x86_64.tar.gz
-rw-r--r-- 1 root root 403177622 Dec  4 13:05 /data/ansible/files/mysql-5.6.46-linux-glibc2.12-x86_64.tar.gz

[root@ansible ~]#cat /data/ansible/files/my.cnf
[mysqld]
socket=/tmp/mysql.sock
user=mysql
symbolic-links=0
datadir=/data/mysql
innodb_file_per_table=1
log-bin
pid-file=/data/mysql/mysqld.pid
[client]
port=3306
socket=/tmp/mysql.sock
[mysqld_safe]
log-error=/var/log/mysqld.log

[root@ansible ~]#cat /data/ansible/files/secure_mysql.sh
#!/bin/bash
/usr/local/mysql/bin/mysql_secure_installation <<EOF

y
123456
123456
y
y
y
y
EOF

[root@ansible ~]#tree /data/ansible/files/
/data/ansible/files/
├── my.cnf
├── mysql-5.6.46-linux-glibc2.12-x86_64.tar.gz
└── secure_mysql.sh
0 directories, 3 files

[root@ansible ~]#cat /data/ansible/install_mysql.yml
---
# install mysql-5.6.46-linux-glibc2.12-x86_64.tar.gz
- hosts: dbsrvs
remote_user: root
gather_facts: no
tasks:
   - name: install packages
    yum: name=libaio,perl-Data-Dumper,perl-Getopt-Long
   - name: create mysql group
    group: name=mysql gid=306
   - name: create mysql user
    user: name=mysql uid=306 group=mysql shell=/sbin/nologin system=yes create_home=no home=/data/mysql
   - name: copy tar to remote host and file mode
    unarchive: src=/data/ansible/files/mysql-5.6.46-linux-glibc2.12-x86_64.tar.gz dest=/usr/local/ owner=root group=root
   - name: create linkfile /usr/local/mysql
    file: src=/usr/local/mysql-5.6.46-linux-glibc2.12-x86_64 dest=/usr/local/mysql state=link
   - name: data dir
    shell: chdir=/usr/local/mysql/ ./scripts/mysql_install_db --datadir=/data/mysql --user=mysql
    tags: data
   - name: config my.cnf
    copy: src=/data/ansible/files/my.cnf  dest=/etc/my.cnf
   - name: service script
    shell: /bin/cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
   - name: enable service
    shell: /etc/init.d/mysqld start;chkconfig --add mysqld;chkconfig mysqld on
    tags: service
   - name: PATH variable
    copy: content='PATH=/usr/local/mysql/bin:$PATH' dest=/etc/profile.d/mysql.sh
   - name: secure script
    script: /data/ansible/files/secure_mysql.sh
    tags: script
   
   
   
#判断centos7或者centos8安装mysql5.7  
[root@centos8 ansible]# mkdir files
[root@centos8 ansible]# ls files/
mysql-5.7.33-linux-glibc2.12-x86_64.tar.gz
[root@centos8 ansible]# vim files/my.cnf
[mysqld]
server-id=1
log-bin
datadir=/data/mysql
socket=/data/mysql/mysql.sock                                                  
                                               
log-error=/data/mysql/mysql.log
pid-file=/data/mysql/mysql.pid
[client]
socket=/data/mysql/mysql.sock
[root@centos8 ansible]# vim vars.yml
---
# variables file
mysql_version: 5.7.33
[root@centos8 ansible]# cat files/set_password.sh
#!/bin/bash
MYSQL_ROOT_PASSWORD=123456
MYSQL_OLDPASSWORD=`awk '/A temporary password/{print $NF}'
/data/mysql/mysql.log`mysqladmin  -uroot -p$MYSQL_OLDPASSWORD password $MYSQL_ROOT_PASSWORD&>/dev/null
[root@centos8 ansible]# vim install_mysql5.7.yml
---
# install mysql-5.7.33-linux-glibc2.12-x86_64.tar.gz
- hosts: 10.0.0.150
remote_user: root
gather_facts: yes
vars_files:
   - vars.yml
tasks:
   - name: install packages for centos7
    yum: name=libaio,perl-Data-Dumper
    when: ansible_facts['distribution_major_version'] == "7"
   - name: install packages for centos8
    yum: name=libaio,perl-Data-Dumper,ncurses-compat-libs
    when: ansible_facts['distribution_major_version'] == "8"
   - name: cteate mysql group
    group: name=mysql gid=306
   - name: create mysql user
    user: name=mysql uid=306 group=mysql shell=/sbin/nologin system=yes create_home=no home=/data/mysql
   - name: copy tar to remote host and file mode
    unarchive: src=/data/ansible/files/mysql-{{mysql_version}}-linux￾glibc2.12-x86_64.tar.gz dest=/usr/local/ owner=root group=root
   - name: create linkfile /usr/local/mysql
    file: src=/usr/local/mysql-{{mysql_version}}-linux-glibc2.12-x86_64 dest=/usr/local/mysql state=link
   - name: PATH variable
    copy: content='PATH=/usr/local/mysql/bin:$PATH' dest=/etc/profile.d/mysql.sh
   - name: PATH variable entry
    shell: . /etc/profile.d/mysql.sh
   - name: config my.cnf
    copy: src=/data/ansible/files/my.cnf dest=/etc/my.cnf
   - name: data dir
    shell: chdir=/usr/local/mysql ./bin/mysqld --initialize --user=mysql --datadir=/data/mysql
   - name: service script
    shell: /bin/cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
   - name: enable service
    shell: /etc/init.d/mysqld start;chkconfig --add mysqld;chkconfig mysqld on
    tags: service
   - name: set mysql user password
    script: /data/ansible/files/set_password.sh
    tags: script
[root@centos8 ansible]# tree
.
├── files
│   ├── my.cnf
│   ├── mysql-5.7.33-linux-glibc2.12-x86_64.tar.gz
│   └── set_password.sh
├── install_mysql5.7.yml
└── vars.yml
1 directory, 5 files
[root@centos8 ansible]# ansible-playbook install_mysql5.7.yml