mysql-test-schema Cookbook

The mysql-test-schema cookbook does the following:
- Sets up and loads the employees schema (https://dev.mysql.com/doc/employee/en/employees-introduction.html)
- Sets up and loads the sakila schema (http://dev.mysql.com/doc/sakila/en/sakila-introduction.html)

Requirements

• 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

Usage

Depending on which of the two schemas (or even both) you want to load include the necessary recipe in your node's run_list:

{
  "name":"my_node",
  "run_list": [
    "recipe[mysql-test-schema::employees]"
    "recipe[mysql-test-schema::sakila]"
  ]
}

Or, place a dependency on the mysql-test-schema cookbook in your cookbook's metadata.rb

depends "mysql-test-schema", "~> 0.1"

Then, in a recipe:

include_recipe "mysql-test-schema::employees"
include_recipe "mysql-test-schema::sakila"

MySQL versions supported

MySQL versions 5.1, 5.5 and 5.6 are supported

MySQL users used by the cookbook

The cookbook assumes that authentication using defaults-file has been setup so that it is not required to pass username and password on the command-line.

Attributes

The following attributes are set by default:
ruby
default["mysql_test_schema"]["employee"]["version"] = "1.0.6"
default["mysql_test_schema"]["employee"]["url"] = "https://launchpad.net/test-db/employees-db-1/#{node["mysql_test_schema"]["employee"]["version"]}/+download"
default["mysql_test_schema"]["employee"]["dump_filename"] = "employees_db-full-#{node["mysql_test_schema"]["employee"]["version"]}.tar.bz2"
default["mysql_test_schema"]["employee"]["checksum"] = "9be9b830a185e947758581cb06f529d1e8b675b29cde13a2860b1319b7e1cb7d"
default["mysql_test_schema"]["sakila"]["url"] = "http://downloads.mysql.com/docs"
default["mysql_test_schema"]["sakila"]["dump_filename"] = "sakila-db.tar.gz"
default["mysql_test_schema"]["sakila"]["checksum"] = "619bad5852078d30d7812492f4e75b3b4baeae99034b34a4934b3715c2abf2b8"


Contributing

1. Fork the repository https://github.com/ovaistariq/chef-cookbooks.git 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

• Author: Ovais Tariq (me@ovaistariq.net)

(c) 2014, Ovais Tariq <me@ovaistariq.net>

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
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
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 <http://www.gnu.org/licenses/>.