Book Image

Salt Cookbook

By : Anirban Saha
Book Image

Salt Cookbook

By: Anirban Saha

Overview of this book

Related Content you might be interested in

Current Title:

Small book image
Salt Cookbook
Anirban Saha
Jul, 2015 | 350 pages
No titles found
Table of Contents (18 chapters)
Salt Cookbook
Salt Cookbook
Credits
Credits
About the Author
About the Author
About the Reviewer
About the Reviewer
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Salt Architecture and Components
Salt Architecture and Components
Introduction
Installing and configuring the Salt master
Configuring the Salt environment and pillar paths
Understanding and configuring Salt pillars
Understanding and writing Salt states
Understanding and writing the top file
Installing and configuring the Salt minion
Configuring environments and grains on the minion
Applying Salt states to minions
2
Writing Advanced Salt Configurations
Writing Advanced Salt Configurations
Introduction
Writing and retrieving pillar data
Using pillar data in states
Using grains in states
Using conditionals in states and pillars
Using Python functions in conditionals
Using iterations in states
Setting and using variables in states
Testing a state run before applying to minions
Configuring nodegroups
Targeting minions
3
Modules, Orchestration, and Scaling Salt
Modules, Orchestration, and Scaling Salt
Introduction
Using execution modules
Using state modules
Configuring templates
Using requisites
Using Salt runners
Orchestration with Salt orchestrate
Salt multi-master setup (active-active mode)
Salt multi-master setup (active-passive mode)
4
General Administration Tasks
General Administration Tasks
Introduction
Running commands
Setting host entries and grains
Setting time zone, locale, and kernel configurations
Handling archive files
Adding groups and users
Performing SSH authentication tasks
Scheduling jobs with cron
Managing volumes
Working with disks and mounts
Managing network configurations
5
Advanced Administration Tasks
Advanced Administration Tasks
Introduction
Managing package repositories
Managing packages using the default package manager
Managing packages using rvm, gem, and pip
Managing files
Managing services
Managing code repositories with Git
Managing code repositories with svn
Configuring alternatives
6
Managing Application Servers
Managing Application Servers
Introduction
Apache web server packages and services
Managing web server modules
Adding web server configuration
Web server security with htpasswd
Setting up Java for Apache Tomcat
Apache Tomcat packages, files, and services
Deploying the WAR file in Apache Tomcat
7
Managing Databases
Managing Databases
Introduction
Using MySQL packages, files, and services
Using MySQL databases
Creating MySQL database users
Running MySQL queries
Providing MySQL user grants
Using PostgreSQL packages, files, and services
Setting up PostgreSQL groups and users
Configuring PostgreSQL databases
8
Configuring Salt Cloud
Configuring Salt Cloud
Introduction
Configuring the Salt cloud environment
Configuring cloud providers
Configuring cloud profiles
Extending profiles and providers
Configuring cloud maps
Using post-install scripts
Launching, querying, and destroying instances
Performing general cloud functions
9
Managing Amazon Web Services
Managing Amazon Web Services
Introduction
Implementing security groups
Using elastic load balancers
Configuring DNS with Route53
Configuring Simple Queue Service
Deploying ElastiCache clusters
Configuring CloudWatch alarms
10
Salt Event and Reactor System
Salt Event and Reactor System
Introduction
Learning the basics of the event system
Listening to events
Firing events
Identifying and working with Salt event types
Integrating and configuring the reactor system
Using reactors for Salt tasks
11
Troubleshooting
Troubleshooting
Introduction
Troubleshooting the Salt master
Troubleshooting the Salt minion
Dealing with too many open files
Connectivity, DNS, and ports
Dealing with YAML configuration problems
Index
Index

Creating MySQL database users

Setting up users and giving them proper permissions to access databases is one of the most critical tasks in database management. In this recipe, you will learn how to create database users and manage their access from different servers.

How to do it...

We will use the same minion as the previous recipe.

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

    mysql:
  stg-passwd-hash: '*CAC560C0ED394C2D89B7A1F08422B200B2FFBC26'

  2. Edit /opt/salt-cookbook/pillar/staging/top.sls to have the following entries:

    staging:
  '*':
    - mysql

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

    include:
  - mysql.database

db_user:
  mysql_user.present:
    - name: stg-db
    - host: '*'
    - password_hash: '{{ pillar['mysql']['stg-passwd-hash'] }}'
    - connection_charset: utf8
    - saltenv:
      - LC_ALL: "en_US.utf8"
    - require:
      - mysql_database: stg_databases

  4. Edit /opt/salt-cookbook/staging...

Previous Section
End of Section 5
Next Section