Christophe L
2012-Mar-19 18:56 UTC
[Puppet Users] Puppet equivalent for mysql[''tunable''] in chef
Hello, Could you please tell us what is the way to do easily "tuning" of the my.cnf conf file in puppet, as it is possible in chef ? Is it already implemented in mysql modules /classes for puppet ? cf. https://github.com/fnichol/chef-mysql mysql[''tunable''][''key_buffer''] = "250M" mysql[''tunable''][''max_connections''] = "800" mysql[''tunable''][''wait_timeout''] = "180" ... Thanks in advance for your answers. Best regards, Christophe -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com. To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.
Adam Heinz
2012-Mar-19 19:18 UTC
Re: [Puppet Users] Puppet equivalent for mysql[''tunable''] in chef
puppet 2.6+, derived from https://github.com/camptocamp/puppet-mysql $mycnf = $::operatingsystem ? { /RedHat|Fedora|CentOS/ => "/etc/my.cnf", default => "/etc/mysql/my.cnf", } augeas { $mycnf: context => "/files$mycnf", changes => [ "set mysqld/key_buffer 250M", "set mysqld/max_connections 800", "set mysqld/wait_timeout 180", ], require => Package["mysql"], notify => Service["mysql"], incl => $mycnf, lens => "Mysql.lns", } -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com. To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.
Christophe L
2012-Mar-20 09:46 UTC
[Puppet Users] Re: Puppet equivalent for mysql[''tunable''] in chef
Thank you ! Best regards, Christophe On 19 mar, 23:18, Adam Heinz <a...@metricwise.net> wrote:> puppet 2.6+, derived fromhttps://github.com/camptocamp/puppet-mysql > > $mycnf = $::operatingsystem ? { > /RedHat|Fedora|CentOS/ => "/etc/my.cnf", > default => "/etc/mysql/my.cnf", > } > > augeas { $mycnf: > context => "/files$mycnf", > changes => [ > "set mysqld/key_buffer 250M", > "set mysqld/max_connections 800", > "set mysqld/wait_timeout 180", > ], > require => Package["mysql"], > notify => Service["mysql"], > incl => $mycnf, > lens => "Mysql.lns", > }-- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com. To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.