This section contains certification information on supported databases for the Hortonworks Data Platform (HDP).
![[Important]](../common/images/admon/important.png) | Important |
|---|---|
It is required that you optimize relational databases that are used with each component for high availability by using the best practices for the database you choose to use. |
The following table identifies supported databases for HDP.
Table 5.1. Supported HDP Databases
| Operating System | Component | Database | Database | Database | Database | Other |
|---|---|---|---|---|---|---|
| PostgreSQL 8.x | PostgreSQL 9.x | MySQL 5.x | Oracle 11gr2 | |||
| RHEL/Centos/Oracle Linux 5.x, RHEL/CentOS/Oracle Linux 6.x, SLES 11, Ubuntu 12 | Hive / HCatalog | Supported. For instructions on how to configure this database for the Hive metastore, refer to the "Installing Hive->Configuring Hive for an External Database->Using Hive with PostgreSQL" section in Installing HDP Manually. | Supported. For instructions on how to configure this database for the Hive metastore, refer to the "Installing Hive->Configuring Hive for an External Database->Using Hive with PostgreSQL" section in Installing HDP Manually. | Supported. For instructions on how to configure this database for the Hive metastore, refer to the "Installing Hive->Configuring Hive for an External Database->Using Hive with MySQL" section in Installing HDP Manually. | Supported. For instructions on how to configure this database for the Hive metastore, refer to the "Installing Hive->Configuring Hive for an External Database->Using Hive with Oracle" section in Installing HDP Manually. | |
| Oozie | Supported. For instructions on how to configure this database for the Oozie, refer to the "Installing Oozie->Configuring Oozie for an External Database->Using Oozie with PostgreSQL" section in Installing HDP Manually. | Supported. For instructions on how to configure this database for Oozie, refer to the "Installing Hive->Configuring Oozie for an External Database->Using Oozie with PostgreSQL" section in Installing HDP Manually. | Supported. For instructions on how to configure this database for Oozie, refer to the "Installing Oozie->Configuring Oozie for an External Database->Using Oozie with MySQL" section in Installing HDP Manually. | Supported. For instructions on how to configure this database for Oozie, refer to the "Installing Oozie->Configuring Oozie for an External Database->Using Oozie with Oracle" section in Installing HDP Manually. | Derby (default) | |
| Hue | Supported. For instructions on how to configure this database for Hue, refer to the "Installing Hue->Configuring Hue for an External Database->Using Hue with PostgreSQL" section in Installing HDP Manually. | Supported. For instructions on how to configure this database for the Hue, refer to the "Installing Hue->Configuring Hue for an External Database->Using Hue with PostgreSQL" section in Installing HDP Manually. | Supported. For instructions on how to configure this database for the Hue metastore, refer to the "Installing Hue->Configuring Hue for an External Database->Using Hue with MySQL" section in Installing HDP Manually. | Supported. For instructions on how to configure this database for the Hue metastore, refer to the "Installing Hue->Configuring Hue for an External Database->Using Hue with Oracle" section in Installing HDP Manually. | SQLite (default) | |
| Ranger | Default. For instructions on how to configure this database for Ranger, see "Installing Ranger" in Installing HDP Manually. | Supported. For instructions on how to configure this database for Ranger, see "Installing Ranger" in Installing HDP Manually. | Supported. For instructions on how to configure this database for Ranger, see "Installing Ranger" in Installing HDP Manually. | Supported. For instructions on how to configure this database for Ranger, see "Installing Ranger" in Installing HDP Manually. |
