PuppetDB replication

[John Guthrie]

I wasn't able to find much on this by searching, so I thought I would ask here, has anyone had any kind of experience with any kind of replication of PuppetDB. In particular, experience with the PE version of PuppetDB would be great to hear about. I have set up PE puppet with the components master, DB, and console on separate machines. I was thinking that getting some kind of replication for the DB might be a good idea.

Any comments?

Thanks.

John Guthrie
jgut...@book.com
This electronic mail message contains information that (a) is or
may be CONFIDENTIAL, PROPRIETARY IN NATURE, OR OTHERWISE
PROTECTED
BY LAW FROM DISCLOSURE, and (b) is intended only for the use of
the addressee(s) named herein. If you are not an intended
recipient, please contact the sender immediately and take the
steps necessary to delete the message completely from your
computer system.

Not Intended as a Substitute for a Writing: Notwithstanding the
Uniform Electronic Transaction Act or any other law of similar
effect, absent an express statement to the contrary, this e-mail
message, its contents, and any attachments hereto are not
intended
to represent an offer or acceptance to enter into a contract and
are not otherwise intended to bind this sender,
barnesandnoble.com
llc, barnesandnoble.com inc. or any other person or entity.

[Ken Barber]

John,

I would generally recommend Hot Standby with Streaming Replication for
PostgreSQL replication. The documentation for such is here:
http://www.postgresql.org/docs/9.3/static/high-availability.html Some
people have also had success using Sloney, although I feel this is
somewhat trickier to setup.

The general difference between the two is that Streaming Replication
is achieved by WAL log shipping, whereas Sloney uses statement
replication.

PuppetDB allows you to provide a secondary read database for queries
as well: http://docs.puppetlabs.com/puppetdb/1.6/configure.html#read-database-settings
this can be pointed at your hot standby node to spread the load a
little.

The pe_postgresql module that ships with PE does not have the
capability to setup such clustering for you yet, but most of the
facilities are there for modifying configuration, permissions and such
that it is possible to do it. The hard part is really how to manage
the initialization steps before the replication can start.

ken.

> --
> 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/12D01FC3B93AC74DB3A731E93798FCB488A39616%40BNJEXCHMB01.bnweb.user.bn.
> For more options, visit https://groups.google.com/groups/opt_out.