The JusDB Database Engineering Blog

MySQL replication errors 1062 and 1032 stop your replica SQL thread silently. Learn to diagnose binlog failures, fix data drift with pt-table-sync, and configure GTID-safe replication.

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

Monitor ETL pipelines with data freshness checks, row count reconciliation, dbt data quality tests, and Slack alerting. Detect silent failures before users do.

Choose jsonb over json for PostgreSQL: GIN indexing, containment operators, path queries, and update operations with || and jsonb_set. Includes performance comparison.

Supabase, PlanetScale, and Neon each take a different approach to serverless databases. Compare their connection limits, branching features, cost models, and which fits your workload.

Compare database sharding strategies: hash sharding for even distribution, range sharding for locality, and directory-based for flexibility. When to shard and alternatives.

Use MySQL JSON columns effectively with path operators, functional indexes via generated columns, JSON_CONTAINS filtering, and partial updates with JSON_SET.

Implement PostgreSQL full-text search with tsvector columns, GIN indexes, and ts_rank scoring. Covers phrase search, weighted fields, and ts_headline snippets.

MySQL InnoDB Cluster combines Group Replication, MySQL Shell, and MySQL Router into a complete HA solution. Here's how to deploy and manage it in production.

DuckDB brings OLAP query performance to your Python process without a server or cluster. Learn how to query Parquet files, replace heavy ETL jobs, and run analytics directly against PostgreSQL.

ScyllaDB 6.0's shard-per-core architecture delivers 3-8x Cassandra throughput on identical hardware. Learn the performance differences, migration path from Cassandra, and when ScyllaDB tablets beat vnodes.

Deploy Kafka Connect with JDBC source connectors, Single Message Transforms, Dead Letter Queues for error handling, and consumer group lag monitoring.