PostgreSQL Internals for the MySQL DBA
PostgreSQL internals explained for MySQL DBAs. MVCC, heap vs clustered index, VACUUM, WAL, and replication, all mapped to their InnoDB equivalents.
Rendiment
Rendiment aims to help the community to improve the performance of the databases, with a focus on MySQL and PostgreSQL
Latest posts
The Claude Code Engineer
Meet the Claude Code Engineer: a new role where QA, product thinking, and AI coordination matter more than writing code. How agentic tools reshape teams.
dbsafe in the Cloud: Safe Schema Changes on AWS Aurora and RDS
Run dbsafe against Aurora MySQL and RDS with TLS. Learn how Aurora's shared-storage architecture complicates gh-ost and why dbsafe auto-detects cloud topology.
Before the Index, Before the Schema: MySQL Makes Three Promises
What is a database actually supposed to do? A framework of three core promises that applies whether you're a DBA, developer, or ops engineer.
Foreign Keys and Schema Changes: The Constraint You Didn’t Plan For
MySQL foreign key constraints extend metadata locks to related tables and eliminate gh-ost for DDL. dbsafe surfaces the full FK impact before you alter.
ON DELETE CASCADE: The Foreign Key Change MySQL Doesn’t Log
MySQL InnoDB's ON DELETE CASCADE bypasses the binlog, audit plugins, and triggers — the three blind spots explained plus a trigger-based workaround for 8.x.
Always Have an Exit Strategy: dbsafe Automatic Rollback Plans
Learn how dbsafe auto-generates rollback SQL for every schema change — with data loss warnings for DROP COLUMN and INSTANT drop notes for MySQL 8.0.29+.
When MySQL Rebuilds Your Table: Understanding COPY Algorithm DDL
Understand MySQL COPY algorithm DDL that rebuilds entire tables. Learn why MODIFY COLUMN and charset conversions are dangerous, and how dbsafe mitigates risk.
Zero-Downtime Schema Changes with MySQL 8.0 INSTANT DDL
Master MySQL 8.0 INSTANT DDL for zero-downtime schema changes. Learn ADD COLUMN, DROP COLUMN without table rebuilds, and use dbsafe to verify before production.
Introducing dbsafe: Know Before You ALTER
Analyze MySQL ALTER TABLE statements before running them. Know the algorithm, locks, and risks without testing on production. Read-only DDL safety tool.