Tech Terms Explained Open in the app →

MySQL

Databases · Beginner · 5 min read

What is it?

MySQL is a widely used open-source relational database that stores data in tables and is known for being fast, simple, and reliable.

Explain like I'm 5

MySQL is like a well-organized spreadsheet program that many websites share: data goes into labeled tables, and you ask for it with simple queries.

Why was it created?

It was built to give the web a free, fast, easy-to-run relational database, fueling the early growth of database-backed websites.

Where is it used?

  • Web application backends
  • Content management systems
  • E-commerce sites
  • Read-heavy workloads

Why should developers care?

MySQL powers a huge share of the web and is a common choice in classic web stacks, so you'll meet it on many teams.

How does it work?

Data lives in tables with defined columns. SQL queries read and write it, transactions group related changes, and storage engines handle how rows are stored and indexed.

Real-world example

A blog platform stores posts, users, and comments in MySQL tables and joins them to render each article page.

Common use cases

  • Storing structured app data
  • Powering CMS and e-commerce
  • Read-heavy web workloads
  • Reporting and queries

Advantages

  • Fast and mature
  • Easy to get started
  • Huge community and tooling
  • Free and open-source

Disadvantages

  • Fewer advanced features than PostgreSQL
  • Some defaults need tuning for strictness
  • Scaling writes takes effort

When should you use it?

For typical web apps needing a reliable, well-supported relational database.

When should you avoid it?

When you need advanced types/features (consider PostgreSQL) or document flexibility (consider MongoDB).

Alternatives

PostgreSQLMariaDBSQLiteMicrosoft SQL Server

Related terms

PostgreSQLAmazon RDSAmazon AuroraORM

Interview questions

Beginner

  • What is MySQL?
  • What is a table and a row?

Intermediate

  • What is an index?
  • What is a JOIN?

Senior

  • How do you scale read traffic with replicas?
  • How would you approach sharding MySQL?

Common misconceptions

  • "MySQL and SQL are the same thing" — SQL is the query language; MySQL is one database that uses it.
  • "MySQL can't scale" — it scales well with replicas, caching, and careful design.

Fun facts

  • MySQL was named after co-founder Michael Widenius's daughter, My.
  • MariaDB is a community fork created by MySQL's original developers.

Timeline

  • 1995 — First released

Learning resources

Quick summary

MySQL is a fast, popular open-source relational database that powers a large share of the web's database-backed apps.

Cheat sheet

  • Relational database using SQL
  • Fast and beginner-friendly
  • Huge ecosystem
  • Scale reads with replicas

If you remember only one thing

MySQL is a fast, popular, beginner-friendly relational database for web apps.