How mysql/mysql-server works
MySQL is a relational SQL database server, accompanied here by command-line clients, server components, and MySQL Router’s REST-service metadata layer. The principal workflow is a client submitting SQL to the server and receiving results. The tree and README establish the product and subsystem scope; sampled excerpts support details for client query attributes, transaction inspection, keyring metadata, resource-manager queries, and REST metadata loading, but do not expose the general SQL execution or storage implementation.
Main entry points: server_component SQL database server · mysql.cc SQL client · keyring_file.cc File keyring · mysqldump.cc Dump and export
Components 22
Client tools
- SQL client
client/mysql.cc - Dump and export
client/mysqldump.cc - Data import
client/mysqlimport.cc - Administration tools
client/mysqladmin.cc - Binlog tools
client/mysqlbinlog.cc - Query attributes
client/client_query_attributes.cc
Database server
- SQL database server
sql/server_component - Transaction inspection
sql/server_component/ongoing_transaction_query_service.cc - Query results
sql/server_component
Server components
- Connection control
components/connection_control/connection_control.cc - Group replication
components/group_replication_resource_manager/resource_manager.cc - Resource queries
components/group_replication_resource_manager/resource_manager_query.cc - Telemetry
components/telemetry/tm_component.cc - Audit events
components/audit_api_message_emit/audit_api_message_emit.cc - Backup
components/mysqlbackup/mysqlbackup.cc
Key management
- File keyring
components/keyrings/keyring_file/keyring_file.cc - Keyring metadata
components/keyrings/keyring_file/service_implementation/keyring_metadata_query_service_definition.cc - Keyring data files
components/keyrings/keyring_file/backend/backend.cc
Router REST services
- REST metadata queries
router/src/mysql_rest_service/src/mrs/database/query_entries_db_service.cc - REST change queries
router/src/mysql_rest_service/include/mrs/database/query_changes_db_service.h - REST metadata database
Other components
- Database user
Connections 23
- Database user → SQL client: submits SQL
- Database user → Dump and export: requests export
- Database user → Data import: provides data
- Database user → Administration tools: requests administration
- Database user → Binlog tools: requests binlog work
- SQL client → SQL database server: sends queries
- Dump and export → SQL database server: reads data
- Data import → SQL database server: loads data
- Administration tools → SQL database server: sends commands
- Binlog tools → SQL database server: accesses server
- SQL database server → Query results: returns results
- SQL database server → Transaction inspection: inspects transactions
- SQL client → Query attributes: binds attributes
- Group replication → Resource queries: runs report queries
- Resource queries → SQL database server: executes SQL
- SQL database server → Connection control: uses connection control
- SQL database server → Telemetry: emits telemetry
- SQL database server → Audit events: emits audit events
- Backup → SQL database server: backs up server
- File keyring → Keyring metadata: exposes metadata
- File keyring → Keyring data files: reads and writes
- REST metadata queries → REST metadata database: queries metadata
- REST change queries → REST metadata database: queries changes