- Under Fabric Components, select Systems.
- Select
next to Systems.
- Select Add System.
- Enter a name, up to 256 characters.Do not select Bridge only system.
- [Optional] Enter a description, maximum 1,000 characters.
- From the Data center list, do one of the following:
- Select the data center corresponding to the preferred QueryGrid Manager instance used for communication.
- If the data center where this system is located is not in the list, enter
to add the data center.
- Select the system type. Options are TERADATA, PRESTO, HADOOP, and OTHER.
- Select platform type. Options are AWS, AZURE, GC, and PRIVATE.
- From the Node software list, do one of the following:
- Select the version of the node software that runs on this system.
- If the version of the node software that runs on this system is not in the list, enter
to upload the software version file.
- [Optional] Select the network to use for internal system communication in QueryGrid.Default is the byn0 network interface when present. You can modify to any working network route.
- Under Resource Allocation, to set the maximum amount of memory needed to support applicable concurrent queries, do one of the following:
Option Description Max memory per node - In the box, add the maximum amount of memory needed.Depending on the available memory on the nodes, tuning settings (such as, FSG Cache) will make sure memory is available for QueryGrid.
Estimate The maximum amount of memory QueryGrid can consume. If the maximum memory is reached, QueryGrid starts rejecting queries. Use the Estimate tool to help estimate the amount of memory needed:
- Select Estimate.
- In Max query concurrency, enter the maximum number of QueryGrid queries expected to run concurrently for all connectors on the system.
- In Max link buffer size, do the following:
- Enter the size of the buffers for the communication channels.
- Select the unit of measurement.
Valid values range from 1 to 999. The default is 1 MB.
- In Max link buffer count, enter the maximum number of buffers that any link or connector is configured to use per communication channel.
Valid values range from 1 to 999. The default value is 4.
- In Max workers per node, enter the number of threads that participate in a query on a given node.
For example, enter the number of AMPs per node on the Teradata system.
- Select Set Value.
The value that appears in the Max memory per node box is calculated from the values you entered in the tool.
- In the box, add the maximum amount of memory needed.
- [Optional] Under Proxy Support choose the following connectivity options:
Connection Description Enable Proxy Service to QueryGrid Managers for nodes that do not have direct access Enables a QueryGrid system to run a proxy service as well as use another proxy service. Use Proxy Service to QueryGrid Managers for nodes that do not have direct access Select one of the following - Connectivity through local nodes
Allows nodes without network access to QueryGrid Manager to still connect to QueryGrid Manager through other nodes in the same system that does have direct access to QueryGrid Manager.
The default network to use for proxy connections is BYNET. If the nodes do not have BYNET, then a different network can be specified.
Nodes that do not have a matching network interface are not used as a proxy.
- Connectivity through bridge system
Allows nodes without network access to QueryGrid Manager to still access QueryGrid Manager through the nodes of a bridge system that do have direct access to QueryGrid Manager.
Select the bridge system to enable connectivity. Enable Proxy Service to QueryGrid Managers for nodes that do not have direct access by enabling the Connectivity through local nodes proxy option.
- Connectivity through local nodes
- [Optional] Select Remove nodes after offline for to have offline nodes removed from the QueryGrid configuration automatically after a specified amount of time (default 48 hours).Only enable this feature on clusters that frequently scale without QueryGrid automatically detecting nodes that are removed, such as with a Hadoop or Presto platform.
- Select Save.