Cluster Deployed QGM Instances | Teradata QueryGrid - Clustering Deployed QueryGrid Manager Instances - Teradata QueryGrid

Teradata® QueryGrid™ Installation and User Guide

Teradata QueryGrid
Release Number
July 2022
English (United States)
Last Update
Product Category
Analytical Ecosystem

When more than one Teradata QueryGrid Manager instance is installed, cluster the Teradata QueryGrid Manager instances for high availability and scalability. Clustering makes sure that all Teradata QueryGrid Manager instances have the same configuration so each instance can administer and monitor Teradata QueryGrid. Create multiple QueryGrid Manager clusters to maintain separate production and test environments.

Instances are joined by one of the following join methods:
  • SSH – Provide SSH credentials to access cluster seed files.
  • Token – Provide token to access cluster seed files using QGM web service. If the standard SSH connectivity is disabled or not available, see Creating a Join Token on generating a join token.
  1. Log on to the Teradata QueryGrid Manager TMS, VM, or server to include in a cluster.
  2. From a console window, run the join-cluster script as root or the tdqgm user:
  3. Select a join method.
    Join Method
    1. SSH - Provide SSH credentials to access cluster seed files
    2. Token - Provide token to access cluster seed files using QGM web service
    Select join method [1-2]:
  4. Enter the hostname of an existing QueryGrid Manager instance to join; if using the token join method, specify the hostname of the QueryGrid Manager instance where the create-join-cluster-token script was run.
  5. Depending on the join method selected, enter one of the following:
    Option Description
    SSH Specify the logon credentials for a user granted read permission to /etc/opt/teradata/tdqgm on that instance.
    Token Enter the token generated by the create-join-cluster-token script on one of the other QueryGrid Manager instances.
  6. Enter the Data Center for this instance.
    By default, data source nodes communicate with QueryGrid Managers in the same data center.
  7. Type y at the prompt to continue with the clustering process.
    All the data on the instance that the cluster command is run from is replaced with the data from the first QueryGrid Manager instance, or the existing cluster, being joined.