主端从端都修改配置文件(把执行结果保存到mysql服务器)
- 主端
1.安装所需软件
[root@server1 salt]# yum install -y mariadb-server mariadb MYSQL-python
[root@server1 salt]# systemctl start mariadb
[root@server1 salt]# mysql##登陆数据库进行授权
MariaDB [(none)]> grant all on salt.* to salt@'%' identified by 'salt';
2.server1倒入数据库
[root@server1 ~]# vim add.sql
[root@server1 ~]# cat add.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;
--
-- 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;
- 从端
server2修改salt-minion配置文件
[root@server2 ~]# vim /etc/salt/minion
[root@server2 ~]# systemctl restart salt-minion
- 测试
在数据库查看
master_job_cache存储数据
1.编写主端配置文件
[root@server1 ~]# vim /etc/salt/master
master_job_cache: mysql
mysql.host: 'localhost'
mysql.user: 'salt'
mysql.pass: 'salt'
mysql.db: 'salt'
mysql.port: 3306
[root@server1 ~]# systemctl restart salt-master
2.数据库授权
[root@server1 ~]# mysql
MariaDB [(none)]> grant all on salt.* to salt@‘localhost’ identified by ‘salt’;
3.安装MYSQL-python并重启salt-master服务
[root@server1 ~]# yum install -y MySQL-python
[root@server1 ~]# systemctl restart salt-master
4.执行相应命令并查看
查看主机
登陆数据库查看数据
可以看到数据中还有server3的数据,而我并没有对sever3的salt-minion的配置文件进行任何处理,却依然可以采集到数据,所以这种方法比较方便简单,推荐使用。