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

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.
  • The database server 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's 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

Using MySQL as an example, follow the instructions in MySQL Database. Be sure to use the instructions for your specific version of MySQL, and keep in mind these extra 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.
  • If you wish to reference the MySQL server by internal FQDN, make sure the MySQL server internal FQDN is registered with the DNS server you configured in the previous section, Setting Up Dynamic DNS on Azure.