MySQL
MySQL is a relational database management system that stores, manages, and queries structured data using SQL.
Amazon Web Services in Action, Third Edition: An in-depth guide to AWS
A MySQL database is a relational database system that stores and queries structured data using SQL.
- How it is used
- Stores WordPress posts and comments separately from uploaded files in an AWS web-application deployment.
- How deep it goes
- Walks through RDS instance choices and dump import steps, but does not develop SQL queries or MySQL internals.
- Examples
- Uses a low-traffic WordPress blog, RDS console inspection, and mysqldump and mysql client commands for migration.
- What you can do after
- Operate/configure it through RDS instance selection and access controls, then import an existing dump using the MySQL client.
Read how Amazon Web Services in Action, Third Edition: An in-depth guide to AWS explains MySQL →
Quarkus in Action
MySQL is an open-source relational database management system that stores and queries structured data with SQL.
- How it is used
- Provides relational persistence for the Inventory service using the Panache repository pattern.
- How deep it goes
- Walks through extensions, datasource properties, a JPA entity, a repository, and a Kubernetes URL change; it does not develop MySQL internals.
- Examples
- Uses an Inventory service, a Car entity and repository, datasource properties, and a Kubernetes JDBC URL override.
- What you can do after
- Operate/configure it as an Inventory service datasource locally and through a Kubernetes-specific JDBC URL.
Also covered in
- PostgreSQL Mistakes and How to Avoid Them
- Microsoft Azure in Action
- gRPC Microservices in Go
- Learn SQL in a Month of Lunches
- Spring Start Here, Second EditionIn early access (MEAP)
- Logs and Telemetry
- The Quick Python Book, Fourth Edition
What to know first
- SQLSQL is a standardized declarative language for defining, querying, and manipulating data in relational database systems.
- backup and restoreBackup and restore is the practice of preserving copies of data or system state and using them to recover it after loss, damage, or failure.
- YAMLYAML is a human-readable data serialization standard for representing structured data, commonly using indentation to express mappings and sequences.
Related concepts
- keyworduses · A language-defined word or token with a predefined syntactic or semantic role, which may be restricted from use as an ordinary identifier.
- truncateuses · TRUNCATE is a SQL statement that removes all rows from a table while preserving its definition.
- databasekind of · A database is an organized persistent data store, typically managed by software, that supports storing, retrieving, and modifying data.
- SQLitealternative to · SQLite is a self-contained, serverless relational database engine implemented as a software library that stores and queries databases in files or memory.
- PostgreSQLalternative to · PostgreSQL is an open-source object-relational database management system that stores and queries data using SQL and supports extensible data types and operations.
- relational database management systemkind of · A relational database management system is software that stores and manages data organized according to the relational model and supports operations for defining, querying, and updating that data.
Questions about MySQL
What is MySQL?
MySQL is a relational database management system that stores, manages, and queries structured data using SQL.
Which Manning books explain MySQL?
Amazon Web Services in Action, Third Edition: An in-depth guide to AWS and Quarkus in Action.
What should I know before learning MySQL?
Manning books that teach MySQL usually introduce SQL, backup and restore and YAML first.
What is the difference between MySQL and SQLite?
MySQL is a relational database management system that stores, manages, and queries structured data using SQL. SQLite is a self-contained, serverless relational database engine implemented as a software library that stores and queries databases in files or memory.
What is MySQL a kind of?
MySQL is a kind of database. A database is an organized persistent data store, typically managed by software, that supports storing, retrieving, and modifying data.
These guides are generated from the text of Manning books by Manning's knowledge graph and link to the sections they draw on. The full books are available on liveBook and at manning.com.

