上次介紹了如何使用ansible playbook安裝zabbix客戶端（//www.survivalescaperooms.com/article/52158.htm），這次介紹一下如何使用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: 3306 mysql監聽端口mysql_sock: /data/mysql/datadir/mysql.sock mysql的sockmysql_charset: utf8 mysql字符集mysql_collation: utf8_general_ci mysql排序方式mysql_version: Percona-Server-5.5.21-rel25.1.tar.gz mysql版本 |
下面是安裝mysql的playbook結構
| 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 |
playbook的mysql安裝的是
| 10:32:06 # cat mysql_install.yml ---- hosts: "{{host}}" remote_user: "{{user}}" gather_facts: True roles: - common - mysql_install |
playbook的mysql協助的是
| 10:32:44 # cat mysql_delete.yml ---- hosts: "{{host}}" remote_user: "{{user}}" gather_facts: True roles: - mysql_delete |
由于在上篇安裝zabbix客戶端已經介紹了結構，所以現在不介紹了。
| 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 |
