Olery’s journey from a mixed MySQL‑MongoDB setup to a PostgreSQL‑centric architecture reveals the pitfalls of schema‑less storage, the criteria for a robust database, a three‑stage migration process, and measurable performance gains across its services.
This article explains how to count paid and unpaid orders per user‑product pair in PostgreSQL by aggregating order statuses into arrays, using a sub‑query with GROUP BY and a CASE expression to produce accurate payment success and total order counts.
The article examines the evolution of database technologies—from traditional relational databases and their ACID guarantees to NoSQL, NewSQL, and Hadoop—illustrating how a gaming company can combine these solutions to handle massive online traffic, ensure data integrity, and enable advanced analytics.
Yelp’s infrastructure team tackled HAProxy’s reload‑induced packet loss by leveraging Linux’s plug qdisc and iptables to delay SYN packets during reloads, enabling zero‑downtime service updates and improving reliability despite the kernel’s brief binding window.
This article explains how LinkedIn uses Apache Kafka as a high‑throughput, fault‑tolerant messaging backbone, detailing its architecture, message categories, layered replication, audit mechanisms, and the engineering practices that keep billions of daily messages reliable and fast.
The article explains why Kafka introduced high availability starting with version 0.8, detailing the need for data replication and leader election, describing replica distribution algorithms, replication mechanics, ISR handling, ZooKeeper structures, and the broker failover process to ensure fault‑tolerant streaming.
This article explains how to leverage PostgreSQL's unnest and string_to_array functions to split a comma‑separated 'arrive' column and efficiently query for popular island destinations such as Maldives, Phuket, Bali, and others without writing complex regular expressions.
This guide explores advanced Python design structures—including list comprehensions, generator expressions, zip processing, decorators, context managers, descriptors, metaclasses, and common patterns—explaining their syntax, best‑practice usage, memory implications, and providing clear code examples for each concept.
This guide compiles essential Linux kernel sysctl settings, Nginx performance tweaks, MySQL configuration for 8 GB RAM, Tomcat connector optimizations, and hardware load monitoring commands to help you fine‑tune a production server for maximum throughput and stability.
RethinkDB 2.0, released after five years of development, brings over 2,000 improvements, live query support, distributed scaling, new driver integrations, and enterprise services, and is already powering real‑time applications for companies ranging from startups to Fortune 500 firms.
The article details Zoosk's real-time communication system, describing member presence, notifications, instant messaging, the XMPP‑based Tigase server cluster, BOSH support, monitoring scripts, performance metrics, business intelligence reporting, and future plans to extend RTC to mobile web applications.
The article explains how to calculate the total number of possible flight‑hotel combinations for travel packages by defining a custom multiplicative aggregate function in PostgreSQL, provides the SQL code, demonstrates its usage with examples, and discusses its practical advantages for flexible grouping.
The 2015 Beijing QCon highlighted four technical talks covering asynchronous processing in distributed systems, the DRC data‑replication infrastructure, minute‑level high‑availability fault recovery, and cloud‑era database operations, illustrating Alibaba's approaches to scalability and reliability in modern cloud platforms.
This article reviews common instant‑messaging protocols, compares popular IM servers such as Openfire, Tigase and Ejabberd, and proposes practical improvements to XMPP handling, server performance, and mobile IM challenges, while also evaluating third‑party services and offering deployment time estimates.
The article details Ctrip's mobile app network architecture, common performance bottlenecks such as DNS, TCP, and payload issues, and presents six practical optimization techniques—including DNS caching, network‑quality detection, service prioritization, retry mechanisms, payload compression, and overseas CDN improvements—that collectively reduced latency by 150‑200 ms and raised service success rates above 99 %.
Although the program uses java.util.Random with different seed values, each execution prints the same 'Hello world' because the Random instances are initialized with fixed seeds, causing the pseudo‑random generator to produce identical sequences that map to the characters forming the phrase.
This article explains HDFS's design goals, master/slave architecture, namespace management, block replication strategies, fault tolerance mechanisms, metadata persistence, communication protocols, robustness features, data organization, access methods, and space reclamation, providing a comprehensive overview of Hadoop's distributed storage system.
This article provides a comprehensive set of macOS performance optimizations—including disabling local Time Machine backups, turning off hibernation, adding the noatime mount option, configuring RAM‑based temporary and cache directories, and disabling unnecessary SSD features—to improve system responsiveness and battery life.
EasyXMS is a simple, lightweight Python script that enables multithreaded batch command execution and file uploads across multiple Linux/Unix servers, offering easy installation, encrypted configuration storage, and comprehensive logging for efficient server operations.
This guide shares ten practical fault‑management techniques—ranging from proactive attitude and prioritizing incidents to continuous follow‑up and team collaboration—to help operations teams reduce damage, maintain service reliability, and keep users engaged during outages.
