psql CLI Quick Reference
Complete PostgreSQL Command Line Reference
Comprehensive reference poster covering connection parameters, meta commands (\d, \l, \du), .psqlrc template, COPY streaming, and real-time activity/lock triage queries.
Other Reference Guides
Other reference posters and cheatsheets curated for database administrators.
InnoDB Tuning Reference
Buffer pool sizing formula, redo log and flush policies, I/O capacity and thread tuning, production-grade my.cnf template, and SHOW ENGINE INNODB STATUS triage guide.
PostgreSQL Security Hardening
pg_hba.conf hardening rules, SCRAM-SHA-256 password policies, SSL/TLS certificate verification, pgaudit audit trails, public schema lockdown, and single-query security check scripts.
PostgreSQL Backup & Recovery Reference
Logical backups with pg_dump/pg_dumpall, physical backups with pg_basebackup and pgBackRest, WAL archiving, Point-in-Time Recovery (PITR), and disaster recovery playbooks.
MySQL Backup & Recovery Reference
Logical backups with mysqldump and MySQL Shell dumpInstance, physical backups with MEB and Percona XtraBackup, Point-in-Time Recovery via binary logs, and the CLONE plugin.
PostgreSQL Indexing & Query Optimization
B-Tree, BRIN, GIN, GiST index selection, EXPLAIN (ANALYZE, BUFFERS) node analysis, slow query triage via pg_stat_statements, and autovacuum/index maintenance guides.
MySQL OCP 8.0 DBA Exam Topic Map
All 7 domains of Oracle 1Z0-908 MySQL 8.0 Database Administrator exam: Architecture, Install/Config, Security, Monitoring, Query Optimization, Backup/Recovery, HA (InnoDB Cluster), and pitfalls.
