使用saltstack中将结果存到mysql中的两种方式

分手后的思念是犯贱 2021-10-19 18:26 239阅读 0赞

## 一.存储执行结果 ##

master推送信息给minion端，minion会保存24小时，有时为了查看数据我们可以将这些数据保存到mysql中。

*  saltstack把执行的结果保存到mysql中，以便进行命令安全审计
 *  mysql负责存储数据，mysql-python负责收集数据
 *  master需要安装mysql和MySQL-python，minion端安装MySQL-python

原理图：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70]

minion与master通信时将数据返回给master的同时，然后通过MySQL-python将数据返回给相应的数据存储系统。

实验环境：

<table> 
 <thead> 
  <tr> 
   <th>server1:172.25.31.1</th> 
   <th>master，mysql，MySQL-python(master_job_cache用到）</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>server2:171.25.31.2</td> 
   <td>minion ，MySQL-python</td> 
  </tr> 
  <tr> 
   <td>server3:172.25.31.3</td> 
   <td>minion ，MySQL-python</td> 
  </tr> 
 </tbody> 
</table>

1.server1安装数据库，并进行授权登陆

[root@server1 ~]# yum install MySQL-python.x86_64 -y
    [root@server1 ~]# yum install -y mariadb
    [root@server1 ~]# yum install -y mariadb-server
    [root@server1 ~]# systemctl start mariadb
    [root@server1 ~]# mysql

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 1]

2.server2上安装MYSQL-python 并修改salt的配置文件

[root@server2 ~]# yum install -y MySQL-python.x86_64
    [root@server2 ~]# vim /etc/salt/minion
    [root@server2 ~]# systemctl restart salt-minion

![在这里插入图片描述][20190815093857659.png]  
3.server1上导入数据库salt

[root@server1 ~]# vim test.sql 
    文件内容：
    CREATE DATABASE  `salt`
      DEFAULT CHARACTER SET utf8
      DEFAULT COLLATE utf8_general_ci;
    
    USE `salt`;
    
    --
    -- Table structure for table `jids`
    --
    
    DROP TABLE IF EXISTS `jids`;
    CREATE TABLE `jids` (
      `jid` varchar(255) NOT NULL,
      `load` mediumtext NOT NULL,
      UNIQUE KEY `jid` (`jid`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    CREATE INDEX jid ON jids(jid) USING BTREE;   ##删除索引,否则后面的步骤会有冲突（删除本行）
    
    --
    -- Table structure for table `salt_returns`
    --
    
    DROP TABLE IF EXISTS `salt_returns`;
    CREATE TABLE `salt_returns` (
      `fun` varchar(50) NOT NULL,
      `jid` varchar(255) NOT NULL,
      `return` mediumtext NOT NULL,
      `id` varchar(255) NOT NULL,
      `success` varchar(10) NOT NULL,
      `full_ret` mediumtext NOT NULL,
      `alter_time` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
      KEY `id` (`id`),
      KEY `jid` (`jid`),
      KEY `fun` (`fun`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    --
    -- Table structure for table `salt_events`
    --
    
    DROP TABLE IF EXISTS `salt_events`;
    CREATE TABLE `salt_events` (
    `id` BIGINT NOT NULL AUTO_INCREMENT,
    `tag` varchar(255) NOT NULL,
    `data` mediumtext NOT NULL,
    `alter_time` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `master_id` varchar(255) NOT NULL,
    PRIMARY KEY (`id`),
    KEY `tag` (`tag`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    [root@server1 ~]# mysql < test.sql

3.测试server2的mysql返回是否正常  
![在这里插入图片描述][20190815095555841.png]4.测试：

[root@server1 ~]# salt server2 cmd.run 'df -h'

![在这里插入图片描述][20190815095735182.png]  
进入数据库查看  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 2]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 3]

## 二.master\_job\_cache ##

由master将数据传给mysql，增加了master的负载  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 4]  
1.编辑server1的master配置文件，并重启服务

[root@server1 ~]# vim /etc/salt/master
    [root@server1 ~]# systemctl restart salt-master

![在这里插入图片描述][20190815100120217.png]  
2.登陆数据库，为本地用户授权  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 5]  
![在这里插入图片描述][20190815100523364.png]

3.执行命令，查看数据库

[root@server1 ~]# salt '*' cmd.run 'hostname'
    [root@server1 ~]# mysql

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 6]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 7]

在master端安装MYSQL-python并开启master\_job\_cacha模块配置，就可以同步所有minion的数据

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70]: /images/20211019/728b637d91664b429cc599a0d74f23b8.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 1]: /images/20211019/60f5c3642ccf4230b2b71ee9559ecdc1.png
[20190815093857659.png]: /images/20211019/58ee80e288204967a9c0817df0390f01.png
[20190815095555841.png]: /images/20211019/14f67eed8d274343ad7bfa2c6fd9bda4.png
[20190815095735182.png]: /images/20211019/f0104114da464ab980385aaa7b16973b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 2]: /images/20211019/23ef47ffd63546228d9a03c70ddb43cd.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 3]: /images/20211019/71141a32c0af4718b74d135c006ff67d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 4]: /images/20211019/b2bd38181e624da991c54d75fa1793b7.png
[20190815100120217.png]: /images/20211019/a1ed53d0762f4f2fad0723bd2288072f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 5]: /images/20211019/c8bd72ecde3243b8a3090c2956bcacae.png
[20190815100523364.png]: /images/20211019/51dbac37a5ce4285a561f11861cc9e98.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 6]: /images/20211019/69f82152105345bb8c2a35b442037f97.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDg4OTYxNg_size_16_color_FFFFFF_t_70 7]: /images/20211019/ea1b4264f28c4faaa1d5683c677df063.png