G'day. I have a problem that I don't know the best way to mesh with Puppet.
Specifically, we have a database active/passive fail-over cluster. Access to
the database is *only* possible on the active machine, not on the passive
machine.
I would like to manage various database resources, including databases, users,
and embedded PL/SQL features, that are database level features: you *MUST*
connect to the database server to check, or modify, them. Direct disk access
is not possible.
So, how do I best manage that via puppet?
If I just configure a "database" resource on both machines I get problems,
since we are not easily able to access the database server on the passive
system.
I can, I suppose, have both systems connect to the virtual IP address that
always points at the active server, and do all their administration over the
network.
That should /mostly/ work, except that it will fall down if I add a new PS/SQL
feature that requires a package installed, and the passive machine runs before
the active one ... so adds the DBMS feature while the package is not yet
installed.
My best guess, right now, is that I need to write a function, or a fact, that
determines if we are the active or passive machine for a specific service[1],
and then only configure those features when we are active.
Comments?
Daniel
Footnotes:
[1] ...and these machines have multiple HA services, which can run on either
or both; machine 1 might be active with the database, but passive with
some other service.
--
✣ Daniel Pittman ✉ dan...@rimspace.net ☎ +61 401 155 707
♽ made with 100 percent post-consumer electrons
Looking for work? Love Perl? In Melbourne, Australia? We are hiring.
--~--~---------~--~----~------------~-------~--~----~
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+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/puppet-users?hl=en
-~----------~----~----~----~------~----~------~--~---
