Greenplum Interconnect

1. The interconnect is the networking layer of Greenplum Database. 

2. The interconnect refers to the inter-process communication between segments and the network infrastructure on which this communication relies. 

3. The Greenplum interconnect uses a standard Gigabit Ethernet switching fabric.

4. By default, the interconnect uses User Datagram Protocol (UDP) to send messages over the network. 

5. The Greenplum software performs packet verification beyond what is provided by UDP. This means the reliability is equivalent to Transmission Control

Protocol (TCP), and the performance and scalability exceeds TCP. If the interconnect used TCP, Greenplum Database would have a scalability limit of 1000 segment

instances. 

6. With UDP as the current default protocol for the interconnect, this limit is not applicable.

7. When a user connects to a database and issues a query, processes are created on each of the segments to handle the work of that query. The interconnect refers to the inter-process communication between the segments, as well as the network infrastructure on which this communication relies.

8. To maximize throughput, interconnect activity is load-balanced over two interconnect networks. 

9. To ensure redundancy, a primary segment and its corresponding mirror segment utilize different interconnect networks. With this configuration, Greenplum

Database can continue its operations in the event of a single interconnect switch failure.

ConnectEMC Event Alerts for Interconnect

Code       Description

14.12002 Interconnect Switch Operational Status.

14.12005 Operational status of Interconnect switch flash memory.

14.12006 State of Interconnect switch flash memory.