[chef] RE: Re: Chef11 HA

[Baruch Shpirer < >]

Is there any draft to the HA procedure/setup?

Also, if I configure postgresql for master-master replication
and use drbd for the bookshelf folder
does it mean i got 2 identical servers in async mode?
Will clients be using same validation public key in both sites?

Baruch

-----Original Message-----
From: Seth Falcon 
[mailto:
 
 
Sent: Monday, February 11/02/2013 17:35
To: 
<
 >
Subject: [chef] Re: Chef11 HA


On Feb 11, 2013, at 1:29 PM, Vaidas Jablonskis wrote:

> This might be slightly unrelated to this conversion, but what I wonder what 
> is stored in postgres database?

All of the Chef object data is stored in the db. You can explore the schema a 
bit like this:


 :~#
 su - opscode-pgsql
$ bash    

 :~$
 which psql /opt/chef-server/embedded/bin/psql

 :~$
 psql opscode_chef psql (9.2.1) Type "help" for help.

opscode_chef=# \d
                         List of relations
 Schema |             Name              |   Type   |     Owner     
--------+-------------------------------+----------+---------------
 public | checksums                     | table    | opscode-pgsql
 public | clients                       | table    | opscode-pgsql
 public | cookbook_version_checksums    | table    | opscode-pgsql
 public | cookbook_version_dependencies | view     | opscode-pgsql
 public | cookbook_versions             | table    | opscode-pgsql
 public | cookbook_versions_by_rank     | view     | opscode-pgsql
 public | cookbooks                     | table    | opscode-pgsql
 public | cookbooks_id_seq              | sequence | opscode-pgsql
 public | data_bag_items                | table    | opscode-pgsql
 public | data_bags                     | table    | opscode-pgsql
 public | environments                  | table    | opscode-pgsql
 public | joined_cookbook_version       | view     | opscode-pgsql
 public | nodes                         | table    | opscode-pgsql
 public | osc_users                     | table    | opscode-pgsql
 public | roles                         | table    | opscode-pgsql
 public | sandboxed_checksums           | table    | opscode-pgsql
 public | schema_info                   | table    | opscode-pgsql
(17 rows)

And find the script used to initialize the schema here:
https://github.com/opscode/chef_db/blob/master/priv/pgsql_schema.sql

> What happens when this database gets corrupted or data is lost, for 
> instance?

Bad things happen. If the db data is lost or corrupted, so is your Chef 
Server.

+ seth