MySQL is an open-source relational database management system (RDBMS) that you query with Structured Query Language (SQL). Oracle develops it and releases it under the GNU General Public License (GPL).
Its key features:
- ACID compliance through the default InnoDB storage engine. ACID stands for atomicity, consistency, isolation and durability, the guarantees that keep data intact even after a crash.
- Storage engines chosen per table, such as InnoDB, MyISAM and Memory.
- Replication from a source server to replicas, and Group Replication, whose multi-primary mode lets every member accept writes.
- Horizontal partitioning, which splits a large table by rows.
- Triggers and stored procedures for logic on the server.
- Full-text indexes for text search.
- It runs on Linux, Windows and macOS.
Rewriting in plainer words…
This answer doesn't lend itself to a diagram - it reads best . No credits were charged.
Why there's no diagram: “”
The interactive diagram is below the answer - jump to diagram ↓ · Below it, the related concept . Jump to it ↓
The diagram below the answer is the concept . Jump to it ↓
Tailored explanation · switch back to · ·
What should the new diagram focus on?