Communication Protocols

Overview

The following describes the different communication protocols that are used to interact with the MySQL server are as follows::

TCP/IP
Unix Socket
Shared Memory
NT Pipes

TCP/IP

Transmission Control Protocol/Internet Protocol, the suite of communications protocols used to connect hosts on the Internet. TCP/IP is built into the UNIX operating system and is used by the Internet, making it the de facto standard for transmitting data over networks. Even network operating systems that have their own protocols, such as Netware, also support TCP/IP.

Unix Socket

In the world of computers, a socket is an endpoint(on either end) of a connection used to form one end of a bi-directional communication link between two applications. (Requires a physical file on the local system.)

Shared Memory

An efficient means of passing data between programs. One program will create a memory region which other processes (if permitted) can access.

NT Pipes

The design of named pipes is biased towards client-server communication, and they work much like sockets: other than the usual read and write operations, Windows named pipes also support an explicit “passive” mode for server applications.

—