search

severalnines / S9s_cookbooks

S9s Chef cookbooks
www.severalnines.com
9 stars 11 forks source link

Is there a reason you didn't use the MySQL cookbook from opscode? #1

Open jaypipes opened 11 years ago

jaypipes commented 11 years ago

Hi!

We're investigating using these cookbooks to set up Galera in our deployments. We've been using the mysql cookbooks from opscode up until now.

Looking through your Galera attributes/default.rb, I see that many of the attributes in the mysql Hash are different from the ones in the mysql cookbook, but I don't know why.

For instance, in the mysql cookbook, to change the innodb buffer pool size, you change this:

node["mysql"]["tunables"]["innodb_buffer_pool_size"]

But in your cookbook, you change:

node["mysql"]["innodb"]["buffer_pool_size"]

Why is this? This means we can't use the attributes we have been using in your recipe.

Secondly, did you think about possibly just submitting changes to the upstream mysql cookbook which add the various wsrep configurations to my.cnf instead of doing everything from scratch?

alyu commented 11 years ago

Hi, There is no reason really, at that time writing it from scratch seemed easier than trying to fit what we wanted to do into an existing recipe and Chef was and still is quite new to us. We could definitely change some of the attributes to better match OpsCode's main MySQL cookboks if that makes using ours a little easier.

And sure, I don't see why we couldn't try adding Galera to OpsCode's MySQL cookbooks but that will require some effort on our side of course to make it work properly. BR, -alex

jaypipes commented 11 years ago

Hi!

As a matter of fact, I gave it a shot myself :)

https://github.com/jaypipes/cookbook-mysql/tree/galera

Am working on this with a colleague in Russia over the next couple weeks. Will keep you updated and will be trying to get it merged upstream.

All the best! -jay

odyssey4me commented 11 years ago

@jaypipes Did you ever complete the work? I see that there is reference in https://github.com/att-cloud/cookbook-mysql#galera-cluster to deploying the Galera cluster, but the upstream opscode cookbook doesn't reflect the same readme entry. Is it still a work in progress?

jaypipes commented 11 years ago

Hi!

In fact, I did complete the work, however I did not use the MySQL cookbook either :) I need to delete the linked reference above -- it no longer refers to a cookbook we use or maintain.

The work I did to get Galera configured via Chef is in (unfortunately) a private Chef repo called cookbook-infra-db that we use at AT&T. I will see about making it public.