Cloudera Docs

Enabling High Availability for SSB

High Availability for SQL Stream Builder (SSB) SSB can be enabled using a Load Balancer. To enable the Load Balancer for SSB after the SSB service is installed, you need to add the Load Balancer instance to the SSB cluster.

  1. Go to your cluster in Cloudera Manager.
  2. Select SQL Stream Builder from the list of services.
  3. Click Actions > Add Role Instances.
    The Add Role Instances wizard is displayed.
  4. On the Assign Roles page, click Select hosts for Load Balancer.
  5. Select a host and click OK.
    You can add additional SQL Stream Engine and Materialized View Engine servers to boost performance:
    1. Select hosts for SQL Stream Engine.
    2. Select hosts for Materialized View Engine.
    3. Click OK > Continue.
  6. Click Continue.
    The newly added hosts are displayed on the Instances tab.
  7. Select all the newly added hosts.
  8. Click Actions for Selected > Start.
  9. Update the Load Balancer URL and Host.
    1. Click Configuration.
    2. Search for load-balancer url.
    3. Provide the host url where the SSB service is installed.
  10. Restart Cloudera Manager. 
    sudo service cloudera-scm-server restart
  11. Access the Streaming SQL Console with Load Balancer.
    1. Go to your cluster in Cloudera Manager.
    2. Select SQL Stream Builder from the list of services.
    3. Click Web UI > SQLStreamBuilder Load Balanced (recommended).
You have a load balanced instance of SSB. You can reach the load balanced instance of Streaming SQL Console from the SSB service page in Cloudera Manager.