Ask Your Question
2

Database scripts

asked 2014-01-27 13:13:48 -0500

melango gravatar image

Does puppet support managing database deployment. I have an oracle database and need to deploy set of scripts for every deployment and in case of failure need to run the fall back scripts. What's the best way to do this in puppet ? or should i just use exec shell, which i feel is not the good way to manage.

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
2

answered 2014-01-27 18:10:45 -0500

Ancillas gravatar image

This is not something that is native to Puppet. I also do not think that Puppet is the right tool for this.

In the past, I have used Puppet to execute Liquibase commands with an Exec resource, but the heavy lifting was done by Liquibase, and not Puppet.

edit flag offensive delete link more

Comments

Thanks Greg, i believe this case will be handled in Puppet , because it will be good to have puppet as a complete deployment solution rather than depending on multiple tools.

melango gravatar imagemelango ( 2014-01-29 00:56:20 -0500 )edit

In that case, I think the Exec resource, like you suggested, is your best bet. Encapsulate all of your logic in a script and shell out to it from Puppet ...(more)

Ancillas gravatar imageAncillas ( 2014-01-30 11:28:36 -0500 )edit

+1 to managing liquibase (or a script that runs liquibase more accurately) with an Exec. Definitely followed this path with success before.

ken gravatar imageken ( 2014-01-30 11:47:19 -0500 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools

Stats

Asked: 2014-01-27 13:13:48 -0500

Seen: 716 times

Last updated: Jan 30 '14