Cloudera Docs

Configuring Trino coordinator high availability

Learn how to configure Trino Coordinator High Availability (HA) to ensure seamless cluster operations in case of coordinator crashes or shutdowns.

Trino Coordinator High Availability (HA) allows running two coordinators in a cluster, with one in an active role and one in a standby role, ensuring that if the active coordinator crashes or experiences a shutdown, the standby coordinator takes over quickly without interrupting cluster operations.

Enabling coordinator high availability deploys an extra standby coordinator node, which requires additional infrastructure resources and incurs extra compute costs. High availability protects against coordinator crashes and node shutdowns, allowing new queries to be accepted without taking the entire Cloudera Data Warehouse offline.

  1. Log in to the Cloudera Data Warehouse web UI as a user with administrator privileges (DWAdmin).
  2. Navigate to the Cloudera Data Warehouse Overview page, and click the Virtual Warehouses tab.
  3. Create a new Trino Virtual Warehouse or edit an existing Trino Virtual Warehouse.

    Configure the High Availability setting based on your workflow:

    For a new Virtual Warehouse, in the Trino Specific Settings section:

    1. Click the High availability (HA) drop-down menu.
    2. Select Active-Passive.
    3. Click Create Virtual Warehouse.

    For an existing Virtual Warehouse:

    1. Click the action menu () for the Virtual Warehouse and select Details.
    2. Click the Sizing And Scaling tab.
    3. Click the High availability (HA) drop-down menu.
    4. Select Active-Passive. By default, this option is disabled.
    5. Click Apply Changes.