Abbreviations and Definitions in MySQL
Abbreviations and Definitions in MySQL
- DMR ==> Development Milestone Release
- RC ==> Release Candidate
- GA ==> General Availability (Release)
- DMG Packages ==> (Native Packages) A file that is used during installation of MySQL (with extension )
- Sakila DB ==> A sample database in MySQL environment
- MySQL Workbench ==>MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. MySQL Workbench is available on Windows, Linux and Mac OS X.
- my.cnf ==> The primary configuration file for the MySQL database server is called my.cnf.
- mysqlcheck==> A MySQL Program that is specifically used to repair, analyze and optimize tables.
- Layers in mySQL==> Application Layer, Server/logical Layer, and Storage/Physical Layer
- Application Layer==> The application layer in MySQL is the topmost layer in the MySQL architecture. It is responsible for handling the client’s requests and providing the output as soon as the instruction is matched.
- Server/logical Layer==> This layer is considered as Brain on MySQL
- Storage/Physical Layer==>responsible for managing and storing data on disk
- Security Layer ==> is responsible for authenticating users and controlling access to the database
- Connection Manager ==> Manage and establish connections to the MySQL Server
- Master server ==>In a MySQL replication setup, Master server sends updates to slave servers
See also