BestHub
Sign in

Databases

Showing 100 articles max
Latest Popular
Architect's Tech Stack
Architect's Tech Stack
Sep 26, 2026 · Databases

Why Database Sharding Is No Longer the Default Choice

The article argues that manual database sharding is shifting from a default scaling strategy to a fallback option, as native distributed databases like TiDB and OceanBase internalize sharding, routing, and distributed transactions, reducing application complexity, though they introduce higher latency, operational overhead, and cost, making single-node MySQL with proper indexing preferable for smaller datasets.

OceanBaseShardingSphereTiDB
0 likes · 8 min read
Why Database Sharding Is No Longer the Default Choice
ITPUB
ITPUB
Sep 26, 2026 · Databases

100 Essential Oracle DBA Commands: Instance, SQL Tuning, RMAN & Data Guard

This comprehensive guide lists 100 essential Oracle DBA commands covering instance management, parameter configuration, session troubleshooting, lock analysis, SQL performance tuning, tablespace and user management, UNDO, temporary tablespace, RMAN backup and recovery, Data Guard, RAC, Data Pump, and OS-level diagnostics, with practical examples and usage notes.

Backup RecoveryDBAData Guard
0 likes · 30 min read
100 Essential Oracle DBA Commands: Instance, SQL Tuning, RMAN & Data Guard
Code Farmer Manor Chronicle
Code Farmer Manor Chronicle
Sep 26, 2026 · Databases

MongoDB Cheat Sheet: SQL to NoSQL Mindset Shift

This MongoDB cheat sheet guides SQL developers through the mindset shift to NoSQL, covering concept mappings, CRUD operations, indexing, aggregation pipelines, and execution plan analysis with practical code examples for each operation and key pitfalls to avoid.

CRUDMongoDBNoSQL
0 likes · 11 min read
MongoDB Cheat Sheet: SQL to NoSQL Mindset Shift
dbaplus Community
dbaplus Community
Sep 26, 2026 · Databases

PostgreSQL JSON vs JSONB: 1M Row Benchmark Shows 7x Query Speed Gap

This article benchmarks PostgreSQL JSON and JSONB types on 1 million rows, revealing JSONB delivers 6-9x faster queries and 26% less storage despite 31% slower writes, with practical guidance on when to choose each type and how to leverage GIN indexes for optimal performance.

Data TypesDatabase BenchmarkGIN Index
0 likes · 20 min read
PostgreSQL JSON vs JSONB: 1M Row Benchmark Shows 7x Query Speed Gap
IT Services Circle
IT Services Circle
Sep 25, 2026 · Databases

Why MySQL Needs Four Isolation Levels Despite MVCC's Lock-Free Reads

This article explains how MySQL's MVCC uses version chains and ReadViews to enable lock-free snapshot reads, why isolation levels control ReadView creation timing (per-statement vs per-transaction), and why READ UNCOMMITTED and SERIALIZABLE bypass MVCC entirely, while writes still require row locks.

Concurrency ControlInnoDBMVCC
0 likes · 8 min read
Why MySQL Needs Four Isolation Levels Despite MVCC's Lock-Free Reads
21CTO
21CTO
Sep 25, 2026 · Databases

MariaDB Outperforms MySQL and PostgreSQL in Simple Query Benchmark

The author benchmarks MariaDB 10.3, MySQL 8.0, and PostgreSQL 12 using a real Turkish motorcycle classifieds app with many simple queries, finding MariaDB 5% faster on average and 7% faster at p95 with lower CPU usage, though MySQL handles tail latency better and memory differences stem from default performance_schema settings.

BenchmarkMariaDBPostgreSQL
0 likes · 10 min read
MariaDB Outperforms MySQL and PostgreSQL in Simple Query Benchmark
Baidu Intelligent Cloud Tech Hub
Baidu Intelligent Cloud Tech Hub
Sep 24, 2026 · Databases

Baidu Canghai: Unified MetaDB & Aries Foundation for Object, File & Block Storage

Baidu's Canghai storage evolves from siloed per-product systems to a unified architecture with MetaDB (distributed transactional metadata database) and Aries (scalable Blob KV data plane with online EC), using directory-aware sharding, conflict merging, Mantle path resolution, and hybrid EC/three-replica adaptation to support object, file, and block storage on one foundation.

AriesBlob KVMantle
0 likes · 38 min read
Baidu Canghai: Unified MetaDB & Aries Foundation for Object, File & Block Storage
Java Captain
Java Captain
Sep 24, 2026 · Databases

7 Common MySQL Index Failure Scenarios and How to Fix Them

This article details seven common MySQL index failure scenarios—including leftmost prefix violations, function usage on indexed columns, implicit type conversion, leading wildcards in LIKE, OR with non-indexed columns, IS NOT NULL, and NOT IN/EXISTS—with concrete SQL examples showing both failing and optimized queries.

IS NULLImplicit Type ConversionIndex Optimization
0 likes · 6 min read
7 Common MySQL Index Failure Scenarios and How to Fix Them
IoT Full-Stack Technology
IoT Full-Stack Technology
Sep 24, 2026 · Databases

Automate MySQL Backups with mysqldump and Cron: Complete Guide

This guide details MySQL scheduled backup using mysqldump commands for full, structural, and data-only exports, a Bash script that retains 31 days of rotating backups with logging, and crontab configuration for automated execution, including restore procedures and practical scheduling examples.

Linuxbackup automationbash script
0 likes · 13 min read
Automate MySQL Backups with mysqldump and Cron: Complete Guide
Xiaolin Talks Programming
Xiaolin Talks Programming
Sep 24, 2026 · Databases

Spring Boot + Cassandra for High-Write Workloads: Data Modeling, Consistency Tuning & Pitfalls

This guide covers integrating Cassandra with Spring Boot for high-write scenarios, detailing data modeling with partition/clustering keys, consistency level selection (LOCAL_QUORUM), query best practices, performance tuning (compaction, compression, JVM), and production pitfalls like hot partitions and tombstone storms.

CassandraCompactionConsistency Levels
0 likes · 35 min read
Spring Boot + Cassandra for High-Write Workloads: Data Modeling, Consistency Tuning & Pitfalls
Lakehouse Research Base
Lakehouse Research Base
Sep 23, 2026 · Databases

Milvus 3.x: From Vector Database to Lake-Native AI Retrieval Engine

This article provides a comprehensive analysis of Milvus 3.x's evolution from a vector database to a Lake-Native retrieval engine, covering its architecture, External Collection for zero-copy indexing on data lakes, Storage V3, ANN indexes (HNSW, IVF, DiskANN), hybrid search, and production RAG architectures with performance tuning and troubleshooting guidance.

ANN IndexDiskANNHNSW
0 likes · 37 min read
Milvus 3.x: From Vector Database to Lake-Native AI Retrieval Engine
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Sep 23, 2026 · Databases

MySQL Deadlock: Practical Example, Detection & Prevention

This article explains MySQL deadlocks with a concrete example of two transactions updating rows in opposite order, demonstrates deadlock detection via SHOW ENGINE INNODB STATUS, and lists prevention techniques including small transactions, proper isolation levels, lock wait timeouts, consistent operation order, and indexing.

InnoDBSQL exampledeadlock
0 likes · 8 min read
MySQL Deadlock: Practical Example, Detection & Prevention
Java Captain
Java Captain
Sep 22, 2026 · Databases

MySQL JOIN: Why ON vs WHERE Placement Changes LEFT JOIN Results

This article explains how placing filter conditions in ON versus WHERE clauses affects MySQL JOIN results, demonstrating with concrete examples that INNER JOIN behaves equivalently while LEFT JOIN preserves driving table rows only when conditions are in ON, with SQL code and result comparisons.

DatabaseINNER JOINJOIN
0 likes · 7 min read
MySQL JOIN: Why ON vs WHERE Placement Changes LEFT JOIN Results
Mingyi World Elasticsearch
Mingyi World Elasticsearch
Sep 21, 2026 · Databases

Easysearch 2.4.0 Vector Search: Verified Guide to Indexing, Querying & Hybrid Search Pitfalls

This article provides a step-by-step verified guide to implementing vector search in Easysearch 2.4.0, covering index creation with dense_vector fields, data ingestion with embeddings, k-NN query pitfalls including the mandatory 'k' parameter, and the critical distinction between compound queries and RRF-based hybrid search for combining keyword and semantic search.

EasysearchEmbeddingHNSW
0 likes · 10 min read
Easysearch 2.4.0 Vector Search: Verified Guide to Indexing, Querying & Hybrid Search Pitfalls