Forge Home

sakila_mysql_db

Downloads and installs MySQL's Sakila sample database http://dev.mysql.com/doc/sakila/en)

10,342 downloads

9,261 latest version

4.5 quality score

We run a couple of automated
scans to help you access a
module's quality. Each module is
given a score based on how well
the author has formatted their
code and documentation and
modules are also checked for
malware using VirusTotal.

Please note, the information below
is for guidance only and neither of
these methods should be considered
an endorsement by Puppet.

Version information

  • 0.3.4 (latest)
  • 0.3.3
  • 0.3.2
  • 0.3.1
  • 0.3.0
released Mar 4th 2015
This version is compatible with:

Start using this module

  • r10k or Code Manager
  • Bolt
  • Manual installation
  • Direct download

Add this module to your Puppetfile:

mod 'garystafford-sakila_mysql_db', '0.3.4'
Learn more about managing modules with a Puppetfile

Add this module to your Bolt project:

bolt module add garystafford-sakila_mysql_db
Learn more about using this module with an existing project

Manually install this module globally with Puppet module tool:

puppet module install garystafford-sakila_mysql_db --version 0.3.4

Direct download is not typically how you would use a Puppet module to manage your infrastructure, but you may want to download the module in order to inspect the code.

Download

Documentation

garystafford/sakila_mysql_db — version 0.3.4 Mar 4th 2015

garystafford-sakila_mysql_db

Puppet module for downloading and installing MySQL Sakila sample database. The sakila_mysql_db Puppet module downloads and installs the MySQL Sakila example database onto an Ubuntu-based target node running MySQL. Note, if MySQL does not exist on target node, the sakila_mysql_db class will install MySQL using puppetlabs-mysql module's mysql::server class (currently version 5.5.x).
There are also two other classes, sakila_mysql_db::cleanup and sakila_mysql_db::uninstall, which can be used to drop the database and to remove all install files.

Support

This module is currently tested on:

  • Ubuntu 12.04
  • Ubuntu 14.04

It may work on other distros. You will need to test.

Usage

include sakila_mysql_db
include sakila_mysql_db::uninstall
include sakila_mysql_db::cleanup

Module Classes

  • sakila_mysql_db (init.pp) - Downloads and installs Sakila database
  • sakila_mysql_db::params - Parameters inherited by all other classes
  • sakila_mysql_db::cleanup - Removes all files from download and install
  • sakila_mysql_db::uninstall - Drops the Sakila database from MySQL instance

Dependencies

The sakila_mysql_db class (init.pp) depends on:

Testing Install

On the node, run any of the following commands in the terminal:

  • sudo service mysql status
  • mysql -u root sakila -e "SHOW TABLES;"
  • mysql -u root sakila -e "SELECT * FROM category;"

MySQL Links

Removing MySQL

  • sudo apt-get remove --purge mysql-server mysql-client mysql-common
  • sudo apt-get autoremove
  • sudo apt-get autoclean
  • sudo reboot
  • sudo service mysql status