**MYSQL** is a relational database with a layered kind of architecture. The layers of the architecture include a server resource end at the middle, the storage engine at the bottom, and the client-end or query execution end at the top. It's a three-layered architecture database system. 

The **architecture of the database** explains the relationship and interaction between the client-end, server-end, and storage-end of the system. Below are the various layers of the database system.



#   
## Client-end

The **client-end** of the MYSQL architecture is the part being interacted with by end-users of the database system. The user makes use of the graphic user interface screen or the command prompt for submission of various MYSQL commands to the server end. 

For every valid command submission, there is a valid output on the screen; for every wrong command submission, there is an error message sent as feedback to the screen. When a user sends a request to the server-end and the server accepts the request, a connection is established at once to enable the user carry out further requests. This could be termed **connection handling**, and it's a function rendered by the client-side of the architecture.

## Server-end

The **server-end** of the architecture comprises the logic of the database system. It is the brain of the MYSQL architecture. It receives every request sent by the client-side and also returns feedback upon processing every request. 

For every request sent by the client, there is an establishment of a connection, this connection is known as a **thread** on the server-side. The server end of the architecture helps in managing every established thread and this is known as **thread handling**. Thread handling is a function carried out by the server-end of the architecture. 


## Storage-end

The MYSQL database contains a different kind of storage engines which exist as a result of varying needs of databases. The storage engines are used to hold every user-created table in the database system. The **storage-end** facilitates the storing and retrieving of MYSQL data. The storage engine has an API that aids in the execution of the queries from the client end of the architecture just by passing rows back and forth in it. 

What is MYSQL architecture?

MYSQL is a relational database with a layered kind of architecture. The layers of the architecture include a server resource end at the middle, the storage engine at the bottom, and the client-end or query execution end at the top. It s a three-layered architecture database system. The architecture of the database explains the relationship and interaction between the client-end, server-end, and storage-end of the system. Below are the various layers of the database system. 