The JusDB Database Engineering Blog

TiDB 8.0 is the most production-ready version of the distributed SQL database yet. With improved HTAP, stronger MySQL compatibility, and Resource Groups, it's compelling for teams outgrowing single-node MySQL.

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

Deploy a production PostgreSQL HA cluster with Patroni and etcd. Covers configuration, patronictl commands, HAProxy integration, and failover procedures.

MongoDB indexes fragment over time as documents are inserted, updated, and deleted. Here's how to detect fragmentation, measure its performance impact, and rebuild indexes safely.

Understand InnoDB crash recovery mechanics and handle edge cases with innodb_force_recovery. Emergency dump procedures and durability settings to prevent future crashes.

Day-to-day MongoDB replica set operations: adding/removing members, triggering elections, diagnosing replication lag, and managing oplog size.

An honest comparison of MongoDB and PostgreSQL in 2026 — document model vs relational model, JSONB as a document store, ACID transaction trade-offs, horizontal scaling, licensing, and migration paths.

Set up PostgreSQL streaming replication from scratch. Covers primary configuration, standby base backup, replication monitoring, and manual failover promotion.

Systematically diagnose and fix MySQL 'Too many connections' errors. Learn to identify connection leaks, tune wait_timeout, and implement ProxySQL pooling.

Configure ProxySQL for transparent read/write splitting, connection pooling, and replication lag monitoring. Covers query rules, hostgroups, and stats analysis.

Configure MySQL Orchestrator for automated failover and replication topology management. Step-by-step guide covering installation, Raft mode, and failover testing.

Choose Redis 8 or Valkey 8 from licensing, feature, managed-service, and operational requirements, then migrate within the documented compatibility boundary.