Tableau Linux External File Store Configuration

1. Mount EFS Mount point on all the nodes and provide the user id for tableau run the ownership on the mount. 

2. stop the services using tsm stop 

3. stop Administrative services on all nodes using below command.              /opt/tableau/tableau_server/packages/scripts.2021x.xx.xxxx.x/stop-administrative-services 

4.Contact your infra team to change all tableau user id to same on all servers and change the ownership of files where the old UID and GID is the owner of them. IG GID is 991

     Update UID and GID manually in /etc/passwd and /etc/group file

    find / -group 991 -exec chgrp -h tableau {} \; 

     find / -user 991 -exec chown -h tableau {} \; 

     cd /etc/systemd/system/ 

     cp -p user@.service user@new_gid.service 

     chmod +x user@new_gid.service 

     systemctl enable user@new_gid.service 

5. make sure UID and GID of tableau is updated to new GID 

6. Reboot all nodes. 

7. Start Administrative services. 

        /opt/tableau/tableau_server/packages/scripts.2021x.xxx.xxx/start-administrative-services 

8. This will take long time to start the licensing services.(30 -40 mins) 

9. Run tsm start to start all the services. 

10. Validate once services have been started. check all the extracts running.

11. Stop the services using tsm stop

12. Run the below command to move to EFS 

        tsm topology external-services storage enable –-network-share /mnt/<network share name>/tableau

13. Run tsm start to start all the services. 

14. Validate once services have been started. check all the extracts running.

There will be folders created under the share. 

Extracts and workbook revisions:

tableau_data tabsvc/dataengine/extracts

tableau_data/tabsvc/dataengine/revisions

PostgreSQL data backups:

tableau_data/tabsvc/pg_backups