Chef Infrastructure Automation Cookbook Second Edition

Book Image

Chef Infrastructure Automation Cookbook Second Edition

By : Matthias Marschall

Book Image

Chef Infrastructure Automation Cookbook Second Edition

By: Matthias Marschall

Overview of this book

Chef Infrastructure Automation Cookbook Second Edition

Chef Infrastructure Automation Cookbook Second Edition

Credits

About the Author

About the Author

About the Reviewers

About the Reviewers

www.PacktPub.com

www.PacktPub.com

Preface

Free Chapter

Chef Infrastructure

Chef Infrastructure

Using version control

Installing the Chef development kit on your workstation

Using the hosted Chef platform

Managing virtual machines with Vagrant

Creating and using cookbooks

Inspecting files on your Chef server with knife

Defining cookbook dependencies

Managing cookbook dependencies with Berkshelf

Downloading and integrating cookbooks as vendor branches into your Git repository

Using custom knife plugins

Deleting a node from the Chef server

Developing recipes with local mode

Using environments

Freezing cookbooks

Running Chef client as a daemon

Using chef-shell

Evaluating and Troubleshooting Cookbooks and Chef Runs

Evaluating and Troubleshooting Cookbooks and Chef Runs

Testing your Chef cookbooks

Flagging problems in your Chef cookbooks

Test-driven development for cookbooks using ChefSpec

Integration testing your Chef cookbooks with Test Kitchen

Showing affected nodes before uploading cookbooks

Overriding a node's run list to execute a single recipe

Using why-run mode to find out what a recipe might do

Debugging Chef client runs

Inspecting the results of your last Chef run

Raising and logging exceptions in recipes

Diff-ing cookbooks with knife

Using community exception and report handlers

Creating custom handlers

Chef Language and Style

Chef Language and Style

Using community Chef style

Using attributes to dynamically configure recipes

Using templates

Mixing plain Ruby with Chef DSL

Installing Ruby gems and using them in recipes

Using libraries

Using definitions

Creating your own Lightweight Resource Providers (LWRP)

Extending community cookbooks by using application wrapper cookbooks

Creating custom Ohai plugins

Creating custom knife plugins

Writing Better Cookbooks

Writing Better Cookbooks

Setting the environment variables

Passing arguments to shell commands

Overriding attributes

Using search to find nodes

Using data bags

Using search to find data bag items

Using encrypted data bag items

Accessing data bag values from external scripts

Getting information about the environment

Writing cross-platform cookbooks

Finding the complete list of operating systems you can use in cookbooks

Making recipes idempotent by using conditional execution

Working with Files and Packages

Working with Files and Packages

Creating configuration files using templates

Using pure Ruby in templates for conditionals and iterations

Installing packages from a third-party repository

Installing software from source

Running a command when a file is updated

Distributing directory trees

Cleaning up old files

Distributing different files based on the target platform

Users and Applications

Users and Applications

Creating users from data bags

Securing the Secure Shell Daemon (SSHD)

Enabling passwordless sudo

Creating nginx virtual hosts

Creating MySQL databases and users

Managing WordPress sites

Managing Ruby on Rails applications

Managing Varnish

Managing your local workstation

Servers and Cloud Infrastructure

Servers and Cloud Infrastructure

Creating your infrastructure using Chef Provisioning

Creating cookbooks from a running system with Blueprint

Running the same command on many machines at once

Setting up SNMP for external monitoring services

Deploying a Nagios monitoring server

Building high-availability services using heartbeat

Using HAProxy to load-balance multiple web servers

Using custom bootstrap scripts

Managing firewalls with iptables

Managing fail2ban to ban malicious IP addresses

Managing Amazon EC2 instances

Loading your Chef infrastructure from a file with spiceweasel and knife

Index

Customer Reviews

5 star

0

4 star

0

3 star

0

2 star

0

1 star

0

Creating MySQL databases and users

You need to use two different cookbooks to manage MySQL (or any other database) on your nodes: the generic database cookbook and the mysql cookbook.

The database cookbook provides resources for managing databases and database users for MySQL, PostgreSQL, and Microsoft SQL Server. The mysql cookbook installs MySQL client and server.

Let's see how we can install MySQL server and create a database and a database user.

Getting ready

Make sure that you have a cookbook called my_cookbook and that the run_list of your node includes my_cookbook, as described in the Creating and using cookbooks recipe in Chapter 1, Chef Infrastructure.

Make sure Berksfile in your Chef repository includes my_cookbook:

mma@laptop:~/chef-repo $ subl Berksfile

cookbook 'my_cookbook', path: './cookbooks/my_cookbook'

How to do it...

We'll install the MySQL server with a database and user:

Edit your cookbook's metadata.rb file to include the dependencies on the database and mysql cookbooks:
```
mma...
```