Mysql communication protocol

Mysql four communication protocols "> Mysql four communication protocols (all the local connections under linux are socket and the others are tcp)

When connecting to mysql, using-h227.0.0.1, the connection protocol between linux and unix is socket protocol, and that under windows is memory protocol.

For example, [root@mysql] # mysql-uandy-pandy-h227.0.0.1

When connecting to mysql, use the tcp/ip protocol when using non-h227.0.0.1.

For example: [root@mysql ~] # mysql-uandy-pandy

The different communication protocols used to interact with MySQL server are described in detail below:

1.TCP/IP protocol

> Transmission Control Protocol (Transmission Control Protocol) / Internet Protocol (Internet Protocol) is a set of communication protocols used to connect hosts on the Internet. TCP/IP was originally used for the UNIX operating system to establish Internet communications. Now it has become a de facto standard for network data transmission. Even network operating systems with their own communication protocols, such as Netware, support the TCP/IP protocol.

2. Unix Socket protocol

In the computer world, an socket is a form of internal process communication that is used to form a two-way communication connection point (a physical file on the local system) between processes on the same host.

3. Share Memory protocol

An effective way to transfer data between programs. A program creates a memory area to provide access to other allowed processes. The Windows explicit "passive" connection mode only works on (Windows system) hosts.

4. NT pipeline

> this named pipe design is more inclined to client-server communication, and they are more like socket: in addition to being used for normal read and write operations, Windows named pipes also support explicit "passive" passive connection mode for server applications. Run only in a separate (Windows platform) host.