(C) Federico Razzoli 2018
Collection of cheatsheets and snippets for MySQL and PostgreSQL. This project serves as a reference for people who is only familiar with one of these systems.
This file contains generic information. For more specific contents, browse the subdirectory.
| MySQL | PostgreSQL |
|---|---|
| Dataset | Cluster |
| Optimizer | Planner |
| Master | Primary |
| Slave | Standby |
| Readonly Slave | Warm Standby |
Some functionalities are based on different idea, so this mapping is a very loosy approximation. Use it as a hint about what to study, don't try to use MySQL concepts in PostgreSQL (or the other way around).
| MySQL | PostgreSQL |
|---|---|
|
Binary Log InnoDB Transaction Logs |
WAL |
| Doublewrite Buffer | Full Page Writes |
| Row Based Replication (RBR) | Streaming Replication or Logical Repliaction |
| Database | Schema |
| / | Database |
|
Tablespace (InnoDB) Data File (MyISAM) |
Heap File |
| Client | Frontend, Client |
| Connection, User Thread | Backend |
|
Buffer Pool (InnoDB) Key Buffer (MyISAM) |
Shared Buffers |
Federico Razzoli < federico.razzoli.dba@gmail.com >