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

This article will explain in detail what the MySQL client and server architecture is. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

Client-server (Client/Server) architecture is a kind of network architecture. Usually, the software under this network architecture is divided into client and server.

What is the server?

The server is the storage and management center of the whole application system resources, and multiple clients deal with the corresponding functions respectively to realize the complete application together. In the client / server structure, the request of the client user is transmitted to the database server, and after being processed by the database server, the result is returned to the user, thus reducing the transmission amount of network data.

When using the application, the user first starts the client, and then tells the server to connect to complete various operations through the relevant commands, and the server provides the corresponding service according to this instruction. Each instance of client software can make a request to a server or application server.

Client and server programs usually do not run on the same computer. For example, when we buy books on Dangdang, the computer and web browser we use are treated as a client. At the same time, the computers, databases and applications that make up Dangdang are used as servers.

Database system classification

Database management systems can be divided into two categories: one is database management systems based on shared file systems, such as Microsoft Access and FileMaker, which are mainly used for desktop purposes and are not suitable for high-end or more critical applications; the other is client-server-based database management systems, such as MySQL, Oracle and SQL Server databases.

Server software is a software that accesses and processes all data. This software runs on a computer called a database server, and only the server software deals with data files.

All requests for adding, deleting, and updating data are done by the server. These requests come from the computer running the client. The client is used to deal with users. For example, if you request an alphabetical list of products, the client submits the request to the server over the network, and the server processes the request, then filters, discards, and sorts the data as needed, and finally returns the results to the client.

Note: the client and server can be installed on two computers or on one computer, and the client communicates with the server whether they are on the same computer or not.

All of these processes are transparent to users, and you don't need to access data files directly. In order to use MySQL, you need to access the computer running the MySQL server and the computer that issues commands to the MySQL client.

For MySQL database management systems, the server is MySQL DBMS. You can run it on a locally installed copy, or you can connect to a copy running on a remote server that you have access to. 

The clients can be tools provided by MySQL (such as MySQL Workbench, SQLyog), scripting languages (such as Perl), Web application development languages (such as ASP, ColdFusion, JSP and PHP), and programming languages (such as C, C++, Java).

This is the end of the article on "what is the MySQL client and server architecture". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

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.