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.
—
MySQL Tutorials
MySQL Tutorials on this website:
https://www.testingdocs.com/mysql-tutorials-for-beginners/
For more information on MySQL Database: