How to find the database used by Ambari, Hive Metastore, Oozie, etc

[#1]

I'm looking for help in determining which database (PostgreSQL, Oracle, MySQL, etc) is being used by Ambari, Hive Metastore, and Oozie on an existing cluster.

Can someone please point me in the right direction?

[#2 · Accepted solution]

@Zack Riesland

For Ambari, go to the ambari-server properties file in the Ambari server host and this would provide the information about the backend db.

For Hive and Oozie, Go to Ambari -> Hive -> Config and this will provide the info. Like wise for Oozie as well.

[#3]

Thanks, @mbalakrishnan

To further clarify, I found my Ambari properties file at /etc/ambari-server/conf/ambari.properties

[#4]

Equivalent lookup for ambari.properties file.

http://<ambari_server>:8080/api/v1/services/AMBARI/components/AMBARI_SERVER?fields=RootServiceCompon...

[#5]

@Zack Riesland

you can use Ambari's RESTFul APIs to know this on a deployed cluster.

For determining ambari server DB use following API:

http://c6401.ambari.apache.org:8080/api/v1/services/AMBARI/components/AMBARI_SERVER?fields=RootServi...

For determining Hive Metastore DB use following API and lookup for hive_database property

http://c6401.ambari.apache.org:8080/api/v1/clusters/c1/configurations/service_config_versions?servic...

For determining Hive Metastore DB use following API and lookup for oozie_database property

http://c6401.ambari.apache.org:8080/api/v1/clusters/c1/configurations/service_config_versions?servic...

[#6]

For oozie, I changed the URL to point to my server, but it gives me back an empty array:

{
  "href" : "<my server>:8080/api/v1/clusters/c1/configurations/service_config_versions?service_name=OOZIE&is_current=true",
  "items" : [ ]
}

Any ideas?

We don't use Oozie for anything, as far as I know