Mysql percona cookbook

Chef Infra (archive)
1

Hello,

What is the best cookbook to install mysql percona distribution.
I found a few on github but not sure which one is the ‘official’ one.

thanks!

-silviu

2

On Mon, Nov 25, 2013 at 8:00 PM, Silviu Dicu silviudicu@gmail.com wrote:

Hello,

What is the best cookbook to install mysql percona distribution.
I found a few on github but not sure which one is the 'official' one.

You can use the Opscode maintained one if you change the package names
that are to be installed with the following attributes:

node['mysql']['client']['packages'] - An array of package names that
should be installed on "client" systems. This can be modified, e.g.,
to specify packages for Percona.

node['mysql']['server']['packages'] - An array of package names that
should be installed on "server" systems. This can be modified, e.g.,
to specify packages for Percona.

--
Andy Gale

http://twitter.com/andygale

3

Hi Andy,

This is what I have into my site cookbook

node.override['mysql']['client']['packages'] = ['percona-server-client-5.5']
include_recipe "mysql::ruby"

When applied gives this:

Chef::Exceptions::Package

package[percona-server-client-5.5] (mysql::client line 47) had an error:
Chef::Exceptions::package: No version specified, and no candidate version
available for percona-server-client-5.5

Also I can confirm that the apt repo is not installed.

Looking into the ruby recipe I can see at

https://github.com/opscode-cookbooks/mysql/blob/master/recipes/ruby.rb#L35

only debian is supported ... I run ubuntu.

This seems to be a bug in the end - should I open a jira ticket ?

thanks!

-silviu

ps: i tried also the client recipe but it does fail as well and doesn't
seem to have support for the percona's repo

2013/11/25 Andy Gale andy@salgo.net

On Mon, Nov 25, 2013 at 8:00 PM, Silviu Dicu silviudicu@gmail.com wrote:

Hello,

What is the best cookbook to install mysql percona distribution.
I found a few on github but not sure which one is the 'official' one.

You can use the Opscode maintained one if you change the package names
that are to be installed with the following attributes:

node['mysql']['client']['packages'] - An array of package names that
should be installed on "client" systems. This can be modified, e.g.,
to specify packages for Percona.

node['mysql']['server']['packages'] - An array of package names that
should be installed on "server" systems. This can be modified, e.g.,
to specify packages for Percona.

--
Andy Gale
http://andy-gale.com
http://twitter.com/andygale

4

It looks like at the moment the recipe that you could add to add the
percona repo has been disabled:
https://github.com/opscode-cookbooks/mysql/blob/master/recipes/_percona_repo-disabled.rb

You could try reenabling that and adding it to your run list.

-j

On Mon, Nov 25, 2013 at 5:00 PM, Silviu Dicu silviudicu@gmail.com wrote:

Hi Andy,

This is what I have into my site cookbook

node.override['mysql']['client']['packages'] =
['percona-server-client-5.5']
include_recipe "mysql::ruby"

When applied gives this:

Chef::Exceptions::Package

package[percona-server-client-5.5] (mysql::client line 47) had an error:
Chef::Exceptions::package: No version specified, and no candidate version
available for percona-server-client-5.5

Also I can confirm that the apt repo is not installed.

Looking into the ruby recipe I can see at

https://github.com/opscode-cookbooks/mysql/blob/master/recipes/ruby.rb#L35

only debian is supported ... I run ubuntu.

This seems to be a bug in the end - should I open a jira ticket ?

thanks!

-silviu

ps: i tried also the client recipe but it does fail as well and doesn't
seem to have support for the percona's repo

2013/11/25 Andy Gale andy@salgo.net

On Mon, Nov 25, 2013 at 8:00 PM, Silviu Dicu silviudicu@gmail.com
wrote:

Hello,

What is the best cookbook to install mysql percona distribution.
I found a few on github but not sure which one is the 'official' one.

You can use the Opscode maintained one if you change the package names
that are to be installed with the following attributes:

node['mysql']['client']['packages'] - An array of package names that
should be installed on "client" systems. This can be modified, e.g.,
to specify packages for Percona.

node['mysql']['server']['packages'] - An array of package names that
should be installed on "server" systems. This can be modified, e.g.,
to specify packages for Percona.

--
Andy Gale
http://andy-gale.com
http://twitter.com/andygale

5

https://github.com/opscode-cookbooks/mysql/blob/master/recipes/_percona_repo-disabled.rb#L26

yeah ... looks like needs more work.

in my mind the flow should be as simple as

mysql::install_percona_repo
mysql::client -> loop trough node[:mysql][:client][:packages] = [....]

this gives the option for both percoana and native packages.

cheers!

2013/11/25 Jeremy Bingham jbingham@gmail.com

It looks like at the moment the recipe that you could add to add the
percona repo has been disabled:
https://github.com/opscode-cookbooks/mysql/blob/master/recipes/_percona_repo-disabled.rb

You could try reenabling that and adding it to your run list.

-j

On Mon, Nov 25, 2013 at 5:00 PM, Silviu Dicu silviudicu@gmail.com wrote:

Hi Andy,

This is what I have into my site cookbook

node.override['mysql']['client']['packages'] =
['percona-server-client-5.5']
include_recipe "mysql::ruby"

When applied gives this:

Chef::Exceptions::Package

package[percona-server-client-5.5] (mysql::client line 47) had an error:
Chef::Exceptions::package: No version specified, and no candidate version
available for percona-server-client-5.5

Also I can confirm that the apt repo is not installed.

Looking into the ruby recipe I can see at

https://github.com/opscode-cookbooks/mysql/blob/master/recipes/ruby.rb#L35

only debian is supported ... I run ubuntu.

This seems to be a bug in the end - should I open a jira ticket ?

thanks!

-silviu

ps: i tried also the client recipe but it does fail as well and doesn't
seem to have support for the percona's repo

2013/11/25 Andy Gale andy@salgo.net

On Mon, Nov 25, 2013 at 8:00 PM, Silviu Dicu silviudicu@gmail.com
wrote:

Hello,

What is the best cookbook to install mysql percona distribution.
I found a few on github but not sure which one is the 'official' one.

You can use the Opscode maintained one if you change the package names
that are to be installed with the following attributes:

node['mysql']['client']['packages'] - An array of package names that
should be installed on "client" systems. This can be modified, e.g.,
to specify packages for Percona.

node['mysql']['server']['packages'] - An array of package names that
should be installed on "server" systems. This can be modified, e.g.,
to specify packages for Percona.

--
Andy Gale
http://andy-gale.com
http://twitter.com/andygale