Try something like this to extract the \d from the hostname:
<% id = fqdn.dup %>
<% id.gsub!(/db(\d).domain.ext/){$1} %>
server-id = <%= id %>
On 09/15/2015 03:59 PM, Tim Dunphy wrote:
Hey guys,
Is there any other way to automate this setting in my.cnf:
server-id=1
So that if the host is db1 it'll get a value of 1, for db2 a value of
2, for db3 a value of 3 and db4 a value of 4?
The only way I can think of this is to have branching logic in the
puppet manifest that does a test on the $hostname fact. But then you'd
have to have 4 files corresponding to each host.
But I'd like to find a way to get this to happen automatically using
templates.
I'm already setting up the SSL certs for the DB servers using the fqdn
fact like this:
ssl-cert=/opt/mysql/<%= fqdn %>.crt
ssl-key=/opt/mysql/<%= fqdn %>.key
I'm looking for a way to just have one my.cnf template for all 4 db
hosts that automatically assigns the right value to server-id the way
I describe above.
Any suggestions that could allow for that would be very welcome!
Thanks,
Tim
--
GPG me!!
gpg --keyserver pool.sks-keyservers.net
<http://pool.sks-keyservers.net> --recv-keys F186197B
--
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 [email protected]
<mailto:[email protected]>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/puppet-users/CAOZy0ekzV%2B8PAHjHVMiVmWS6%3DvXo2FNLpGowtWu-%2B-qCFKe6Tg%40mail.gmail.com
<https://groups.google.com/d/msgid/puppet-users/CAOZy0ekzV%2B8PAHjHVMiVmWS6%3DvXo2FNLpGowtWu-%2B-qCFKe6Tg%40mail.gmail.com?utm_medium=email&utm_source=footer>.
For more options, visit https://groups.google.com/d/optout.
--
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/puppet-users/55F87A47.9010808%40ias.edu.
For more options, visit https://groups.google.com/d/optout.
