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: - ...

Get Salt Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial