SaltStack – Using the Mysql Module

salt '*' saltutil.refresh_pillar

官網的例子真的沒看懂，英文菜。其實就簡單一步。

參考文檔

https://docs.saltstack.com/en/latest/ref/modules/all/salt.modules.mysql.html

<a href="https://z900collector.wordpress.com/linux/using-the-saltstack-mysql-module/" target="_blank">https://z900collector.wordpress.com/linux/using-the-saltstack-mysql-module/</a>

minion  yum install MySQL-python -y

salt-master主要是找/usr/lib/python2.6/site-packages/salt/modules/test.py

[root@cm1 salt]# cat /etc/salt/minion

master: 172.1.1.1

id: cm1

mysql.host: 'localhost'

mysql.port: 3306

mysql.user: 'root'

mysql.socket: 'x.sock'

mysql.pass: 'xx' 

mysql.charset: 'utf8'

/etc/init.d/salt-minion restart

'''

執行順序,測試指令

state.show_sls執行函數來檢視salt state的執行順序

sudo salt stage-db1 state.show_sls mysql

sudo salt stage-db1 state.apply mysql test=True

sudo salt stage-db1 state.apply mysql

mysql

sudo salt stage-db1 mysql.db_list

salt '*' mysql.db_list

最完整的例子

https://www.digitalocean.com/community/tutorials/saltstack-infrastructure-creating-salt-states-for-mysql-database-servers

1.salt-minion端

mysql連接配接資訊 /etc/salt/minion.d/mysql.conf

mysql.default_file: '/etc/mysql/salt.cnf'

vim /etc/mysql/salt.cnf

2.vim /srv/pillar/top.sls

base:

  'G@env:dev and G@role:dbserver':

    - match: compound

    - dev.mysql

  'G@env:stage and G@role:dbserver':

    - stage.mysql

  'G@env:prod and G@role:dbserver':

    - prod.mysql

3.vim /srv/salt/mysql/init.sls

debconf-utils:

  pkg.installed

mysql_setup:

  debconf.set:

    - name: mysql-server

    - data:

        'mysql-server/root_password': {'type': 'password', 'value': '{{ salt['pillar.get']('mysql:root_pw', '') }}' }

        'mysql-server/root_password_again': {'type': 'password', 'value': '{{ salt['pillar.get']('mysql:root_pw', '') }}' }

    - require:

      - pkg: debconf-utils

python-mysqldb:

mysql-server:

  pkg.installed:

      - debconf: mysql-server

      - pkg: python-mysqldb

mysql:

  service.running:

    - watch:

      - pkg: mysql-server

      - file: /etc/mysql/my.cnf

/etc/mysql/my.cnf:

  file.managed:

    - source: salt://mysql/files/etc/mysql/my.cnf.jinja

    - template: jinja

    - user: root

    - group: root

    - mode: 640

/etc/salt/minion.d/mysql.conf:

    - source: salt://mysql/files/etc/salt/minion.d/mysql.conf

      - service: mysql

/etc/mysql/salt.cnf:

    - source: salt://mysql/files/etc/mysql/salt.cnf.jinja

restart_minion_for_mysql:

    - name: salt-minion

      - file: /etc/salt/minion.d/mysql.conf

上面是digitoean雲上的例子。最重要的是/etc/salt/minion.d

本文轉自 liqius 51CTO部落格，原文連結：http://blog.51cto.com/szgb17/1929487，如需轉載請自行聯系原作者