Database Requirements
Ambari requires a relational database to store information about the cluster configuration and topology. If you install HDP Stack with Hive or Oozie, they also require a relational database. The following table outlines these database requirements:
|
Component | Databases |
Description |
|---|---|---|
|
Ambari |
- PostgreSQL 8 - PostgreSQL 9.1.13+,9.3, 9.4*** - MariaDB 10* - MySQL 5.6 - Oracle 11gr2 - Oracle 12c** |
By default, Ambari will install an instance of PostgreSQL on the Ambari Server host. Optionally, to use an existing instance of PostgreSQL, MySQL or Oracle. For further information, see Using Non-Default Databases - Ambari. |
|
Hive |
- PostgreSQL 8 - PostgreSQL 9.1.13+, 9.3, 9.4*** - MariaDB 10* - MySQL 5.6 - Oracle 11gr2 - Oracle 12c** |
By default (on RHEL/CentOS/Oracle Linux 6), Ambari will install an instance of MySQL on the Hive Metastore host. Otherwise, you need to use an existing instance of PostgreSQL, MySQL or Oracle. See Using Non-Default Databases - Hive for more information. |
|
Oozie |
- PostgreSQL 8 - PostgreSQL 9.1.13+, 9.3, 9.4*** - MariaDB 10* - MySQL 5.6 - Oracle 11gr2 - Oracle 12c** |
By default, Ambari will install an instance of Derby on the Oozie Server host. Optionally, to use an existing instance of PostgreSQL, MySQL or Oracle, see Using Non-Default Databases - Oozie for more information. The default instance of Derby should not be used for a production environment. If you plan to use Derby for a demo, development or test environment, migration of the Oozie database from Derby to a new database is only available in the community. |
| Ranger |
- PostgreSQL 9.1.13+, 9.3, 9.4*** - MariaDB 10* - MySQL 5.6 - Oracle 11gr2 - Oracle 12c** |
You must have an existing instance of PostgreSQL , MySQL or Oracle available for Ranger. Refer to Installing Ranger for more information. |
* Use of an existing MariaDB 10 database is only supported with HDP 2.5 when running on RHEL/CentOS/Oracle Linux 7 or SLES 12.
** Use of an existing Oracle 12c database is only supported with HDP 2.3 or later.
*** Use of an existing PostgreSQL 9.4 is only supported with HDP 2.5.
![[Important]](../common/images/admon/important.png) | Important |
|---|---|
For the Ambari database, if you use an existing Oracle database, make sure the Oracle listener runs on a port other than 8080 to avoid conflict with the default Ambari port. Alternatively, refer to Hortonworks Data Platform Apache Ambari Reference for information on Changing the Default Ambari Server Port. |
| Important |
|---|---|
Using the Microsoft SQL Server or SQL Anywhere database options are not supported. |