Saltstack_使用指南08_远程执行-返回程序

 

1. 主机规划

 

salt 版本

1 [root@salt100 ~]# salt --version
2 salt 2018.3.3 (oxygen)
3 [root@salt100 ~]# salt-minion --version
4 salt-minion 2018.3.3 (oxygen)

 

returners文档

https://docs.saltstack.com/en/latest/ref/returners/index.html

 

returner modules文档

https://docs.saltstack.com/en/latest/ref/returners/all/index.html#all-salt-returners

 

注意事项

修改了master或者minion的配置文件，那么必须重启对应的服务。

 

2. 数据库配置

2.1. 数据库安装

根据规划在 salt100 部署mariadb 数据库

1 # 数据库安装
2 yum install -y mariadb mariadb-server    
3 # 启动数据库
4 systemctl start mariadb.service   # 如果有必要可以设置为开机自启动
5 # 在「其他」机器安装，用于测试远程是否可以连接
6 yum install -y mariadb  

 

2.2. 字符集设置

配置文件也要修改

 1 [root@salt100 ~]# mysql
 2 welcome to the mariadb monitor.  commands end with ; or \g.
 3 your mariadb connection id is 2
 4 server version: 5.5.60-mariadb mariadb server
 5 
 6 copyright (c) 2000, 2018, oracle, mariadb corporation ab and others.
 7 
 8 type 'help;' or '\h' for help. type '\c' to clear the current input statement.
 9 
10 mariadb [(none)]> show variables like '%char%';  
11 +--------------------------+----------------------------+
12 | variable_name            | value                      |
13 +--------------------------+----------------------------+
14 | character_set_client     | utf8                       |
15 | character_set_connection | utf8                       |
16 | character_set_database   | latin1                     |
17 | character_set_filesystem | binary                     |
18 | character_set_results    | utf8                       |
19 | character_set_server     | latin1                     |
20 | character_set_system     | utf8                       |
21 | character_sets_dir       | /usr/share/mysql/charsets/ |
22 +--------------------------+----------------------------+
23 8 rows in set (0.00 sec)
24 
25 mariadb [(none)]> set character_set_database=utf8;  
26 query ok, 0 rows affected (0.00 sec)
27 
28 mariadb [(none)]> set character_set_server=utf8;  
29 query ok, 0 rows affected (0.00 sec)
30 
31 mariadb [(none)]> show variables like '%char%';  
32 +--------------------------+----------------------------+
33 | variable_name            | value                      |
34 +--------------------------+----------------------------+
35 | character_set_client     | utf8                       |
36 | character_set_connection | utf8                       |
37 | character_set_database   | utf8                       |
38 | character_set_filesystem | binary                     |
39 | character_set_results    | utf8                       |
40 | character_set_server     | utf8                       |
41 | character_set_system     | utf8                       |
42 | character_sets_dir       | /usr/share/mysql/charsets/ |
43 +--------------------------+----------------------------+
44 8 rows in set (0.01 sec)

 

2.3. 创建数据库、用户、授权

 1 # 创建数据库
 2 mariadb [(none)]> create database  `salt`
 3          default character set utf8
 4          default collate utf8_general_ci;
 5 query ok, 1 row affected (0.00 sec)
 6 
 7 mariadb [(none)]> show create database salt;
 8 +----------+---------------------------------------------------------------+
 9 | database | create database                                               |
10 +----------+---------------------------------------------------------------+
11 | salt     | create database `salt` /*!40100 default character set utf8 */ |
12 +----------+---------------------------------------------------------------+
13 1 row in set (0.00 sec)
14 
15 # 创建用户并授权
16 mariadb [(none)]> grant all on salt.* to salt@'%' identified by 'salt';  # 用于远程访问
17 query ok, 0 rows affected (0.00 sec)
18 
19 mariadb [(none)]> grant all on salt.* to salt@'salt100' identified by 'salt';   # 用于本地访问
20 query ok, 0 rows affected (0.00 sec)
21 
22 mariadb [(none)]> flush privileges; 
23 query ok, 0 rows affected (0.00 sec)
24 
25 mariadb [(none)]> select user,host,password from mysql.user where user = 'salt';
26 +------+---------+-------------------------------------------+
27 | user | host    | password                                  |
28 +------+---------+-------------------------------------------+
29 | salt | %       | *36f75abc6d500dfa6e905046fd8be5e115812dd0 |
30 | salt | salt100 | *36f75abc6d500dfa6e905046fd8be5e115812dd0 |
31 +------+---------+-------------------------------------------+
32 2 rows in set (0.00 sec)

 

本地或者远程登录测试

1 mysql -hsalt100 -usalt -psalt
2 # 或者
3 mysql -h172.16.1.100 -usalt -psalt

 

2.4. 创建表

相关文档

https://docs.saltstack.com/en/latest/ref/returners/all/salt.returners.mysql.html#module-salt.returners.mysql

 

 1 use salt;
 2 
 3 --
 4 -- table structure for table `jids`
 5 --
 6 drop table if exists `jids`;
 7 create table `jids` (
 8   `jid` varchar(255) not null,
 9   `load` mediumtext not null,
10   unique key `jid` (`jid`)
11 ) engine=innodb default charset=utf8;
12 
13 --
14 -- table structure for table `salt_returns`
15 --
16 drop table if exists `salt_returns`;
17 create table `salt_returns` (
18   `fun` varchar(50) not null,
19   `jid` varchar(255) not null,
20   `return` mediumtext not null,
21   `id` varchar(255) not null,
22   `success` varchar(10) not null,
23   `full_ret` mediumtext not null,
24   `alter_time` timestamp default current_timestamp,
25   key `id` (`id`),
26   key `jid` (`jid`),
27   key `fun` (`fun`)
28 ) engine=innodb default charset=utf8;
29 
30 --
31 -- table structure for table `salt_events`
32 --
33 drop table if exists `salt_events`;
34 create table `salt_events` (
35 `id` bigint not null auto_increment,
36 `tag` varchar(255) not null,
37 `data` mediumtext not null,
38 `alter_time` timestamp default current_timestamp,
39 `master_id` varchar(255) not null,
40 primary key (`id`),
41 key `tag` (`tag`)
42 ) engine=innodb default charset=utf8;

 

3. 安装依赖包

1 salt '*' state.single pkg.installed name=mysql-python    
2 或者
3 salt '*' cmd.run 'yum install -y mysql-python'    

 

4. minion返回结果到mysql数据库

由 minion 端直接返回到 mysql 数据库，不需要经过 master 端。

 

相关文档

https://docs.saltstack.com/en/latest/topics/jobs/external_cache.html

 

4.1. minion端存储架构

 

4.2. 方式一：所有minion端都添加设置

1 [root@salt03 ~]# vim /etc/salt/minion 
2 …………
3 mysql.host: 'salt100'
4 mysql.user: 'salt'
5 mysql.pass: 'salt'
6 mysql.db: 'salt'
7 mysql.port: 3306
8 
9 [root@salt03 ~]# systemctl restart salt-minion.service  # 修改了配置，需要重启 minion

 

4.3. 方式二：在master端添加设置

 1 [root@salt100 ~]# vim /etc/salt/master 
 2 …………
 3 ext_job_cache: mysql
 4 mysql.host: 'salt100'
 5 mysql.user: 'salt'
 6 mysql.pass: 'salt'
 7 mysql.db: 'salt'
 8 mysql.port: 3306
 9 
10 [root@salt100 ~]# systemctl restart salt-master.service   # 修改了配置，需要重启 master

 

4.4. 测试执行

 1 # 说明： 带了 --return mysql ，适合上面的方式一，在minion端配置
 2 # 如果没有带  --return mysql ，适合上面的方式二，在master端配置
 3 [root@salt100 ~]# salt '*' test.ping --return mysql  
 4 salt03:
 5     true
 6 salt01:
 7     true
 8 salt02:
 9     true
10 salt100:
11     true
12 [root@salt100 ~]# salt 'salt0*' cmd.run 'df -h' --return mysql  
13 salt03:
14     filesystem      size  used avail use% mounted on
15     /dev/sda3        18g  2.0g   16g  12% /
16     devtmpfs        901m     0  901m   0% /dev
17     tmpfs           911m   12k  911m   1% /dev/shm
18     tmpfs           911m  9.6m  902m   2% /run
19     tmpfs           911m     0  911m   0% /sys/fs/cgroup
20     /dev/sda1       197m  113m   85m  58% /boot
21     tmpfs           183m     0  183m   0% /run/user/1001
22 salt01:
23     filesystem      size  used avail use% mounted on
24     /dev/sda3        18g  2.1g   16g  12% /
25     devtmpfs        901m     0  901m   0% /dev
26     tmpfs           911m   12k  911m   1% /dev/shm
27     tmpfs           911m  9.6m  902m   2% /run
28     tmpfs           911m     0  911m   0% /sys/fs/cgroup
29     /dev/sda1       197m  113m   85m  58% /boot
30     tmpfs           183m     0  183m   0% /run/user/1001
31 salt02:
32     filesystem      size  used avail use% mounted on
33     /dev/sda3        18g  2.0g   16g  12% /
34     devtmpfs        901m     0  901m   0% /dev
35     tmpfs           911m   12k  911m   1% /dev/shm
36     tmpfs           911m  9.6m  902m   2% /run
37     tmpfs           911m     0  911m   0% /sys/fs/cgroup
38     /dev/sda1       197m  113m   85m  58% /boot
39     tmpfs           183m     0  183m   0% /run/user/1001

 

4.5. 数据库表信息

 

5. master返回结果到mysql数据库

数据从minion端返回到master之后，再由master写入mysql

 

相关文档

https://docs.saltstack.com/en/latest/topics/jobs/external_cache.html

 

5.1. master端存储架构

 

5.2. master端添加如下配置

 1 [root@salt100 ~]# vim /etc/salt/master 
 2 …………
 3 master_job_cache: mysql
 4 mysql.host: 'salt100'
 5 mysql.user: 'salt'
 6 mysql.pass: 'salt'
 7 mysql.db: 'salt'
 8 mysql.port: 3306
 9 
10 [root@salt100 ~]# systemctl restart salt-master.service   # 修改了配置，需要重启 master

 

5.3. 测试执行

1 [root@salt100 ~]# salt '*' grains.items
2 [root@salt100 ~]# salt '*' cmd.run 'w' 

 

5.4. 数据库表信息