Can you explain the logical architecture of MySQL?

1.	Can you explain the logical architecture of MySQL?
Answer» The top layer contains the services most network-based client/server TOOLS or servers need such as connection handling, authentication, SECURITY, and so forth. The second layer contains much of MYSQL’s brains. This has the code for query parsing, analysis, optimization, CACHING, and all the built-in functions. The third layer contains the storage engines that are responsible for storing and retrieving the data stored in MySQL.

Answer»

The top layer contains the services most network-based client/server TOOLS or servers need such as connection handling, authentication, SECURITY, and so forth.
The second layer contains much of MYSQL’s brains. This has the code for query parsing, analysis, optimization, CACHING, and all the built-in functions.

The third layer contains the storage engines that are responsible for storing and retrieving the data stored in MySQL.

Discussion

No Comment Found

Related InterviewSolutions