Yes. In most companies once the automation platform is chosen then everything
is moved to be under its management.
I have 3 current clients managing Oracle, SQLServer, MySQL and Psotgresql along
with their application servers.
Matthew Parker
Chief Technologist
Dimensional DBA
Oracle Gold Partner
425-891-7934 (cell)
D&B 047931344
CAGE 7J5S7
Dimensional.dba@xxxxxxxxxxx
<http://www.linkedin.com/pub/matthew-parker/6/51b/944/> View Matthew Parker's
profile on LinkedIn
www.dimensionaldba.com <http://www.dimensionaldba.com/>
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> On Behalf
Of tefetufe .
Sent: Friday, June 15, 2018 4:35 AM
To: dimensional.dba@xxxxxxxxxxx
Cc: Jay.Miller@xxxxxxxxxxxxxxxx; Oracle-L@xxxxxxxxxxxxx; cstephens16@xxxxxxxxx;
post.ethan@xxxxxxxxx; sethmiller.sm@xxxxxxxxx
Subject: Re: Configuration management / Puppet for Oracle DBA'ing
Sorry if I’m hijacking the real question but while we are on the subject I
wanted to ask if you are using puppet for central management of lifecycles of
databases
What we want is (for both oracle and mssql estate)
1- manage databases centrally using puppet and push changes using puppet. No
local changes will be allowed in this model. Everything will be done puppet
and we want to use puppet to report differences between the environments so we
can capture behaviour differences caused by changes earlier than prod cycle.
2- being able to auto provision application tailored databases using puppet.
Meaning; If somebody wants another db or new dv for their app we want to deploy
all changes to that app using puppet (assuming all tailoring - parameters users
storage- already exist) We already have vmware as our private cloud. We want to
extent the provisioning capacity from base db to ready to use db. All they need
to do is give me an X db rather than give me a db when they provision.
3- mass patching using puppet
I need to understand if our plans are doable with puppet or not. Appreciate if
anybody uses puppet for this purpose.
I asked the question for puppet but i’m open suggestions for other tools as well
Thans
On Fri, Jun 15, 2018 at 11:59 Matthew Parker <dimensional.dba@xxxxxxxxxxx
<mailto:dimensional.dba@xxxxxxxxxxx> > wrote:
The base code is about deployment and config, but as you expand what you put
under automation, it is about general operations to.
The real part of automation and deployment is about repeatable task
implementation and being able to perform against the whole fleet even at the
same time.
With puppet modules I have developed a standard RU/RUR from deployment of code
to server to patch apply completion is 12 minutes. Now imagine patching your
whole fleet in the same 12 minutes.
Automation is about being a force multiplier for you and insurance of fleet
consistency.
For full operational automation you have to start thinking in terms of SOPs. If
you can write down the steps that need to be performed, you can automate the
process.
Matthew Parker
Chief Technologist
Dimensional DBA
Oracle Gold Partner
425-891-7934 (cell)
D&B 047931344
CAGE 7J5S7
Dimensional.dba@xxxxxxxxxxx <mailto:Dimensional.dba@xxxxxxxxxxx>
<http://www.linkedin.com/pub/matthew-parker/6/51b/944/> View Matthew Parker's
profile on LinkedIn
www.dimensionaldba.com <http://www.dimensionaldba.com/>
From: oracle-l-bounce@xxxxxxxxxxxxx <mailto:oracle-l-bounce@xxxxxxxxxxxxx>
<oracle-l-bounce@xxxxxxxxxxxxx <mailto:oracle-l-bounce@xxxxxxxxxxxxx> > On
Behalf Of Ethan Post
Sent: Thursday, June 14, 2018 8:24 PM
To: cstephens16@xxxxxxxxx <mailto:cstephens16@xxxxxxxxx> ; 'Matthew Parker'
<dimensional.dba@xxxxxxxxxxx <mailto:dimensional.dba@xxxxxxxxxxx> >
Cc: Jay.Miller@xxxxxxxxxxxxxxxx <mailto:Jay.Miller@xxxxxxxxxxxxxxxx> ;
sethmiller.sm@xxxxxxxxx <mailto:sethmiller.sm@xxxxxxxxx> ;
Oracle-L@xxxxxxxxxxxxx <mailto:Oracle-L@xxxxxxxxxxxxx>
Subject: RE: Configuration management / Puppet for Oracle DBA'ing
I took a quick look at the github repo, it looked like a lot of code/config. My
question is will it still work in a year or two? If not are you ready to fix
the supporting code in the repo?
I have never worked in an environment where provisioning was a big issue and
certainly not the bulk of workload. I feel like many of us are adopting a
provisioning mindset because the folks designing tools like puppet, chef and
ansible are heavy users of provisioning and higher ups are pushing
“automation”. If provisioning was an issue I would probably just build out an
image which can quickly be replicated or find some other solution which off the
top of my head I can think of a few.
Just my 2 cents. Been here for many years but like a bunch of you just lurk
these days. No better list in the world IMHO.
Thanks!
Ethan
From: oracle-l-bounce@xxxxxxxxxxxxx <mailto:oracle-l-bounce@xxxxxxxxxxxxx>
<oracle-l-bounce@xxxxxxxxxxxxx <mailto:oracle-l-bounce@xxxxxxxxxxxxx> > On
Behalf Of Chris Stephens
Sent: Tuesday, June 12, 2018 2:38 PM
To: Matthew Parker <dimensional.dba@xxxxxxxxxxx
<mailto:dimensional.dba@xxxxxxxxxxx> >
Cc: Jay.Miller@xxxxxxxxxxxxxxxx <mailto:Jay.Miller@xxxxxxxxxxxxxxxx> ;
sethmiller.sm@xxxxxxxxx <mailto:sethmiller.sm@xxxxxxxxx> ;
Oracle-L@xxxxxxxxxxxxx <mailto:Oracle-L@xxxxxxxxxxxxx>
Subject: Re: Configuration management / Puppet for Oracle DBA'ing
as appealing as ansible sounds (at least to investigate), i think i'll run with
puppet for now since I'm new here and it's what everyone uses. thanks for all
the input!
--
--
Coskan GUNDOGAR
Oracle DBA
Email: coskan@xxxxxxxxx <mailto:coskan@xxxxxxxxx>
Blog: http://coskan.wordpress.com
Twitter: http://www.twitter.com/coskan
Linkedin: http://uk.linkedin.com/in/coskan