BestHub
Sign in
Tagged articles
625 articles
Page 1 of 7
ITPUB
ITPUB
May 11, 2026 · Databases

What Human Evolution Teaches About IT Architecture Trade‑offs (Ahead of the 2026 SACC)

The article draws a detailed analogy between millions of years of human evolution—standing up, shedding hair, expanding the brain, and recruiting ancient bacteria—and modern IT architecture, showing how each design choice brings hidden costs, why perfect systems are impossible, and how embracing trade‑offs, extensions, and continuous iteration can lead to resilient, self‑healing databases.

Cloud Nativearchitecturedatabases
0 likes · 22 min read
What Human Evolution Teaches About IT Architecture Trade‑offs (Ahead of the 2026 SACC)
IT Services Circle
IT Services Circle
Apr 28, 2026 · Artificial Intelligence

How an AI Agent Deleted a Company’s Database in 9 Seconds – The Aftermath and Lessons

In April 2026 an AI coding assistant (Cursor powered by Claude Opus 4.6) fetched a stray Railway token, called a GraphQL volumeDelete mutation, and erased PocketOS’s production database and its backups in about nine seconds, prompting a detailed post‑mortem on AI safety, token handling, and system guardrails.

AI agentsCursorOperations
0 likes · 9 min read
How an AI Agent Deleted a Company’s Database in 9 Seconds – The Aftermath and Lessons
Senior Tony
Senior Tony
Apr 11, 2026 · Databases

Why Vectors Need a Dedicated Database and How Milvus Solves It

This article explains what vectors are, why traditional relational databases struggle with high‑dimensional similarity queries, and how the open‑source Milvus vector database efficiently stores, indexes, and retrieves massive vectors for AI applications such as semantic search, image matching, and recommendation.

AI applicationsANNMilvus
0 likes · 5 min read
Why Vectors Need a Dedicated Database and How Milvus Solves It
dbaplus Community
dbaplus Community
Mar 22, 2026 · Industry Insights

Will Data Engineers Vanish by 2030? A Bold Forecast for the Future of Data Stacks

The article predicts that by 2030 the traditional data‑engineer role and modern data‑stack components will collapse into a few unified, HTAP‑capable databases, semantic layers, and AI agents, reshaping pipelines, warehouses, and even edge computing while urging engineers to pivot toward semantic modeling and AI orchestration.

AIEdge ComputingFuture Trends
0 likes · 19 min read
Will Data Engineers Vanish by 2030? A Bold Forecast for the Future of Data Stacks
21CTO
21CTO
Mar 14, 2026 · Databases

Why SQL Is Making a Comeback: From Browsers to Backend

The article explores how three emerging trends—lightweight client‑side databases, schema‑less JSONB support, and modern synchronization engines—are reviving SQL, making it a first‑class data language for browsers, edge computing, and traditional back‑ends while preserving strong consistency and developer productivity.

JSONBSQLSynchronization
0 likes · 10 min read
Why SQL Is Making a Comeback: From Browsers to Backend
ITPUB
ITPUB
Mar 3, 2026 · Databases

Why Is Installing Modern Databases Still So Painful?

Even in 2026, installing databases like Oracle remains a complex, error‑prone process, and this article explores the historical roots, recent AI‑assisted attempts, and four key reasons why database installation still challenges engineers.

AIDevOpsInstallation
0 likes · 8 min read
Why Is Installing Modern Databases Still So Painful?
Raymond Ops
Raymond Ops
Feb 11, 2026 · Databases

Mastering Redis Memory: From Basics to Advanced Troubleshooting

This comprehensive guide walks you through the real costs of Redis memory problems, explains the three‑layer memory architecture and five major consumers, provides a toolbox of INFO and MEMORY commands plus monitoring scripts, and offers step‑by‑step solutions for seven common issues, best‑practice optimizations, real‑world case studies, a daily checklist, and advanced techniques such as Lua scripts and smart cache warm‑up.

BackendMemory Managementdatabases
0 likes · 26 min read
Mastering Redis Memory: From Basics to Advanced Troubleshooting
ByteDance Data Platform
ByteDance Data Platform
Feb 11, 2026 · Databases

How ByteHouse Redefines Real‑Time Multimodal Analytics with a Cloud‑Native Data Warehouse

ByteHouse, ByteDance's cloud‑native data warehouse, evolves from a traditional warehouse to a next‑generation AI‑ready platform that handles 800+ PB of data, supports 25,000 nodes, and delivers real‑time, multimodal analytics through a decoupled storage‑compute architecture, AI‑driven query optimization, and native vector search integration.

AI OptimizationCloud NativeReal-time analytics
0 likes · 9 min read
How ByteHouse Redefines Real‑Time Multimodal Analytics with a Cloud‑Native Data Warehouse
AntTech
AntTech
Jan 30, 2026 · Databases

Award-Winning Papers Reveal Databases, AI Typography, and Financial Benchmarks

Three award‑winning papers—OceanBase’s unitized database architecture for billion‑scale map services, a video‑diffusion‑based dynamic typography system that animates text semantically, and the FinBench LDBC financial graph benchmark—are examined, highlighting their design, experimental results, and impact on industry applications.

AIDistributed SystemsGraph Benchmark
0 likes · 6 min read
Award-Winning Papers Reveal Databases, AI Typography, and Financial Benchmarks
Sohu Tech Products
Sohu Tech Products
Jan 28, 2026 · Backend Development

How We Evolved a News App Comment System: From Threaded Views to AI‑Driven Ranking

This article details the evolution of a news‑app comment backend, covering early thread‑based displays, the transition to sharded databases and mixed adjacency‑path models, current hot‑comment ranking strategies, an in‑house experiment platform, topic aggregation via Kafka, and future AI‑driven architectural enhancements.

AIBackendComment System
0 likes · 16 min read
How We Evolved a News App Comment System: From Threaded Views to AI‑Driven Ranking
SpringMeng
SpringMeng
Jan 25, 2026 · Interview Experience

How a 40‑Minute Shower Cost Me an Offer and What I Learned from the Interview

The author recounts how a 40‑minute shower coincided with a missed offer notification, then provides a detailed set of technical interview questions covering frontend, backend, mobile, databases, cloud and AI tools, adds commentary on AI‑assisted development, and explains the final hiring decision.

AI toolsBackendHiring Process
0 likes · 6 min read
How a 40‑Minute Shower Cost Me an Offer and What I Learned from the Interview
DaTaobao Tech
DaTaobao Tech
Jan 12, 2026 · Artificial Intelligence

Top 10 AI‑Powered Development Practices from Alibaba’s Tech Teams

This article aggregates ten technical case studies from Alibaba, covering AI‑assisted code cleaning, specification‑driven development, multi‑agent front‑end automation, AI coding fundamentals, index optimization, and workflow designs that together illustrate how AI can boost efficiency across backend, frontend, and database engineering.

AIAutomationCode Generation
0 likes · 10 min read
Top 10 AI‑Powered Development Practices from Alibaba’s Tech Teams
dbaplus Community
dbaplus Community
Dec 28, 2025 · Databases

How Treating Your Database as a Compute Engine Boosted Dashboard Speed 166×

The article explains why teams mistakenly use databases merely as storage, shows a real‑world Node.js dashboard that suffered severe latency, demonstrates how moving aggregation and filtering into SQL queries eliminated N+1 and filtering issues, and presents dramatic performance gains and best‑practice guidelines.

Node.jsORMSQL
0 likes · 17 min read
How Treating Your Database as a Compute Engine Boosted Dashboard Speed 166×
Ray's Galactic Tech
Ray's Galactic Tech
Dec 27, 2025 · Databases

Why Redis Handles Millions of QPS: The Four Core Design Secrets

Redis achieves single‑machine million‑level QPS not merely because it stores data in memory, but through a tightly coordinated set of four core design principles—pure in‑memory operation, single‑threaded architecture, I/O multiplexing, and highly optimized data structures—that together deliver ultra‑low latency and massive throughput.

In-MemorySingle Threaddatabases
0 likes · 5 min read
Why Redis Handles Millions of QPS: The Four Core Design Secrets
JD Tech Talk
JD Tech Talk
Dec 3, 2025 · Databases

How DongSQL’s Syntax Extensions and Concurrency Controls Supercharge E‑commerce Performance

This article provides an in‑depth technical analysis of DongSQL’s kernel redesign—including RETURNING clause, Inventory Hint, CCL concurrency control, Statement Outline, and thread‑pool optimizations—showing how each feature dramatically improves throughput and latency for high‑traffic e‑commerce workloads.

Concurrency ControlSQLdatabases
0 likes · 12 min read
How DongSQL’s Syntax Extensions and Concurrency Controls Supercharge E‑commerce Performance
dbaplus Community
dbaplus Community
Nov 30, 2025 · Databases

How Uber Scales Database Backup and Recovery to Petabytes

This article explains how Uber built a robust, continuously backed‑up and recoverable database platform that handles tens of petabytes of data, detailing the challenges, architecture, scheduling, backup and restore frameworks, and the technology‑specific snapshot logic that enable fast RPO/RTO at massive scale.

BackupRecoveryUber
0 likes · 14 min read
How Uber Scales Database Backup and Recovery to Petabytes
Efficient Ops
Efficient Ops
Nov 30, 2025 · Databases

Why MySQL’s utf8 Isn’t True UTF‑8 and How utf8mb4 Solves It

MySQL’s original utf8 implementation was a limited, buggy version that only supported three‑byte characters, leading to data loss for emojis and rare symbols, so MySQL introduced utf8mb4 as a full UTF‑8 solution and now recommends it as the default encoding.

Character Setdatabasesencoding
0 likes · 5 min read
Why MySQL’s utf8 Isn’t True UTF‑8 and How utf8mb4 Solves It
Top Architect
Top Architect
Nov 25, 2025 · Databases

MySQL 8.0 End‑of‑Life in 2026: Migration Paths and Alternatives

With MySQL 8.0 support ending on April 30, 2026, users must migrate within six months to avoid security risks, and can choose upgrading to the latest MySQL, switching to Percona Server, or moving to alternatives like MariaDB or PostgreSQL, each with its own pros and cons.

EOLMariaDBPercona
0 likes · 7 min read
MySQL 8.0 End‑of‑Life in 2026: Migration Paths and Alternatives
Java Web Project
Java Web Project
Nov 25, 2025 · Industry Insights

What the 2025 Stack Overflow Survey Reveals About the Hottest Languages, Databases, and AI Tools

The 2025 Stack Overflow Developer Survey of over 90,000 respondents shows JavaScript still leads as the most popular language, PostgreSQL overtakes MySQL as the top database, Zig tops the high‑salary list, while ChatGPT and GitHub Copilot dominate AI tool usage, and developers anticipate workflow changes within a year.

2025AI toolsStack Overflow Survey
0 likes · 6 min read
What the 2025 Stack Overflow Survey Reveals About the Hottest Languages, Databases, and AI Tools
dbaplus Community
dbaplus Community
Nov 16, 2025 · Backend Development

How Shopify Scales 30 TB per Minute with a Monolithic Architecture

Shopify handles over 30 TB of data each minute and millions of requests by using a disciplined, modular monolithic architecture enhanced with hexagonal design, Pods isolation, real‑time data pipelines, and a heavily sharded MySQL deployment, demonstrating that simplicity can scale to internet‑level traffic without microservices.

Hexagonal ArchitectureScalabilitydatabases
0 likes · 10 min read
How Shopify Scales 30 TB per Minute with a Monolithic Architecture
Xiaolei Talks DB
Xiaolei Talks DB
Oct 22, 2025 · Databases

How to Evaluate a Database’s Long‑Term Service Capability

In a landscape crowded with OLTP, OLAP, HTAP, NewSQL and cloud‑native options, this article explains why enterprises must look beyond performance and assess a database’s five‑dimensional long‑term service capability to ensure sustainable growth and low migration risk.

Technology Selectiondatabasesenterprise architecture
0 likes · 9 min read
How to Evaluate a Database’s Long‑Term Service Capability
Meituan Technology Team
Meituan Technology Team
Oct 16, 2025 · Databases

How Meituan’s Database Capacity Evaluation System Boosts Stability and Efficiency

Meituan’s database team introduced a capacity evaluation system that uses online traffic replay in sandbox environments, accelerated replay to uncover performance bottlenecks, and a capacity‑operation loop to monitor and manage cluster resources, thereby improving database stability, safety of changes, and resource utilization.

Performance Testingcapacity planningdatabases
0 likes · 19 min read
How Meituan’s Database Capacity Evaluation System Boosts Stability and Efficiency
Big Data Technology & Architecture
Big Data Technology & Architecture
Oct 13, 2025 · Databases

Apache Doris 3.1 Unveiled: Variant, Index, and Lakehouse Boosts

The Apache Doris 3.1 release strengthens lake‑house capabilities with major upgrades to the VARIANT data type, vertical compaction, inverted index storage, new tokenizers, enhanced materialized view support for Iceberg/Paimon/Hudi, and numerous query‑performance optimizations such as faster partition pruning and dynamic partition clipping, offering smoother handling of thousands of columns and large‑scale semi‑structured data.

Apache DorisLakehouseVARIANT
0 likes · 8 min read
Apache Doris 3.1 Unveiled: Variant, Index, and Lakehouse Boosts
Senior Brother's Insights
Senior Brother's Insights
Oct 7, 2025 · Databases

Why MySQL OR Queries Often Skip Indexes—and How to Fix Them

This article explains how MySQL's OR conditions can cause index loss, provides concrete query examples, analyzes why the optimizer falls back to full table scans, and offers practical solutions such as rewriting with UNION or adding missing indexes to restore efficient index usage.

Index OptimizationOR querySQL
0 likes · 7 min read
Why MySQL OR Queries Often Skip Indexes—and How to Fix Them
Liangxu Linux
Liangxu Linux
Oct 2, 2025 · Backend Development

Backend Interview Essentials: TCP/UDP, HTTP, Linux, MySQL Indexes, C++ STL & Concurrency

The article first presents a ranking of Chinese internet companies by workplace comfort, then offers a comprehensive backend interview guide covering TCP vs UDP, HTTP protocols, Linux process commands, MySQL B+Tree indexing, C++ struct vs class differences, STL containers, and thread‑safety of maps, complete with code examples and diagrams.

Networkingdatabasesinterview
0 likes · 18 min read
Backend Interview Essentials: TCP/UDP, HTTP, Linux, MySQL Indexes, C++ STL & Concurrency
DevOps Coach
DevOps Coach
Sep 26, 2025 · Backend Development

30 Essential System Design Concepts Every Engineer Should Master

This comprehensive guide walks readers through the core building blocks of system design—from client‑server architecture, IP addressing, DNS, and proxies to databases, scaling strategies, caching, microservices, and API management—providing practical examples, diagrams, and code snippets to prepare for real‑world projects and technical interviews.

APIBackendScalability
0 likes · 31 min read
30 Essential System Design Concepts Every Engineer Should Master
dbaplus Community
dbaplus Community
Sep 6, 2025 · Fundamentals

30 Must‑Know System Design Concepts to Build Scalable, Reliable Applications

This article walks you through the 30 core system‑design concepts—from client‑server basics, IP, DNS, and load balancing to databases, sharding, caching, CAP theorem, microservices, message queues, rate limiting, API gateways and idempotency—showing how each piece fits together to create high‑performance, fault‑tolerant software.

APIScalabilitySystem Design
0 likes · 29 min read
30 Must‑Know System Design Concepts to Build Scalable, Reliable Applications
Su San Talks Tech
Su San Talks Tech
Aug 30, 2025 · Backend Development

Why Is Tencent Rated Most Comfortable? 10 Essential Backend Interview Q&A

The article first presents a comfort ranking of Chinese internet companies, highlighting Tencent as the most comfortable, then provides a comprehensive backend interview guide covering networking fundamentals, HTTP protocols, Linux process commands, MySQL indexing, C++ struct vs class, STL containers, map thread‑safety, and the differences between queues and stacks.

BackendNetworkingdatabases
0 likes · 19 min read
Why Is Tencent Rated Most Comfortable? 10 Essential Backend Interview Q&A
Xiaolei Talks DB
Xiaolei Talks DB
Aug 28, 2025 · Databases

How AI Is Transforming Databases: Highlights from China’s DTCC2025

At DTCC2025 in Beijing, industry leaders showcased AI-driven innovations, vector database advances, RAG techniques, and distributed database performance breakthroughs, illustrating how databases are evolving from passive data stores into intelligent, autonomous systems that boost efficiency, scalability, and business value across sectors.

AIDistributed SystemsRAG
0 likes · 10 min read
How AI Is Transforming Databases: Highlights from China’s DTCC2025
ITPUB
ITPUB
Aug 10, 2025 · Databases

Why Did These Database Titans Fall? Lessons from 50 Years of DB Evolution

The article chronicles half a century of database history, analyzing the rise and collapse of systems like Informix, Sybase, FoxPro, HBase, and dBase, while examining how Oracle, Microsoft, and IBM are adapting to cloud and AI, and forecasting the forces reshaping the future of data storage.

AIBig DataDatabase History
0 likes · 9 min read
Why Did These Database Titans Fall? Lessons from 50 Years of DB Evolution
Xiaokun's Architecture Exploration Notes
Xiaokun's Architecture Exploration Notes
Jul 20, 2025 · Databases

How to Achieve Linear Consistency in Single-Leader Replication: Challenges and Solutions

This article examines eventual and linear consistency in leader‑based replication, explains read‑your‑writes and shared‑data scenarios, discusses replication lag, failover trade‑offs, multi‑data‑center risks, and shows how consensus systems like ZooKeeper and etcd implement true linear consistency.

Distributed SystemsReplicationdatabases
0 likes · 13 min read
How to Achieve Linear Consistency in Single-Leader Replication: Challenges and Solutions
macrozheng
macrozheng
Jul 15, 2025 · Fundamentals

2025 Stack Overflow Survey: Hottest Languages, Databases & AI Tools Unveiled

According to the 2025 Stack Overflow Developer Survey of over 90,000 participants, JavaScript remains the top language, PostgreSQL overtakes MySQL as the most popular database, Zig tops the highest‑earning languages, Node.js and React dominate web frameworks, VS Code leads IDE usage, and ChatGPT and GitHub Copilot are the preferred AI tools.

AI toolsdatabasesdeveloper survey
0 likes · 8 min read
2025 Stack Overflow Survey: Hottest Languages, Databases & AI Tools Unveiled
Su San Talks Tech
Su San Talks Tech
Jul 13, 2025 · Fundamentals

2025 Stack Overflow Survey: Hottest Languages, Databases & AI Tools Revealed

According to the 2025 Stack Overflow Developer Survey of over 90,000 participants, JavaScript remains the top language, PostgreSQL overtakes MySQL as the most popular database, Node.js leads web frameworks, Visual Studio Code dominates IDEs, while ChatGPT and GitHub Copilot are the preferred AI tools, with developers increasingly trusting AI for coding tasks.

AI toolsWeb Frameworksdatabases
0 likes · 7 min read
2025 Stack Overflow Survey: Hottest Languages, Databases & AI Tools Revealed
Su San Talks Tech
Su San Talks Tech
Jul 10, 2025 · Fundamentals

10 Crucial System Design Trade‑offs Every Engineer Should Know

This article examines ten common system‑design trade‑offs—from vertical versus horizontal scaling and SQL versus NoSQL to consistency versus availability—explaining each option, its benefits and drawbacks, and helping engineers make informed architectural decisions.

System Designarchitecturedatabases
0 likes · 11 min read
10 Crucial System Design Trade‑offs Every Engineer Should Know
IT Services Circle
IT Services Circle
Jul 9, 2025 · Fundamentals

2025 Stack Overflow Survey: Hottest Languages, Databases & AI Tools Revealed

The 2025 Stack Overflow Developer Survey of over 90,000 participants highlights JavaScript's continued dominance, PostgreSQL overtaking MySQL as the top database, Zig as the highest‑earning language, and widespread AI tool adoption, while revealing mixed trust levels and expectations of workflow changes within a year.

AI toolsdatabasesdeveloper survey
0 likes · 5 min read
2025 Stack Overflow Survey: Hottest Languages, Databases & AI Tools Revealed
Java Captain
Java Captain
Jul 5, 2025 · Fundamentals

2025 Stack Overflow Survey: Top Languages, Databases & AI Tools

According to Stack Overflow’s 2025 Developer Survey of over 90,000 participants, JavaScript remains the most popular language, PostgreSQL tops databases, Node.js and React dominate web frameworks, Visual Studio Code leads IDE usage, while ChatGPT and GitHub Copilot are the preferred AI tools, with developers expecting AI to reshape workflows within a year.

AI toolsIDEWeb Frameworks
0 likes · 7 min read
2025 Stack Overflow Survey: Top Languages, Databases & AI Tools
Java Backend Full-Stack
Java Backend Full-Stack
Jul 3, 2025 · Interview Experience

Why the Second Question in My SF Interview Made Me Walk Away

The article shares a detailed SF interview experience, covering typical Java interview questions such as self‑introduction, challenging projects, learning paths, abstract class vs interface, HashMap vs Hashtable, insertion steps, red‑black and B+ trees, MySQL and Redis indexing choices, large‑table optimization, JVM memory model, and the purpose of the Survivor space.

Data StructuresHashMapJVM
0 likes · 23 min read
Why the Second Question in My SF Interview Made Me Walk Away
Architecture Digest
Architecture Digest
Jul 2, 2025 · Fundamentals

2025 Stack Overflow Survey: Hottest Languages, Databases & AI Tools

The 2025 Stack Overflow Developer Survey, with over 90,000 participants, shows JavaScript remains the most popular language, Zig tops the highest‑earning list, PostgreSQL overtakes MySQL as the leading database, Node.js and React dominate web frameworks, Visual Studio Code is the preferred IDE, and ChatGPT leads AI search tools, while developers anticipate AI reshaping workflows within a year.

AI toolsWeb Frameworksdatabases
0 likes · 7 min read
2025 Stack Overflow Survey: Hottest Languages, Databases & AI Tools
Java Tech Enthusiast
Java Tech Enthusiast
Jul 2, 2025 · Databases

Why MySQL GROUP BY Can Be Slow and How to Optimize It

This article explains why MySQL GROUP BY queries may run slowly, analyzes the execution plan showing temporary tables and filesort, and provides practical optimization techniques such as removing unnecessary sorting, adding indexes, adjusting buffer settings, and considering application‑level or materialized view solutions.

GROUP BYdatabasesindexing
0 likes · 4 min read
Why MySQL GROUP BY Can Be Slow and How to Optimize It
AI Large Model Application Practice
AI Large Model Application Practice
Jun 23, 2025 · Databases

How Google’s MCP Toolbox Simplifies Enterprise Database Access for LLM Agents

This guide explains Google’s open‑source MCP Toolbox for Databases, covering its core concepts, installation, configuration, two usage modes (native SDK and MCP), example LangGraph agent integration, security features, observability, and practical code snippets for building reliable LLM‑driven database tools.

LLM agentsMCP ToolboxObservability
0 likes · 11 min read
How Google’s MCP Toolbox Simplifies Enterprise Database Access for LLM Agents
IT Services Circle
IT Services Circle
Jun 21, 2025 · Backend Development

How Instagram Scaled to 14 Million Users: Inside Its Backend Architecture

This article recounts a 2009 photo‑sharing startup idea, then dives into Instagram’s backend design principles, cloud infrastructure, request flow, data storage, sharding, caching, background jobs, and monitoring, illustrating how disciplined engineering enabled rapid scaling to millions of users.

Backendclouddatabases
0 likes · 9 min read
How Instagram Scaled to 14 Million Users: Inside Its Backend Architecture
MaGe Linux Operations
MaGe Linux Operations
Jun 14, 2025 · Databases

Essential DM Database Management SQL Commands You Need to Know

This guide presents a comprehensive collection of frequently used SQL commands for managing the DM (DaMeng) database, covering version and license queries, server configuration, session monitoring, object management, tablespace handling, backup procedures, and performance tuning, all illustrated with clear examples and code snippets.

DM DatabaseDatabase AdministrationSQL Commands
0 likes · 6 min read
Essential DM Database Management SQL Commands You Need to Know
Big Data Technology & Architecture
Big Data Technology & Architecture
Jun 9, 2025 · Databases

Why Data Warebase Could Be the Next Game‑Changer for AI Workloads

The article examines how emerging data‑infrastructure trends, multi‑modal databases like Neon, Supabase, and ClickHouse, and the convergence of OLTP, OLAP, and vector search are reshaping AI workloads, introducing the Data Warebase concept that unifies warehouse and database capabilities to meet modern AI workflow demands.

AIHTAPMultimodal Retrieval
0 likes · 32 min read
Why Data Warebase Could Be the Next Game‑Changer for AI Workloads
Xiaokun's Architecture Exploration Notes
Xiaokun's Architecture Exploration Notes
Jun 8, 2025 · Databases

Why Data Replication Matters: Architectures, Formats, and Consistency Models

This article explores the principles of data replication, comparing shared memory, shared disk, and non‑shared storage architectures, detailing replication formats, consistency challenges, and various replication strategies such as synchronous, asynchronous, semi‑synchronous, and majority‑based approaches, helping engineers choose the right trade‑offs.

Asynchronous ReplicationConsistencydata replication
0 likes · 12 min read
Why Data Replication Matters: Architectures, Formats, and Consistency Models
Liangxu Linux
Liangxu Linux
Jun 2, 2025 · Operations

10 Must‑Know Ops Tools to Transform Reactive Firefighting into Proactive Management

This guide presents ten essential operations tools—including Zabbix, Prometheus, MySQL, Redis, Ansible, Jenkins, Docker, Kubernetes, LVS, and Kafka—covering monitoring, databases, automation, containerization, and load balancing, to help engineers shift from reactive firefighting to proactive, efficient system management.

AutomationContainersMessaging
0 likes · 4 min read
10 Must‑Know Ops Tools to Transform Reactive Firefighting into Proactive Management
Architect
Architect
Jun 1, 2025 · Databases

Dynamic Extension of Fields in Billion‑Row Core Tables: Architecture and Implementation

To avoid lock, page split, and index degradation when adding fields to billion‑row core tables, this article presents a practical solution that uses dynamic field extension via configurable management, JSON‑based extension fields, and an extension‑table architecture integrated with Elasticsearch for storage and retrieval.

Dynamic FieldsElasticsearchdatabases
0 likes · 10 min read
Dynamic Extension of Fields in Billion‑Row Core Tables: Architecture and Implementation
IT Services Circle
IT Services Circle
May 16, 2025 · Databases

Internship Guidance, ByteDance Three‑Round Interview Experience, MySQL Replication Mechanics, and I/O Model Overview

The article combines practical advice for fresh graduates seeking internships and interview tips, shares a detailed ByteDance three‑round backend interview experience, explains MySQL master‑slave replication stages, binlog formats, and compares blocking, non‑blocking, multiplexed, and asynchronous I/O models.

I/OReplicationSystems
0 likes · 15 min read
Internship Guidance, ByteDance Three‑Round Interview Experience, MySQL Replication Mechanics, and I/O Model Overview
Alibaba Cloud Developer
Alibaba Cloud Developer
May 15, 2025 · Databases

How PolarDB MySQL Limitless Redefines Cloud‑Native Database Performance

This article examines the architecture and innovations of Alibaba Cloud's PolarDB MySQL Limitless multi‑master cluster, detailing its cloud‑native design, high‑performance horizontal scaling, distributed transaction mechanisms, multi‑node DDL, high‑availability strategies, and record‑breaking TPC‑C benchmark results.

Cloud NativeDistributed TransactionsScalability
0 likes · 13 min read
How PolarDB MySQL Limitless Redefines Cloud‑Native Database Performance
IT Services Circle
IT Services Circle
May 6, 2025 · Databases

Efficient Strategies for Deleting Massive Data from Large Tables

This article explains the risks of bulk deletions on million‑row tables and provides a step‑by‑step guide—including pre‑deletion planning, indexing, backup, batch deletion, partitioning, table recreation, TRUNCATE, and post‑deletion verification—to safely and quickly remove large volumes of data while minimizing lock contention, log growth, CPU spikes, replication lag, and rollback complications.

Batch DeletePartitioningSQL
0 likes · 11 min read
Efficient Strategies for Deleting Massive Data from Large Tables
macrozheng
macrozheng
Apr 30, 2025 · Fundamentals

Key Questions for a Basic Infrastructure Interview: TCP, Redis, Kafka, CAP & More

This article compiles essential interview questions covering TCP connection termination, multi‑port listening, page load workflow, Redis data structures, Kafka consumer sizing and at‑most‑once semantics, the CAP theorem, Singleton usage, C++ map complexity, and a doubly linked list reversal algorithm, providing concise explanations and code examples.

AlgorithmsBackend DevelopmentDistributed Systems
0 likes · 14 min read
Key Questions for a Basic Infrastructure Interview: TCP, Redis, Kafka, CAP & More
Xiaolei Talks DB
Xiaolei Talks DB
Apr 28, 2025 · Databases

How China's DBA Landscape Is Evolving with Domestic Databases and AI

The article examines China's rapid shift toward domestic databases across finance, government, and energy sectors, highlighting how DBAs must upgrade from reactive fire‑fighting to strategic architects by mastering distributed systems, AI‑driven automation, cloud‑native tools, and open‑source community collaboration.

AIDBADistributed Systems
0 likes · 12 min read
How China's DBA Landscape Is Evolving with Domestic Databases and AI
Architecture Digest
Architecture Digest
Apr 28, 2025 · Backend Development

A Curated List of Influential Open‑Source Projects That Support Thousands of Developers

This article presents a curated collection of notable open‑source projects—including Skynet, flv.js, Tinyhttpd, Memcached, Redis, LevelDB, Libevent, SQLite, OpenResty, MeiliSearch, FreeSwitch, ffmpeg, ImageMagick, CEF, OBS Studio, VirtualApp, VideoCrafter, OpenCV, draw.io, and OpenSSL—detailing their primary functions, typical use cases, and GitHub repositories, illustrating how they have sustained large developer communities.

BackendSoftware Engineeringdatabases
0 likes · 11 min read
A Curated List of Influential Open‑Source Projects That Support Thousands of Developers
Volcano Engine Developer Services
Volcano Engine Developer Services
Apr 28, 2025 · Artificial Intelligence

How ByteBrain’s AI‑Powered Infra is Redefining Cloud and Database Performance

ByteDance’s ByteBrain team showcases how large‑model AI, operations research, and system‑level innovations have produced award‑winning papers and billions of yuan in cost savings while improving on‑call efficiency, database estimation, and cloud infrastructure reliability.

AIInfrastructure Optimizationcloud computing
0 likes · 9 min read
How ByteBrain’s AI‑Powered Infra is Redefining Cloud and Database Performance
ByteDance Data Platform
ByteDance Data Platform
Apr 25, 2025 · Databases

How ByteDance’s AQETuner Cuts Query Latency by 23% and Boosts Reliability

ByteDance Data Platform’s recent breakthroughs in database research—spanning query‑level Bayesian tuning, adaptive stream‑processing parallelism, and learned cardinality estimation—were highlighted by two papers accepted at VLDB 2025 and ICDE 2025, showcasing significant performance gains and real‑world deployments.

AIParameter Tuningcardinality estimation
0 likes · 5 min read
How ByteDance’s AQETuner Cuts Query Latency by 23% and Boosts Reliability
Top Architect
Top Architect
Apr 24, 2025 · Databases

Data Synchronization Strategies Between MySQL and Elasticsearch

This article examines why MySQL alone struggles with large‑scale, complex queries, introduces Elasticsearch as a complementary search engine, and compares several synchronization approaches—including synchronous double‑write, asynchronous double‑write, Logstash pipelines, binlog streaming, Canal, and Alibaba Cloud DTS—detailing their implementations, advantages, disadvantages, and typical use cases.

Backend DevelopmentElasticsearchdata synchronization
0 likes · 16 min read
Data Synchronization Strategies Between MySQL and Elasticsearch
21CTO
21CTO
Apr 20, 2025 · Databases

Choosing the Right Database: B‑Tree vs LSM‑Tree – A Story‑Driven Deep Dive

This article walks you through the inner workings of modern databases—explaining storage engines, query parsing, execution, and transaction models—while comparing classic B‑Tree structures with newer LSM‑Tree designs to help you decide whether SQL or NoSQL best fits your performance and consistency needs.

B+TreeLSM‑TreeStorage Engines
0 likes · 8 min read
Choosing the Right Database: B‑Tree vs LSM‑Tree – A Story‑Driven Deep Dive
ITPUB
ITPUB
Apr 13, 2025 · Operations

How Cursor Scaled Its AI Code Editor: Lessons from Indexing to Object Storage

Cursor, the AI‑powered code editor, grew to handle billions of document queries and over a hundred‑million model calls daily, prompting a multi‑stage infrastructure overhaul that moved from a failing YugaByte setup to PostgreSQL RDS, then to object‑storage‑backed databases, while tackling indexing, inference scaling, and cold‑start challenges.

AIInferenceInfrastructure
0 likes · 11 min read
How Cursor Scaled Its AI Code Editor: Lessons from Indexing to Object Storage
Xiaokun's Architecture Exploration Notes
Xiaokun's Architecture Exploration Notes
Mar 29, 2025 · Databases

Exploring Data Models: From Hierarchical to Graph and Schema-on-Read/Write

This article examines the evolution of data models—from conceptual, logical, and physical layers to hierarchical, network, relational, document, and graph structures—explaining their characteristics, implementation examples, and the contrasting schema‑on‑read versus schema‑on‑write approaches for modern data storage systems.

data modelingdatabasesgraph database
0 likes · 10 min read
Exploring Data Models: From Hierarchical to Graph and Schema-on-Read/Write
Cognitive Technology Team
Cognitive Technology Team
Mar 28, 2025 · Databases

Index Condition Pushdown (ICP) Optimization in MySQL

Index Condition Pushdown (ICP) is a MySQL query‑optimization technique that pushes eligible WHERE predicates to the storage engine so that index entries can filter rows early, reducing row fetches and server‑engine communication.

SQLdatabasesindex condition pushdown
0 likes · 5 min read
Index Condition Pushdown (ICP) Optimization in MySQL
Ma Wei Says
Ma Wei Says
Feb 10, 2025 · Databases

How Redis Handles Expired Keys: Periodic vs Lazy Deletion Strategies

This article explains Redis's two expiration mechanisms—periodic scanning with configurable frequency and lazy deletion on client access—detailing their configurations, execution steps, performance trade‑offs, and replication pitfalls to help developers manage memory efficiently.

ExpirationLazy DeletionMemory Management
0 likes · 5 min read
How Redis Handles Expired Keys: Periodic vs Lazy Deletion Strategies
JD Cloud Developers
JD Cloud Developers
Feb 5, 2025 · Databases

Cutting Procurement Query Times by 92%: Data Heterogeneity & ES Strategies

This case study details how the BIP procurement system tackled massive data volume, complex queries, and slow SQL by segmenting inbound orders, leveraging Elasticsearch, introducing a dynamic routing layer, and implementing robust ES high‑availability and monitoring, ultimately reducing query load by over 90%.

Big DataPerformance Optimizationdata modeling
0 likes · 14 min read
Cutting Procurement Query Times by 92%: Data Heterogeneity & ES Strategies
dbaplus Community
dbaplus Community
Jan 20, 2025 · Databases

What’s New in the Database World? 2024 H2 Industry Review and Key Product Updates

The 2024 second‑half database industry review highlights accelerated growth, AI‑database integration, multimodal support, storage‑compute separation, and a comprehensive roundup of major product releases and feature enhancements across RDBMS, NoSQL, NewSQL, cloud, and big‑data ecosystems, with links to detailed changelogs and download resources.

AI integrationBig DataCloud Databases
0 likes · 50 min read
What’s New in the Database World? 2024 H2 Industry Review and Key Product Updates
Top Architect
Top Architect
Jan 17, 2025 · Databases

MySQL to Elasticsearch Data Synchronization Strategies: Sync Write, Async Write, Logstash, Binlog, Canal, and DTS

This article explains various methods for synchronizing data between MySQL and Elasticsearch—including synchronous and asynchronous double‑write, Logstash pipelines, real‑time Binlog replication, Canal parsing, and Alibaba Cloud DTS—detailing their implementation approaches, advantages, disadvantages, and typical application scenarios.

CanalElasticsearchLogstash
0 likes · 16 min read
MySQL to Elasticsearch Data Synchronization Strategies: Sync Write, Async Write, Logstash, Binlog, Canal, and DTS
JD Tech
JD Tech
Jan 9, 2025 · Databases

Challenges and Practices of Distributed Data Systems: Master‑Slave Replication, Partitioning, and High‑Availability Strategies

This article examines the core challenges of distributed data systems—including consistency, availability, and partition tolerance—then details master‑slave replication mechanisms for MySQL and Redis, various replication modes and binlog formats, and explores data partitioning, sharding, and hot‑key mitigation techniques for scalable, high‑availability deployments.

Replicationdatabaseshigh availability
0 likes · 23 min read
Challenges and Practices of Distributed Data Systems: Master‑Slave Replication, Partitioning, and High‑Availability Strategies
Java Tech Enthusiast
Java Tech Enthusiast
Dec 31, 2024 · Backend Development

Tencent Backend Interview Experience and Technical Knowledge Summary

The article details Tencent’s updated 15‑month compensation packages for 2025 backend roles, outlines a one‑hour interview covering OS process/thread concepts, sorting algorithms, MySQL storage engines and indexing, Redis data structures, Java collections, and compares RocketMQ with Kafka for reliable messaging.

Data StructuresInterview PreparationOperating Systems
0 likes · 27 min read
Tencent Backend Interview Experience and Technical Knowledge Summary
macrozheng
macrozheng
Dec 26, 2024 · Databases

Master DBeaver: Free Open‑Source Tool for Managing 100+ Databases

This guide introduces the open‑source DBeaver database manager, walks through downloading, installing, and configuring it, demonstrates its use with a SpringBoot3 + Vue e‑commerce project, and covers theme settings, data source creation, table operations, SQL editing, and its support for various database types.

DBeaverDatabase ManagementSQL
0 likes · 7 min read
Master DBeaver: Free Open‑Source Tool for Managing 100+ Databases
21CTO
21CTO
Dec 21, 2024 · Artificial Intelligence

What Were the Top 10 Software Development Breakthroughs of 2024?

This roundup reviews the ten most impactful software development news of 2024, covering .NET 9, OSI's open‑source AI definition, Anthropic's Claude updates, PostgreSQL 17, Swift 6, NIST's post‑quantum encryption standards, VS Code .NET MAUI support, OpenAI's GPT‑4o, GitHub Copilot Workspace, and IBM's acquisition of HashiCorp.

databasessoftware development
0 likes · 11 min read
What Were the Top 10 Software Development Breakthroughs of 2024?
IT Services Circle
IT Services Circle
Dec 20, 2024 · Backend Development

Comprehensive Backend Development Interview Notes: OS Memory, Concurrency, Networking, Databases, Redis, Kafka, and Docker

This article compiles detailed backend interview notes covering salary expectations, OS stack vs heap differences, process and thread concepts, DNS resolution, ping protocol, MySQL indexing and locking mechanisms, Redis performance characteristics, Kafka throughput optimizations, and Docker's underlying implementation.

BackendDockerNetworking
0 likes · 17 min read
Comprehensive Backend Development Interview Notes: OS Memory, Concurrency, Networking, Databases, Redis, Kafka, and Docker
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
Dec 20, 2024 · Databases

11 Proven Ways to Keep Redis Lightning‑Fast and Avoid Latency

This guide presents eleven practical recommendations—including avoiding large keys, disabling costly commands, using UNLINK, enabling lazy free, batching operations, and configuring connection pools—to help developers maintain Redis performance and prevent latency spikes in production environments.

Performance OptimizationSpring Bootcaching
0 likes · 13 min read
11 Proven Ways to Keep Redis Lightning‑Fast and Avoid Latency
System Architect Go
System Architect Go
Dec 15, 2024 · Operations

A Structured Framework for Optimizing System Components

This article presents a comprehensive framework for optimizing system components such as databases, caches, message queues, and search engines, covering environment configuration, data structure organization, client‑side usage, and inter‑component collaboration, illustrated with MySQL, Redis, Kafka, and Elasticsearch examples.

SearchSystem optimizationcaching
0 likes · 6 min read
A Structured Framework for Optimizing System Components
21CTO
21CTO
Dec 11, 2024 · Operations

8 Essential Strategies to Build Scalable Systems

This article outlines eight crucial strategies—including stateless services, horizontal scaling, load balancing, auto‑scaling, caching, database replication, sharding, and asynchronous processing—to help engineers design systems that handle growing traffic without sacrificing performance or reliability.

System Designdatabases
0 likes · 9 min read
8 Essential Strategies to Build Scalable Systems
Top Architect
Top Architect
Dec 9, 2024 · Databases

Database Monitoring and Slow Query Log Management Guide

This article provides a practical guide on monitoring database system resources using Linux commands, configuring MySQL slow query logging, analyzing performance issues, and outlines best practices, while also promoting a ChatGPT community and related services.

DevOpsdatabaseslogging
0 likes · 7 min read
Database Monitoring and Slow Query Log Management Guide
Python Programming Learning Circle
Python Programming Learning Circle
Nov 19, 2024 · Databases

Overview of Lightweight Python Databases and Their Usage

This article surveys several lightweight Python databases—including PickleDB, TinyDB, ZODB, Durus, Buzhug, Gadfly, and PyTables—detailing their main features, typical use cases, cautions, and providing basic code examples to help developers choose and apply the right storage solution for small‑scale or prototype projects.

NoSQLObject PersistencePython
0 likes · 23 min read
Overview of Lightweight Python Databases and Their Usage
AntData
AntData
Nov 18, 2024 · Databases

Modern Data Paradigms: From Relational Databases to Vector Retrieval and AI

This article surveys the evolution of modern data technologies—from the 4V characteristics of big data and the limitations of traditional relational databases, through the rise of NoSQL and polyglot persistence, to embedding‑driven vector search, hybrid retrieval and RAG, illustrating how each paradigm frees applications from data constraints.

Big DataData ArchitectureEmbedding
0 likes · 30 min read
Modern Data Paradigms: From Relational Databases to Vector Retrieval and AI
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 11, 2024 · Databases

New JSON Format for EXPLAIN and EXPLAIN ANALYZE in MySQL 8.3+

MySQL 8.3 introduces a new iterator‑aware JSON output for EXPLAIN and EXPLAIN ANALYZE, selectable via the explain_json_format_version variable, which aligns JSON with the tree format, provides richer execution statistics, and can be accessed programmatically through EXPLAIN INTO across all recent MySQL releases.

JSONdatabasesexplain
0 likes · 11 min read
New JSON Format for EXPLAIN and EXPLAIN ANALYZE in MySQL 8.3+
Efficient Ops
Efficient Ops
Oct 23, 2024 · Databases

How NineData Boosts R&D Collaboration 5× with Multi‑Cloud Database Management

The NineData presentation at the 2024 GOPS Global Operations Conference in Shanghai detailed multi‑cloud, multi‑source database architecture trends, showcased their intelligent data management platform, explained data replication principles, DevOps challenges and AI‑enhanced solutions, and highlighted real‑world customer success stories across industries.

AICloud NativeDevOps
0 likes · 11 min read
How NineData Boosts R&D Collaboration 5× with Multi‑Cloud Database Management
Baidu Intelligent Cloud Tech Hub
Baidu Intelligent Cloud Tech Hub
Oct 14, 2024 · Databases

How Baidu’s New Cloud‑Native Databases Power Enterprise AI in 2024

At the 2024 Baidu Cloud Summit, the speaker detailed recent breakthroughs across Baidu’s cloud‑native database suite—including PegaDB KV, GaiaDB relational, VDB vector, and the integrated DBSC, EDAP, and DBStack platforms—highlighting performance, cost, scalability, and AI‑ready features that address enterprise data challenges.

AIBig DataEnterprise Data
0 likes · 11 min read
How Baidu’s New Cloud‑Native Databases Power Enterprise AI in 2024
AntTech
AntTech
Oct 12, 2024 · Artificial Intelligence

Observations from ISSTA 2024: Conference Highlights, Awarded Papers, Keynotes, and In‑Depth Reviews

The article reports on the 33rd ISSTA 2024 conference in Vienna, summarizing its acceptance statistics, highlighting the Impact Paper Award and Distinguished Papers, detailing keynotes on large‑language‑model‑driven software quality, and providing extensive reviews of selected research works ranging from fuzzing and program repair to database query simplification and AI‑oriented code generation.

ISSTA2024LLMProgramRepair
0 likes · 29 min read
Observations from ISSTA 2024: Conference Highlights, Awarded Papers, Keynotes, and In‑Depth Reviews
Java Architecture Stack
Java Architecture Stack
Sep 25, 2024 · Databases

When to Use NOT NULL vs NULL in Database Design: Practical Guidelines

This article explains when to use NOT NULL versus NULL in relational database schemas, covering required fields, optional columns, unknown‑state representation, foreign keys, performance impact, versioning, data analysis, migration, default values and JSON types, with concrete SQL examples and practical guidance.

JSONSQLdata integrity
0 likes · 13 min read
When to Use NOT NULL vs NULL in Database Design: Practical Guidelines