In this expert Q&A, two leading Chinese database specialists discuss why MySQL’s major releases lag behind Oracle’s, examine the influence of Alibaba on MySQL’s domestic growth, and explore the broader implications for the Chinese open‑source database ecosystem.
This article explains how to generate red packets, calculate random amounts, and handle user grabbing and opening actions while ensuring high‑concurrency safety using atomic CAS operations in a cache to prevent oversubscription.
This guide explains how to choose the right forum or mailing list, write clear and concise subject lines, provide detailed yet focused problem descriptions, use proper formatting, and follow etiquette so that your technical questions receive helpful responses from the community.
The article analyzes the use of a master/slave architecture for distributed caching, explains why two clusters, CAS, and proxy are employed, discusses consistency and availability challenges, and evaluates possible mitigation strategies for cache failures.
This article explains the characteristics and usage scenarios of B-Tree and Hash indexes in MySQL, including supported operators, example queries, when indexes are applied or ignored, and performance considerations for different storage engines such as MEMORY.
This guide explains how VMware Workstation simulates physical network devices, sets up virtual NICs and switches, and uses DHCP and NAT services to enable guest VMs to communicate internally, bridge to the host network, or access the Internet.
Xen is an open‑source hypervisor developed at Cambridge that enables running up to 128 modified operating systems on a single machine, with components including the Xen Hypervisor, Dom0 and DomU, and supports full, para‑virtualization, hardware‑assisted virtualization, and various I/O and network virtualization methods.
This article chronicles the historical shift from early hierarchical data models to relational SQL, the rise of NoSQL, and the emergence of NewSQL solutions like Alibaba's DRDS, illustrating key concepts with diagrams, code examples, and a detailed Q&A.
An in‑depth look at 360’s long‑connection push platform built with Go, covering system architecture, key performance indicators, scalability challenges, optimization strategies, operational practices, and practical Q&A for building reliable, high‑throughput messaging services.
Registers outrun main memory because they sit closer to the CPU, employ high‑performance hardware designs, and involve far fewer access steps, a distinction illustrated with examples from iPhone 5s architecture and detailed step‑by‑step memory access processes.
The article dissects Luo Yonghao’s recent smartphone launch, exposing how overreliance on personal charisma, compromised branding, rushed product design, and flawed market positioning turned the ‘Smartisan’ venture into a costly compromise, and draws broader lessons about product management, brand integrity, and the perils of low‑price hardware strategies.
Facebook’s web team revisited Yahoo’s 2007 cache research, measuring how often PC and mobile browsers serve resources from cache today, discovering that roughly 45% of requests still miss the cache and that cache lifetimes are short, prompting new optimization recommendations.
This article summarizes a live Q&A where experts compare MySQL official, MariaDB, and Percona branches, discuss the pros and cons of each, and explore how MySQL DBAs can balance source‑code knowledge with operational expertise to advance their careers and influence architecture and business integration.
This article explains the step‑by‑step order in which MySQL processes a SELECT statement, detailing how each clause creates a virtual table that feeds into the next operation until the final LIMIT result is returned to the user.
This article explains how to formulate technical questions so that experienced hackers and community members are more likely to provide helpful answers, emphasizing prior research, clear presentation, humility, and demonstrating effort to avoid being perceived as a 'loser' who merely demands solutions.
This article introduces SQLite, a lightweight ACID‑compliant relational database widely used in mobile devices, detailing its zero‑configuration design, key features, limitations, transaction and locking mechanisms, and the Write‑Ahead Logging mode that enables concurrent reads and writes.
Google's Go 1.5 release replaces the traditional C compiler with a native Go compiler, introduces major performance and garbage‑collection improvements, and crucially adds support for the ARM architecture that dominates smartphones, enabling developers to write high‑performance mobile applications in Go.
Drawing on Will Larson’s insights, this article outlines essential principles for building horizontally scalable systems—including linear capacity growth, redundancy, load‑balancing techniques, caching strategies, CDN usage, offline processing with message queues, and the benefits of a dedicated platform layer for robust, maintainable backend architectures.
This article examines why cloud virtual machines can achieve lower failure rates than physical servers by leveraging large‑scale operations, kernel optimization, hot‑patching, live migration, and proactive hardware quality management, while highlighting the challenges smaller organizations face.
DRBD (Distributed Replicated Block Device) is a software‑based, network‑driven block replication solution that mirrors disks, partitions, or logical volumes across servers in real time, offering synchronous and asynchronous modes, transparent failover, and a middle‑layer between the filesystem and physical storage.
