Book Image

Salt Cookbook

By : Anirban Saha
Book Image

Salt Cookbook

By: Anirban Saha

Overview of this book

Table of Contents (18 chapters)
Salt Cookbook
Credits
About the Author
About the Reviewer
www.PacktPub.com
Preface
Index

Using MySQL packages, files, and services


In this recipe, you will learn about how to install the MySQL database. Make sure the proper configuration file for MySQL is present on the host, and the database service is running.

How to do it...

  1. Configure a new minion in the staging environment called salt-minion-mysql. Create a new state directory called mysql in the staging environment.

  2. Create and edit /opt/salt-cookbook/staging/mysql/init.sls to have the following entries:

    mysql_package:
      pkg.installed:
        - name: mysql-server
    
    mysql_conf:
      file.managed:
        - name: /etc/my.cnf
        - source: salt://mysql/files/my.cnf
        - user: root
        - group: root
        - mode: 0644
        - require:
          - pkg: mysql_package
    
    mysql_service:
      service:
        - name: mysqld
        - running
        - enable: True
        - require:
          - file: mysql_conf
        - watch:
          - file: mysql_conf
  3. Create a directory called files in the mysql state directory.

  4. Create and edit /opt/salt-cookbook/staging/mysql/files/my.cnf to have...