Configuring a database

Learn how to configure the properties of an operational database in your Cloudera on cloud environment.

After you create an operational database with the specified worker and edge nodes, if you want to change the node counts, you can do so for the existing database, without needing to create a new one.

Configuring worker nodes

Know how to configure an operational database's autoscaling and worker node properties in your Cloudera on cloud environment.

Required role: You must be logged into the Cloudera Operational Database as an ODAdmin.

  1. In the Cloudera Operational Database web interface, select the Databases tab.
  2. Find the database you want to configure.
  3. In the row of the selected database, click (Actions) and choose Configure Database.
  4. In the Configure Database drawer, click View All Nodes.
  5. In the Nodes tab, click Worker > Configure Worker Nodes
  6. Modify the settings for Autoscaling and Worker Nodes.
    Consider these points while setting the worker nodes.
    • Ensure that the number of maximum worker nodes is greater than or equal to the minimum number of worker nodes; otherwise, autoscaling is disabled.

      If autoscaling is enabled, the operational database automatically adjusts the maximum and minimum number of worker nodes; however, you can set these node counts to remain in the cluster.

    • Non-micro clusters must have at least three worker nodes; while micro clusters can have one minimum worker node.
    • The supported value range for different clusters is as follows:

      Micro: 1 minimum, 5 maximum

      Light: 3 minimum, 100 maximum

      Heavy: 3 minimum, 800 maximum

  7. Click Confirm.
The new settings are reflected in the existing database immediately after the modification.

Configuring edge nodes

Know how to configure the edge nodes of an existing operational database in your Cloudera on cloud environment.

Required role: You must be logged into the Cloudera Operational Database as an ODAdmin.

  1. In the Cloudera Operational Database web interface, select the Databases tab.
  2. Find the database you want to configure.
  3. In the row of the selected database, click (Actions) and choose Configure Database.
  4. In the Configure Database drawer, click View All Nodes.
  5. In the Nodes tab, click Edge > Add Edge Nodes to add a specific number of edge nodes.
    You can add a maximum of 20 edge nodes to the cluster.

    Once the edge node is created, click (Actions) to perform one of the following:

    • View Details: to check the details of the edge node.
    • Delete Node: to delete the specific edge node.
The new settings are reflected in the existing database immediately after the modification.