MySQL Glossary

MySQL is an open source, object-relational database built with speed and reliability in mind. Its large and active developer community has created many third-party applications, tools, and libraries that expand MySQL’s functionality.


This glossary defines the core concepts behind MySQL to help build your mental model of how MySQL work and understand what the documentation is referring to when it uses certain terminology.

ACID compliance is a set of database characteristics consisting of atomicity, consistency, isolation, and durability that ensure that database transactions are completed efficiently.
ACL
An access control list, or ACL, is a list of user permissions that controls access to a system resource.
Connection status metric is a metric that measures the number of threads created, connected, and running in relation to a database’s connection limit.
Database as a Service, Managed Database Service, or DBaaS for short, is a cloud service that allows users to access a cloud database system without having a personal cloud data system on a subscription basis.
End-to-end encryption, or E2EE, is a system of communication that encrypts messages for everyone including the messaging service except the user receiving the message and the user that sent the message.
Failover is a high availability (HA) mechanism that monitors servers for failures and reroutes traffic or operations to a redundant server when the primary server fails.
High Availability (HA) is an approach to infrastructure design focusing on reducing downtime and eliminating single points of failure.
Hot standby is the act of listening for when a primary node fails in order for the standby node to take its place.
The index vs. sequential reads plot presents the proportion of reads that use an index over the total number of reads across all databases (schemas) on the master server.
Linux Unified Key Setup (LUKS) is an open source disk encryption specification for block storage devices.
Machine type is the set of virtualized hardware resources used for a virtual machine (VM) instance.
Node plan, database or cluster configuration is the hardware plan for node specifications.
Operations throughput metric is a measurement of throughput of fetch, insert, update, and delete operations across all databases on the server.
Point-in-time recovery, or PITR for short, ensures that automatic backups are made in order to restore or recover data made in a previous state of the server.
A port is a communication endpoint of a network connection. A port is identified using a port number for each transport protocol.
A read-only node is a replica of the cluster’s primary node.
SQL mode, or sql_mode is a MySQL system variable meant to configure operational characteristics of the MySQL server.
SSL certificate is a digital document outlining the identity of the website.
A standby node is a node that is set aside idling on hot standby.
Tag
Tags are keywords associated with resources which help with managing resource ownership and organize lookups and actions on resources.