Adoptable Cookbooks List

Looking for a cookbook to adopt? You can now see a list of cookbooks available for adoption!
List of Adoptable Cookbooks

Supermarket Belongs to the Community

Supermarket belongs to the community. While Chef has the responsibility to keep it running and be stewards of its functionality, what it does and how it works is driven by the community. The chef/supermarket repository will continue to be where development of the Supermarket application takes place. Come be part of shaping the direction of Supermarket by opening issues and pull requests or by joining us on the Chef Mailing List.

Select Badges

Select Supported Platforms

Select Status


mysql-sys (2) Versions 0.5.0

Installs the mysql-sys tool. Description of the tool is available here

cookbook 'mysql-sys', '= 0.5.0', :supermarket
cookbook 'mysql-sys', '= 0.5.0'
knife supermarket install mysql-sys
knife supermarket download mysql-sys
Quality 100%

mysql-sys Cookbook

Installs the mysql-sys tool. The tool is a collection of views, functions and procedures to help MySQL administrators get insight into MySQL database usage.
Detailed description of the tool is available here:


  • Chef 11 or higher
  • Ruby 1.9 or higher (preferably from the Chef full-stack installer)
  • Network accessible package repositories

Platform Support

The following platforms are supported:
* CentOS
* Red Hat

The following 64-bit platforms have been tested:
* CentOS 6.4
* CentOS 6.5
* CentOS 7.0

Cookbook Dependencies

  • mysql-chef_gem
  • database


Just include mysql-sys in your node's run_list:

  "run_list": [

Or include the default recipe in another cookbook
include_recipe "mysql-sys::default"

MySQL versions supported

MySQL version 5.6 is supported

MySQL users used by the cookbook

The cookbook requires the MySQL root user password.

If data bags are not being used to store the passwords for the users then the following attribute must store the "root" user password:
node.set["mysql"]["root_password"] = "changeme"

Using encrypted data bag for storing MySQL credentials

It is recommended though to store the user passwords in encrypted data bag.
If encrypted data bag is being used then the following attribute must be set:
node.set["mysql_sys"]["use_encrypted_databag"] = true
node.set["mysql_sys"]["databag_name"] = "passwords"
node.set["mysql_sys"]["databag_item"] = "mysql_users"

The above assumes that a data bag was created as follows:
knife data bag create passwords mysql_users --secret-file /path/to/databag_encryption_key

An example data bag item json is shown below:
"id": "mysql_users",
"root": "some_secure_password"


The following attributes are set by default:
default["mysql_sys"]["version"] = "1.3.0"
default["mysql_sys"]["git_repository"] = "git://"
default["mysql_sys"]["git_revision"] = "v1.3.0a"
default["mysql_sys"]["use_encrypted_databag"] = false
default["mysql_sys"]["databag_name"] = "passwords"
default["mysql_sys"]["databag_item"] = "mysql_users"

The other attribute that is needed and not set by default is:


  1. Fork the repository on Github
  2. Create a named feature branch (like add_component_x)
  3. Write your change
  4. Write tests for your change (if applicable)
  5. Run the tests, ensuring they all pass
  6. Submit a Pull Request using Github

License & Authors

(c) 2014, Ovais Tariq <>

This program is free software: you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program.  If not, see <>.

Dependent cookbooks

mysql-chef_gem >= 0.0.0
database ~> 2.1

Contingent cookbooks

There are no cookbooks that are contingent upon this one.

Foodcritic Metric

0.5.0 passed this metric