The JusDB Database Engineering Blog

GTIDs eliminate manual binlog position tracking in MySQL replication. This guide covers enabling GTIDs, CHANGE MASTER TO MASTER_AUTO_POSITION, and failover.

Choose between ElastiCache Redis and Memcached — data structures, persistence, replication, and cost considerations

Manage SQL schema migrations with Flyway — versioned and repeatable scripts, CI/CD integration, and team workflows

A production guide to MySQL slow query log — enabling with long_query_time and log_queries_not_using_indexes, analyzing with pt-query-digest, reading EXPLAIN output, and fixing full table scans and N+1 loops.

Optimize MySQL connection management for maximum throughput. Learn connection pooling with HikariCP, ProxySQL load balancing, and thread pool configuration.

MySQL 8.0 finally supports true descending indexes — eliminating the filesort that MySQL 5.7 required when sorting results in descending order. Here's how descending indexes work and when to add them.

Deploy Airbyte to replicate data from MySQL, PostgreSQL, and MongoDB to your warehouse — connectors, scheduling, and transforms

Build fault-tolerant MySQL clusters with Group Replication. Learn multi-primary vs single-primary modes, conflict resolution, network partitioning handling, and failover strategies.

A complete guide to PostgreSQL memory configuration and performance tuning, covering shared_buffers, work_mem, effective_cache_size, checkpoint tuning, and autovacuum settings that matter in production.

Most MySQL maintenance tasks still rely on cron, but systemd timers offer better logging, dependency management, and failure handling. Here's how to convert your MySQL maintenance scripts to systemd services.

Optimize database performance by choosing the right data types and constraints. Learn about VARCHAR vs TEXT, INT sizes, ENUM optimization, and constraint best practices.

Avoid these common MySQL configuration mistakes that cripple performance. Learn proper buffer pool sizing, connection limits, and InnoDB settings for production workloads.