Skip to content
Snippets Groups Projects
Select Git revision
  • e540589cb06da9d077943f953cd226f45ee0bcc2
  • master default
  • v0.52.5
  • v0.52.4
  • v0.52.3
  • v0.52.2
  • v0.52.1
  • v0.52.0
  • v0.51.0
  • v0.50.0
  • v0.49.0
11 results

pillar.example

Blame
  • pillar.example 3.38 KiB
    mysql:
      global:
        client-server:
          default_character_set: utf8
    
      clients:
        mysql:
          default_character_set: utf8
        mysqldump:
          default_character_set: utf8
    
      library:
        client:
          default_character_set: utf8
    
      server:
        # Use this account for database admin (defaults to root)
        root_user: 'admin'
        # root_password: '' - to have root@localhost without password
        root_password: 'somepass'
        root_password_hash: '*13883BDDBE566ECECC0501CDE9B293303116521A'
        user: mysql
        # If you only manage the dbs and users and the server is on
        # another host
        host: 123.123.123.123
        # my.cnf sections changes
        mysqld:
          # you can use either underscore or hyphen in param names
          bind-address: 0.0.0.0
          log_bin: /var/log/mysql/mysql-bin.log
          datadir: /var/lib/mysql
          port: 3307
          binlog_do_db: foo
          auto_increment_increment: 5
          binlog-ignore-db:
           - mysql
           - sys
           - information_schema
           - performance_schema
        mysql:
          # my.cnf param that not require value
          no-auto-rehash: noarg_present
    
      salt_user:
        salt_user_name: 'salt'
        salt_user_password: 'someotherpass'
        grants:
          - 'all privileges'
    
      # Manage databases
      database:
        - foo
        - bar
      schema:
        foo:
          load: True
          source: salt://mysql/files/foo.schema
        bar:
          load: False
        baz:
          load: True
          source: salt://mysql/files/baz.schema.tmpl
          template: jinja
        qux:
          load: True
          source: salt://mysql/files/qux.schema.tmpl
          template: jinja
          context:
            encabulator: Turbo
            girdlespring: differential
        quux:
          load: True
          source: salt://mysql/files/qux.schema.tmpl
          template: jinja
          context:
            encabulator: Retro
            girdlespring: integral
    
      # Manage users
      # you can get pillar for existing server using scripts/import_users.py script
      user:
        frank:
          password: 'somepass'
          host: localhost
          databases:
            - database: foo
              grants: ['select', 'insert', 'update']
              escape: True
            - database: bar
              grants: ['all privileges']
        bob:
          password_hash: '*6C8989366EAF75BB670AD8EA7A7FC1176A95CEF4'
          host: localhost
          ssl: True
          ssl-X509: True
          ssl-SUBJECT: Subject
          ssl-ISSUER: Name
          ssl-CIPHER: Cipher
          databases:
            # https://github.com/saltstack/salt/issues/41178
            # If you want to refer to databases using wildcards, turn off escape so
            # the renderer does not escape them, enclose the string in '`' and
            # use two '%'
            - database: '`foo\_%%`'
              grants: ['all privileges']
              grant_option: True
              escape: False
            - database: bar
              table: foobar
              grants: ['select', 'insert', 'update', 'delete']
        nopassuser:
          password: ~
          host: localhost
          databases: []
        application:
          password: 'somepass'
          mine_hosts:
            target: "G@role:database and *.example.com"
            function: "network.get_hostname"
            expr_form: compound
          databases:
            - database: foo
              grants: ['select', 'insert', 'update']
    
      # Override any names defined in map.jinja
    #  lookup:
    #    server: mysql-server
    #    client: mysql-client
    #    service: mysql-service
    #    python: python-mysqldb
    
      # Install MySQL headers
      dev:
        # Install dev package - defaults to False
        install: False