Creating MySQL databases and users
You need to use two different cookbooks to manage 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 MySQL client and server.
Let's see how we can install MySQL server and create a database and a database user.
Getting ready
Make sure that you have a cookbook called my_cookbook
and that the run_list
of your node includes my_cookbook
, as described in the Creating and using cookbooks recipe in Chapter 1, Chef Infrastructure.
Make sure Berksfile
in your Chef repository includes my_cookbook
:
mma@laptop:~/chef-repo ...
Get Chef Infrastructure Automation Cookbook - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.