server1上边装数据库;
yum install mariadb-server -y
systemctl start mariadb
mysql_secure_installation 初始化
建立salt数据库:
vim salt.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;
导入数据:
mysql -p < salt.sql
登陆数据库查看
方式一:
1、修改配置
minion端配置:
yum install mysql-python -y
vim /etc/salt/minion
return: mysql
mysql.host: 'server1'
mysql.user: 'salt'
mysql.pass: 'salt'
mysql.db: 'salt'
mysql.port: 3306
systemctl restart salt-minion
2、数据库授权
server1:
msyql -uroot -p
grant all on salt.* to salt@'%' identified by 'salt';
3、测试
salt server2 cmd.run hostname 产生数据
登陆数据库查看是否有新的数据产生
方式二、
1、修改配置
vim /etc/salt/master
master_job_cache: mysql
systemctl restart salt-master
yum install mysql-python -y 需要通过python存储数据
2、授权
msyql -uroot -p
grant all on salt.'*' to salt@'localhost' identified by 'salt';
3、测试
salt server3 cmd.run hostname 产生新的数据
登陆数据库,查看是否产生新的数据