Help using chef community mysql cookbook for idempotent chef-client runs

Eric_Feldhusen · October 28, 2013, 2:26pm

I’m been working my way through using various chef community cookbooks, but
I’m a little stuck on using the mysql cookbook.

I can install the MySQL service fine, but I’m having trouble with creating
users and database(s) in a way that’s idempotent once the users and
databases are there.

Also, is there a way to import a schema or an existing database dump file
that I have copied to the client from the chef server?

Thanks for any suggestions.

Eric Feldhusen

tduffield_opscode · October 28, 2013, 2:32pm

Hey Eric,
Have you tried checking out the database cookbook?

There are LWRPs that should help you do what you are looking to do.

Tom Duffield — Automation Consulting Engineer

651.769.7497 – tom@opscode.com – *my:
*Linkedinhttp://www.linkedin.com/in/thomasduffield/
Twitter https://twitter.com/tomduffield

OPSCODE

CODE CAN
opscode.com http://www.opscode.com Blog http://www.opscode.com/blog/
Facebook http://www.facebook.com/opscode
Twitterhttp://www.twitter.com/opscode
YouTube http://www.youtube.com/opscode

On Mon, Oct 28, 2013 at 9:26 AM, Eric Feldhusen
efeldhusen.lists@gmail.comwrote:

I'm been working my way through using various chef community cookbooks,
but I'm a little stuck on using the mysql cookbook.

I can install the MySQL service fine, but I'm having trouble with creating
users and database(s) in a way that's idempotent once the users and
databases are there.

Also, is there a way to import a schema or an existing database dump file
that I have copied to the client from the chef server?

Thanks for any suggestions.

Eric Feldhusen

Vladimir_Skubriev · October 28, 2013, 2:35pm

28.10.2013 18:26, Eric Feldhusen ?????:

I'm been working my way through using various chef community
cookbooks, but I'm a little stuck on using the mysql cookbook.

I can install the MySQL service fine, but I'm having trouble with
creating users and database(s) in a way that's idempotent once the
users and databases are there.

Also, is there a way to import a schema or an existing database dump
file that I have copied to the client from the chef server?

Thanks for any suggestions.

Eric Feldhusen
You can see this example:

github.com

computerlyrik/chef-bacula/blob/master/recipes/server.rb

#
# Cookbook Name:: bacula
# Recipe:: server
#
# Copyright 2012, 2013 computerlyrik
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
#     http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
#

node.set['bacula']['fd']['address'] = "127.0.0.1"

This file has been truncated. show original

--
Best regards,

CVision Lab System Administrator
Vladmir Skubriev

Eric_Feldhusen · October 29, 2013, 4:01pm

I'm still figuring out the LWRP's.

Eric

On Mon, Oct 28, 2013 at 10:32 AM, Tom Duffield tom@opscode.com wrote:

Hey Eric,
Have you tried checking out the database cookbook?
GitHub - chef-boneyard/database: DEPRECATED: Development repository for Chef database cookbook

There are LWRPs that should help you do what you are looking to do.

Tom Duffield — Automation Consulting Engineer

651.769.7497 – tom@opscode.com – *my: *Linkedinhttp://www.linkedin.com/in/thomasduffield/
Twitter https://twitter.com/tomduffield

OPSCODE

CODE CAN
opscode.com http://www.opscode.com Bloghttp://www.opscode.com/blog/
Facebook http://www.facebook.com/opscode Twitterhttp://www.twitter.com/opscode
YouTube http://www.youtube.com/opscode

On Mon, Oct 28, 2013 at 9:26 AM, Eric Feldhusen <
efeldhusen.lists@gmail.com> wrote:

I'm been working my way through using various chef community cookbooks,
but I'm a little stuck on using the mysql cookbook.

I can install the MySQL service fine, but I'm having trouble with
creating users and database(s) in a way that's idempotent once the users
and databases are there.

Also, is there a way to import a schema or an existing database dump file
that I have copied to the client from the chef server?

Thanks for any suggestions.

Eric Feldhusen

Justin_Witrick · October 29, 2013, 4:41pm

Here is a sample of how I use a definition and the databases cookbook to handle creating multiple databases/users:

gist.github.com

https://gist.github.com/jwitrick/7218037

gistfile1.txt

define :create_db do
      db_name = params[:name]
      mysql_connection = { :host => 'localhost',
        :username => 'root',
        :password => node['mysql']['server_root_password'] }

      service "mysqld" do
        action :start
      end
      directory "#{node['mysql']['dbs']['base_dir']}" do

This file has been truncated. show original

Justin

-----Original Message-----
From: “Eric Feldhusen” efeldhusen.lists@gmail.com
Sent: Tuesday, October 29, 2013 12:01pm
To: chef@lists.opscode.com
Subject: [chef] Re: Re: Help using chef community mysql cookbook for idempotent chef-client runs

I’m still figuring out the LWRP’s.
Eric

On Mon, Oct 28, 2013 at 10:32 AM, Tom Duffield <[mailto:tom@opscode.com] tom@opscode.com> wrote:

Hey Eric,
Have you tried checking out the database cookbook? [https://github.com/opscode-cookbooks/database] https://github.com/opscode-cookbooks/database
There are LWRPs that should help you do what you are looking to do.

Tom Duffield — Automation Consulting Engineer
651.769.7497 – [mailto:tom@opscode.com] tom@opscode.com – my: [http://www.linkedin.com/in/thomasduffield/] Linkedin [https://twitter.com/tomduffield] Twitter

OPSCODE
CODE CAN
[http://www.opscode.com] opscode.com [http://www.opscode.com/blog/] Blog [http://www.facebook.com/opscode] Facebook [http://www.twitter.com/opscode] Twitter [http://www.youtube.com/opscode] YouTube

On Mon, Oct 28, 2013 at 9:26 AM, Eric Feldhusen <[mailto:efeldhusen.lists@gmail.com] efeldhusen.lists@gmail.com> wrote:

I’m been working my way through using various chef community cookbooks, but I’m a little stuck on using the mysql cookbook.
I can install the MySQL service fine, but I’m having trouble with creating users and database(s) in a way that’s idempotent once the users and databases are there.
Also, is there a way to import a schema or an existing database dump file that I have copied to the client from the chef server?
Thanks for any suggestions.
Eric Feldhusen

Topic		Replies	Views
Installing mysql with chef Chef Infra (archive)	3	400	September 27, 2015
Opscode MySQL cookbook Chef Infra (archive)	2	252	May 4, 2010
Example Mysql create users/database setup? Chef Infra (archive)	0	229	September 27, 2011
Community-mysql instead of mysql Chef Infra (archive)	3	354	March 5, 2014
Database and database_user resources Chef Infra (archive)	0	287	August 22, 2011

Help using chef community mysql cookbook for idempotent chef-client runs

Related topics