Which type of network traffic is transported over the internal InfiniBand network in a Database
Machine?
A.
IDB protocol traffic only
B.
Both Clustered ASM and RAC database instance traffic
C.
Clustered ASM Instance traffic only
D.
RAC database instance traffic only
E.
IDB protocol traffic,Clustered ASM traffic, and RAC database instance traffic
Explanation:
The Exadata software is optimally divided between the database servers and
Exadata
cells. The database servers and Exadata Storage Server Software communicate using the iDB –
the Intelligent Database protocol. iDB is implemented in the database kernel and transparently
maps database operations to Exadata-enhanced operations. iDB implements a function shipping
architecture in addition to the traditional data block shipping provided by the database. iDB is
used to ship SQL operations down to the Exadata cells for execution and to return query result
sets to the database kernel. Instead of returning database blocks, Exadata cells return only the
rows and columns that satisfy the SQL query. Like existing I/O protocols, iDB can also directly
read and write ranges of bytes to and from disk so when offload processing is not possible
Exadata operates like a traditional storage device for the Oracle Database. But when feasible, the
intelligence in the database kernel enables, for example, table scans to be passed down to
executeon the Exadata Storage Server so only requested data is returned to the database server.
iDB is built on the industry standard Reliable Datagram Sockets (RDSv3) protocol and runs over
InfiniBand. ZDP (Zero-loss Zero-copy Datagram Protocol), a zero-copy implementation of
RDS, is used to eliminate unnecessary copying of blocks. Multiple network interfaces can be used
on the database servers and Exadata cells. This is an extremely fast low-latency protocol that
minimizes the number of data copies required to service I/O operations.
Note:
*The Database Machine uses a state of the art InfiniBand interconnect between the servers and
storage. Each database server and Exadata cell has dual port Quad Data Rate (QDR) InfiniBand
connectivity for high availability.
*The same InfiniBand network also provides a high performance cluster
interconnect for the Oracle Database Real Application Cluster (RAC) nodes.
Note:
*An InfiniBand network allows you to connect multiple Oracle Exadata Database Machines to form
a larger single system image configuration; each InfiniBand link provides 40 Gigabits of
bandwidth–many times higher than traditional storage or server networks
I think the correct answer is E. As per documentation “is used for storage networking, RAC interconnect and high-performance external connectivity.
A is the correct option. For RAC Traffic, there is a Cluster Interconnect
All traffic via infiniband switches is in iDB protocol.
The tech is inbuilt
Now its even inside the oracle kernel. I mean oracle db directly does ‘direct to wire’
So even RAC traffic is in form of iDB
E should be correct answer. iDB protocol is for compute node to cell but not for RAC traffic among compute nodes
I guess A is correct answer.
E for me
there is ethernet switch among DB servers for RAC traffic.
I vote for A
E
A is right. Compute node and cell node use iDB to communicate
B is right. RAC instance traffic (interconnect) and ASM clustered traffic use Infiniband
C is wrong. Not ONLY
D is wrong. Not ONLY
E is right. iDB, ASM and instance traffic use infiniband
So E is the correct.
A. is wrong, it is not ONLY the IDB protocol
B. is worng, it more than ASM and RAC
C. is worng, it is not ONLY ASM instance traffic
D. is wrong, it is not RAC database instance traffic ONLY
E. is right, IDB protocol as well ASM and RAC traffic
E
A: IDB protocol traffic only
Explanation:
Inside a Infiniband network what is TRANSPORTED it’s the iDB protocol. The question is what is transported not what infiniband network makes communication
http://www.oracle.com/technetwork/database/exadata/exadata-technical-whitepaper-134575.pdf