Setting alternative 'tmpdir' for latest mysql cookbook


#1

I’m using the latest mysql cookbook, and finding that on a thinly provisioned MySQL server with attached disk for MySQL, the “tmpdir” is hardcoded in /etc/mysql-default/my.cnf to be “/tmp”. This is a problem.

I’m happy to insert values in an /etc/mysql-default/conf.d/tmpdir.cfg, but those can be obscure when people simply read /etc/my.cnf. Can I get any traction to make that a setting in the LWRP?

Nico Kadel-Garcia
Lead DevOps Engineer
nkadel@skyhookwireless.com


#2

Hi Nico.

This falls under https://github.com/chef-cookbooks/mysql/issues/281

I’m planning on fixing that up in the next feature release.

Overriding it with an mysql_config resource is the best thing to do for now.

-s

On Thu, Apr 16, 2015 at 11:49 AM, Nico Kadel-Garcia
nkadel@skyhookwireless.com wrote:

I’m using the latest mysql cookbook, and finding that on a thinly provisioned MySQL server with attached disk for MySQL, the “tmpdir” is hardcoded in /etc/mysql-default/my.cnf to be “/tmp”. This is a problem.

I’m happy to insert values in an /etc/mysql-default/conf.d/tmpdir.cfg, but those can be obscure when people simply read /etc/my.cnf. Can I get any traction to make that a setting in the LWRP?

Nico Kadel-Garcia
Lead DevOps Engineer
nkadel@skyhookwireless.com


#3

Thanks. I think it needs to be instance specific, if it’s used at all. While ‘tmpdir’ can often be safely shared for multiple simultaneously running MySQL instances, it can be helpful for multiple MySQL instances to have separate ‘tmpdir’ directories to segregate bulky or problematic operations.

Nico Kadel-Garcia
Lead DevOps Engineer
nkadel@skyhookwireless.com

-----Original Message-----
From: Sean OMeara [mailto:someara@chef.io]
Sent: Thursday, April 16, 2015 12:01 PM
To: chef@lists.opscode.com
Subject: [chef] Re: Setting alternative ‘tmpdir’ for latest mysql cookbook

Hi Nico.

This falls under https://github.com/chef-cookbooks/mysql/issues/281

I’m planning on fixing that up in the next feature release.

Overriding it with an mysql_config resource is the best thing to do for now.

-s

On Thu, Apr 16, 2015 at 11:49 AM, Nico Kadel-Garcia
nkadel@skyhookwireless.com wrote:

I’m using the latest mysql cookbook, and finding that on a thinly provisioned
MySQL server with attached disk for MySQL, the “tmpdir” is hardcoded in
/etc/mysql-default/my.cnf to be “/tmp”. This is a problem.

I’m happy to insert values in an /etc/mysql-default/conf.d/tmpdir.cfg, but
those can be obscure when people simply read /etc/my.cnf. Can I get any
traction to make that a setting in the LWRP?

Nico Kadel-Garcia
Lead DevOps Engineer
nkadel@skyhookwireless.com