MySQL Architecture

MySQL Architecture     When a query comes to MySQL from Client program   it will go to Query parsing  (hear it will check for SQL syntax by checking every character in SQL query and generate SQL_ID for each SQL query.) then it will sent to Optimization … Read More

Client/Server architecture of MySQL.

Client/Server architecture of MySQL  Networked environment using a client/server model. -central acts as server -Various client programs connects to the server and make requests. Components Of MySQL  Installations : The MySQL Database also follows the client and server model architecture and following are the components… Read More

When to Use MongoDB

When to Use MongoDB   Is MongoDB right for your application? That depends on the kind of data you have, and what you want to do with that data. NoSQL databases have risen to the occasion when it comes to unstructured data and the kind… Read More

MySQL : Installing Multiple MySQL

Installing Multiple MySQL   The need to have multiple instances of MySQL (the well-known mysqld process) running in the same server concurrently in a transparent way, instead of having them executed in separate containers/virtual machines.   MySQL provides a tool to facilitate the execution of… Read More