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. MySQL and PostgreSQL are supported.

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

Database Server Requirements

You can install a database server on the same host as Cloudera Director and DNS, or you can add one to a different host in the same virtual network as Cloudera Director and the cluster. Consider the following when installing a 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 , follow the instructions in MySQL Database. Use the instructions for your specific version of MySQL, and keep in mind these addtional 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.