For PE 3, what are the stable/supported database backends?

36 views
Skip to first unread message

leam hall

unread,
Jun 25, 2015, 3:27:53 PM6/25/15
to puppet...@googlegroups.com
We're looking to move from yaml and json to a database. What good options are along the lines of MySQL, Postgres, or MongoDB?

Thanks!

Leam

Craig Dunn

unread,
Jun 26, 2015, 5:11:24 AM6/26/15
to puppet...@googlegroups.com
On Thu, Jun 25, 2015 at 9:27 PM, leam hall <leam...@gmail.com> wrote:
> We're looking to move from yaml and json to a database. What good options
> are along the lines of MySQL, Postgres, or MongoDB?

Are you talking about Hiera? If so, you can checkout hiera-mysql[1].
Or use something like CouchDB that's fronted with an HTTP API and use
hiera-http[2] to talk to it.

[1]: http://github.com/crayfishx/hiera-mysql
[2]: http://github.com/crayfishx/hiera-http

Regards
Craig

--
Enviatics | Automation and configuration management
http://www.enviatics.com | @Enviatics
Puppet Training http://www.enviatics.com/training/

Lindsey Smith

unread,
Jun 26, 2015, 12:21:43 PM6/26/15
to puppet...@googlegroups.com
On Thu, Jun 25, 2015 at 12:27 PM, leam hall <leam...@gmail.com> wrote:
We're looking to move from yaml and json to a database. What good options are along the lines of MySQL, Postgres, or MongoDB?

Would you expand on why you're interested in moving to a database-based implementation? Are you using both YAML and JSON today?

thanks,
Lindsey

 

Thanks!

Leam

--
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...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/5a0903b4-2126-49ae-8ca5-d93811a6b7d9%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

leam hall

unread,
Jun 26, 2015, 12:25:24 PM6/26/15
to puppet...@googlegroups.com
On Fri, Jun 26, 2015 at 12:20 PM, Lindsey Smith <l.s...@puppetlabs.com> wrote:

On Thu, Jun 25, 2015 at 12:27 PM, leam hall <leam...@gmail.com> wrote:
We're looking to move from yaml and json to a database. What good options are along the lines of MySQL, Postgres, or MongoDB?

Would you expand on why you're interested in moving to a database-based implementation? Are you using both YAML and JSON today?


Lindsey, sure!  We have a few other projects that could use a database back end. Further, our hiera is starting to get a little complex for us and the solution seems to be moving to a MySQL database. What I'm hoping in the long run is to let multiple tools query the same tables.

This could be done in JSON or YAML, but then we run in to update clashes and such. 

Make sense?

Leam

 
--
Reply all
Reply to author
Forward
0 new messages