Multiple chef servers sharing one postgresql db


#1

Ohai!

I’m probably missing something obvious here.

But we want to have a open-source chef server in

3 data centers sharing a single postgresql DB.

But I don’t see an obvious config parameter/s

to point the different services to the DB…

Has anyone done this kind of setup before?

Thanks

Daniel Gutierrez


#2

Hmm, you mean different DBs on a single Postgres cluster or the same actual DB? The latter won’t work unless you also sync the bookshelf data and that might be tricky across a WAN. Using something like WAL-E for async replication might be more amenable to that kind of setup.

–Noah

On Jun 24, 2014, at 4:11 PM, Daniel Gutierrez daniel_gutierrez_99@yahoo.com wrote:

Ohai!

I’m probably missing something obvious here.
But we want to have a open-source chef server in
3 data centers sharing a single postgresql DB.
But I don’t see an obvious config parameter/s
to point the different services to the DB…
Has anyone done this kind of setup before?

Thanks

Daniel Gutierrez


#3

Thanks Noah,

How about one copy of chef-server on a NAS/SAN mounted volume
but booted on 3 different servers? Have you seen this kind of config
before? Any locking issues, etc…

Thanks again,

Daniel Gutierrez

On Tuesday, June 24, 2014 4:15 PM, Noah Kantrowitz noah@coderanger.net wrote:

Hmm, you mean different DBs on a single Postgres cluster or the same actual DB? The latter won’t work unless you also sync the bookshelf data and that might be tricky across a WAN. Using something like WAL-E for async replication might be more amenable to that kind of setup.

–Noah

On Jun 24, 2014, at 4:11 PM, Daniel Gutierrez daniel_gutierrez_99@yahoo.com wrote:

Ohai!

I’m probably missing something obvious here.
But we want to have a open-source chef server in
3 data centers sharing a single postgresql DB.
But I don’t see an obvious config parameter/s
to point the different services to the DB…
Has anyone done this kind of setup before?

Thanks

Daniel Gutierrez


#4

We ran into the same issue, and ended up using community PostgreSQL
cookbook instead of one that comes with chef-server setup.

On Tue, Jun 24, 2014 at 4:11 PM, Daniel Gutierrez <
daniel_gutierrez_99@yahoo.com> wrote:

Ohai!

I’m probably missing something obvious here.
But we want to have a open-source chef server in
3 data centers sharing a single postgresql DB.
But I don’t see an obvious config parameter/s
to point the different services to the DB…
Has anyone done this kind of setup before?

Thanks

Daniel Gutierrez


Best regards, Dmitriy V.