Cluster O & M automation tool ansible uses playbook to install mysql_MySQL

Cluster O & M automation tool ansible uses playbook to install mysql Cluster

Last time I introduced how to use ansible playbook to install the zabbix client (http://www.bitsCN.com/article/52158.htm), this time I introduced how to use playbook to install mysql.

The following is the information for installing mysql:

Mysql_basedir:/data/mysql/basedir source code directory mysql_datadir: 3306 mysql listening port mysql_sock:/data/mysql/datadir/mysql. sock mysql sockmysql_charset: utf8 mysql character set mysql_collation: utf8_general_ci mysql sort mysql_version: Percona-Server-5.5.21-rel25.1.tar.gz mysql version

The following is the playbook structure for installing 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

The mysql installation for playbook is

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

Which of the following is the help of mysql in playbook?

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

The structure of zabbix client has been introduced in the previous article.

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 Script To 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=0 failed=0 real 2m1.596suser 0m8.815ssys 0m0.848s

2. test after installation

Log on to the test machine 192.168.240.17 to check the mysql installation status.

[root@ip-10-10-240-21 tmp]# lltotal 16lrwxrwxrwx 1 root root 30 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 Jul 9 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  1 0 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.pidmysql 22156 21333 2 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 20233 0 22:33 pts/0 00: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-x 4 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)

As you can see, the installation has been completed as per my requirements. The deletion test is carried out below.

3. delete

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=6 changed=5 unreachable=0 failed=0 real 0m25.248suser 0m0.632ssys 0m0.102s

4. test after deletion

[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 Jul 9 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 20233 0 22:50 pts/0 00: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]#

The deletion is complete.

If you want to use my example, you can download it from the address of Baidu cloud (the file is larger than 50 MB and cannot be placed in the attachment or 51 Download Center). The address is "attachment ".

11:20:08 # unzip -v mysql_install.zip Archive: mysql_install.zip Length Method Size Cmpr Date Time CRC-32 Name-------- ------ ------- ---- ---------- ----- -------- ----  113 Defl:N  89 21% 07-14-2014 10:32 aaed0763 mysql_install.yml  99 Defl:N  82 17% 07-14-2014 10:32 70c2a028 mysql_delete.yml  0 Stored  0 0% 07-03-2014 17:29 00000000 roles/common/  0 Stored  0 0% 06-30-2014 15:58 00000000 roles/common/meta/  267 Defl:N  178 33% 06-30-2014 15:58 31ee20ec roles/common/meta/main.yml  0 Stored  0 0% 07-11-2014 09:31 00000000 roles/common/tasks/  586 Defl:N  268 54% 07-08-2014 10:18 1c0af2a1 roles/common/tasks/main.yml  0 Stored  0 0% 06-19-2014 13:43 00000000 roles/common/handlers/  58 Defl:N  48 17% 06-19-2014 13:43 8d058053 roles/common/handlers/main.yml  0 Stored  0 0% 06-19-2014 13:30 00000000 roles/common/vars/  0 Stored  0 0% 06-19-2014 13:30 00000000 roles/common/templates/  0 Stored  0 0% 06-19-2014 13:30 00000000 roles/common/files/  0 Stored  0 0% 06-24-2014 11:27 00000000 roles/mysql_install/  0 Stored  0 0% 07-08-2014 14:12 00000000 roles/mysql_install/meta/  198 Defl:N  149 25% 07-08-2014 14:12 b03e00eb roles/mysql_install/meta/main.yml  0 Stored  0 0% 07-14-2014 09:27 00000000 roles/mysql_install/tasks/  201 Defl:N  153 24% 07-14-2014 09:27 51de730b roles/mysql_install/tasks/delete.yml  65 Defl:N  41 37% 07-14-2014 09:27 a3197ca7 roles/mysql_install/tasks/main.yml 1281 Defl:N  329 74% 07-14-2014 09:27 73d60454 roles/mysql_install/tasks/copy.yml 1162 Defl:N  375 68% 07-14-2014 09:27 e5a7341c roles/mysql_install/tasks/install.yml  0 Stored  0 0% 06-19-2014 13:30 00000000 roles/mysql_install/handlers/  0 Stored  0 0% 07-14-2014 09:51 00000000 roles/mysql_install/vars/  313 Defl:N  177 44% 07-14-2014 09:51 bf4476a7 roles/mysql_install/vars/main.yml  0 Stored  0 0% 07-14-2014 11:11 00000000 roles/mysql_install/templates/  518 Defl:N  241 54% 07-14-2014 09:15 529052bf roles/mysql_install/templates/install_mysql.sh 10905 Defl:N  3765 66% 06-26-2014 14:06 e35e7b82 roles/mysql_install/templates/mysqld 2122 Defl:N  823 61% 07-14-2014 09:49 f91c74ab roles/mysql_install/templates/my.cnf  794 Defl:N  275 65% 07-03-2014 13:15 560ee63e roles/mysql_install/templates/mysql_security.sh  0 Stored  0 0% 06-26-2014 13:59 00000000 roles/mysql_install/files/61805835 Defl:N 60413846 2% 06-26-2014 16:18 f61e317d roles/mysql_install/files/mysql.tar.gz  0 Stored  0 0% 06-24-2014 11:27 00000000 roles/mysql_delete/  0 Stored  0 0% 07-08-2014 14:12 00000000 roles/mysql_delete/meta/  197 Defl:N  147 25% 07-08-2014 14:12 fe6b0ef8 roles/mysql_delete/meta/main.yml  0 Stored  0 0% 07-14-2014 09:39 00000000 roles/mysql_delete/tasks/  692 Defl:N  245 65% 07-14-2014 09:39 dccd57b4 roles/mysql_delete/tasks/delete.yml  22 Stored  22 0% 06-27-2014 13:30 728ce4aa roles/mysql_delete/tasks/main.yml  0 Stored  0 0% 06-19-2014 13:30 00000000 roles/mysql_delete/handlers/  0 Stored  0 0% 07-03-2014 13:16 00000000 roles/mysql_delete/vars/  313 Defl:N  177 44% 07-14-2014 10:56 bf4476a7 roles/mysql_delete/vars/main.yml  0 Stored  0 0% 06-27-2014 13:30 00000000 roles/mysql_delete/templates/  0 Stored  0 0% 06-27-2014 13:30 00000000 roles/mysql_delete/files/--------   ------- ---       -------61825741   60421430 2%       41 files