服务器之家：专注于服务器技术及软件下载分享
分类导航

Mysql|Sql Server|Oracle|Redis|MongoDB|PostgreSQL|Sqlite|DB2|mariadb|Access|数据库技术|

服务器之家 - 数据库 - Mysql - 集群运维自动化工具ansible使用playbook安装mysql

集群运维自动化工具ansible使用playbook安装mysql

2020-04-11 16:00hebedich Mysql

本文主要介绍了如何使用playbook安装mysql,需要的朋友可以参考下

上次介绍了如何使用ansible playbook安装zabbix客户端，这次介绍一下如何使用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
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
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
[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
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]#

可以看到都删除完成。

如果大家想使用我的例子，可以从百度云的地址下载（文件大于50M，没办法放到附件或者51下载中心）地址是http://pan.baidu.com/s/1mgG8jY4，然后放到/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

 

  • mysql
  • ansible
  • 集群运维自动化工具
  • playbook

    • 延伸 · 阅读

    精彩推荐
    最近更新
    编辑推荐
    阅读排行
    热门标签
    150 　 1044 　 1062 　 1449 　 1053 　 1045 　 1290 　 1819 　 2013 　 1406 　 1005 　 1862 　 1864 　 1146 　 2003 　 1175 　 1215 　 1615 　 1054 　 2006 　 1130 　 1366 　 10048 　 28000 　 1786 　 1135 　 1577 　 1665 　 1067 　 1093 　
    © 2019-2024 服务器之家(www.zzvips.com) 版权所有关于我们联系我们版权申明网站地图