JusDB

JusDB

Uncompromised database reliability engineered by experts. Trusted by startups to enterprises worldwide.

Services

  • Remote DBA
  • Database SRE
  • Performance Tuning
  • Security Audits
  • All Services

Company

  • About Us
  • Careers
  • Contact
  • Blog

Community

Join database engineers sharing tips, troubleshooting, and best practices.

Join Slack

Contact

  • contact@jusdb.com
  • +91-9994791055
  • Trichy, Tamil Nadu, India

© 2026 JusDB, Inc. All rights reserved.

Privacy PolicyTerms of UseCookies PolicySecurity
  1. Home
  2. Blog
Expert Database Knowledge

Database Insights

Expert insights on database management, performance optimization, and reliability engineering from industry professionals

Popular Searches

Topics:
All Articles(217)Database Performance(40)MySQL(25)PostgreSQL(12)Database Engineering(31)Database SRE(24)Cloud Databases(20)Analytics & OLAP(9)NoSQL Databases(30)Database Architecture(18)High Availability(8)

Latest Articles

Showing 12 of 217 articles

TiDB's Raft-Based Replication: How Distributed Consensus Keeps Your Data Safe
Database Architecture

TiDB's Raft-Based Replication: How Distributed Consensus Keeps Your Data Safe

TiDB uses Raft consensus protocol through TiKV to replicate every region across three or more nodes. Here's how leader election, log replication, and region management work in practice.

5/20/2024
9 min
3
TiDB
Replication
Read
Valkey: The Open-Source Redis Alternative After the License Change
NoSQL Databases

Valkey: The Open-Source Redis Alternative After the License Change

Migrate from Redis to Valkey — compatibility, performance benchmarks, and what changes for operators

5/7/2024
10 min
1
Redis
NoSQL
Read
Demystifying TiDB's Write Path: A Guide to Scalable Data Management
Database Architecture

Demystifying TiDB's Write Path: A Guide to Scalable Data Management

TiDB's write path crosses multiple layers — SQL parser, planner, TiKV region leader, Raft log replication, and 2PC commit — before a transaction is durable. Here's a complete walkthrough.

3/25/2024
9 min
2
TiDB
Architecture
Read
MySQL Architecture Deep Dive: From Query Execution to Physical Storage
Database Performance

MySQL Architecture Deep Dive: From Query Execution to Physical Storage

Understand MySQL query execution from parser to storage. Learn optimizer internals, execution plans, buffer management, and physical storage organization.

3/19/2024
33 min
2.3K
MySQL
InnoDB
Read
A
Database Engineering

Apache Flink CDC: Real-Time Database Change Capture at Scale

Use Apache Flink CDC to capture MySQL and PostgreSQL changes — stateful processing, exactly-once semantics, and Kubernetes deployment

2/20/2024
13 min
2
Open Source
Replication
Read
PostgreSQL 17 Incremental Backup: pg_basebackup and pg_combinebackup Explained
Database SRE

PostgreSQL 17 Incremental Backup: pg_basebackup and pg_combinebackup Explained

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

2/9/2024
9 min
2
PostgreSQL
Migration
Read
pgvector Complete Guide: Vector Similarity Search in PostgreSQL
Database Engineering

pgvector Complete Guide: Vector Similarity Search in PostgreSQL

pgvector brings vector similarity search to PostgreSQL — enabling semantic search, recommendation engines, and RAG pipelines without a separate vector database.

1/15/2024
10 min
2
PostgreSQL
Vector Database
Read
How to Downgrade MongoDB from 7.0 to 6.0: A Step-by-Step Guide
NoSQL Databases

How to Downgrade MongoDB from 7.0 to 6.0: A Step-by-Step Guide

Downgrading MongoDB requires careful planning — setting the Feature Compatibility Version before replacing binaries, handling replica set members in sequence, and verifying data integrity throughout.

11/23/2023
8 min
1
MongoDB
NoSQL
Read
MongoDB Indexing: A Complete Guide to Faster Queries
NoSQL Databases

MongoDB Indexing: A Complete Guide to Faster Queries

MongoDB's indexing system supports single-field, compound, multikey, text, geospatial, and partial indexes. Choosing the right index type and key order determines whether your queries use microseconds or seconds.

11/16/2023
11 min
2
MongoDB
NoSQL
Read
MySQL Replication Options: Native Replication vs Group Replication vs InnoDB Cluster
MySQL

MySQL Replication Options: Native Replication vs Group Replication vs InnoDB Cluster

MySQL offers multiple replication topologies — traditional async replication, semi-sync, Group Replication, and InnoDB Cluster. Understanding the trade-offs determines whether your failover takes seconds or minutes.

11/9/2023
9 min
MySQL
Replication
Read
Real-Time Analytics Pipeline: PostgreSQL to ClickHouse via CDC
Analytics & OLAP

Real-Time Analytics Pipeline: PostgreSQL to ClickHouse via CDC

Build a real-time analytics pipeline from PostgreSQL to ClickHouse using CDC — architecture, latency, and schema mapping

11/7/2023
12 min
1
ClickHouse
PostgreSQL
Read
V
Database Architecture

Vector Databases Compared: pgvector, Pinecone, Weaviate, and Qdrant

Compare vector database options for AI workloads — pgvector in PostgreSQL, Pinecone, Weaviate, and Qdrant

10/24/2023
12 min
2
Vector Database
Indexing
Read
Previous
12345
Next
Search
Newsletter

Get the latest database insights and expert tips delivered to your inbox.

Categories
Database PerformanceMySQLPostgreSQLDatabase EngineeringDatabase SRECloud DatabasesAnalytics & OLAPNoSQL DatabasesDatabase ArchitectureHigh Availability
Popular Tags
MySQL
Performance
PostgreSQL
Optimization
Architecture
Scaling
Monitoring
Replication
Open Source
NoSQL
Stay Connected

Subscribe to our RSS feed for instant updates.

RSS Feed