Update on COOK-1441, database, mysql, postgresql cookbooks


#1

Ohai, Chefs!

We have released the following cookbooks today:

  • database (v1.3.2)
  • mysql (v1.3.0)
  • postgresql (v1.0.0)

A huge thank you and cookbook release MVP goes to Jesse Howarth and Jamie Winsor of RiotGames for their comments, feedback, and of course, pull requests.

Also, thank you to everyone else who participated in the discussions on the mailing list or in IRC. We appreciate everyone’s patience during the process. It turns out that the problem is very tricky to resolve, and I think the solution is going to be the best general case for the broadest audience.

The theme of the major changes in these releases is around the installation of the RubyGems “mysql” and “pg”. That is, the client recipes in both cookbooks will no longer install the RubyGems by default. That has been moved to the ruby recipe in each cookbook. The database cookbook now has postgresql and mysql recipes that will include the appropriate ruby recipe, as a matter of convenience. This was tracked under the ticket COOK-1441.

Please be aware that if you are using an Omnibus installation of Chef, the “pg” gem does not install properly without a huge amount of compilation hassle. This issue is tracked under ticket COOK-1406.

The following attributes are arrays that contain the package names based on the platform of the node.

  • node[‘mysql’][‘client’][‘packages’]
  • node[‘mysql’][‘server’][‘packages’]
  • node[‘postgresql’][‘client’][‘packages’]
  • node[‘postgresql’][‘server’][‘packages’]

These were namespaced under client and server to make them clearer and easier to parse programmatically. If you wish to install the native package for the rubygems your platform (if it has one), you can simply modify the attribute, and Chef will handle that for you.

A side benefit of the mysql attributes is that Percona should be a “drop in” replacement by simply populating the attributes with the Percona package names.

A lot of tickets are resolved in these releases. See the CHANGELOG.md and README.md for more details, and the tickets for the various issues and resolutions.

database:

mysql:

postgresql:


Opscode, Inc
Joshua Timberman, Technical Program Manager
IRC, Skype, Twitter, Github: jtimberman


#2

Hi Josuha and all,

On Thu, Aug 16, 2012 at 11:18 PM, Joshua Timberman joshua@opscode.com wrote:

Ohai, Chefs!

We have released the following cookbooks today:

  • database (v1.3.2)
  • mysql (v1.3.0)
  • postgresql (v1.0.0)

A huge thank you and cookbook release MVP goes to Jesse Howarth and Jamie Winsor of RiotGames for their comments, feedback, and of course, pull requests.

great stuff.

I was wondering, is there any plan to merge Noah’s changes to the
database cookbook?
I have been using his version for—well, almost a year now, and the DSL
makes it much more convenient to define a database for an application.
If it’s just a matter of cleaning it up and merging it, I could take
care of it (when time allows).

Andrea


#3

Can you share a link to this version?

Jamie Winsor
@resetexistence

On Aug 17, 2012, at 12:03 AM, Andrea Campi andrea.campi@zephirworks.com wrote:

Hi Josuha and all,

On Thu, Aug 16, 2012 at 11:18 PM, Joshua Timberman joshua@opscode.com wrote:

Ohai, Chefs!

We have released the following cookbooks today:

  • database (v1.3.2)
  • mysql (v1.3.0)
  • postgresql (v1.0.0)

A huge thank you and cookbook release MVP goes to Jesse Howarth and Jamie Winsor of RiotGames for their comments, feedback, and of course, pull requests.

great stuff.

I was wondering, is there any plan to merge Noah’s changes to the
database cookbook?
I have been using his version for—well, almost a year now, and the DSL
makes it much more convenient to define a database for an application.
If it’s just a matter of cleaning it up and merging it, I could take
care of it (when time allows).

Andrea


#4

On Fri, Aug 17, 2012 at 9:52 AM, Jamie Winsor jamie@vialstudios.com wrote:

Can you share a link to this version?

Sure: https://github.com/coderanger/djangocon2011/tree/master/cookbooks/database
Now that I look at it, Noah’s still requires some cleaning up, and
I’ve possibly made a small tweaks; so don’t get too stuck up on the
code.

What I think is more interesting is the way you use it:


which sits side by side with the corresponding application:

Andrea


#5

On Aug 17, 2012, at 2:35 AM, Andrea Campi andrea.campi@zephirworks.com wrote:

On Fri, Aug 17, 2012 at 9:52 AM, Jamie Winsor jamie@vialstudios.com wrote:

Can you share a link to this version?

Sure: https://github.com/coderanger/djangocon2011/tree/master/cookbooks/database
Now that I look at it, Noah’s still requires some cleaning up, and
I’ve possibly made a small tweaks; so don’t get too stuck up on the
code.

I’d like to see this in the database cookbook too. Is there a COOK ticket open? If not do you mind opening one?

Thanks!


Opscode, Inc
Joshua Timberman, Technical Program Manager
IRC, Skype, Twitter, Github: jtimberman