Merge QueryGrid Manager Clusters | Teradata QueryGrid - Merging QueryGrid Manager Clusters - Teradata QueryGrid

Teradata® QueryGrid™ Installation and User Guide

Teradata QueryGrid
Release Number
July 2022
English (United States)
Last Update
Product Category
Analytical Ecosystem
PrerequisiteMigrating nodes require Cluster B to be online and both tdqg-manager and tdqg-node on Cluster B to be running QueryGrid version and later. Also, the nodes must be able to access at least one the QueryGrid Managers in Cluster A. If these conditions are not met, the nodes cannot be migrated and an option to cancel the migration becomes available. The nodes can be re-added using the method used to initially add the node to the system.
Use the following procedure, with the terms Cluster A and Cluster B as examples, to merge two clusters.
If merging a site with a full Vantage stack and analytical nodes, open an incident with the QueryGrid GSO team for consultation before merging.
  1. Create a Backup of one of the QueryGrid Managers in Cluster B to merge.
  2. Copy the newly created backup from the Cluster B QueryGrid Manager to one of the Cluster A QueryGrid Managers.
  3. Run the migrate command as the root or tdqgm user on the Cluster A QueryGrid Manager where you copied the Cluster B backup file and answer the prompts.
    /opt/teradata/tdqgm/bin/ backup-file

    Where backup_file is the path name of the backup ZIP file.

  4. Review the summary of actions to be performed before selecting Y or N to continue.
    Selecting N aborts the migration.
  5. In the QueryGrid portlet, validate that Cluster A contains the configuration from both Cluster A and Cluster B.
    When the migration is successful, nodes previously registered to Cluster B now display as owned by Cluster A and offline on Cluster B.
  6. If the migration fails, view details of the migration in the /var/opt/teradata/tdqgm/logs/tdqgm-command.log file.
  7. Run the /opt/teradata/tdqgm/bin/ command on one of the QueryGrid Managers from Cluster A and record the following information from the output:
    Command Description
    join host The public address of the QueryGrid Manager used by nodes to connect to the QueryGrid Manager.
    join token The temporary authentication token enabling other QueryGrid Managers to join the cluster.
    cluster ID The UUID identifying the cluster.
  8. Join the QueryGrid Managers from Cluster B to Cluster A, one at a time, using the /opt/teradata/tdqgm/bin/ command on each QueryGrid Manager from Cluster B.
  9. If the same instance of Viewpoint is used to monitor both clusters, delete Cluster B from the Monitored Systems portlet; otherwise, re-add the certificate on the Cluster B Viewpoint instance so the QueryGrid portlet continues to work for the new cluster.