Menu

Communication Protocols

Communication Protocols

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/

 

Related Posts

MySQL COALESCE() Function

MySQL COALESCE() Function The COALESCE() function in MySQL returns the first non-null value from a list of expressions. If all arguments are NULL, it returns NULL. Syntax COALESCE(expr1, expr2, …, exprN) expr1, expr2, …, exprN: These are the expressions to evaluate. The function returns the first non-null expression from this list. It requires at least […]

MySQL Configurator Tool

MySQL Configurator Tool

MySQL Configurator Tool MySQL Configurator tool allows you to configure and optimize MySQL installations for better performance, security, and functionality. It simplifies the setup process, especially for those who are new to MySQL or need to tailor configurations to specific requirements. Features of MySQL Configurator Some of the features of the tool are as follows: […]