This article explains how PostgreSQL’s process architecture allows existing connections to continue operating and persist data even when the postmaster (main) process crashes, demonstrates the behavior with step‑by‑step experiments, and discusses the limitations and monitoring implications.
The interview explores how Ctrip adapts its travel services for Apple Watch, detailing the specific features offered, the design considerations for business travelers, and the technical challenges and opportunities of extending a mobile travel platform onto a wearable device.
This article recounts how TalkingData progressively introduced Spark into its Hadoop‑YARN based mobile big‑data platform, detailing early architectures, migration challenges, performance gains, the fully Spark‑centric redesign with Kafka and Spark Streaming, encountered pitfalls, and future plans for further optimization.
This article explains the concept of Single Sign-On (SSO), why it’s essential for large web platforms, the core steps of storing and validating trust, common cookie‑based approaches, their security drawbacks, and how server‑side solutions using distributed caches and digital signatures can provide a robust, cross‑domain authentication system.
This article explains why using SELECT * is problematic and demonstrates a simple technique—adding a computed column that triggers a divide‑by‑zero error—to block SELECT * queries while still allowing column‑specific selections.
This article outlines the UIOC (Urgent Incident Office Center) process, detailing a six‑step workflow, multi‑team collaboration tactics, common troubleshooting methods, and pitfalls to avoid, helping operations teams achieve 99.99% availability while handling emergencies efficiently.
This article presents a detailed case study of an Oracle RAC system performance bottleneck, walks through comprehensive monitoring, storage and partitioning analysis, and outlines a step‑by‑step optimization plan—including KEEP pool tuning and partition redesign—that dramatically improved I/O latency and overall throughput.
Senior DBA and architect Bai Shan answers community questions on advancing from DBA to architect, future career routes, testing environment setup, interpreting AWR storage metrics, using sar and iostat for disk I/O monitoring, cache sizing, and the growing importance of automation in cloud-era database operations.
This article explains what system load capacity is, how to measure it using requests per second, identifies key factors such as bandwidth, hardware, OS and server configurations, and provides practical tuning steps for Linux, TCP, Nginx, Tomcat and databases to improve scalability.
An in‑depth guide walks readers through building a comprehensive monitoring system for small‑to‑medium enterprises, covering hardware, system, application, network, security, traffic analysis, business metrics, log aggregation, automation, visualization, and practical integration with tools like Zabbix, IPMI, ELK, and Smokeping.
Caching dramatically improves website performance by storing data in memory for faster responses and reducing database load, with Memcached and Redis as popular solutions; proper routing algorithms like consistent hashing are essential to scale clusters without causing cache misses or service disruption.
The article examines why product‑focused founders often stumble as their companies scale, outlining three failure causes—including lack of desire to be CEO, board panic, and the Product‑CEO paradox—and offers practical strategies for CEOs to stay visionary while avoiding over‑control.
The article traces the history of the legendary "Hello World" program—from Brian Kernighan's 1978 C book and its early B-language roots, through its cultural symbolism, to the hardware breakthroughs that helped it become a universal first program for generations of developers.
The article explores the definition of a programmer, outlines essential skills and daily responsibilities, discusses common career pitfalls, and provides practical advice on personal branding and professional growth for software developers.
This article traces Node.js’s evolution from a modest 2009 V8‑based runtime to a dominant backend platform, highlighting npm’s impact, its event‑driven, non‑blocking architecture, real‑world strengths and limitations, and why careful evaluation is essential before adopting it.
This article introduces Erlang as a general‑purpose concurrent language, highlighting its fault‑tolerant runtime, simple 550‑line syntax, pattern‑matching capabilities, process creation with spawn, and practical examples using the ibrowse HTTP library to demonstrate message passing and distributed computing.
In a lively Q&A session, industry experts discuss the relationship between Docker and IaaS, share best‑practice guidelines for container deployment, examine emerging standards like OCI and CNCF, and forecast the next five years of infrastructure evolution.
This guide explains how QQ Browser’s WeChat debugging tool lets developers run and test their server code locally without an external domain, by generating a public URL that forwards messages from the WeChat server to the local program.
This article traces the evolution of Weibo's recommendation architecture across three major phases—independent 1.0, layered 2.0, and platform‑centric 3.0—detailing the driving business and technical factors, architectural components, advantages, shortcomings, and key outcomes of each stage.
This article demonstrates how to use strace, including its -c, -T, and -e options, to identify kernel‑level system calls such as clone that cause high CPU consumption in PHP processes on a Linux server, providing step‑by‑step commands and interpretation of the results.
