Setting Up MySQL or PostgreSQL

A database server can be installed on the same host as Cloudera Director and DNS, or you can add your database server to a different host in the same virtual network as Cloudera Director and the cluster. The supported databases are MySQL and PostgreSQL.

A dedicated database server is required for production clusters. The following steps are optional for non-production, proof-of-concept clusters.

Database Server Requirements

You can install a database server on the same host as the Cloudera Director server, a different host in the same Virtual Network as Cloudera Director and the cluster, or configure an existing database. Whichever method you choose, these are requirements for the database server:
  • It must be JDBC accessible both locally and remotely.
  • The credentials provided to Cloudera Director must have superuser/administrator privileges.
  • Increase the connection count according to Cloudera documentation on MySQL Database or PostgreSQL Database.
  • Ensure sufficient CPU, memory, IOs, and bandwidth for the database server, especially if the database server is shared between multiple clusters.

Example for MySQL Installation

For MySQL, follow the instructions in Using MySQL for Cloudera Director Server. Use the instructions for your specific version of MySQL, and keep in mind these additional requirements:
  • Your MySQL server must be in the same virtual network as the rest of the cluster.
  • Reference your MySQL server host by private IP address or an internal fully-qualified domain name (FQDN) that resolves to a private IP address.
  • To reference the MySQL server by internal FQDN, make sure the MySQL server internal FQDN is registered with the DNS server you configured in Setting Up Dynamic DNS on Azure.