This tutorial explains how to install Flask‑SQLAlchemy, configure a Flask app to connect to MySQL, define ORM models, perform queries, handle pagination, update records, and execute join queries, providing code examples and best‑practice tips for backend development.
This guide introduces Laravel's Eloquent ORM, explains its core concepts, and provides step‑by‑step code examples for retrieving, querying, and sorting records, helping developers harness the power of object‑relational mapping in PHP applications.
This article analyzes the shortcomings of traditional relational databases in big‑data scenarios and introduces five major NoSQL categories—columnar, key‑value, document, full‑text search, and graph databases—detailing their principles, advantages, disadvantages, common implementations, and appropriate use cases to guide storage technology selection.
Aries, an internally built MySQL incremental log distribution platform, leverages GTID‑based binlog dumping to achieve stable, consistent, and real‑time data synchronization across heterogeneous systems, supporting use cases such as Elasticsearch sync, cache updates, archiving, and live statistics.
This article summarizes the major functional and performance enhancements introduced in MySQL 8.0 InnoDB, including a unified data dictionary, atomic DDL, fast column addition, encryption, improved Memcached plugin, parallel redo log writes, and future roadmap items.
This article explains why distributed locks are essential for maintaining data consistency in distributed systems, outlines their key requirements, and compares three common implementation approaches—database‑based, Redis‑based, and ZooKeeper‑based—complete with code examples and practical considerations.
This article explains how Laravel’s Illuminate Database Query Builder class encapsulates connection, grammar, and result processing components, provides a unified query interface, and is instantiated via the table() method while adhering to interface‑driven design principles for consistent database operations.
This article explains the concept, design considerations, and step‑by‑step implementation of a lightweight database connection pool in Java, covering its core components, thread‑safe management, configuration handling, and a test demonstration of its functionality.
WeChat Mini Program Cloud Development offers a serverless backend—cloud functions, database, and file storage—exclusively for Mini Programs, providing simple login, generous free tiers, and easy JavaScript integration, while developers must handle promises for async calls and supplement its limited permission model with custom logic.
This article compiles the most frequently asked Java interview questions—from basic introductions and multithreading concepts to JVM internals, Spring framework details, middleware, database fundamentals, and Redis—providing a comprehensive study guide for job seekers.
This article introduces WeChat Mini Program Cloud Development, explains its serverless architecture, compares it with PaaS and BaaS solutions, outlines suitable scenarios, highlights advantages such as built‑in login and free storage, warns of common misconceptions, and shares practical tips and a GitHub demo project.
This article explains the fundamentals of database transactions, the ACID properties, and how they are implemented, then delves into distributed transaction challenges and solutions such as two‑phase commit, three‑phase commit, XA, and Saga patterns, highlighting their trade‑offs and practical usage.
This article explains fundamental MySQL concepts including primary, candidate, super and foreign keys, transaction ACID properties, view creation, differences among DROP, DELETE and TRUNCATE, index structures and types, join variations, normalization forms, optimization techniques, replication mechanisms, engine distinctions, and logging formats.
This article examines five common Redis deployment patterns—single instance, master‑slave replication, Sentinel, Cluster, and custom high‑availability solutions—detailing their architectures, advantages, drawbacks, and practical configuration tips to help engineers choose the most suitable setup for their workloads.
On August 4 2018, Didi Open Source and the Open Source Database Forum hosted a salon where five industry experts presented the latest advances in open‑source databases—covering Redis multi‑data‑center deployment, MySQL InnoDB Cluster, streaming‑processing architecture, PostGIS GIS solutions, and Redis 5.0 features—followed by a Q&A, a prize draw, and a showcase of Didi’s growing open‑source portfolio.
Discover a collection of ten practical Eloquent ORM techniques—including increment/decrement shortcuts, conditional method chaining, boot method customizations, advanced relationship queries, and the when() helper—that empower Laravel developers to write cleaner, more efficient database code and avoid common pitfalls.
Redis Cluster is a distributed system that partitions its keyspace into 16,384 hash slots across up to 16,384 nodes, enabling automatic sharding, slot migration, replication, and high‑availability features such as automatic node discovery, master‑slave election, and online resharding without service interruption.
This article explains how to select an appropriate Team Foundation Server (TFS) deployment topology and design a data storage strategy, covering single, dual, and cluster deployments, hardware recommendations by team size, high‑availability options, performance testing results, and best practices for managing TFS databases.
The article chronicles three generations of Hangzhou‑origin engineers—from gritty early Alibaba pioneers to modern cloud and blockchain specialists—showing how their relentless problem‑solving, cultural resilience, and tech‑first mindset transformed China’s internet ecosystem and positioned the city as a global engineering hub.
The Galera MySQL 5.7.17 SST fails when a pre‑initialized node is added because the rsync‑based SST filter omits the independent undo‑log tablespace files (undo*), causing InnoDB to roll back uncommitted transactions; adding an undo* rule to the filter copies the missing files and resolves the error, a fix now upstream.
This article outlines seven frequent misuse patterns in Redis development—such as improper use of collection types, missing expirations, oversized values, inefficient batch operations, unnecessary requests, poor key naming, and unsafe commands—provides real‑world case analyses, and offers practical recommendations to improve Redis health and performance.
This tutorial walks you through configuring Django templates, static files, middleware, and MySQL database settings, then defines models for publishers, books, and authors, implements CRUD views and URL routing, and creates the necessary front‑end templates to build a complete library management application.
This guide walks through Redis 5's stream feature, showing how to set up a Docker Redis instance, add entries, perform range queries, use blocking reads, create and manage consumer groups, handle pending messages, claim ownership, inspect stream metadata, delete entries, and limit stream length for efficient message queue implementations.
This article explores Redis’s advanced features—including data types, master‑slave, sentinel, and cluster architectures, transaction handling, RDB/AOF persistence, pub/sub messaging, and a practical e‑commerce search case study—providing design insights and best‑practice configurations for high‑availability and performance.
This article explains why auto‑increment primary keys are preferred in MySQL, how B+Tree and hash indexes differ, the benefits of composite and partitioned indexes, isolation levels, MVCC, row‑level locking, triggers, stored procedures, optimization tips, MyISAM vs InnoDB, table design guidelines, and also covers Redis architecture, persistence, replication, and eviction policies.
This article provides an in‑depth tutorial on using Django's ORM, covering model creation, custom table names, single and composite indexes, one‑to‑many and many‑to‑many relationships, forward and reverse lookups, performance tuning with select_related and prefetch_related, and model validation techniques.
This article examines three common cache‑update strategies, explains why some lead to data inconsistency, and proposes practical solutions such as delayed double‑delete, asynchronous retries, and message‑queue based recovery to maintain cache‑database consistency in high‑concurrency systems.
This guide explains how to install MySQL, configure the Python MySQL client, set up a Django project, add an app, modify settings to connect to a local MySQL database, and run the development server to verify the installation.
This tutorial explains how to set up a six‑node Redis cluster (three masters and three slaves) on one Linux VM by creating separate directories and configuration files for each instance, installing Ruby tools, starting the instances, and using the redis‑trib.rb script to create and verify the cluster.
This article explains how to design and implement a highly available Redis deployment using master‑slave replication, multiple Redis Sentinel instances, and a virtual IP to provide seamless failover while maintaining simple client connectivity, covering failure scenarios, architecture choices, and practical configuration tips.
To prevent memory overflow when processing massive arrays in PHP, read large files line‑by‑line, batch database queries, promptly unset variables, and prefer a pre‑counted for‑loop over foreach for mutable collections, thereby freeing memory gradually and ensuring stable script execution.
This article presents a comprehensive overview of Oracle partitioning, covering basic concepts, the evolution of partition features across versions, practical best‑practice scenarios, and the latest enhancements in Oracle 12c, 12.2, and 18c that improve performance, manageability, and availability.
Tencent Cloud Database’s massive‑operation strategy combines a dedicated architect team, a three‑layer automated platform for resource, task and health management, and AI‑driven intelligent services that customize workloads, automate tuning, and enable proactive scaling and self‑healing across hundreds of thousands of instances.
This article explains how to design a highly available Redis service using Sentinel, compares four deployment architectures, discusses failure scenarios and quorum requirements, and shows how a virtual IP can provide a single‑point access while ensuring continuous service.
This article explains the different MySQL storage engines, describes the various lock types and their granularity, and provides a comprehensive list of practical measures to improve MySQL security and protect the database from common attacks.
The article outlines Redis 5.0's major new capabilities—including Streams, module APIs, enhanced RDB metadata, cluster management improvements, new sorted‑set commands, active memory defragmentation, HyperLogLog upgrades, better memory reporting, HELP sub‑commands, connection performance, bug fixes, and Jemalloc 5.1—while also detailing important migration notes from version 4.0 and providing a reference link to the Streams introduction.
This talk details SF Express’s journey from heterogeneous legacy databases to standardized open‑source, distributed architectures and intelligent operations, covering standardization, migration to open‑source, scaling with Mycat, automated resource pooling, and the ThinkDB platform that drives proactive, automated DBA workflows.
This guide explains three practical ways to track SQL Server backup and restore operations—using SSMS UI, T‑SQL with the STATS option, and dynamic management views—plus how to retrieve backup history and avoid common pitfalls.
MongoDB 4.0 introduces true ACID‑compliant multi‑document transactions, bridging the gap between relational database consistency and NoSQL flexibility, while preserving high performance, scalability, and ease of development for a wide range of application scenarios.
This article outlines Alibaba Cloud Redis development guidelines, covering key naming conventions, value design, command usage, client configuration, lifecycle management, and recommended tools, providing practical recommendations to avoid common pitfalls, improve performance, and ensure reliable operation of Redis in production environments.
This tutorial demonstrates how to install PyMongo, connect to a MongoDB server, and perform comprehensive CRUD operations, query filters, array manipulations, and nested field updates using Python code examples.
This article provides a detailed, command-line tutorial for installing MySQL 5.7 on a Linux system, covering directory creation, downloading and extracting the binary package, user setup, initialization, configuration file adjustments, service startup, and password configuration.
This article examines common hardware and network failures in data centers, analyzes real‑world outage cases, classifies fault domains, and presents comprehensive strategies for database fault handling—including logging, checkpointing, backup, replication, and high‑availability architectures—to improve reliability and reduce downtime.
This article introduces MongoDB, an open-source document-oriented database, outlines its key features such as indexing, sharding, and MapReduce, and provides step-by-step instructions for installing and running MongoDB on a system using Homebrew, along with basic shell commands.
This article explains MySQL index fundamentals, demonstrates performance issues with slow queries, and walks through practical optimization cases using EXPLAIN, covering index creation, covering indexes, and composite indexes, and best practices for when to add or avoid indexes.
The article explains how to extend MySQL’s built‑in lexer and Bison‑based parser to expose table names, query features, and optimization advice via a simple language‑agnostic service, illustrating core data structures, useless‑condition elimination, feature generation for slow‑query analysis, and practical learning tips.
This guide provides a comprehensive overview of MySQL fundamentals—including CRUD statements, table creation, index management, data manipulation, transaction control, stored procedures, and trigger creation—complete with syntax examples and practical tips for reliable database development.
The article recounts how Alibaba and Ant Group were forced by the massive Double‑11 transaction surge to develop their own OceanBase database, explores the five‑year struggle, the broader fintech innovations, and the strategic mindset of autonomous R&D and open‑source sharing.
This guide walks through configuring MySQL master‑slave replication inside Docker containers, covering environment setup, container creation, MySQL configuration changes, replication user creation, synchronization commands, troubleshooting tips, and verification of data replication between the master and slave instances.
The talk details Ele.me’s rapid growth from 300k to over 10 million daily orders, describing the challenges of high‑concurrency, multi‑active micro‑service architecture, IDC planning, database refactoring, disaster‑recovery, NOC operations, and the systematic processes that enabled stable, scalable delivery across two data centers.
This article explains how MySQL InnoDB implements consistent reads using multi‑version concurrency control (MVCC), detailing isolation levels, undo‑log mechanics, hidden columns, rollback segments, transaction commit behavior, and the impact on SELECT, INSERT, UPDATE, and DELETE operations.
This article walks readers through setting up MySQL replication, from the basic master‑slave model to a one‑master‑multiple‑slave cluster, covering configuration files, essential parameters, verification commands, performance tips, and common pitfalls for production deployments.
This article explains the ACID properties, write‑ahead logging, and how RocksDB implements a three‑step write path and a leader‑follower Group Commit mechanism to improve transaction throughput by batching fsync operations.
This article presents a comprehensive, step‑by‑step roadmap for aspiring backend developers, covering language selection, tooling, best practices, security, databases, frameworks, testing, deployment, and continuous learning to help readers confidently master modern backend development.
This article introduces MySQL 8's Common Table Expressions (CTEs), explains their syntax and advantages over derived tables, and provides multiple practical examples—including recursive queries, table creation, and usage in INSERT, UPDATE, and DELETE statements—plus a Docker setup tip for MySQL 8.
This article provides a comprehensive overview of HBase's architecture, detailing the roles of RegionServers, HMaster, ZooKeeper, Regions, the META table, write and read paths, compaction processes, region splitting, load balancing, HDFS replication, crash recovery, and the system's advantages and challenges.
This article explains the sophisticated pagination system used by Stack Overflow, covering offset‑based queries, a custom Tag Engine, database joins, in‑memory sorting, and caching techniques that together deliver rapid page navigation even over billions of records.
This article walks through MySQL 8.0's key relational‑database enhancements, including invisible indexes for performance testing, the SET PERSIST command for persistent configuration, default utf8mb4 encoding, Common Table Expressions for clearer queries, and window functions for advanced ranking and aggregation.
This article compiles a comprehensive set of Java interview topics—including core language concepts, concurrency, JVM tuning, database optimization, data structures, operating‑system fundamentals, networking, frameworks, distributed systems, and design challenges—to help developers deepen their understanding and excel in technical interviews.
The 2018 Gdevops Global Agile Operations Summit in Chengdu gathered industry experts who shared practical insights on AIOps implementation, sharding database ecosystems, DevOps adoption in traditional enterprises, large‑scale data management, ElasticSearch clustering, AWS blue‑green deployments, cloud database operations, Alibaba's double‑11 ops platform, 58 delivery mini‑program architecture, and scalable game service design.
This article presents the design, implementation, and evaluation of X‑Engine, a next‑generation LSM‑Tree based storage engine that offloads compaction to FPGA, achieving up to 50% KV‑interface and 40% SQL‑interface performance gains for write‑intensive OLTP workloads.
This article explains how to define high availability for Redis, enumerates typical failure scenarios, compares four deployment patterns—from a single instance to a three‑sentinel setup—and provides practical steps, diagrams, and tips for achieving reliable Redis service using Sentinel and virtual IP failover.
This guide compiles over a hundred essential interview questions covering Java fundamentals, JVM tuning, thread pools, memory management, databases, Linux system internals, networking basics, and popular frameworks like Spring and Dubbo, helping candidates prepare comprehensively for backend development roles.
This article introduces Alibaba’s X‑Engine storage engine, the foundation of the next‑generation distributed database X‑DB, and explains how FPGA‑accelerated compaction and asynchronous scheduling dramatically improve write‑intensive OLTP performance, reduce CPU contention, and achieve up to 50 % throughput gains while maintaining fault tolerance.
This article provides a comprehensive, step‑by‑step overview of MySQL's InnoDB storage engine, covering database vs instance definitions, internal processes, tablespace layout, file formats, record layouts, B‑tree indexes, lock types, and transaction isolation levels for developers seeking a solid foundation.
This guide walks through configuring Oracle multi‑master data replication, covering site creation, group objects, propagator and receiver setup, purge scheduling, database link creation, replication group definition, table registration, conflict handling, and finally resuming replication, all illustrated with complete SQL code examples.
This tutorial demonstrates how to install PyMySQL, establish a MySQL connection in Python, and perform table creation, data insertion, and query operations using example code, while outlining required prerequisites such as credentials and database details.
This article introduces Redis as a key‑value caching system, compares it with MongoDB and Memcache, explains installation, shows how to use the redis‑py Python client—including direct connections, connection pools, and basic data‑type operations—and provides code examples for setting and retrieving values.
This article explains why MySQL queries can become case‑insensitive, describes how collations and character sets control case sensitivity, and presents three practical solutions—changing the collation, converting column types, and using binary or collate clauses in queries—to achieve case‑sensitive behavior.
This article presents a visual summary of the Alibaba Java Development Handbook, covering programming conventions, exception logging, unit testing, security guidelines, MySQL usage, and project structure to help developers quickly recall essential backend Java practices.
This guide introduces the most commonly used HBase operational tools—including Canary, hbck, HFile viewer, CopyTable, Export/Import, ImportTsv, CompleteBulkload, RowCounter, CellCounter, and clean utilities—explaining their purposes, typical use‑cases, and exact command syntax for effective cluster administration.
This comprehensive guide compiles over a hundred critical Java interview questions covering core language concepts, multithreading, JVM internals, databases, caching, distributed systems, system design, and security to help candidates prepare thoroughly and confidently for technical interviews.
The article explains that Oracle Enterprise Manager requires listeners with dynamic registration, shows how a static listener on a non‑default port causes a "database is down" error, and provides step‑by‑step commands to modify the local_listener parameter so both listeners register dynamically and EM works correctly.
This document provides a comprehensive step-by-step guide to installing and configuring Redis on Linux and macOS, covering package download, compilation, service setup, and operational configuration.
This guide explains why a Redis cluster is needed for large data sets, describes the hash‑slot architecture introduced in Redis 3.0, and provides step‑by‑step instructions—including directory creation, configuration changes, instance startup, Ruby gem installation, and cluster creation commands—to build a functional Redis cluster on a Mac.
Tencent Cloud’s business continuity solutions combine high‑availability clusters, multi‑AZ load balancing, and cross‑region disaster‑recovery architectures—such as CLB‑CVM‑MySQL configurations, CDB hot‑standby instances, DNS‑based failover, and data‑sync services—to ensure continuous operation and rapid recovery from localized or regional failures.
This guide compiles a thorough list of Java interview questions and key concepts, ranging from basic collections and JVM memory to concurrency, database optimization, messaging systems, NoSQL, Zookeeper, Linux commands, and system design challenges, providing a solid study roadmap for developers.
This tutorial explains how to set up two MySQL servers—one as master for writes and one as slave for reads—by configuring replication accounts, binary logging, server IDs, firewall rules, and then demonstrates read/write separation using a lightweight PHP framework.
This guide answers common Oracle backup questions, covering planning for 50‑TB databases, speed calculations, backup window design, RMAN versus Data Pump, multi‑user and RAC scenarios, catalog usage, performance troubleshooting, and practical SQL queries for monitoring backup status.
This article introduces a PHP‑based SQL auto‑review platform that lets developers submit MySQL statements for automatic performance and compliance checks, integrates rules from Inception, Percona, and Meituan SQLAdvisor, and provides step‑by‑step installation and deployment guidance.
This article traces the evolution of database systems—from early navigational models and Codd's relational theory through the rise of NoSQL and sharding, to the resurgence of NewSQL and the emerging HTAP paradigm—highlighting technical motivations, design trade‑offs, and future directions.
This article examines common MySQL concurrency problems—including table locks from MyISAM, metadata locks during online DDL, row‑level deadlocks, and lock‑wait timeouts—explains how to detect them with processlist and InnoDB status, and provides practical mitigation strategies.
This article walks through a real‑world SQL Server performance‑tuning investigation, explaining the six‑factor analysis framework, diagnosing CMEMTHREAD waits, and presenting concrete hardware, configuration, and code‑level solutions that eliminated the issue and improved overall database throughput.
This article explains why distributed locks are needed in Java applications, outlines the essential conditions they must satisfy, and compares three practical implementations—database‑based, Redis‑based, and Zookeeper‑based—providing code snippets and performance considerations for each.
This guide shows how to combine Spring Security and MyBatis to implement username‑password authentication backed by a MariaDB database, covering repository cloning, database setup, Maven execution, and a deep dive into the underlying authentication filter and provider classes with code examples.
An in‑depth look at SQLite’s Write‑Ahead Logging (WAL) mode and the asynchronous checkpoint optimization used in WeChat’s WCDB, covering implementation details, performance gains, A/B test results, and practical code examples for enabling these features on Android.
This article explains step‑by‑step how to collect replication status, examine MySQL error logs and binary logs, understand common replication failures such as duplicate databases or missing binlog files, and apply GTID and configuration best practices to troubleshoot and fix MySQL replication problems in high‑availability setups.
This article explains the fundamentals of MySQL binary logs, how to enable and query them, the different binlog formats, practical steps for setting up master‑slave replication, and methods for using binlog to recover data after accidental changes.
This article explains why creating a database connection for each request is inefficient, introduces the concept and configuration of connection pools, provides a custom Java DataSource implementation, and demonstrates the use of popular open‑source pools such as DBCP, C3P0, and Tomcat JNDI with complete code examples.
This article outlines the most compelling reasons to choose PostgreSQL, covering its advanced data types like JSONB and Range, powerful extensions such as Citus, HyperLogLog and PostGIS, logical replication, rich indexing options, upsert support, foreign data wrappers, and a host of legacy capabilities.
The article introduces WCDB Swift, a pure‑Swift rewrite of Tencent's mobile database, detailing its model binding via Codable, language‑integrated queries, thread‑safe concurrency, encryption, full‑text search, and innovative use of Swift’s KeyPath and Mirror to achieve high performance and stability on iOS.
This comprehensive guide walks through the full lifecycle of enterprise system architecture, covering access‑chain analysis, network and hardware foundations, virtualization and container strategies, layered design, load‑balancing, database high‑availability, service segmentation, and operational safeguards such as CMDB, monitoring, and disaster‑recovery.
This article explains the four MySQL transaction isolation levels—Read Uncommitted, Read Committed, Repeatable Read, and Serializable—by creating a sample table and running step‑by‑step command‑line sessions that demonstrate dirty reads, non‑repeatable reads, phantom reads, and the practical limits of InnoDB's MVCC implementation.
Alibaba’s database team explains how their next‑generation X‑DB system achieved extreme elasticity, high performance, and cost efficiency during the Double 11 shopping festival by leveraging cloud‑native hybrid deployment, containerization, storage‑compute separation, Paxos‑based consistency, and AI‑driven self‑optimizing DBA tools, while outlining key challenges and solutions.
This memoir chronicles a Chinese IT professional’s two‑decade evolution from a university student and Oracle DBA to a DevOps and cloud operations leader, sharing career milestones, technical choices, and practical insights for anyone pursuing a long‑term operations career.
This guide explains Redis’s core features, shows how to design clear key naming conventions, and demonstrates practical applications of the string, hash, list, set, and sorted‑set data types with concrete commands and examples for building fast, memory‑based caches.
This article provides a comprehensive guide to Android's Room persistence library, covering the creation of Entity classes, defining Data Access Objects (DAO), building the RoomDatabase, handling foreign keys, embedded objects, query methods, LiveData and RxJava return types, as well as database migrations and type converters for complex data types.
This article explains how PostgreSQL transforms and rewrites query trees, why a completed transform‑rewrite tree may not be optimal, and details the subquery_planner’s role, tuple_fraction handling, and the step‑by‑step logical optimization process used to generate efficient execution plans.
The article introduces AWS S3 SELECT for in‑object SQL filtering, highlights Aurora's new Multi‑Master and Serverless capabilities, describes DynamoDB's on‑demand backup and Global Tables, and provides a brief overview of the managed graph database Neptune, emphasizing performance and cost benefits.
This article explains MySQL's logical architecture, the step‑by‑step query execution process, and provides practical performance‑tuning advice—including schema design, data‑type choices, index strategies, and specific query optimizations such as COUNT, JOIN, LIMIT pagination, and UNION—backed by code examples and diagrams.
