This article reviews a decade‑long evolution of backend engineering—from early LAMP stacks to modern micro‑services, middleware, cloud, big data, AI, and containerization—explaining why new developers need to understand each layer's role in today’s complex internet systems.
A collection of vivid DBA anecdotes reveals common pitfalls—from missed alerts and accidental production restarts to unsafe terminal habits—and distills practical safeguards that any database operator can adopt to avoid costly mishaps.
This article examines why modern businesses rely on databases, explains the concept and advantages of open‑source software, and provides a detailed comparison of three popular open‑source databases—PostgreSQL, MariaDB, and Percona—highlighting their strengths, weaknesses, and ideal use cases.
The March 2019 database popularity ranking shows Oracle, MySQL, and SQL Server all gaining points, with MySQL leading the surge, Oracle’s rise linked to its new 19c release, and PostgreSQL experiencing its first decline in six months.
This guide outlines essential Java engineering skills—from distributed architecture and algorithms to advanced JVM concepts—and provides a curated collection of recent Alibaba interview questions to help developers with 1‑5 years of experience prepare effectively.
This article outlines Meituan’s transition of its database platform from manual, script‑based operations through tool‑ and product‑centric stages to a private‑cloud and automation era, discusses current challenges such as root‑cause analysis and staffing, and shares insights on moving toward fully intelligent, data‑driven database operations.
This article explains the differences between row‑oriented and column‑oriented storage, compares their trade‑offs, and introduces HBase’s column‑family architecture, including row keys, column qualifiers, timestamps, cells, and how it maps to a multi‑dimensional map structure.
The article recounts a pre‑promotion MySQL replication incident at JD.com, explains the master‑slave architecture and thread roles, identifies slow‑SQL and missing indexes as root causes of replication lag, and proposes practical measures to reduce latency and improve system stability.
This article introduces the open‑source DBLE distributed middleware, provides official resource links, outlines its main configuration files—including server.xml, schema.xml, and rule.xml—explains the role of schema.xml for sharding, and presents a detailed example with code and diagrams to help users configure DBLE effectively.
This guide outlines the ten core competencies—from data structures and version control to IDEs, databases, Unix, Excel, programming languages, networking, and scripting—that every new or aspiring software developer should master to build a successful career.
The January 2019 DB-Engines newsletter compiles the newest releases, feature highlights, and performance improvements across RDBMS, NoSQL, NewSQL, time‑series, big‑data, domestic, and cloud database families, while also explaining the ranking methodology and providing download links for the full issue.
This comprehensive guide outlines the mindset, methodology, general and professional skills, core architectural concepts, design principles, and essential tools needed for anyone aspiring to become a proficient software architect in modern technology environments.
This article explains how Alibaba transformed its database infrastructure through hybrid‑cloud high‑performance ECS, container‑based multi‑instance deployment, and a user‑space storage‑compute separation architecture with RDMA, dramatically improving resource utilization, scaling speed, and cost efficiency for massive traffic spikes.
This talk details Ele.me’s three‑month rollout of a dual‑active (multi‑active) database system, covering design principles, architecture, migration steps, challenges such as data consistency and DDL handling, the tools built (DRC, D‑Bus, DCP, EMHA), and the performance and reliability benefits achieved.
This article introduces Zhuanzhuan's multi‑service storage layer—including MySQL, TiDB, ZZRedis, ZZKV/ZZList, and ZZOS—detailing their applicable scenarios, architectural designs, and the improvements made to address scalability, security, and resource‑usage challenges.
This article presents a set of 14 multiple‑choice and short‑answer questions covering database indexing, locking mechanisms, DELETE behavior, network protocols, OSPF LSA types, Linux signals, port inspection, list deduplication, Python data structures, class inheritance, HTTP GET/POST differences, site reliability improvements, and hash function evaluation.
In November 2018, ACM honored Alibaba Damo Academy’s chief database scientist Li Fei‑Fei with the Distinguished Scientist award, recognizing his pioneering work on distributed, intelligent, and secure database systems, his transition from academia to industry, and his vision for future cloud‑native database technologies and academia‑industry collaboration.
This article examines why traditional relational databases like MySQL struggle with analytical workloads, compares ROLAP and MOLAP approaches, explains Spark’s architecture and its advantages for OLAP, and details how Alibaba Cloud’s DRDS HTAP leverages a Spark‑based engine to deliver real‑time distributed query processing.
The article explains how distributed storage systems solve the fundamental problems of data sharding and redundancy by describing three sharding methods (hash, consistent‑hash, and range‑based), the criteria for choosing a shard key, the role of metadata servers, and consistency techniques such as leasing, all illustrated with concrete examples and code snippets.
This article outlines the journey of a financial services company from manual DBA tasks through tool‑assisted operations to a fully automated platform, detailing the platform’s technical stack, functional modules, metadata design principles, evolving SQL audit workflow, and future directions for intelligent database operations.
This guide compiles essential interview topics covering computer network protocols, MySQL and Redis database concepts, core data structures and algorithms, Linux commands and system internals, operating‑system fundamentals, and key Java and PHP concepts, providing a thorough preparation checklist for developers.
This comprehensive guide outlines the essential technical and soft‑skill roadmap for programmers, covering computer fundamentals, data structures, Java basics, multithreading, JVM internals, databases, distributed systems, architecture, learning methods, personal branding, English importance, and ways to stay competitive.
The author shares personal interview experiences and a comprehensive list of Python backend interview questions covering syntax, algorithms, networking, databases, Linux, and Django, while emphasizing daily coding practice and GitHub activity as key to impressing interviewers.
This article presents a comprehensive, stage‑by‑stage recommendation of Java books covering fundamentals, advanced topics, architecture, software development processes, databases, networking, multithreading, and design patterns, helping developers navigate the overwhelming literature and deepen their expertise.
Amid rising cloud outages and strict financial regulations, this article examines traditional multi‑active database solutions such as Oracle RAC and IBM GDPS, contrasts them with modern distributed database designs, and details SequoiaDB’s multi‑active architecture and concrete disaster‑recovery procedures for single‑node, site‑wide, and network failures.
A technical article detailing the investigation and resolution of a MySQL error related to insert buffer merge operations during table deletion, involving code analysis and system debugging.
This article presents a curated list of noteworthy open‑source C projects—including event libraries, caching systems, databases, web servers, testing frameworks, and classic Unix kernels—each with a brief description, key features, and download links for developers seeking practical learning resources.
The article explores why many engineers repeat tasks without building lasting knowledge, explains how systematic practice, thorough review, and logical reasoning can transform isolated experiences into a connected web of expertise, and illustrates these ideas with a real MySQL connection‑slow case study.
This article details JD Logistics' warehouse management system database architecture, the shift between local and centralized deployments, and how the UDBA automation platform, performance tuning, fault‑self‑healing, data archiving, and MySQL upgrades together ensure high performance and high availability across thousands of warehouses.
This article outlines the evolution of financial‑grade cloud native architecture, describing its origins, key principles, incremental delivery, sustainable innovation, and evolutionary planning, while addressing scalability, disaster‑recovery, distributed‑transaction, and elastic resource challenges with practical Ant Financial case studies.
This guide outlines a complete Java learning path covering computer fundamentals, core Java concepts, JVM internals, database basics, design patterns, HTTP protocol, Spring framework, and advanced backend topics such as web services, distributed systems, and Hadoop.
This talk walks through the fundamentals of consumer‑finance services, details the evolving database architecture—including sharding, connection‑pool handling, resource isolation, and high‑performance caching—and shares the team's DevOps transformation and outlook toward NewSQL and AI‑driven operations.
A Chinese company, StarRing Technology, became the first ever to pass the notoriously difficult TPC‑DS benchmark, revealing the test’s history, methodology, and why this achievement marks a major milestone for database performance in the big‑data era.
This article recounts Ant Group’s journey from early database research to the large‑scale deployment of OceanBase, outlining three strategic questions, architectural evolution, unit‑based design, and multi‑city disaster‑recovery solutions that illustrate how self‑developed database technology can become a core product.
This article explores the internal implementation of Redis blocking commands such as BLPOP and BRPOP, detailing how keys are blocked, the data structures involved, the timeout detection across event loops, and the mechanisms that unblock clients both on timeout and on normal list pushes.
This article presents a concise 14‑question quiz covering key concepts in database indexing, locking, Linux signals, network protocols, Python data structures, and hash functions, plus open‑ended discussion prompts on system reliability and hash evaluation.
This article presents a comprehensive, sequential roadmap for aspiring backend developers, covering language selection, practice projects, package managers, standards, security, testing, databases, frameworks, caching, APIs, authentication, messaging, search, Docker, web servers, WebSockets, GraphQL, graph databases, and continuous learning.
A developer recounts a terrifying production database loss, explores how a misconfigured environment caused the outage, highlights the critical role of backups, and shares hard‑earned lessons about authentication token handling and preventing similar catastrophes in future projects.
This article presents essential MySQL command-line operations, database and table management statements, and compares equivalent SQL syntax in Oracle, covering date handling, string functions, and notable differences such as pagination and auto‑increment behavior.
This article surveys Qihoo 360’s notable open‑source projects—including distributed system testing tools, high‑performance storage services, AI scheduling platforms, database alternatives, frontend frameworks, mobile plugin solutions, and development utilities—highlighting their purposes, key features, and public GitHub repositories.
This guide compiles key Python fundamentals, algorithm challenges, networking concepts, database knowledge, Linux commands, and Django project topics that frequently appear in junior backend interview screenings, urging candidates to practice coding daily and showcase their Git activity.
This article explains the fundamentals of consistency in distributed storage systems, contrasts it with database transaction consistency, and details the various consistency levels offered by Azure Cosmos DB, Apache Cassandra, and OceanBase, highlighting their guarantees, configurations, and the performance‑availability trade‑offs involved.
The March 2018 DBAplus Newsletter compiles the latest releases across RDBMS, NoSQL, NewSQL, time‑series and big‑data ecosystems, highlighting new features, performance improvements, compatibility updates and key technical links for Oracle, MySQL, MariaDB, SQL Server, DB2, PostgreSQL, TiDB, CockroachDB, InfluxDB, Hadoop and several Chinese‑made databases.
A candid recount of a technical interview at Alibaba reveals essential Java, Spring, database, Linux, JVM, threading, distributed systems, and design pattern knowledge that candidates should master to succeed in backend development roles.
A comprehensive collection of Java interview questions covering fundamentals, common collections, concurrency, JVM internals, design patterns, data structures, networking, databases, caching, messaging, frameworks, distributed systems, and micro‑service architecture to help developers prepare for junior to mid‑level positions.
This article outlines the essential technical abilities a software engineer should develop, ranging from understanding computation models and efficient data handling to mastering programming languages, system architecture, testing, and tooling, providing a comprehensive roadmap for building robust, scalable software solutions.
This article presents a detailed Java learning roadmap covering core language fundamentals, intermediate topics like I/O and multithreading, advanced concepts such as design patterns and frameworks, front‑end basics, databases, J2EE, popular frameworks, server technologies, development tools, and practical project recommendations.
A 2017 roundup highlights ten innovative database releases—including a time‑series extension for PostgreSQL, a multi‑model Azure service, Google’s globally distributed Spanner, Amazon’s Neptune graph service, and several open‑source cloud‑native databases—detailing their key features, architectures, and intended use cases.
This article reviews the evolution of modern multi‑core processors and non‑volatile memory, analyzes their impact on database system architecture, discusses cache‑friendly designs, distributed logging, and benchmark results, and highlights the opportunities and challenges for DBMS developers in the era of NVRAM.
This article summarizes a 2017 Gdevops talk that examines the evolution of many‑core processors and non‑volatile memory, explains how memory‑wall effects impact modern DBMS performance, and presents architectural and algorithmic adaptations—including cache‑friendly structures, lock management, and write‑behind logging—to exploit new hardware.
The November 2017 DB‑Engines ranking shows Oracle, MySQL and Microsoft SQL Server still dominate the top three, while Splunk and HBase swap places, PostgreSQL climbs to fourth with a 54.1% year‑over‑year gain, and the list is based on five popularity factors such as search engine queries, job postings, and Stack Overflow activity.
This guide outlines the essential skills—from HTML/CSS and JavaScript to backend languages, databases, HTTP/REST, architecture, Git, and core algorithms—needed to become a full‑stack web developer in 2017 and land your first job.
This article details the evolution of JD's Elastic Database, describing the challenges of scaling MySQL, the staged solutions including sharding, JProxy, and the final elastic architecture with services like Topology, JED‑Gate, and JED‑Tablet, and explains its query processing, dynamic resharding, and automatic failover mechanisms.
This article introduces two open‑source script collections—dbm_lite for Oracle database administration and mysql_mgr_test for rapid MySQL Group Replication deployment—detailing their features, supported platforms, usage instructions, and how to obtain them from GitHub.
From dropping out of university at 19 to founding MySQL, Monty Widenius’s relentless coding passion, open‑source philosophy, and partnership with David Axmark transformed a hobby project into the world’s most popular database, shaping modern data management and inspiring generations of developers.
This guide walks you through the essential steps, tools, and commands needed to securely back up a website—including files, databases, and optional configuration logs—using SSH, SCP, and tar on Linux or macOS systems.
The article explains how set‑based SQL queries outperform procedural, row‑by‑row approaches by showing concrete examples, AUTOTRACE statistics, and PL/SQL function alternatives, highlighting massive differences in consistent gets, recursive calls, and overall resource consumption for large production data sets.
The 2017 overview of China’s domestic database sector examines funding milestones, new product releases, and market activities of key players such as Nanda General, HanGao Software, Kingbase, Inspur K‑DB, and XingRuiGe, highlighting their technical capabilities and strategic directions.
This article presents a comprehensive overview of prominent Alibaba open‑source projects spanning frontend frameworks, mobile cross‑platform solutions, backend systems, databases, testing tools, and UI components, each with brief descriptions and GitHub links for developers seeking robust, enterprise‑grade resources.
Based on a 2017 Stack Overflow survey of 64,000 developers, this article explains why SQL remains the second‑most used programming language, detailing eight technical, community‑driven and practical reasons that keep relational databases indispensable despite the rise of newer technologies.
This article explores practical techniques for synchronizing heterogeneous data sources, performing batch and incremental analytics with Hadoop and Spark, designing low‑latency real‑time computation pipelines, implementing push notifications, and choosing appropriate storage solutions—from in‑memory caches to distributed databases—while addressing performance, reliability, and scalability challenges.
This article presents a detailed, game‑like learning roadmap for programmers, recommending foundational scripting languages, Unix/Linux mastery, web development, databases, C/C++ and Java, system programming, design patterns, and advanced topics such as distributed systems and big‑data technologies to guide career growth.
This article explains the concept of linearizability, contrasts it with serializability, and describes how Google Spanner uses the TrueTime API and commit‑wait mechanisms to provide external consistency and reliable snapshot reads in a globally distributed database system.
This article provides a detailed introduction to data migration, explaining why and when it is needed, outlining its major challenges such as security, compatibility and downtime, and describing the four primary migration approaches—application, volume‑manager, network, and storage—along with common tools and technologies.
This week’s tech roundup covers GitHub’s shift to Electron for cross‑platform desktop clients, Tencent’s AI‑powered location services, Facebook’s open‑source ParlAI dialogue framework, Microsoft’s AR glasses prototype, Google Lens advancements, FDA‑approved medical VR, Apache Beam’s first stable release, Amazon DAX preview, and MapD’s open‑source GPU database.
Facing ever‑growing complexity, Java developers can streamline their projects by mastering a curated list of essential data storage and processing tools—including MongoDB, Elasticsearch, Cassandra, Redis, Hazelcast, EHCache, Hadoop, Solr, Spark, and Memcached—each offering distinct strengths for modern big‑data applications.
This article explains the end‑to‑end storage I/O path, analyzes how each node contributes to overall latency, compares IOPS and throughput, and provides practical guidance on configuring storage for Microsoft SQL Server workloads.
This article presents a comprehensive, Chinese‑language collection of big‑data resources—including relational databases, distributed file systems, key‑value stores, distributed programming tools, file data models, and key‑map frameworks—compiled by w3cschool to help programmers deepen their understanding of big data technologies.
The article reviews the major software development trends of 2016—including progressive web apps, chatbots, evolving front‑end frameworks, cloud adoption, and machine‑learning breakthroughs—while highlighting key programming languages, databases, tools, and technologies to watch in 2017.
This article discusses DBA career advancement, outlining typical salary increase mechanisms, promotion pathways, and proposes a seven‑level DBA competency framework to help professionals plan growth and negotiate better compensation within the industry.
This article explains how to use Oracle's driving_site hint to minimize network traffic in distributed DBLINK queries, demonstrates a banking case where execution time drops from over eight seconds to under one second, and provides step‑by‑step view‑based solutions for DML optimization.
This article examines YouTube's large‑scale architecture, detailing its platform components, web and video services, database evolution, data‑center strategy, and key lessons for building high‑concurrency, fault‑tolerant backend systems.
This guide outlines the critical tasks DBA teams should perform before, during, and after the Chinese New Year holiday, including daily security practices, pre‑holiday inspections, on‑call rotations, post‑holiday reviews, and detailed checklist scripts to ensure database reliability and prevent incidents.
This article surveys the technical architectures of major web platforms—including Wikipedia, Facebook, Yahoo Mail, Twitter, Google App Engine, Amazon, and Youku—highlighting their load‑balancing, caching, database, and scaling strategies to reveal how they handle massive traffic and data volumes.
This article provides a detailed overview of three leading Chinese database systems—Da Meng DM, GBase, and Sinoregal DS—highlighting their latest versions, key new features, compatibility improvements, high‑availability solutions, and performance enhancements for enterprise and big‑data workloads.
This article explains the fundamentals of transactions, the ACID properties, isolation levels, distributed transactions, the CAP theorem, and the BASE model, illustrating how they shape consistency, availability, and reliability in modern database and distributed system design.
This article explains the importance of data storage, describes single‑node storage engines and data models, outlines transaction and concurrency control, and covers distributed storage principles, CAP and FLP theorems, 2PC and Paxos protocols, as well as redundancy, backup, and failover mechanisms.
The article outlines the step‑by‑step evolution of a .NET‑based web system, describing how a single‑server setup grows into a multi‑tier, load‑balanced, clustered, stateless, micro‑service architecture that leverages caching, NoSQL, search engines, cloud services, Docker and CDN to handle large‑scale traffic and data processing.
This article explores core database design concepts, covering normalization principles, denormalization tactics, schema simplification, MySQL architecture, various data partitioning methods—including vertical, horizontal, logical, and time‑based sharding—and practical routing and storage optimizations for high‑performance systems.
The conference featured a series of high‑availability architecture talks covering performance‑driven design, RPC framework resilience, big‑data platform evolution, MySQL cluster consistency, and cloud infrastructure best practices, presented by experts from 58.com, Alibaba, Tencent, Baidu, and others.
This article examines the evolution of Taobao's technical architecture—from a LAMP stack through Oracle‑based mainframes to a cloud‑native platform—highlighting the performance, scalability, and cost challenges of traditional IT and offering best‑practice strategies for migrating enterprise systems to the cloud.
The article explains how unnoticed database issues often cause system slowness, outlines key diagnostic questions for operations teams, and presents a three‑step approach—discover, solve, prevent—to regularly health‑check and optimize databases for reliable performance.
This guide presents a concise, experience‑based checklist for optimizing SQL SELECT statements, covering index verification, dataset reduction, column selection, unnecessary table removal, outer join elimination, and computed column cleanup, each illustrated with real‑world examples and visual aids.
This article explains Redis's five primary data types—String, Hash, List, Set, and Sorted Set—detailing their commands, use‑cases, internal encodings, memory‑saving configuration parameters, and the available persistence strategies, while offering practical recommendations for production deployments.
This article explains how to design and implement heterogeneous data synchronization, leverage batch and stream processing frameworks like Hadoop and Storm for large‑scale analysis, and choose appropriate storage solutions—from in‑memory databases to distributed column‑family stores—while addressing performance, reliability, and monitoring in complex distributed environments.
During performance testing, an Oracle SQL using bind variables showed two child cursors with identical execution plans; the article explains this phenomenon by detailing Oracle’s rolling cursor invalidation mechanism, the role of the ROLL_INVALID_MISMATCH flag, and how to reproduce and observe it.
This article explains Oracle cursor concepts, details the key V$SQL and related views, highlights crucial columns for performance tuning, and describes important parameters such as open_cursor and cursor_sharing, helping DBAs optimize SQL execution and manage shared pool memory effectively.
The article explains how a company is retiring Oracle due to cost and scalability, outlines a staged move to NoSQL and cloud storage, argues that SQL remains vital, and shares practical examples of Spark SQL rewrites and JDBC‑based Hive integration.
This article explains how to fix a three‑node MySQL replication chain where the intermediate slave cannot log updates and the downstream slave cannot connect, by adding the log‑slave‑updates option and granting the appropriate remote privileges.
Redis Labs introduces the Redis Module System, enabling developers to extend Redis with C‑based modules that provide advanced features such as in‑database image processing via GraphicsMagick and enhanced string operations like CHECKAND and PREPEND, fostering a growing ecosystem of shared modules.
An overview of the front‑end, back‑end programming languages and databases employed by major web services such as Google, YouTube, Facebook, Amazon and others, illustrating the diverse technology stacks that power large‑scale websites.
This article explains MySQL backup fundamentals, compares cold, snapshot, logical (mysqldump, mydumper) and physical (Xtrabackup) methods, outlines their workflows, pros and cons, and discusses lock‑related performance impacts and Percona's backup‑lock improvements.
This article presents a curated collection of open‑source development tools and libraries—including Taobao Open API client TOP, autoResponsive UI component, ali‑OSS Node.js wrapper, Alibaba Wasp distributed database, Brix framework, and numerous utilities for cloud, databases, and front‑end development—each with brief descriptions and usage links.
The article details how LeTV upgraded its payment platform in 2015 to handle up to 100,000 orders per second by implementing database sharding based on user IDs, a Snowflake‑style globally unique order ID, asynchronous consistency via message queues, multi‑level data caching, and high‑availability architectures for both master‑slave and load‑balanced deployments.
This article explains how the Oracle oerr utility works as a shell script, shows how it maps facilities to components, locates the appropriate message files, and demonstrates using sed and awk to extract detailed error descriptions, causes, and actions for any ORA code.
This article provides a comprehensive, curated overview of the most influential open‑source software across the full technology stack—including operating systems, web servers, programming languages, frameworks, databases, big‑data tools, and development utilities—offering practical insights for engineers seeking to understand and adopt proven solutions.
This article details how Kuaidi Dache scaled from 2013 to 2015 by addressing LBS performance limits, redesigning long‑connection services, refactoring monolithic code into layered services with Dubbo and RocketMQ, building a secure open platform, implementing Storm‑based real‑time monitoring, and migrating data storage to sharded MySQL, Canal‑driven sync, and HBase for massive scalability.
Uber’s Schemaless is a highly available, horizontally scalable MySQL‑based key‑value store that abandons fixed schemas, supports JSON blobs, triggers, and global secondary indexes, and was created to meet five critical requirements for trip data storage, including linear expansion, write throughput, and reliable operations.
When Redis reaches its maxmemory limit, it can use one of six eviction policies—volatile‑lru, allkeys‑lru, volatile‑random, allkeys‑random, volatile‑ttl, or noeviction—to decide which keys to remove, with defaults and configurable sampling influencing performance and accuracy.
Databases originated in the 1960s‑1990s when the United States consolidated wartime intelligence into computer‑stored Data Bases, and a review of their development from 1962 to 2016 reveals a relentless stream of technological breakthroughs that continuously enrich everyday life.
