运维自动化之ansible playbook安装mysql_MySQL

mysql_basedir: /data/mysql/basedir源码目录mysql_datadir: /data/mysql/datadir数据目录mysql_user: mysql mysql用户mysql_database_user: root 数据库用户mysql_passwd: 'E4yR3WnoluSFTCBAI' 数据库密码mysql_port: 3306mysql监听端口mysql_sock: /data/mysql/datadir/mysql.sockmysql的sockmysql_charset: utf8 mysql字符集mysql_collation: utf8_general_cimysql排序方式mysql_version: Percona-Server-5.5.21-rel25.1.tar.gz mysql版本

10:24:06 # tree mysql_*mysql_delete├── files├── handlers├── meta│ └── main.yml├── tasks│ ├── delete.yml│ └── main.yml├── templates└── vars └── main.ymlmysql_install├── files│ └── mysql.tar.gz├── handlers├── meta│ └── main.yml├── tasks│ ├── copy.yml│ ├── delete.yml│ ├── install.yml│ └── main.yml├── templates│ ├── install_mysql.sh│ ├── my.cnf│ ├── mysqld│ └── mysql_security.sh└── vars └── main.yml12 directories, 15 files

10:32:06 # cat mysql_install.yml ---- hosts: "{{host}}"remote_user: "{{user}}"gather_facts: Trueroles:- common- mysql_install

10:32:44 # cat mysql_delete.yml ---- hosts: "{{host}}"remote_user: "{{user}}"gather_facts: Trueroles:- mysql_delete

10:26:00 #time ansible-playbook mysql_install.yml --extra-vars "host=192.168.240.17 user=root" --private-key=/root/test.pem PLAY [192.168.240.17] ********************************************************* GATHERING FACTS *************************************************************** ok: [192.168.240.17]TASK: [common | Install initializtion require software] *********************** changed: [192.168.240.17]TASK: [mysql_install | Copy Mysql Software To Redhat Client] ****************** changed: [192.168.240.17]TASK: [mysql_install | Create Mysql User In Redhat Client] ******************** changed: [192.168.240.17]TASK: [mysql_install | Copy Mysql Start Script To Redhat Client] ************** changed: [192.168.240.17]TASK: [mysql_install | Copy Install Mysql ScriptTo Redhat Client] *********** changed: [192.168.240.17]TASK: [mysql_install | Copy Mysql Config To Redhat Client] ******************** changed: [192.168.240.17]TASK: [mysql_install | Copy Mysql Security Script To Redhat Client] *********** changed: [192.168.240.17]TASK: [mysql_install | Create Mysql Install Dir] ****************************** ok: [192.168.240.17]TASK: [mysql_install | Uncompression Mysql Software To Redhat Client] ********* changed: [192.168.240.17]TASK: [mysql_install | Modify Mysql Dir Permission In Redhat Client] ********** ok: [192.168.240.17] => (item=/data/mysql/datadir)ok: [192.168.240.17] => (item=/data/mysql/basedir)TASK: [mysql_install | Install Mysql Script In Redhat Client] ***************** changed: [192.168.240.17]TASK: [mysql_install | Start Myql Security Script In Redhat Client] *********** changed: [192.168.240.17]TASK: [mysql_install | Add Boot Start Mysql Service In Redhat Client] ********* changed: [192.168.240.17]TASK: [mysql_install | Delete Mysql compression Software In Redhat Client] **** changed: [192.168.240.17]PLAY RECAP ******************************************************************** 192.168.240.17 : ok=15 changed=12 unreachable=0failed=0 real 2m1.596suser 0m8.815ssys 0m0.848s

[root@ip-10-10-240-21 tmp]# lltotal 16lrwxrwxrwx 1 root root30 Jul 13 22:27 mysql.sock -> /data/mysql/datadir/mysql.sock-rw------- 1 root root 256 Jul 10 06:07 tmp.0PLkgCq81n-rw------- 1 root root 197 Jul9 05:35 yum_save_tx-2014-07-09-09-35ibcBiO.yumtx-rw-rw-r-- 1 zabbix zabbix 320 Jul 10 21:39 zabbix_agentd.log-rw-rw-r-- 1 zabbix zabbix 5 Jul 10 21:39 zabbix_agentd.pid[root@ip-10-10-240-21 tmp]# ps -ef|grep mysqlroot 21333 10 22:27 ?00:00:00 /bin/sh /data/mysql/basedir/bin/mysqld_safe --defaults-file=/data/mysql/datadir/my.cnf --datadir=/data/mysql/datadir --pid-file=/data/mysql/datadir/mysql.pidmysql22156 213332 22:27 ?00:00:08 /data/mysql/basedir/bin/mysqld --defaults-file=/data/mysql/datadir/my.cnf --basedir=/data/mysql/basedir --datadir=/data/mysql/datadir --plugin-dir=/data/mysql/basedir/lib/plugin --user=mysql --log-error=/data/mysql/datadir/mysql-error.log --open-files-limit=10240 --pid-file=/data/mysql/datadir/mysql.pid --socket=/data/mysql/datadir/mysql.sock --port=3306root 22440 202330 22:33 pts/000:00:00 grep mysql[root@ip-10-10-240-21 tmp]# ll /data/mysql/total 8drwxr-xr-x 13 mysql mysql 4096 Jun 26 03:59 basedirdrwxr-xr-x4 mysql mysql 4096 Jul 13 22:28 datadir[root@ip-10-10-240-21 tmp]# ll /etc/init.d/mysqld -rwxr-xr-x 1 root root 10905 Jul 13 22:27 /etc/init.d/mysqld[root@ip-10-10-240-21 tmp]# /etc/init.d/mysqld statusMySQL (Percona Server) running (22156) [OK][root@ip-10-10-240-21 tmp]# chkconfig --list|grep mysqlmysqld 0:off 1:off 2:on 3:on 4:on 5:on 6:off[root@ip-10-10-240-21 tmp]# mysql -h 192.168.240.17 -u root -pE4yR3WnoluSFTCBAIERROR 1045 (28000): Access denied for user 'root'@'192.168.240.17' (using password: YES)[root@ip-10-10-240-21 tmp]# mysql -h 10.10.240.21 -u root -pE4yR3WnoluSFTCBAIWelcome to the MySQL monitor.Commands end with ; or /g.Your MySQL connection id is 8Server version: 5.5.21-log Source distributionCopyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '/h' for help. Type '/c' to clear the current input statement.mysql> show databases;+--------------------+| Database |+--------------------+| information_schema || mysql|| performance_schema |+--------------------+3 rows in set (0.00 sec)mysql> use mysqlReading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedmysql> select host,user,password from user;+--------------+--------+-------------------------------------------+| host | user | password|+--------------+--------+-------------------------------------------+| 10.10.240.21 | root | *BE78618CBAFFF409CE17D81579C1678B94439BE1 || %| zabbix | *DEEF4D7D88CD046ECA02A80393B7780A63E7E789 |+--------------+--------+-------------------------------------------+2 rows in set (0.00 sec)

10:49:18 #time ansible-playbook mysql_delete.yml --extra-vars "host=192.168.240.17 user=root" --private-key=/root/test.pem PLAY [192.168.240.17] ********************************************************* GATHERING FACTS *************************************************************** ok: [192.168.240.17]TASK: [mysql_delete | Stop Mysql Service] ************************************* changed: [192.168.240.17]TASK: [mysql_delete | Delete Mysql Boot Start Script] ************************* changed: [192.168.240.17]TASK: [mysql_delete | Delete Mysql Dir And Socket] **************************** changed: [192.168.240.17]TASK: [mysql_delete | Delete Mysql User] ************************************** changed: [192.168.240.17]TASK: [mysql_delete | Delete Mysql Service Start Script] ********************** changed: [192.168.240.17]PLAY RECAP ******************************************************************** 192.168.240.17 : ok=6changed=5unreachable=0failed=0 real 0m25.248suser 0m0.632ssys 0m0.102s

[root@ip-10-10-240-21 tmp]# ll /tmp/total 16-rw------- 1 root root 256 Jul 10 06:07 tmp.0PLkgCq81n-rw------- 1 root root 197 Jul9 05:35 yum_save_tx-2014-07-09-09-35ibcBiO.yumtx-rw-rw-r-- 1 zabbix zabbix 320 Jul 10 21:39 zabbix_agentd.log-rw-rw-r-- 1 zabbix zabbix 5 Jul 10 21:39 zabbix_agentd.pid[root@ip-10-10-240-21 tmp]# ll /data/total 4drwxr-xr-x 3 root root 4096 Jul 10 22:11 webroot[root@ip-10-10-240-21 tmp]# ps -ef|grep mysqlroot 22955 202330 22:50 pts/000:00:00 grep mysql[root@ip-10-10-240-21 tmp]# ll /etc/init.d/mysqlls: cannot access /etc/init.d/mysql: No such file or directory[root@ip-10-10-240-21 tmp]# chkconfig --list|grep mysql[root@ip-10-10-240-21 tmp]#

11:20:08 # unzip -v mysql_install.zip Archive:mysql_install.zip Length MethodSizeCmprDateTime CRC-32 Name--------------------- ---- ---------- ----- ------------ 113Defl:N 8921% 07-14-2014 10:32 aaed0763mysql_install.yml99Defl:N 8217% 07-14-2014 10:32 70c2a028mysql_delete.yml 0Stored0 0% 07-03-2014 17:29 00000000roles/common/ 0Stored0 0% 06-30-2014 15:58 00000000roles/common/meta/ 267Defl:N17833% 06-30-2014 15:58 31ee20ecroles/common/meta/main.yml 0Stored0 0% 07-11-2014 09:31 00000000roles/common/tasks/ 586Defl:N26854% 07-08-2014 10:18 1c0af2a1roles/common/tasks/main.yml 0Stored0 0% 06-19-2014 13:43 00000000roles/common/handlers/58Defl:N 4817% 06-19-2014 13:43 8d058053roles/common/handlers/main.yml 0Stored0 0% 06-19-2014 13:30 00000000roles/common/vars/ 0Stored0 0% 06-19-2014 13:30 00000000roles/common/templates/ 0Stored0 0% 06-19-2014 13:30 00000000roles/common/files/ 0Stored0 0% 06-24-2014 11:27 00000000roles/mysql_install/ 0Stored0 0% 07-08-2014 14:12 00000000roles/mysql_install/meta/ 198Defl:N14925% 07-08-2014 14:12 b03e00ebroles/mysql_install/meta/main.yml 0Stored0 0% 07-14-2014 09:27 00000000roles/mysql_install/tasks/ 201Defl:N15324% 07-14-2014 09:27 51de730broles/mysql_install/tasks/delete.yml65Defl:N 4137% 07-14-2014 09:27 a3197ca7roles/mysql_install/tasks/main.yml1281Defl:N32974% 07-14-2014 09:27 73d60454roles/mysql_install/tasks/copy.yml1162Defl:N37568% 07-14-2014 09:27 e5a7341croles/mysql_install/tasks/install.yml 0Stored0 0% 06-19-2014 13:30 00000000roles/mysql_install/handlers/ 0Stored0 0% 07-14-2014 09:51 00000000roles/mysql_install/vars/ 313Defl:N17744% 07-14-2014 09:51 bf4476a7roles/mysql_install/vars/main.yml 0Stored0 0% 07-14-2014 11:11 00000000roles/mysql_install/templates/ 518Defl:N24154% 07-14-2014 09:15 529052bfroles/mysql_install/templates/install_mysql.sh 10905Defl:N 376566% 06-26-2014 14:06 e35e7b82roles/mysql_install/templates/mysqld2122Defl:N82361% 07-14-2014 09:49 f91c74abroles/mysql_install/templates/my.cnf 794Defl:N27565% 07-03-2014 13:15 560ee63eroles/mysql_install/templates/mysql_security.sh 0Stored0 0% 06-26-2014 13:59 00000000roles/mysql_install/files/61805835Defl:N 60413846 2% 06-26-2014 16:18 f61e317droles/mysql_install/files/mysql.tar.gz 0Stored0 0% 06-24-2014 11:27 00000000roles/mysql_delete/ 0Stored0 0% 07-08-2014 14:12 00000000roles/mysql_delete/meta/ 197Defl:N14725% 07-08-2014 14:12 fe6b0ef8roles/mysql_delete/meta/main.yml 0Stored0 0% 07-14-2014 09:39 00000000roles/mysql_delete/tasks/ 692Defl:N24565% 07-14-2014 09:39 dccd57b4roles/mysql_delete/tasks/delete.yml22Stored 22 0% 06-27-2014 13:30 728ce4aaroles/mysql_delete/tasks/main.yml 0Stored0 0% 06-19-2014 13:30 00000000roles/mysql_delete/handlers/ 0Stored0 0% 07-03-2014 13:16 00000000roles/mysql_delete/vars/ 313Defl:N17744% 07-14-2014 10:56 bf4476a7roles/mysql_delete/vars/main.yml 0Stored0 0% 06-27-2014 13:30 00000000roles/mysql_delete/templates/ 0Stored0 0% 06-27-2014 13:30 00000000roles/mysql_delete/files/-------------------------61825741 60421430 2%41 files