q9989 发表于 2018-7-31 08:20:23

Saltstack-7:返回

  新建数据库salt,及表
  CREATE DATABASEsalt
  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;
  授权

  grant all on salt.* to salt@'%' >  在每个minion安装phthon-mysql
  yum install mysql
  yum install MySQL-python
  master和minion配置文件更改
  mysql.host: '192.16.0.163'
  mysql.user: 'salt'
  mysql.pass: 'salt'
  mysql.db: 'salt'
  mysql.port: 3306
  重启minion
  第二种返回只在master配置,不用再minion返回
  master_job_cache: mysql
页: [1]
查看完整版本: Saltstack-7:返回