Shulou(Shulou.com)05/31 Report--

Editor to share with you MySQL there are several communication protocols, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to understand it!

Mysql four communication protocols (socket is the local connection under linux and tcp is the other)

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.

These are all the contents of the article "MySQL has several communication protocols". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.