Forge Home


Downloads and installs MySQL's Sakila sample database


8,629 latest version

4.5 quality score

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:
  • Ubuntu

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.



garystafford/sakila_mysql_db — version 0.3.4 Mar 4th 2015


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.


This module is currently tested on:

  • Ubuntu 12.04
  • Ubuntu 14.04

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


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


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