BestHub
Sign in
Tagged articles

Database

2745 articles · Page 24 of 28
Youzan Coder
Youzan Coder
Mar 27, 2019 · Databases

MySQL Slave Crash-Safe Feature Analysis

The article examines MySQL 5.6’s crash‑safe slave replication, explaining how earlier versions’ unsafe relay‑log handling could corrupt position data, describing the atomic update of mysql.slave_relay_log_info via table‑based relay‑log info and transaction coordination, and covering configuration options, recovery behavior, GTID implications, performance trade‑offs, and implementation guidance.

Crash SafeDatabaseGTID
0 likes · 9 min read
MySQL Slave Crash-Safe Feature Analysis
Big Data Technology & Architecture
Big Data Technology & Architecture
Mar 20, 2019 · Databases

Understanding JOIN Operators: From Traditional Databases to Apache Flink Streaming

This article explains the purpose and types of SQL JOIN operators, demonstrates their syntax and semantics with examples, compares traditional database joins to Apache Flink's streaming two‑stream join implementation, and discusses optimization techniques such as state management, shuffle handling, and join reordering.

Apache FlinkDatabaseSQL
0 likes · 22 min read
Understanding JOIN Operators: From Traditional Databases to Apache Flink Streaming
Java Captain
Java Captain
Mar 9, 2019 · Fundamentals

Understanding Java Enums: Usage, Switch Cases, Singleton Implementation, and Database Integration

This article explores Java enums in depth, covering their basic definition, typical usage patterns such as iteration and switch statements, implementing singletons, integrating with databases via MyBatis type handlers, and addressing common misconceptions about memory consumption, illustrating each concept with clear code examples.

DatabaseEnumJava
0 likes · 7 min read
Understanding Java Enums: Usage, Switch Cases, Singleton Implementation, and Database Integration
JD Tech
JD Tech
Mar 7, 2019 · Databases

Distributed Transaction Solutions in Apache ShardingSphere: XA, Saga, and Flexible Transactions

Apache ShardingSphere provides an integrated distributed transaction solution combining traditional ACID‑compliant two‑phase commit, flexible Saga‑based transactions, and automatic transaction management, detailing their architectures, features, trade‑offs, and usage guidelines for developers handling multi‑database microservice environments.

DatabaseDistributed TransactionsMicroservices
0 likes · 18 min read
Distributed Transaction Solutions in Apache ShardingSphere: XA, Saga, and Flexible Transactions
Youzan Coder
Youzan Coder
Mar 6, 2019 · Databases

Why Concurrent Inserts Trigger MySQL Deadlocks: An In‑Depth InnoDB Lock Analysis

This article examines a MySQL 5.6 InnoDB deadlock scenario caused by concurrent batch INSERTs, detailing the table schema, test cases, lock acquisition phases, log analysis, lock compatibility matrix, and discusses why typical SQL‑level fixes are limited, suggesting index redesign or data sharding as mitigation.

DatabaseDeadlockInnoDB
0 likes · 11 min read
Why Concurrent Inserts Trigger MySQL Deadlocks: An In‑Depth InnoDB Lock Analysis
Tencent Cloud Developer
Tencent Cloud Developer
Mar 6, 2019 · Cloud Native

Building a Subscription Management Mini Program with Tencent Cloud Serverless Functions

The article shows how a single front‑end developer can create the “Moly Subscription Assistant” WeChat mini‑program in five days using Tencent Cloud serverless development, covering OpenID authentication, cloud‑function CRUD for subscriptions, scheduled currency‑rate updates, and a fully managed backend without any traditional servers.

Cloud FunctionsCurrency ExchangeDatabase
0 likes · 10 min read
Building a Subscription Management Mini Program with Tencent Cloud Serverless Functions
Java Captain
Java Captain
Mar 3, 2019 · Databases

Redis Overview: Architecture, Persistence, High Availability, and Client Features

This article explains Redis as an in‑memory data store used for caching, database, and messaging, walks through its evolution from simple HTTP caching to dedicated servers, and details server‑side features like persistence, Sentinel, replication, clustering, as well as client‑side capabilities such as rich data types, transactions, Lua scripting, pipelining, and distributed locks.

ClusterDatabaseDistributed Systems
0 likes · 11 min read
Redis Overview: Architecture, Persistence, High Availability, and Client Features
Youzan Coder
Youzan Coder
Mar 1, 2019 · Databases

Why Do MySQL Inserts Cause Deadlocks? A Deep Dive into a Real-World Case

This article analyzes a MySQL deadlock scenario where concurrent inserts and unique‑key conflicts lead to circular lock waits, explains the underlying lock behavior, walks through the full deadlock log, and proposes using INSERT ON DUPLICATE KEY UPDATE to prevent the issue.

DatabaseDeadlockInnoDB
0 likes · 7 min read
Why Do MySQL Inserts Cause Deadlocks? A Deep Dive into a Real-World Case
dbaplus Community
dbaplus Community
Feb 25, 2019 · Databases

Unlock Oracle SQL Performance with the Rare num_index_keys Hint

A SAP month‑end CO module query suffered severe slowdown despite standard index hints, prompting a deep dive into execution plans, statistics, and a little‑known num_index_keys hint that dramatically improves IN‑list iterator access and reduces filter overhead.

DatabaseIndex HintOracle
0 likes · 7 min read
Unlock Oracle SQL Performance with the Rare num_index_keys Hint
dbaplus Community
dbaplus Community
Feb 24, 2019 · Databases

How to Boost MySQL Query Speed: Key Factors and Proven Optimizations

This comprehensive guide explains the main factors that slow down MySQL queries—including inefficient SQL, concurrency limits, CPU and disk I/O bottlenecks, network issues, large tables, and transaction overhead—while offering concrete configuration tweaks, storage‑engine choices, indexing strategies, and sharding techniques to dramatically improve performance.

DatabaseMySQLOptimization
0 likes · 24 min read
How to Boost MySQL Query Speed: Key Factors and Proven Optimizations
ITPUB
ITPUB
Feb 22, 2019 · Databases

Why B‑Tree vs B+Tree Matters: MySQL Indexing Essentials

This article explains MySQL’s storage engines, compares B‑Tree and B+Tree indexes, details their structures and search processes, and outlines key principles for designing efficient indexes to avoid slow queries in relational databases.

B+ treeB-TreeDatabase
0 likes · 12 min read
Why B‑Tree vs B+Tree Matters: MySQL Indexing Essentials
360 Tech Engineering
360 Tech Engineering
Feb 20, 2019 · Databases

Pika 3.0 New Features Overview

Pika 3.0, the open‑source C++ Redis‑compatible storage built on RocksDB, introduces a new Blackwidow engine, enhanced binlog, and optimized server layer, delivering higher interface performance, reduced disk usage, extended key length, full ZSET compatibility, and improved overall efficiency.

C++DatabasePika
0 likes · 3 min read
Pika 3.0 New Features Overview
Youzan Coder
Youzan Coder
Feb 20, 2019 · Databases

HBase Read Path Analysis

The article first outlines HBase’s overall architecture and core components, then details the end‑to‑end read path—from client request routing to RegionServer processing, data organization and filtering—and finally presents practical client‑ and server‑side optimizations such as heterogeneous storage, HDFS short‑circuit, hedged reads, high‑availability reads, and warm‑up failure fixes, illustrated with Youzan’s production cluster.

DatabaseDistributed SystemsHBase
0 likes · 17 min read
HBase Read Path Analysis
Java Captain
Java Captain
Feb 16, 2019 · Databases

Seven SQL JOIN Types Explained with Example Queries

The article explains seven SQL join techniques—including INNER, LEFT, RIGHT, FULL OUTER, and their exclusive variants—illustrated with diagrams and accompanied by complete SELECT statements that demonstrate how to combine rows from two tables based on matching keys.

DatabaseInner JoinJOIN
0 likes · 3 min read
Seven SQL JOIN Types Explained with Example Queries
Youzan Coder
Youzan Coder
Feb 15, 2019 · Databases

Why Three Concurrent INSERTs Trigger a Deadlock in InnoDB?

This article walks through a step‑by‑step InnoDB deadlock case where three sessions inserting rows with the same unique key cause a lock‑compatibility conflict, explains the INSERT lock phases, shows the actual deadlock log, and reveals why the deadlock occurs.

DatabaseDeadlockInnoDB
0 likes · 14 min read
Why Three Concurrent INSERTs Trigger a Deadlock in InnoDB?
Efficient Ops
Efficient Ops
Feb 11, 2019 · Databases

Best Redis Cluster Options: Client Sharding, Proxy, Codis, Official

Redis, a high‑performance NoSQL database, offers multiple clustering approaches—including client‑side sharding, proxy‑based solutions like Twemproxy and Codis, and the native Redis Cluster—each with distinct trade‑offs in scalability, availability, operational complexity, and performance, guiding engineers to select the optimal architecture for their workloads.

ClusteringCodisDatabase
0 likes · 15 min read
Best Redis Cluster Options: Client Sharding, Proxy, Codis, Official
Programmer DD
Programmer DD
Feb 11, 2019 · Databases

How Partitioned Tables Supercharge MySQL Performance and Their Limits

This article demonstrates how MySQL partition tables dramatically improve query speed for large datasets, compares partition-key, secondary-index, and full‑scan queries, outlines the practical performance gains, and details the numerous limitations and trade‑offs that influence when to adopt partitioning versus sharding.

DatabaseMySQLpartitioning
0 likes · 15 min read
How Partitioned Tables Supercharge MySQL Performance and Their Limits
JD Tech
JD Tech
Feb 11, 2019 · Backend Development

Optimizing JD Service Market's Plugin List Service: From Thread Scaling to a Unified Cache Layer

This article presents a comprehensive case study of how JD's Service Market improved the performance of its core "Available Plugin List" service by analyzing self‑optimizations, resolving external resource conflicts, designing a unified caching model, and implementing asynchronous cache construction using binlog and MQ, ultimately achieving a six‑fold traffic surge handling during peak events.

DatabaseMessage QueueMicroservices
0 likes · 12 min read
Optimizing JD Service Market's Plugin List Service: From Thread Scaling to a Unified Cache Layer
Java Captain
Java Captain
Feb 9, 2019 · Databases

Evolution of Redis Cluster Architecture and Interview Tips

This article reviews the progression of Redis high‑availability solutions—from simple replication with Sentinel, through proxy‑based setups, to native Redis Cluster—explains their advantages and drawbacks, and provides practical interview Q&A tips for candidates.

ClusterDatabaseHigh Availability
0 likes · 9 min read
Evolution of Redis Cluster Architecture and Interview Tips
ITPUB
ITPUB
Jan 28, 2019 · Databases

How to Prevent Redis Single‑Point Failures with Sentinel and Master‑Slave Replication

This article explains Redis’s key features and common use cases, highlights the risks of single‑node deployments, compares two master‑slave replication architectures, and outlines their pros and cons, and details how Redis Sentinel provides automated monitoring, failover, and configuration to achieve high availability.

DatabaseHigh AvailabilityRedis
0 likes · 10 min read
How to Prevent Redis Single‑Point Failures with Sentinel and Master‑Slave Replication
dbaplus Community
dbaplus Community
Jan 27, 2019 · Databases

How to Build a Highly Available Redis Service with Sentinel and Virtual IP

This article walks through the design of a highly available Redis deployment, explains common failure scenarios, compares single‑node, master‑slave, and multi‑Sentinel architectures, and shows how adding a virtual IP and three Sentinel instances can provide robust HA while keeping client usage simple.

DatabaseHigh AvailabilityRedis
0 likes · 13 min read
How to Build a Highly Available Redis Service with Sentinel and Virtual IP
Youzan Coder
Youzan Coder
Jan 25, 2019 · Databases

Analyzing MySQL Deadlock Logs: A Step-by-Step Guide

The guide walks through creating a sample InnoDB table, reproducing a delete‑vs‑insert deadlock, and dissecting the SHOW ENGINE INNODB STATUS output to explain lock modes such as X, S, GAP and INSERT‑INTENTION, showing how one transaction’s IX lock and another’s X lock on the same index create a classic deadlock and why understanding these modes is crucial for diagnosis.

DatabaseInnoDBLock Analysis
0 likes · 8 min read
Analyzing MySQL Deadlock Logs: A Step-by-Step Guide
Java Captain
Java Captain
Jan 21, 2019 · Databases

19 Common MySQL Optimization Techniques

The article lists nineteen practical MySQL optimization methods—including using EXPLAIN, limiting IN clause size, avoiding SELECT *, using LIMIT 1, reducing unnecessary sorting, preferring UNION ALL, avoiding ORDER BY RAND(), distinguishing IN/EXISTS, applying proper pagination, segment queries, avoiding NULL checks, using full‑text indexes, preventing expression‑based WHERE clauses, respecting left‑most prefix, forcing indexes, handling range queries, and optimizing JOINs—to improve query performance and resource usage.

DatabaseMySQLQuery Tuning
0 likes · 11 min read
19 Common MySQL Optimization Techniques
NetEase Game Operations Platform
NetEase Game Operations Platform
Jan 19, 2019 · Databases

Design and Implementation of Redis Application Layer Protocol (RESP) and Its Python Clients

This article explains the RESP protocol used by Redis, details its five data types, demonstrates pipeline handling with raw sockets, examines the parsing and command‑packing logic of the redis‑py client, analyzes the pipeline implementation and limitations of redis‑py‑cluster, and speculates on upcoming RESP3 features.

DatabasePipelineProtocol
0 likes · 20 min read
Design and Implementation of Redis Application Layer Protocol (RESP) and Its Python Clients
StarRing Big Data Open Lab
StarRing Big Data Open Lab
Jan 16, 2019 · Big Data

What’s New in Transwarp TDH 5.2.3? Key Performance and Stability Enhancements

TDH 5.2.3 introduces a series of stability and performance upgrades—including transaction and compaction optimizations, enhanced error handling, SQL length protection, improved Oracle‑compatible UDFs, default resource pool support, Guardian caching, TxSQL monitoring, and workflow and OLAP engine fixes—aimed at delivering a more reliable big‑data platform.

Big DataDatabaseOptimization
0 likes · 10 min read
What’s New in Transwarp TDH 5.2.3? Key Performance and Stability Enhancements
DataFunTalk
DataFunTalk
Jan 16, 2019 · Big Data

NetEase Data Infrastructure: Database Technologies and Big Data Platform Overview

This article presents NetEase Hangzhou Research Institute's experience in building a data infrastructure, covering database innovations such as InnoSQL, NTSDB, and InnoRocks, as well as the integration of big‑data components like HDFS, Spark, Impala, and Kudu to enable efficient storage, processing, and real‑time analytics.

Data PlatformDatabaseImpala
0 likes · 12 min read
NetEase Data Infrastructure: Database Technologies and Big Data Platform Overview
Programmer DD
Programmer DD
Jan 3, 2019 · Backend Development

Mastering Idempotence: Techniques to Ensure Safe Operations in Backend Systems

This article explains the concept of idempotence, provides real‑world examples such as duplicate form submissions and payment requests, and details practical backend techniques—including query handling, unique indexes, token mechanisms, pessimistic and optimistic locks, distributed locks, and API design—to guarantee that repeated operations produce consistent results without side effects.

Databasedistributed-systemsidempotence
0 likes · 10 min read
Mastering Idempotence: Techniques to Ensure Safe Operations in Backend Systems
dbaplus Community
dbaplus Community
Jan 2, 2019 · Operations

How to Boost Banking System Performance: A Proven Testing & Optimization Playbook

This article presents a comprehensive methodology for performance testing and optimization of a new corporate banking system, covering evaluation metrics, monitoring tools, test environment setup, common bottlenecks, detailed troubleshooting steps, and real‑world case studies to achieve higher throughput, lower latency, and better scalability.

DatabaseJVMLoadRunner
0 likes · 24 min read
How to Boost Banking System Performance: A Proven Testing & Optimization Playbook
dbaplus Community
dbaplus Community
Jan 1, 2019 · Databases

19 Essential MySQL Optimization Techniques Every Developer Should Know

This article presents 19 practical MySQL optimization tips, ranging from using EXPLAIN and proper indexing to rewriting IN/EXISTS queries, avoiding costly ORDER BY RAND(), improving pagination, leveraging full‑text indexes, and applying join and execution‑plan strategies for faster, more efficient database performance.

DatabaseMySQLOptimization
0 likes · 12 min read
19 Essential MySQL Optimization Techniques Every Developer Should Know
Tencent Cloud Developer
Tencent Cloud Developer
Dec 24, 2018 · Cloud Computing

Serverless Development and Cloud Services for WeChat Mini Programs

The talk explains how Tencent’s serverless Mini Program Cloud Development platform eliminates the brain, cost, and coordination pains of backend creation by providing native, one‑click cloud functions, a MongoDB‑compatible database, and CDN‑accelerated storage, enabling single engineers to build scalable, reliable Mini Program services quickly and affordably.

Cloud FunctionsDatabaseServerless
0 likes · 13 min read
Serverless Development and Cloud Services for WeChat Mini Programs
21CTO
21CTO
Dec 23, 2018 · Databases

Why Misplaced Quotes in MySQL UPDATE Can Zero Out Your Data

This article examines a MySQL data‑update mishap caused by misplaced quotation marks, showing how such syntax errors turn intended string assignments into zero values, and explains the underlying expression evaluation that leads to all rows being updated to 0.

Data lossDatabaseMySQL
0 likes · 6 min read
Why Misplaced Quotes in MySQL UPDATE Can Zero Out Your Data
Architect's Tech Stack
Architect's Tech Stack
Dec 22, 2018 · Backend Development

Understanding Idempotency: Concepts, Examples, and Implementation Techniques

This article explains the mathematical and programming concept of idempotency, provides real‑world examples such as duplicate form submissions and payment requests, and details practical techniques—including query/select operations, unique indexes, token mechanisms, pessimistic and optimistic locks, distributed locks, and API design—to ensure idempotent behavior in backend systems.

DatabaseDistributed SystemsOptimistic Lock
0 likes · 9 min read
Understanding Idempotency: Concepts, Examples, and Implementation Techniques
dbaplus Community
dbaplus Community
Dec 17, 2018 · Databases

Exploring MongoDB 4.0 Multi-Document ACID Transactions vs MySQL

MongoDB 4.0 introduces multi‑document ACID transactions with snapshot isolation, supporting replica sets and WiredTiger, and this article explains ACID concepts, outlines limitations, demonstrates session commands, and compares transaction behavior—including conflict detection, repeatable reads, and phantom reads—to MySQL’s implementation.

ACID TransactionsDatabaseMongoDB
0 likes · 10 min read
Exploring MongoDB 4.0 Multi-Document ACID Transactions vs MySQL
dbaplus Community
dbaplus Community
Dec 11, 2018 · Databases

How We Fixed MongoDB Outages and Boosted Performance in Production

This article outlines MongoDB's key features, describes a real‑world outage caused by misconfigured connection limits, details the root‑cause analysis and temporary remediation, and presents a comprehensive set of configuration, sharding, and hardware optimizations that dramatically improved the system's reliability and throughput.

ConfigurationDatabaseMongoDB
0 likes · 14 min read
How We Fixed MongoDB Outages and Boosted Performance in Production
WeChat Client Technology Team
WeChat Client Technology Team
Dec 6, 2018 · Databases

How SQLiteLint Detects Hidden Performance Issues in Mobile Apps

This article introduces SQLiteLint, a runtime analysis tool that automatically checks SQLite usage in mobile apps for index problems, redundant indexes, SELECT *, AUTOINCREMENT, missing prepared statements, and without‑rowid opportunities, enabling developers to catch performance issues before release.

DatabaseSQLiteindex optimization
0 likes · 17 min read
How SQLiteLint Detects Hidden Performance Issues in Mobile Apps
Tencent Cloud Developer
Tencent Cloud Developer
Nov 27, 2018 · Mobile Development

Developing a Mini Program with Cloud Functions: Posting, Viewing, and Commenting

Using the cloud‑development model, the author built a mini‑program that lets users publish posts with optional images, browse a list of posts, view details, and add comments, leveraging cloud functions for CRUD operations, cloud database for storage, and cloud storage for images, while noting the rapid prototyping advantage and the modest 2 GB database and 5 GB storage limits.

Cloud FunctionsDatabaseJavaScript
0 likes · 9 min read
Developing a Mini Program with Cloud Functions: Posting, Viewing, and Commenting
Java Captain
Java Captain
Nov 26, 2018 · Backend Development

Design and Implementation of a Gas Purchase‑Sale‑Stock System Using Maven, Spring, and ExtJS

This article walks through the complete backend development of a gas purchase‑sale‑stock management system, covering entity and database design, Maven multi‑module project setup, Spring and web.xml configuration, environment‑specific property handling with a portable‑config Maven plugin, and a sample login controller implementation using Java, Spring MVC, and ExtJS.

DatabaseExtJSJava
0 likes · 21 min read
Design and Implementation of a Gas Purchase‑Sale‑Stock System Using Maven, Spring, and ExtJS
21CTO
21CTO
Nov 25, 2018 · Backend Development

Inside Oracle’s 25‑Million‑Line C Code: Why Fixing One Bug Takes Weeks

An Oracle Database developer describes the massive, flag‑laden C codebase, the endless testing cycles, and why even tiny bug fixes can require weeks of work, highlighting the extreme complexity and maintenance challenges of large enterprise databases.

Bug fixingDatabaseOracle
0 likes · 5 min read
Inside Oracle’s 25‑Million‑Line C Code: Why Fixing One Bug Takes Weeks
Test Development Learning Exchange
Test Development Learning Exchange
Nov 25, 2018 · Backend Development

Mastering Django Model Meta Options: A Complete Guide

This article explains every Django Model Meta attribute—including abstract, app_label, db_table, db_tablespace, get_latest_by, managed, order_with_respect_to, ordering, permissions, proxy, unique_together, verbose_name, and verbose_name_plural—detailing their purpose, usage, and code examples for precise database and admin control.

DatabaseDjangoMeta
0 likes · 6 min read
Mastering Django Model Meta Options: A Complete Guide
ITPUB
ITPUB
Nov 21, 2018 · Databases

Why Is Redis Lagging? Key Causes and Practical Fixes

This article explains the main factors that cause Redis latency—including network bottlenecks, Redis’s single‑threaded design, deployment choices, OS settings, and slow commands—and provides concrete commands and best‑practice solutions to diagnose and reduce the delay.

DatabasePerformance TuningRedis
0 likes · 6 min read
Why Is Redis Lagging? Key Causes and Practical Fixes
Youzan Coder
Youzan Coder
Nov 16, 2018 · Databases

Optimizing Large-Scale Pagination Queries in MySQL

When paginating millions of rows in MySQL, avoid large OFFSET scans by using delayed joins or bookmark techniques that first fetch primary‑key values via covering indexes, then retrieve the needed rows, dramatically reducing I/O and query latency.

DatabaseIndexMySQL
0 likes · 10 min read
Optimizing Large-Scale Pagination Queries in MySQL
dbaplus Community
dbaplus Community
Nov 12, 2018 · Databases

Unlocking MySQL 8.0 Optimizer: Cost Model Configuration and Histogram Usage

This article explains how MySQL 8.0 improves the optimizer by introducing configurable cost model constants and a histogram feature, showing how to query and update system tables, use ANALYZE TABLE to create and manage histograms, and explore the underlying code structures and future tuning possibilities.

Cost ModelDatabaseHistogram
0 likes · 19 min read
Unlocking MySQL 8.0 Optimizer: Cost Model Configuration and Histogram Usage
Alibaba Cloud Infrastructure
Alibaba Cloud Infrastructure
Nov 10, 2018 · Databases

A Decade of Alibaba Database Evolution for Double 11: From Commercial to Open‑Source to Self‑Developed

Over ten years Alibaba's database team transformed from commercial Oracle‑based systems to open‑source AliSQL and finally to the self‑developed X‑DB, introducing distributed middleware, cloud resources, full‑link testing, intelligent optimization and storage‑compute separation to support the massive Double 11 traffic peaks.

AlibabaDatabasePerformance
0 likes · 21 min read
A Decade of Alibaba Database Evolution for Double 11: From Commercial to Open‑Source to Self‑Developed
Alibaba Cloud Developer
Alibaba Cloud Developer
Nov 6, 2018 · Databases

How Alibaba’s Database Tech Evolved for Double 11: 10 Years of Innovation

This article chronicles Alibaba's decade‑long journey of database innovations—from commercial and open‑source systems to a self‑developed distributed engine—highlighting the technical breakthroughs, performance optimizations, and intelligent features that powered successive Double 11 shopping festivals.

AlibabaDatabaseDistributed Systems
0 likes · 23 min read
How Alibaba’s Database Tech Evolved for Double 11: 10 Years of Innovation
Tencent Cloud Developer
Tencent Cloud Developer
Nov 5, 2018 · Databases

Best Practices for Redis Database on the Cloud

In this talk, Tencent Cloud senior engineer Zou Peng outlines cloud‑native best practices for Redis 4.0 clusters, detailing a smart‑proxy architecture with gossip‑based management, lazy‑scan big‑key handling, automatic fail‑over, the high‑performance CKV engine, and practical guidance on scaling, sharding, monitoring, and cost‑effective high‑availability deployment.

ClusterData MigrationDatabase
0 likes · 14 min read
Best Practices for Redis Database on the Cloud
AntTech
AntTech
Oct 24, 2018 · Fundamentals

A Comprehensive Overview of Alibaba’s Open‑Source Projects Across Frontend, Backend, Mobile, Database, and System Domains

This article presents a curated collection of Alibaba Group’s open‑source projects, spanning frontend design systems, Java libraries, database engines, distributed file and messaging systems, as well as tutorials, highlighting each project's purpose, key features, and GitHub repository links for developers seeking robust, production‑grade solutions.

AlibabaDatabaseDistributed Systems
0 likes · 20 min read
A Comprehensive Overview of Alibaba’s Open‑Source Projects Across Frontend, Backend, Mobile, Database, and System Domains
21CTO
21CTO
Oct 17, 2018 · Databases

Scaling Payment Systems: Sharding, Snowflake IDs, and High‑Availability

This article explains how to design a high‑throughput payment system using database sharding, Snowflake‑style globally unique order IDs, eventual consistency via message queues, high‑availability architectures, data tiering, and coarse‑fine traffic control to handle massive request spikes.

Data TieringDatabaseEventual Consistency
0 likes · 15 min read
Scaling Payment Systems: Sharding, Snowflake IDs, and High‑Availability
dbaplus Community
dbaplus Community
Oct 16, 2018 · Databases

Master MySQL Window Functions: From Basics to Advanced Use Cases

This tutorial explains why and how to use MySQL window functions, covering their concepts, syntax, various function families, practical examples such as ranking, distribution, lead/lag, first/last, and aggregations within dynamic windows, plus detailed SQL snippets and visual illustrations.

AnalyticsDatabaseMySQL
0 likes · 13 min read
Master MySQL Window Functions: From Basics to Advanced Use Cases
Xianyu Technology
Xianyu Technology
Oct 16, 2018 · Big Data

Millisecond-Level Counting for Billion-Scale Data via Offline Batch and Online Incremental Statistics

To achieve millisecond‑level counting on billion‑scale data, the Xianyu team replaced slow MySQL count queries with an offline batch that snapshots relational tables and computes totals, then uses KV‑store incremental statistics for online updates, delivering sub‑10 ms responses with near‑100 % success.

Big DataDatabaseincremental counting
0 likes · 7 min read
Millisecond-Level Counting for Billion-Scale Data via Offline Batch and Online Incremental Statistics
Java Backend Technology
Java Backend Technology
Oct 15, 2018 · Databases

Master MySQL Indexes and Locks: Boost Performance and Avoid Pitfalls

This article explains MySQL's index structures, how indexes accelerate queries but slow down writes, the differences between B‑tree and hash indexes, clustered versus non‑clustered indexes, the left‑most prefix rule, and provides a comprehensive overview of MySQL locking mechanisms and best practices.

DatabaseIndexInnoDB
0 likes · 18 min read
Master MySQL Indexes and Locks: Boost Performance and Avoid Pitfalls
Architects' Tech Alliance
Architects' Tech Alliance
Sep 11, 2018 · Databases

Understanding Distributed Transactions: Principles, 2PC, 3PC, XA, Saga, and Message‑Based Approaches

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 and three‑phase commit, XA, Saga patterns, choreography vs. orchestration, and message‑based transaction mechanisms.

2PC3PCACID
0 likes · 16 min read
Understanding Distributed Transactions: Principles, 2PC, 3PC, XA, Saga, and Message‑Based Approaches
Architects' Tech Alliance
Architects' Tech Alliance
Sep 11, 2018 · Databases

Pessimistic vs Optimistic Locking: A Story-Based Explanation

This article uses a humorous story of two threads battling over inventory updates to illustrate the principles, advantages, and drawbacks of pessimistic and optimistic locking in distributed systems, helping readers understand when to apply each concurrency control method.

DatabaseDistributed SystemsOptimistic Lock
0 likes · 8 min read
Pessimistic vs Optimistic Locking: A Story-Based Explanation
Java Backend Technology
Java Backend Technology
Sep 8, 2018 · Databases

Master MySQL Quickly: Essential Tips, Best Practices, and Common Pitfalls

This comprehensive guide walks you through mastering MySQL by covering server configuration choices, storage engine selection, data type recommendations, index strategies, backup methods, logging options, and practical advice on triggers, views, stored procedures, and character set handling, all aimed at boosting performance and avoiding common mistakes.

DatabaseMySQLPerformance
0 likes · 26 min read
Master MySQL Quickly: Essential Tips, Best Practices, and Common Pitfalls
High Availability Architecture
High Availability Architecture
Sep 7, 2018 · Databases

Understanding NoSQL and Database Selection in the Big Data Era

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.

ColumnarData StorageDatabase
0 likes · 18 min read
Understanding NoSQL and Database Selection in the Big Data Era
Zhongtong Tech
Zhongtong Tech
Aug 31, 2018 · Databases

How Aries Uses MySQL GTID Binlog to Power Real‑Time Data Sync at Scale

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.

Data IntegrationDatabaseGTID
0 likes · 7 min read
How Aries Uses MySQL GTID Binlog to Power Real‑Time Data Sync at Scale
Efficient Ops
Efficient Ops
Aug 30, 2018 · Databases

What’s New in MySQL 8.0 InnoDB? Key Features and Performance Boosts

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.

DatabaseInnoDBMySQL
0 likes · 13 min read
What’s New in MySQL 8.0 InnoDB? Key Features and Performance Boosts
Java Captain
Java Captain
Aug 28, 2018 · Databases

Design and Implementation of a Mini Database Connection Pool

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.

DatabaseDesign PatternsJava
0 likes · 5 min read
Design and Implementation of a Mini Database Connection Pool
Tencent Cloud Developer
Tencent Cloud Developer
Aug 27, 2018 · Mobile Development

WeChat Mini Program Cloud Development: Overview, Advantages, and Common Pitfalls

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.

DatabaseFaaSJavaScript
0 likes · 7 min read
WeChat Mini Program Cloud Development: Overview, Advantages, and Common Pitfalls
Tencent Cloud Developer
Tencent Cloud Developer
Aug 24, 2018 · Cloud Computing

Unlocking WeChat Mini Program Cloud Development: Benefits, Pitfalls & Real‑World Demo

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.

DatabaseJavaScriptMini Program
0 likes · 7 min read
Unlocking WeChat Mini Program Cloud Development: Benefits, Pitfalls & Real‑World Demo
21CTO
21CTO
Aug 23, 2018 · Databases

Mastering Database Transactions: From ACID to Distributed Saga

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.

2PCACIDDatabase
0 likes · 19 min read
Mastering Database Transactions: From ACID to Distributed Saga
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Aug 21, 2018 · Databases

Mastering MySQL: Keys, Transactions, Indexes, Joins, and Optimization Essentials

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.

DatabaseMySQLSQL
0 likes · 29 min read
Mastering MySQL: Keys, Transactions, Indexes, Joins, and Optimization Essentials
dbaplus Community
dbaplus Community
Aug 19, 2018 · Databases

Redis Deployment Options: Pros & Cons of Single, Replication, Sentinel, Cluster, and Custom Solutions

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.

ClusterDatabaseHigh Availability
0 likes · 12 min read
Redis Deployment Options: Pros & Cons of Single, Replication, Sentinel, Cluster, and Custom Solutions
Didi Tech
Didi Tech
Aug 14, 2018 · Databases

Recap of the Open Source Salon: Latest Developments in Open Source Databases and Streaming Processing

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.

DatabaseMySQLOpen Source
0 likes · 4 min read
Recap of the Open Source Salon: Latest Developments in Open Source Databases and Streaming Processing
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Aug 3, 2018 · Databases

Understanding Redis Cluster: Architecture, Slot Sharding, Node Management, and High Availability

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.

ClusterDatabaseHigh Availability
0 likes · 5 min read
Understanding Redis Cluster: Architecture, Slot Sharding, Node Management, and High Availability
DevOps
DevOps
Aug 3, 2018 · Operations

How to Choose the Right TFS Network Topology and Plan a Data Storage Strategy

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.

DatabaseDevOpsHigh Availability
0 likes · 12 min read
How to Choose the Right TFS Network Topology and Plan a Data Storage Strategy
Alibaba Cloud Developer
Alibaba Cloud Developer
Jul 27, 2018 · R&D Management

How Hangzhou’s Engineer Culture Powered China’s Tech Revolution

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.

AlibabaDatabaseTech history
0 likes · 27 min read
How Hangzhou’s Engineer Culture Powered China’s Tech Revolution
Java Backend Technology
Java Backend Technology
Jul 26, 2018 · Databases

7 Common Redis Misuse Scenarios and How to Fix Them

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.

DatabaseOptimizationPerformance
0 likes · 11 min read
7 Common Redis Misuse Scenarios and How to Fix Them
MaGe Linux Operations
MaGe Linux Operations
Jul 22, 2018 · Backend Development

Build a Full-Featured Django Library Management System from Scratch

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.

DatabaseDjangoORM
0 likes · 16 min read
Build a Full-Featured Django Library Management System from Scratch
Java High-Performance Architecture
Java High-Performance Architecture
Jul 21, 2018 · Databases

Master Redis Streams: From Simple Adds to Powerful Consumer Groups

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.

DatabaseMessage QueueStreams
0 likes · 10 min read
Master Redis Streams: From Simple Adds to Powerful Consumer Groups
Efficient Ops
Efficient Ops
Jul 18, 2018 · Databases

Mastering Redis: Advanced Types, Replication, Persistence, and Real-World Design

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.

DatabasePersistenceRedis
0 likes · 10 min read
Mastering Redis: Advanced Types, Replication, Persistence, and Real-World Design
Java Captain
Java Captain
Jul 7, 2018 · Databases

Understanding MySQL Indexes, B+Tree vs Hash, Partitioning, and Redis Fundamentals

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.

B+ treeDatabaseMySQL
0 likes · 28 min read
Understanding MySQL Indexes, B+Tree vs Hash, Partitioning, and Redis Fundamentals