上次介绍了如何使用ansible playbook安装zabbix客户端（http://dl528888.blog.51cto.com/2382721/1436745），这次介绍一下如何使用playbook安装mysql。
下面是安装mysql的信息：
|
1
2
3
4
5
6
7
8
9
10
|
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的sock
mysql_charset: utf8 mysql字符集
mysql_collation: utf8_general_ci mysql排序方式
mysql_version: Percona-Server-5.5.21-rel25.1.
tar
.gz mysql版本
|
下面是安装mysql的playbook结构
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
|
10:24:06
# tree mysql_*
mysql_delete
├── files
├── handlers
├── meta
│ └── main.yml
├── tasks
│ ├── delete.yml
│ └── main.yml
├── templates
└── vars
└── main.yml
mysql_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.yml
12 directories, 15 files
|
playbook的mysql安装的是
|
1
2
3
4
5
6
7
8
|
10:32:06
# cat mysql_install.yml
---
- hosts:
"`host`"
remote_user:
"`user`"
gather_facts: True
roles:
- common
- mysql_install
|
playbook的mysql协助的是
|
1
2
3
4
5
6
7
|
10:32:44
# cat mysql_delete.yml
---
- hosts:
"`host`"
remote_user:
"`user`"
gather_facts: True
roles:
- mysql_delete
|
由于在上篇安装zabbix客户端已经介绍了结构，所以现在不介绍了。
1、安装mysql
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
|
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.596s
user 0m8.815s
sys 0m0.848s
|
2、安装后测试
登陆192.168.240.17的测试机查看mysql安装情况
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
|
[root@ip-10-10-240-21 tmp]
# ll
total 16
lrwxrwxrwx 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 mysql
root 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
.pid
mysql 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=3306
root 22440 20233 0 22:33 pts
/0
00:00:00
grep
mysql
[root@ip-10-10-240-21 tmp]
# ll /data/mysql/
total 8
drwxr-xr-x 13 mysql mysql 4096 Jun 26 03:59 basedir
drwxr-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 status
MySQL (Percona Server) running (22156) [ OK ]
[root@ip-10-10-240-21 tmp]
# chkconfig --list|grep mysql
mysqld 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 -pE4yR3WnoluSFTCBAI
ERROR 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 -pE4yR3WnoluSFTCBAI
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection
id
is 8
Server version: 5.5.21-log Source distribution
Copyright (c) 2000, 2011, Oracle and
/or
its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and
/or
its
affiliates. Other names may be trademarks of their respective
owners.
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 mysql
Reading table information
for
completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql>
select
host,user,password from user;
+--------------+--------+-------------------------------------------+
| host | user | password |
+--------------+--------+-------------------------------------------+
| 10.10.240.21 | root | *BE78618CBAFFF409CE17D81579C1678B94439BE1 |
| % | zabbix | *DEEF4D7D88CD046ECA02A80393B7780A63E7E789 |
+--------------+--------+-------------------------------------------+
2 rows
in
set
(0.00 sec)
|
可以看到已经按照我的要求安装完成，下面在进行删除测试。
3、删除
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
|
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.248s
user 0m0.632s
sys 0m0.102s
|
4、删除后测试
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
[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 4
drwxr-xr-x 3 root root 4096 Jul 10 22:11 webroot
[root@ip-10-10-240-21 tmp]
# ps -ef|grep mysql
root 22955 20233 0 22:50 pts
/0
00:00:00
grep
mysql
[root@ip-10-10-240-21 tmp]
# ll /etc/init.d/mysql
ls
: 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]
#
|
可以看到都删除完成。
如果大家想使用我的例子，可以从github里下载（地址是https://github.com/dl528888/ansible-examples/tree/master/mysql_install），然后放到/etc/ansible目录里，下面是压缩包里的内容
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
|
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
|
如果觉得好，给个赞并多评论，谢谢。
本文转自 reinxu 51CTO博客，原文链接：http://blog.51cto.com/dl528888/1437882，如需转载请自行联系原作者
