0 views collected around this technical thread.
The article examines SQL's recent drop to 12th place in the TIOBE June 2025 ranking, recounts its historical highs and removal from the list, highlights its pervasive use in everyday systems, and discusses how the rise of AI and NoSQL databases may reshape its future role.
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.
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.
DuckDB's DuckLake is an open‑standard, SQL‑driven data lake and catalog format that simplifies lakehouse architecture by managing metadata in a database while storing data in scalable Parquet files, offering multi‑user collaboration, time‑travel queries, and MIT licensing.
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.
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.
An investigation reveals that MySQL treats trailing spaces in VARCHAR values as insignificant during string comparison, causing queries like SELECT * WHERE name='Tom' to match rows with extra spaces, and demonstrates that using the BINARY keyword restores exact matching, highlighting a potential bug in MySQL 5.7.
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.
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.
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.
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.
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.
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.
This guide explains Elasticsearch Index Lifecycle Management (ILM), detailing its five phases, the actions available in each stage, the criteria for phase transitions, and step‑by‑step configuration through Kibana and API commands, helping engineers automate index handling and reduce manual maintenance.
This article explains how to monitor system resources using commands like top, iostat, and vmstat, shows how to enable and view MySQL slow query logs, offers troubleshooting tips, and also promotes a ChatGPT community with related services and offers.
This article details how JD’s BIP procurement system tackled massive data volume and complex query performance issues by reducing slow SQL, partitioning “in‑stock” orders, migrating large datasets to Elasticsearch, implementing dynamic query routing, and establishing robust monitoring, resulting in a 92% data reduction and smoother operations.
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.
The article shares a personal Ctrip referral story, recent campus‑recruitment salary figures, and a comprehensive interview guide covering C++ vs Java differences, memory layout, OS concepts, networking fundamentals, database indexing, and a classic min‑stack algorithm problem.
This article combines a look at Tencent Cloud Zhiy developer salaries and interview insights with in‑depth explanations of OS memory allocation, process vs thread vs coroutine, DNS resolution, MySQL indexing and locking, Redis speed factors, Kafka’s high throughput design, and Docker’s container architecture, plus resource links.
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.