Hands-on PostgreSQL Database Reliability and Modernization lab covering observability, migration, Terraform, AWS DMS, Flyway, recovery and OLTP/OLAP design.
-
Updated
Sep 8, 2026 - Python
Hands-on PostgreSQL Database Reliability and Modernization lab covering observability, migration, Terraform, AWS DMS, Flyway, recovery and OLTP/OLAP design.
PostgreSQL reliability engineering lab for HA, failure testing, migration safety, durability, PITR, and observability.
PostgreSQL extension lifecycle & version upgrade automation — compatibility matrices, safe low-downtime upgrade paths, dependency resolution, and rollback automation with Python and CI/CD.
SQL Server backup, restore-chain, PITR, and recovery-validation framework focused on reliability, traceability, and operational resilience.
Enterprise-grade AWS infrastructure automation using modular Terraform (VPC, ALB, ECS Fargate, RDS MySQL), combined with local database disaster recovery workflows, query optimization, and GitHub Actions CI/CD automation.
Six database engines, eight failover scenarios, real multi-node clusters — measured HA, sharding and backup/restore for PostgreSQL 18, Redis, MongoDB, ScyllaDB, SolrCloud and Galera.
Workload-aware, deterministic rehearsal for SQL migration risk
PostgreSQL HA on a three-VM cluster: Patroni + etcd on amd64 Rocky 8, pgBackRest over mutual TLS — failover, replica rebuild and point-in-time restore actually performed, with measured results.
Scaling PostgreSQL out with Citus, time-series with TimescaleDB, and a 2×2 replicated ClickHouse cluster: migration planner, online rebalance under load, tenant isolation, compression, and every failure measured.
MySQL binary log archiving, GTID management, and point-in-time recovery (PITR) automation — a production-focused, code-first knowledge base for DBAs and reliability engineers.
To associate your repository with the database-reliability topic, visit your repo's landing page and select "manage topics."