This article shares practical MongoDB indexing guidelines—including compound index rules, naming limits, cardinality considerations, TTL and geospatial indexes, lock behavior, and real‑world case studies—to help DBAs and developers design efficient, safe indexes for production workloads.
This guide explains how to clean redundant fields, restructure a massive MySQL table, batch‑fetch data with LIMIT, rewrite slow queries, and compare three insertion methods—including prepared statements and bulk inserts—to cut migration time from hours to under 20 minutes.
This guide explains why ORA-38706 and ORA-38707 occur when Flashback Database is turned on, shows how to switch the Oracle database to ARCHIVE mode, and provides step‑by‑step SQL commands to enable Flashback and verify the configuration.
An embedded‑system developer discovers that FatFs reports FR_NO_FILESYSTEM on a correctly formatted SD card because the card’s partition information resides in the fourth MBR entry, which FatFs only checks in the first entry, and resolves the issue by re‑formatting with f_mkfs or upgrading to FatFs V0.10.
The article examines common pitfalls and best‑practice solutions for traditional enterprises building e‑commerce platforms that must handle traffic spikes, covering large‑scale query optimization, distributed architecture, database design, service degradation strategies, and comprehensive monitoring and operations.
This guide explains how to set up and use a Python script that highlights specified log keywords with colors in the terminal, including configuring the script, adding aliases in .zshrc or .bashrc, piping command output through the script, and tips for grep buffering and Python line reading.
This article explains the PageRank algorithm, illustrates its principles with a loan‑club trust‑score example, and shows how to compute and analyze PageRank on large graphs using the Graphene platform, including detailed SQL steps and performance comparisons.
The article explains when MySQL sharding is needed, outlines five practical principles for deciding to split databases or tables, provides real‑world examples, and shares operational tips for implementing horizontal partitioning to improve performance, availability, and manageability.
The article examines agentless backup technology, comparing its implementation in virtualized and physical environments, detailing supported interfaces, evaluating a real‑world Asigra Cloud Backup case, and discussing security risks, performance impacts, and when traditional agents remain necessary.
This article reviews major open‑source log collection tools—Chukwa, Scribe, Flume, Logstash, Kafka, and TT—examining their architectures, strengths, and limitations to help engineers select the most suitable solution for high‑volume, low‑latency data pipelines.
This guide walks through securing an Nginx web server by configuring buffer size limits, timeouts, concurrent connection controls, host and method restrictions, user‑agent blocking, hot‑link protection, directory access rules, SSL setup, PHP hardening, chroot isolation, and firewall‑level IP connection limits.
In this talk, Alipay engineers reveal how their mobile app achieves ultra‑reliable, low‑latency wireless performance through a layered network architecture, custom protocols like MMTP and MTLS, traffic‑aware load balancing, and data‑driven operations, illustrating strategies that can reduce transaction failures by a thousandth and scale to billions of daily payments.
This article examines the evolution from traditional monolithic access security to modern microservice architectures, outlines key design principles, compares four common authentication schemes, and demonstrates a Spring Cloud Security implementation using OAuth2 and UAA for fine‑grained, token‑based protection.
This article explains Android performance testing challenges, details ANR causes and types, describes tools like TraceView and ANR‑WatchDog, and introduces VSync‑based smoothness metrics using Choreographer to detect frame skips and improve app responsiveness.
The article reviews the evolution, challenges, and commercial and open‑source deep learning platforms—including DistBelief, COTS, Adam, MXNet, TensorFlow, and Petuum—while highlighting real‑world applications such as image recognition, recommendation, sentiment analysis, and crowd monitoring.
This guide explains how to use Parallel SSH (PSSH) to execute commands, copy files, and synchronize directories across multiple servers, including installation steps and configuring password‑less SSH for streamlined server management.
PhxSQL is an open‑source MySQL cluster that uses Paxos to provide Zookeeper‑level linearizable consistency and high availability while remaining fully compatible with MySQL, offering read‑write and read‑only ports, minimal MySQL intrusion, simple architecture, and detailed design principles compared to alternatives like Galera and MySQL Group Replication.
The article analyzes the technical challenges of massive e‑commerce traffic spikes such as Double 11 and presents a three‑pillar architecture—fast front‑end delivery, stable back‑end services, and dazzling real‑time analytics—using CDN caching, database optimizations, load‑balancing, system decoupling, and cloud‑native components.
This article details the evolution of Taobao’s homepage over two years, covering its migration from PHP to Node, the modular building platform, performance optimizations, stability mechanisms, and agile operational practices that keep billions of daily page views fast and reliable.
The article explains how MySQL’s ease of use, open‑source nature, early replication support, flexible storage‑engine architecture, and strong community contributions have driven its widespread adoption and sustained popularity in modern high‑concurrency, high‑availability applications.
