Book Image

Puppet 5 Cookbook - Fourth Edition

By : Thomas Uphill
Book Image

Puppet 5 Cookbook - Fourth Edition

By: Thomas Uphill

Overview of this book

Puppet is a configuration management system that automates all your IT configurations, giving you control of managing each node. Puppet 5 Cookbook will take you through Puppet's latest and most advanced features, including Docker containers, Hiera, and AWS Cloud Orchestration. Updated with the latest advancements and best practices, this book delves into various aspects of writing good Puppet code, which includes using Puppet community style, checking your manifests with puppet-lint, and learning community best practices with an emphasis on real-world implementation. You will learn to set up, install, and create your first manifests with version control, and also learn about various sysadmin tasks, including managing configuration files, using Augeas, and generating files from snippets and templates. As the book progresses, you'll explore virtual resources and use Puppet's resource scheduling and auditing features. In the concluding chapters, you'll walk through managing applications and writing your own resource types, providers, and external node classifiers. By the end of this book, you will have learned to report, log, and debug your system.
Table of Contents (16 chapters)
Title Page
Packt Upsell
Contributors
Preface
Index

Creating databases and users


Managing a database means more than ensuring the service is running; a database server is nothing without databases. Databases need users and privileges. Privileges are handled with GRANT statements. We will use the puppetlabs-mysql package to create a database and a user with access to that database. We'll create a MariaDB user, drupal, and a database, called drupal. We'll create a nodes table within the drupal database and place data into that table.

How to do it...

Follow these steps to create the databases and users:

  1. Create a database definition within your dbserver class:
mysql::db { 'drupal':
  host     => 'localhost',
  user     => 'drupal',
  password => 'Cookbook',
  sql      => '/root/drupal.sql',
  require  => File['/root/drupal.sql']
}
$drupal = @(DRUPAL)
  CREATE TABLE users (
    id INT PRIMARY KEY AUTO_INCREMENT, 
    title VARCHAR(255),
    body TEXT);
  INSERT INTO users (id, title, body) VALUES (1,'First Node','Contents of first Node...