Home  >  Blog  >   Tableau

How to deploy tableau server in high availability environments?

Rating: 5
  
 
6310
  1. Share:
Tableau Articles

As tableau server usage increases, the requirement to ensure its continuous availability also rises. Strategies to assure constant availability is predominantly referred to as high availability. These strategies necessitate that the core component of the tableau server must be redundant to reduce the chance of unplanned downtime. Realizing this goal requires deployment in a distributed environment and running unnecessary critical processes on separate servers.

If you’re configuring a Tableau Server system for high availability, the steps you perform are all designed to build in redundancy, thus reducing your potential downtime. The four areas that require redundancy are the data engine, repository, and gateway processes, and the primary Tableau Server, which runs the server licensing component. Because there must always be one active in the repository process, configuring the cluster is a multi-phased procedure that requires the primary Tableau Server to be stopped and restarted at certain points so that settings can take effect.

Achieving significant redundancy can be perceived by using a three-server cluster, but to achieve a fully redundant configuration, at least four servers are necessary.

These core tutorials will help you to learn the fundamentals of Tableau. For practical experience explore "Tableau online training."

Tableau High Availability

The three-node cluster

In this configuration, one node hosts the gateway, which paths requests to the other two worker servers. Both worker servers run all of the server processes. Though all of the tableau server’s processes should be redundant, the three definite processes that must be made redundant are the gateway, the data engine processes, and the repository process. Prior to tableau server version 8, both workers have instances of the repository and data engine processes, but only one of the two workers was actively accepting requests.

Now, both data engine processes actively accept requests, even though only one is considered as primary. In prior releases, the second worker has standby copies of the processes and is automatically promoted to achieve status if the main worker fails. This promotion is called fail-over.

Checkout Tableau Server Tutorials

A three-node system helps you reduce the primary’s vulnerability:

Three-node system

This configuration would look like the following Process Status table on the Server Status page.



[Related Page - Server deployment on multiple physical machines in tableau ]

Process Status table

In a three-node cluster, the Data Engine and Repository processes have been moved from the primary to a worker, and the primary is only running the Gateway and Search & Browse processes. In this configuration, if your active worker fails, the passive worker automatically becomes active.

There are still two things you can do to improve these three-node clusters:

1) Add a load balancer to interface with the three active gateways.

2) Create a backup to address the single point of failure: the primary.

The loss of a worker machine can occur without even making the cluster inaccessible. However, since there is only a single gateway machine, if that server goes offline, the cluster will be inaccessible to the users. To have complete fault tolerance, a four-node cluster is required.

MindMajix Youtube Channel

[Related Page - Ad Hoc Analysis & Self-Service Parameters In Tableau]

The four node cluster

In a four-node cluster, a second gateway machine is added to make that critical node redundant. However, this standby gateway server must be promoted to active status manually. There is currently no automatic fail-over for gateway machines.

Checkout Tableau Interview Questions


The high availability setup process is similar to the basic cluster configuration detailed in the when and how to deploy a server on multiple physical machines section of this post.
The steps to set up a high availability configuration are:

  1. Install the tableau server on the primary machine (note the IP address of this machine).
  2. Stop the tableau server service on the primary machine.
  3. Run the tableau server worker installer on the other machines including the cluster (the primary server IP is needed for this step).
  4. Open the configuration utility.
  5. Select the servers tab and click the add button.
  6. In the add tableau server dialog box, type the IP address of the first worker.
  7. Specify the number of each type of process.
  8. Ensure that both the extracted storage and repository storage are included in this host’s settings. Click OK.
  9. Start the tableau server service on the primary machine.
  10. View the server status and observe that the instances of the extract engine and repository on the new worker appear to be down. This will be resolved once the primary server has transmitted all the data for these processes to the new worker machine.
  11. After the worker extracts the engine and repository, processes switch from service down to service stand by, stop the tableau server service on the primary machine again.
  12. Open the configuration utility on the primary server.
  13. Clear the extract stored in the configuration utility on this host and also the repository storage checkboxes for the primary server. Remove all other processes to configure this machine as a gateway only. Click OK.
  14. Click the add button on the servers tab.
  15. In the add tableau server dialog box, type the IP address of the second worker and specify the number of each type of process. Be sure to check both the extracted storage and repository storage in this host’s settings. Click OK.
  16. As an optional step, you can configure e-mail alerts about the cluster status from the e-mail alerts tab in the configuration utility.
  17. Close the configuration utility and restart the tableau server service.
  18. Once the service comes back up, check the status of the cluster of the tableau server maintenance page. You should see the IP address of the primary server listed with only the gateway service. You should also see the two worker server IP addresses listed with the remaining tableau server processes. One worker will have an active data engine and repository and the other worker will have standby copies of these processes.

The three-node configuration presented earlier may be augmented with a redundant gateway server to increase reliability. For information about making the gateway redundant and the manual fail-over process see the “Configuring a highly available gateway” section of the tableau server administrator’s guide.

List Of Tableau Courses:

 Tableau Advanced
 Tableau Server
 Data Visualization and Dashboarding Fundamentals

 

Join our newsletter
inbox

Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!

Course Schedule
NameDates
Tableau TrainingMar 23 to Apr 07View Details
Tableau TrainingMar 26 to Apr 10View Details
Tableau TrainingMar 30 to Apr 14View Details
Tableau TrainingApr 02 to Apr 17View Details
Last updated: 04 Apr 2023
About Author

As a Senior Writer for Mindmajix, Saikumar has a great understanding of today’s data-driven environment, which includes key aspects such as Business Intelligence and data management. He manages the task of creating great content in the areas of Programming, Microsoft Power BI, Tableau, Oracle BI, Cognos, and Alteryx. Connect with him on LinkedIn and Twitter.

read more
Recommended Courses

1 / 15