2.10 - Configuring Virtual IP Addresses - Teradata QueryGrid

Teradata® QueryGrid™ Installation and User Guide

Teradata QueryGrid
September 2019
User Guide
If your system is configured with Network Address Translation (NAT), each node has one or more unique virtual IP addresses associated with it. You can use the virtual IP addresses of a node for target QueryGrid systems on a public network to communicate with that node.
To use virtual IP addresses, each NAT-configured node that runs Teradata QueryGrid node software must have a text file containing its virtual IP addresses.
You can use virtual IP addresses on data source nodes, bridge nodes, or both. However, to reduce the number of virtual IP addresses that need to be configured, Teradata recommends using virtual IP addresses only on bridge nodes.

Using a Teradata-to-Hadoop QueryGrid link configured with NAT as an example, perform the following steps to configure the Virtual IP:

  1. On each node in your NAT configured system, log on and go to the following directory: /etc/opt/teradata/tdqg/node
  2. In the directory, create a text file called virtual_ips.
  3. Using one virtual IP address per line, populate the text file with the virtual IP addresses for that node. The virtual IP addresses must be a valid IPV4 or IPV6 address. Each virtual IP entry is associated with a separate interface name which is reported to the QueryGrid Manager and are represented as vip followed by a number. These generated interface names are based on the order of the addresses listed in the file. In the following example, the IP address interface names are reported as vip0 and vip1:
    For the target system to successfully communicate with this virtual IP configured system, create a new network configuration with the virtual IP interface name and use this network configuration in the link configuration. If both the source and target systems are configured with NAT, the target system nodes also require similar configuration.
  4. Save the file.
  5. Restart the node by typing the following: service tdqg-node restart

    During QueryGrid operations, the IP address in each line of the file are read, validated, and used as virtual IP addresses. If the file does not exist in the /etc/opt/teradata/tdqg/node directory, a file not present message is logged in /var/opt/teradata/tdqg/node/version/logs/ tdqgnode-boot-version.log.

  6. After restart, verify in Viewpoint that all nodes in the system show a status of ONLINE.
  7. Select View Node Details on each node to verify the correct vip interface names are listed in the Network Interfaces section.
For examples on configuring virtual IP addresses, log on to https://access.teradata.com and search for KCS014729.