mysql自己搭建

首先要在master機(jī)器上創(chuàng)建數(shù)據(jù)庫CREATE?DATABASE??`salt`

DEFAULT?CHARACTER?SET?utf8

DEFAULT?COLLATE?utf8_general_ci;

USE?`salt`;

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;

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;

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;

授權(quán)：

grant?all?on?salt.*?to?salt@'%'?identified?by?'salt';

master和minion端：vim?/etc/salt/minion

mysql.host:?'192.168.141.250'?#這里的ip寫master的ip

mysql.user:?'salt'

mysql.pass:?'salt'

mysql.db:?'salt'

mysql.port:?3306

保存退出，并重啟服務(wù)

/etc/init.d/salt-minion?restart

我們執(zhí)行一條命令：

salt '*' test.ping --return mysql

我們進(jìn)入mysql命令行：mysql

show?databases;

use?salt;

show?tables;

select?*?from?salt_returns\G;

結(jié)果如下：

***************************?1.?row?***************************

fun:?test.ping

jid:?20170321234131569065

return:?true

id:?web12.limingyu.com

success:?1

full_ret:?{"fun_args":?[],?"jid":?"20170321234131569065",?"return":?true,?"retcode":?0,?"success":?true,?"fun":?"test.ping",?"id":?"web12.limingyu.com"}

alter_time:?2017-03-21?23:41:32

總結(jié)

以上是生活随笔為你收集整理的mysql登陆salt_salt把返回写入到mysql的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。