Example: Install and Configure a Three-Node HA Cluster

A multi-node high availability installation of Tableau Server can help to maximise the efficiency and availability of Tableau Server. When configuring a multi-node Tableau Server deployment, the steps you perform are designed to build in redundancy, helping to reduce your potential downtime. In addition to simply improving efficiency by moving or adding server processes to additional nodes, you can create a highly available (HA) installation of Tableau Server by satisfying these requirements:

Add additional nodes for a total of at least three nodes
Deploy a Coordination Service ensemble on at least three nodes
Add an instance of Client File Service (CFS) on at least one additional node (we recommend adding an instance on each node running the Coordination Service)
Add a second instance of the File Store on one of the additional nodes (Data Engine will be installed automatically, if it is not already on the node)
Add a second instance of the Repository (pgsql) on one of the additional nodes

A Tableau Server installation that includes these additions will have built-in redundancy and can support failover in the event of a problem with the repository. This example shows how to do this, and more.

A Single Server System

After installing Tableau Server on an initial node, you have a system that is running everything it needs to function. It has at least one instance of all server processes and is the most basic configuration of Tableau Server. It has no redundancy. The server topology looks like this (some TSM-specific processes are not shown):

A Three-Node System

To build in redundancy, you need to add additional nodes to host instances of the repository and the data engine and file store processes. You can add instances of other processes, including multiple instances of a process on a node. In addition, to reduce the system’s vulnerability, you can run multiple gateways and additional instances of some of the server processes. The fewest number of computers required to achieve this configuration is three.

In the diagram below, the file store process has been added to both additional nodes. A second, passive instance of the repository has also been added to one of the other new nodes. Finally, the server processes (shown in blue) have been added to the additional nodes to provide redundancy.

Configuration steps

This procedure describes how to configure a three-node HA Tableau Server cluster with two repository instances and two file store/data engine instances on the additional nodes as pictured above.

Before you begin

Before you install Tableau Server on any additional nodes, ensure that each additional node meets the distributed requirements. See Distributed Requirements for details.

Note: This operation includes steps that you may need to perform using the TSM command line. To use the TSM CLI, you need administrator access to the command line on one of the nodes in your installation and TSM administrator credentials to run TSM commands.

Step 1: Install the initial node

See Install and Configure Tableau Server.

Step 2: Generate a bootstrap file for the additional nodes

Open TSM in a browser:
https://<tsm-computer-name>:8850
For more information, see Sign in to Tableau Services Manager Web UI.
Click the Configuration tab, and in the Add a Node box, click Download Bootstrap File.
The bootstrap file is created and copied to your local computer.
Embedded credentials are included in the bootstrap file by default. If you don't want credentials embedded in the bootstrap file, clear the Include temporary credentials in file option. If you want to completely disable the ability to include embedded credentials in node bootstrap files, you can set a configuration option for the server. See features.PasswordlessBootstrapInit for more details.

Step 3: Install and initialise node 2

Step 4: Install and initialise node 3

Repeat Step 3 above.

Step 5: Configure the new node with a minimum topology

To complete the process of adding new nodes to your cluster, you need to configure them with a minimum topology. With a minimum topology, the only pending change will be the addition of Cluster Controller, which is required on each node. If you want other processes on the nodes you can add most of them at the same time. This example only configures the nodes with Cluster Controller.

Open TSM in a browser:
https://<tsm-computer-name>:8850
For more information, see Sign in to Tableau Services Manager Web UI.
Click the Configuration tab. A message should tell you that new nodes were added.
Click Continue to dismiss the message.
Click Pending Changes at the top of the page:
If you are configuring a cluster with three or more nodes, a Coordination Service ensemble warning displays. You can continue. You will deploy a Coordination Service ensemble in a separate step.
Click Apply Changes and Restart and Confirm to confirm a restart of Tableau Server.
When Tableau Server restarts, the nodes are included with the minimum topology necessary.

Step 6: Deploy a Coordination Service ensemble

If you install a total of three or more nodes, you should also deploy a Coordination Service ensemble. If you do not, you will get a warning message every time you make changes to the server configuration or topology. You can ignore this message, but as a best practice you should deploy a multi-node Coordination Service ensemble.

When you install Tableau Server, a single instance of the Coordination Service is installed on the initial node. TSM and Tableau Server depend on the Coordination Service to function properly, so to provide redundancy and ensure availability on multi-node installations, configure additional instances of the Coordination Service by deploying a Coordination Service ensemble. Coordination Service ensembles are installed with one, three or five instances of the Coordination Service. In a three-node installation of Tableau Server, the recommended number of Coordination Service instances is three, one on each node.

Do not attempt to deploy a Coordination Service ensemble if there are other changes pending. Discard or apply any pending changes before deploying a new Coordination Service ensemble.

The following steps illustrate how to deploy a new Coordination Service ensemble on an existing three-node Tableau Server cluster and clean up the old ensemble.

On the initial node, open a command prompt as administrator.
Stop Tableau Server:
tsm stop
If prompted, sign in as a TSM administrator.
Some TSM processes will continue to run, including the Administration Controller and Administration Agent.
Confirm there are no pending changes:
tsm pending-changes list
If there are pending changes, you need to either discard the changes or apply them. Applying pending changes will take some time:
- Discard the changes
```
tsm pending-changes discard
```
- Apply the changes:
```
tsm pending-changes apply
```
Wait until the command completes and you are returned to the system prompt.
Get the node IDs for each node in the cluster:
tsm topology list-nodes -v
Use the tsm topology deploy-coordination-service command to add a new Coordination Service ensemble by adding the Coordination Service to specified nodes. You must specify the node(s) that the Coordination Service should be added to, using the actual node ID to identify each node. The command also makes the new ensemble the "production" ensemble (the ensemble in use) and removes the old ensemble, unless the deployment fails. If this happens, see step 6 below.
Note: A "y/n" prompt displays confirming that a server restart will take place. To run the command without input, include the --ignore-prompt option.
For example, deploy the Coordination Service to all three nodes of a three-node cluster, where the nodes are node1, node2 and node3:
tsm topology deploy-coordination-service -n node1,node2,node3
Wait until the command completes and you are returned to the system prompt.
(Optional) If the deployment fails, you need to run the tsm topology cleanup-coordination-service command to remove the unsuccessfully deployed ensemble. For details on running the command, see tsm topology cleanup-coordination-service.
Start Tableau Server:
tsm start

For more information and details on deploying a new Coordination Service ensemble, see Deploy a Coordination Service Ensemble.

Step 7: Configure Client File Services (CFS) on additional nodes

Add CFS to additional nodes. We recommend you add CFS to every node running the Coordination Service.

On the initial node, open a command prompt as administrator.
Find the node ID for the node you are adding CFS to:
tsm topology list-nodes -v
Add CFS on the node by specifying the node, the process, and a single instance.
For example, this command adds an instance of CFS to node2:
tsm topology set-process -n node2 -pr clientfileservice -c 1
If you attempt to add an instance of CFS to a node that already is configured with CFS, an error message will let you know there is already an instance on the node.
To add CFS to additional nodes, repeat this step for each node.
Apply the changes:
tsm pending-changes apply

Step 8: Configure processes for node 2

Open TSM in a browser:
https://<tsm-computer-name>:8850
For more information, see Sign in to Tableau Services Manager Web UI.
Click the Configuration tab.
Specify the processes and number of instances that should run on the first additional node.
In this example:
1. Select Gateway.
2. Set the Application Server (vizportal) count to 2.
3. Set the VizQL Server count to 2.
4. Set the Cache Server count to 2.
5. Set the Backgrounder count to 2.
  Adding Backgrounder to a node will also add an instance of Data Engine if one is not already on the node.
6. Set the Data Server count to 2.
7. Select File Store.
8. Select Repository (pgsql).
9. Select Metrics Service. (The legacy Metrics feature was retired in February 2024 for Tableau Cloud and in Tableau Server version 2024.2. For more information, see Create and Troubleshoot Metrics (Retired).)
10. Select Messaging Service.
11. Select Data Source Properties.
12. Select Content Exploration Service.
13. Select Collections Service.
14. Select Search and Index Server.
The specific processes and process counts you set will depend on your organisational environment and needs. Some processes are added automatically when you add another process. For more information, see Configure Nodes and Tableau Server Processes.
Note: The TSM Web UI limits you to a maximum of 8 instances of processes that allow you to select the number of instances. To configure more instances than this, use the command line and the TSM topology set-process command. For more information, see tsm topology set-process.

Step 9: Configure processes for node 3

In TSM, on the Configuration tab, specify the processes and number of instances that should run on the second additional node.
In this example:
1. Select Gateway.
2. Set the Application Server (vizportal) count to 2.
3. Set the VizQL Server count to 2.
4. Set the Cache Server count to 2.
5. Set the Backgrounder count to 2.
  Adding Backgrounder to a node will also add an instance of Data Engine if one is not already on the node.
6. Set the Data Server count to 2.
7. Select File Store.
8. Select Metrics Service. (The legacy Metrics feature was retired in February 2024 for Tableau Cloud and in Tableau Server version 2024.2. For more information, see Create and Troubleshoot Metrics (Retired).)
9. Select Data Source Properties.
10. Select Content Exploration Service.
11. Select Collections Service.
12. Select Search and Index Server.
Click Pending Changes at the top of the page:
The Pending Changes list displays.
Click Apply Changes and Restart and Confirm to confirm a restart of Tableau Server.

Note: This method of installation from the command line requires you to set Windows environment variables on each additional node for the username and password of an administrator on the initial node. For an alternate method of automating Tableau Server installation without including unencrypted credentials, see Automated Installation of Tableau Server.