You need to use two different cookbooks for managing MySQL (or any other database) on your nodes: the generic database
cookbook and the mysql
cookbook.
The database
cookbook provides resources for managing databases and database users for MySQL, PostgreSQL, and Microsoft SQL Server. The mysql
cookbook installs a MySQL Client and server.
Let's see how we can install a MySQL server and create a database and a database user.
Make sure you've a cookbook called my_cookbook
and the run_list
of your node includes my_cookbook
as described in the Creating and using cookbooks section in Chapter 1, Chef Infrastructure.
Make sure you've the berkshelf
gem installed as described in the Managing cookbook dependencies with Berkshelf section in Chapter 1, Chef Infrastructure.
Create your Berksfile
in your Chef repository including my_cookbook
:
mma@laptop:~/chef-repo $ subl Berksfile
cookbook 'my_cookbook', path: './cookbooks/my_cookbook'