MySQL Architecture
MySQL follow Client-Server Architecture. It has the three following layers: 1. Client 2. Server 3. Storage Layer Client Layer: The requests by client to the Server with the help of Client Layer. The Client make request through Command Prompt or through GUI screen like workbench or python or java connectors by using valid MySQL commands and expressions. If the Expressions and commands are valid then the output is obtained on the screen. Some important stages in client layer are : Connection Handling : Accept the connection and connect to server based on the allowed connection values. Creates thread for each connection in backgroud. So we can also called as "Thread handling" Authentication : It verifies the user name and password Security : Checks the privileges to execute the requested statement. Server Layer: This Layer is also known as “Brain of MySQL Architecture”. When the client give request instructions to the Server and the server gives the output as...
