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.

The Load Balancer role uses an nginx binary that requires OpenSSL 1.1 or later on the host. Red Hat Enterprise Linux and CentOS 7.9 ship OpenSSL 1.0.2 by default, which is not compatible. Before you add or start the Load Balancer role, install OpenSSL 1.1 or later on that host and ensure libssl.so.1.1 is available to nginx. If OpenSSL 1.1 is missing, starting the role can fail with an error such as error while loading shared libraries: libssl.so.1.1: cannot open shared object file.

Go to your cluster in Cloudera Manager.
Select SQL Stream Builder from the list of services.
Click Actions > Add Role Instances.
The Add Role Instances wizard is displayed.
On the Assign Roles page, click Select hosts for Load Balancer.
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.
Click Continue.
The newly added hosts are displayed on the Instances tab.
Select all the newly added hosts.
Click Actions for Selected > Start.
Update the Load Balancer URL and Host.
1. Click Configuration.
2. Search for loadbalancer.url.
3. Provide the host url where the SSB service is installed.

Restart Cloudera Manager.

sudo service cloudera-scm-server restart

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.