dusan.dordevic@clavistechnology.com
2013-Jul-02 11:42 UTC
[Puppet Users] Re-create my.cnf when using Puppet MySQL module
Hi, I am using Puppet MySQL module from forge and everything works as expected. It downloaded and installed mysql, created database, set pass, etc. I wanted to make few configuration changes, so I changed mysql/templates/my.cnf.erb but it seems Puppet did not detected that change. What be the best way to trigger re-creation of my.cnf file ? Thanks, Dusan -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users+unsubscribe@googlegroups.com. To post to this group, send email to puppet-users@googlegroups.com. Visit this group at http://groups.google.com/group/puppet-users. For more options, visit https://groups.google.com/groups/opt_out.
Nikola Petrov
2013-Jul-03 07:10 UTC
Re: [Puppet Users] Re-create my.cnf when using Puppet MySQL module
You can use custom settings that will be put in /etc/mysq/conf.d/ and will be included in you setup by overriding any setting in my.cnf. Here is an example from our setup: mysql::server::config{ ''my-cool-settings'': settings => { ''mysqld'' => { ''max_connections'' => ''400'', #the maximum number of open connections ''max_connect_errors'' => ''1000'', # sane value because the default is 10 which is not enough at all! ''character-set-server'' => ''utf8'', #use utf8 by default ''innodb_buffer_pool_size'' => $innodb_buffer_pool_size, #innodb buffer size } } } -- Nikola On Tue, Jul 02, 2013 at 04:42:56AM -0700, dusan.dordevic@clavistechnology.com wrote:> Hi, > > I am using Puppet MySQL module from forge and everything works as expected. > It downloaded and installed mysql, created database, set pass, etc. > > I wanted to make few configuration changes, so I changed > mysql/templates/my.cnf.erb > > but it seems Puppet did not detected that change. What be the best way to > trigger re-creation of my.cnf file ? > > Thanks, > Dusan > > -- > You received this message because you are subscribed to the Google Groups "Puppet Users" group. > To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users+unsubscribe@googlegroups.com. > To post to this group, send email to puppet-users@googlegroups.com. > Visit this group at http://groups.google.com/group/puppet-users. > For more options, visit https://groups.google.com/groups/opt_out. > >-- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users+unsubscribe@googlegroups.com. To post to this group, send email to puppet-users@googlegroups.com. Visit this group at http://groups.google.com/group/puppet-users. For more options, visit https://groups.google.com/groups/opt_out.