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
- 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
- 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.