Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Identify server used for storage of metadata

Identify server used for storage of metadata

Contributor

Hello All,

 

I see sqllite3 as database type for hue.

 

For cloudera management service monitors,activity monitor,host monitor, I see mysql as database.

Also, all the three nodes have mysql instances running on them and I see databases in each of the instances. 

 

PFB the logs.

 

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| amon |
| clouderacm |
| metastore |
| mysql |
| nav |
| navms |
| performance_schema |
| rman |
| sentry |
| test |
+--------------------+

 

mysql> show databases;
+----------------------------+
| Database |
+----------------------------+
| information_schema |
| Adeo_RetailPlatform |
| CVS_RetailPlatform |
| RETAILERHA_RetailPlatform |
| Users_RetailPlatform |
| Walmart_RetailPlatform |
| amon |
| clouderacm |
| datalakeDev |
| hive |
| infopltfrm_transDB |
| infopltfrm_transDBv02 |
| infopltfrm_transDBv02_prod |
| ip_dms |
| ip_odsdb_qa |
| ip_transDB_ISDev |
| ip_transDB_ISDev1 |
| ip_transDBv02 |
| ip_transDBv05 |
| metastore |
| mysql |
| nav |
| navms |
| oozieserver |
| performance_schema |
| rman |
| sentry |
| test |
| testsalesfinal |
+----------------------------+
29 rows in set (0.00 sec)

 

mysql> show databases;
+-----------------------+
| Database |
+-----------------------+
| information_schema |
| RetailQA |
| amon |
| clouderacm |
| datalakeQA |
| hive |
| infopltfrm_transDBv02 |
| ip_odsdb_qa |
| ip_transDB_ISQA |
| ip_transDBv02 |
| ip_transDBv05 |
| metastore |
| mysql |
| nav |
| navms |
| oozieserver |
| performance_schema |
| rman |
| sentry |
| test |
+-----------------------+
20 rows in set (0.06 sec)

 

As per the document, MySQL has been defaulted for install 

 

Can you please help me to identify server that is used for storing metadata for cloudera,hive etc?