The JusDB Database Engineering Blog

Secure database credentials with AWS Secrets Manager, automatic rotation, Kubernetes secrets, and git-secrets scanning. Never hardcode connection strings.

Implement MySQL point-in-time recovery using binary logs. Covers binlog configuration, mysqlbinlog replay with stop-datetime, GTID-based filtering, and S3 binlog archival.

Compare PostgreSQL backup approaches: logical dumps, physical base backups, and WAL-G incremental cloud backups. Covers PITR, restore speed, and backup verification.

Choose PostgreSQL backup and recovery methods from explicit RTO and RPO, preserve continuous WAL, verify manifests, and rehearse isolated restores.

mysqld_exporter exposes 300+ MySQL metrics for Prometheus. Learn to deploy it, configure essential alerting rules for connection saturation and replication lag, and build production dashboards in Grafana.

PostgreSQL 17 finally adds native incremental backup support — allowing subsequent backups to capture only changed blocks since the last full backup.

Use pg_upgrade to migrate between PostgreSQL major versions — upgrade strategies, pre-checks, and rollback plans

Build a data-driven capacity planning process using historical metrics, growth trends, and resource modeling

Migrate from DynamoDB to Aerospike for better cost-performance at scale. Real case study showing 60% cost reduction with improved latency and throughput.

PostgreSQL PITR lets you recover your database to any point in time — down to the second — by replaying WAL segments on top of a base backup. Here's how to set it up correctly.

Reduce AWS RDS MySQL costs by 40-60% with proven optimization strategies. Learn Reserved Instance planning, right-sizing, storage optimization, and read replica strategies.

Optimize AWS RDS PostgreSQL costs without sacrificing performance. Learn instance sizing, storage class selection, backup strategies, and Multi-AZ optimization.