BestHub
Sign in
Tagged articles

Database

2745 articles · Page 13 of 28
ITPUB
ITPUB
Sep 18, 2022 · Databases

Master Redis Memory: 7 Proven Techniques to Store More Data with Less RAM

This article explains how Redis stores key‑value pairs, details the internal data structures such as dict, dictEntry and redisObject, and provides practical memory‑saving tricks—including key shortening, encoding choices, object sharing, bitmap usage, hash consolidation, fragmentation handling, and 32‑bit deployment—to dramatically reduce RAM consumption while maintaining performance.

CacheData StructuresDatabase
0 likes · 19 min read
Master Redis Memory: 7 Proven Techniques to Store More Data with Less RAM
Java Backend Technology
Java Backend Technology
Sep 17, 2022 · Databases

What New SQL Features Did SQLite Add in 2018?

This article reviews SQLite's 2018 enhancements, covering Boolean literals, window functions, the FILTER clause, UPSERT syntax, column‑renaming support, and other API changes, while comparing SQLite's capabilities to other major database systems.

Boolean LiteralsDatabaseFILTER clause
0 likes · 11 min read
What New SQL Features Did SQLite Add in 2018?
Java High-Performance Architecture
Java High-Performance Architecture
Sep 13, 2022 · Information Security

How to Perform Fuzzy Searches on Encrypted Data: Strategies and Trade‑offs

This article examines why encrypted data hinders fuzzy queries, categorizes three implementation approaches—from naive in‑memory decryption to conventional database tricks and advanced algorithmic solutions—evaluates their security, performance, and storage impacts, and provides practical references for real‑world systems.

AlgorithmDatabaseEncryption
0 likes · 11 min read
How to Perform Fuzzy Searches on Encrypted Data: Strategies and Trade‑offs
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 13, 2022 · Databases

Using ClickHouse Materialized Views: Creation, Testing, and Time‑Zone Issue Resolution

This article explains how to create a ClickHouse materialized view that aggregates per‑minute data from a per‑second table, demonstrates insertion and query tests, investigates an unexpected 1970‑01‑01 timestamp caused by time‑zone handling, and provides the corrected view definition aligning field names.

ClickHouseDatabaseTime Zone
0 likes · 8 min read
Using ClickHouse Materialized Views: Creation, Testing, and Time‑Zone Issue Resolution
Java Backend Technology
Java Backend Technology
Sep 13, 2022 · Databases

Master‑Slave MySQL Replication & Read‑Write Splitting with ShardingJDBC: A Step‑by‑Step Guide

This article explains why a single MySQL instance can become a bottleneck, introduces asynchronous master‑slave replication using binary logs, provides detailed configuration commands for both master and slave servers, and shows how to achieve read‑write splitting in Java projects with ShardingJDBC, including dependency setup, YAML configuration, and testing procedures.

DatabaseMySQLShardingJDBC
0 likes · 11 min read
Master‑Slave MySQL Replication & Read‑Write Splitting with ShardingJDBC: A Step‑by‑Step Guide
dbaplus Community
dbaplus Community
Sep 12, 2022 · Databases

How to Resolve Deep Pagination Performance Problems in MySQL

This article walks through a real‑world incident caused by MySQL deep pagination, explains how the slow queries and CPU spikes were diagnosed, and presents several concrete optimization techniques—including ID‑based queries, range scans, sub‑queries and cursor‑based pagination—culminating in a stable production fix.

DatabaseDeep PaginationMySQL
0 likes · 10 min read
How to Resolve Deep Pagination Performance Problems in MySQL
Architects' Tech Alliance
Architects' Tech Alliance
Sep 12, 2022 · Databases

China Database Industry Report: Trends, Market Landscape, and Domestic Vendors

This article provides a comprehensive analysis of the Chinese database industry, covering global trends such as the dominance of relational databases and the rise of NoSQL, the impact of cloud vendors and open‑source, domestic market opportunities, classifications of database types, and profiles of leading Chinese vendors, highlighting how big‑data and AI are reshaping demand and creating growth prospects for home‑grown solutions.

Chinese marketCloud ComputingDatabase
0 likes · 10 min read
China Database Industry Report: Trends, Market Landscape, and Domestic Vendors
Java High-Performance Architecture
Java High-Performance Architecture
Sep 6, 2022 · Databases

Top 20 MySQL Optimization Tips to Boost Query Performance

This article presents twenty practical MySQL optimization techniques—from selecting specific columns and avoiding OR in WHERE clauses to proper indexing, join strategies, and using EXPLAIN—helping developers improve query speed, reduce resource consumption, and write more maintainable SQL code.

DatabasePerformancebest-practices
0 likes · 18 min read
Top 20 MySQL Optimization Tips to Boost Query Performance
dbaplus Community
dbaplus Community
Sep 4, 2022 · Databases

How to Choose the Right Database: Relational vs NoSQL Storage Guide

This article presents a comprehensive framework for selecting a storage solution, covering business and technical metrics, comparing relational databases with various NoSQL types, and offering concrete pros, cons, and scenario‑based recommendations to help engineers make informed data‑store decisions.

DatabaseNoSQLSelection
0 likes · 18 min read
How to Choose the Right Database: Relational vs NoSQL Storage Guide
IT Architects Alliance
IT Architects Alliance
Sep 4, 2022 · Cloud Native

What Is Cloud Native? Core Concepts, Architecture Principles, and Key Technologies

This article explains the definition of cloud native, its industry impact, technical characteristics, architectural design principles, and the essential technologies—including containers, serverless containers, bare‑metal containers, microservices, serverless computing, specialized chips, networking, and databases—that together enable elastic, resilient, and observable cloud‑first applications.

ContainersDatabaseServerless
0 likes · 10 min read
What Is Cloud Native? Core Concepts, Architecture Principles, and Key Technologies
DataFunTalk
DataFunTalk
Sep 3, 2022 · Databases

OpenMLDB: An Open‑Source Machine Learning Database for Consistent Online and Offline Feature Serving

This article presents OpenMLDB, an open‑source machine learning database that unifies offline and online feature computation with millisecond‑level latency, outlines its development history, architecture, recent 0.6.0 enhancements, ecosystem integrations, and multiple real‑world deployment case studies across finance, banking, research, and marketing domains.

AIDatabaseFeature Store
0 likes · 16 min read
OpenMLDB: An Open‑Source Machine Learning Database for Consistent Online and Offline Feature Serving
Past Memory Big Data
Past Memory Big Data
Aug 31, 2022 · Databases

How to Begin Contributing to an Apache Top‑Level Open Source Project

This guide walks readers through the complete process of joining an Apache top‑level project—using Apache Doris as an example—including reading the README, joining mailing lists and chat groups, finding a first‑issue, forking the repository, making code changes, submitting a pull request, and passing community review.

Apache DorisCommunityDatabase
0 likes · 12 min read
How to Begin Contributing to an Apache Top‑Level Open Source Project
dbaplus Community
dbaplus Community
Aug 24, 2022 · Databases

Mastering SQL Server: Essential Commands, Advanced Queries, and Maintenance Techniques

This guide compiles fundamental SQL Server commands for creating, modifying, and deleting databases and tables, advanced query operators, join strategies, pagination, data synchronization, performance tuning, backup and restore procedures, and useful built‑in functions, providing a comprehensive reference for database professionals.

DatabaseSQL CommandsSQL Server
0 likes · 27 min read
Mastering SQL Server: Essential Commands, Advanced Queries, and Maintenance Techniques
Tencent Cloud Developer
Tencent Cloud Developer
Aug 24, 2022 · Backend Development

Go Distributed ID Generation: UUID, ShortUUID, XID, KSUID, ULID, Snowflake, and Segment Modes

The article surveys Go‑based distributed ID generation techniques—from UUID, short‑UUID, XID, KSUID, ULID, and Snowflake to database auto‑increment, Redis, ZooKeeper, and segment/leaf approaches—detailing their characteristics, trade‑offs, implementation snippets, and strategies for ordering, uniqueness, and clock‑rollback handling.

DatabaseGoRedis
0 likes · 12 min read
Go Distributed ID Generation: UUID, ShortUUID, XID, KSUID, ULID, Snowflake, and Segment Modes
IT Services Circle
IT Services Circle
Aug 24, 2022 · Databases

Data Consistency Between MySQL and Redis: Strategies and Best Practices

This article examines common pitfalls and six practical strategies for maintaining data consistency between MySQL and Redis caches, comparing naive approaches with optimal solutions such as cache double‑delete, asynchronous serialization via message queues, and binlog‑driven eventual consistency, and offers recommendations for real‑time and eventual consistency scenarios.

Cache ConsistencyDatabaseEventual Consistency
0 likes · 8 min read
Data Consistency Between MySQL and Redis: Strategies and Best Practices
Cognitive Technology Team
Cognitive Technology Team
Aug 20, 2022 · Backend Development

Common Pitfalls of Spring Transaction Management and How to Avoid Them

This article explains common pitfalls of Spring's transaction management—including AOP proxy limitations, unchecked exception handling, self‑invocation, asynchronous execution, multiple data sources, and large transaction issues—and provides practical solutions such as using class‑based proxies, configuring rollback rules, and splitting transactions into smaller units.

AOPDatabaseJava
0 likes · 6 min read
Common Pitfalls of Spring Transaction Management and How to Avoid Them
Top Architect
Top Architect
Aug 18, 2022 · Backend Development

Common Causes of Backend Interface Performance Issues and Their Optimization Strategies

The article systematically analyzes why backend APIs become slow—covering database slow queries, complex business logic, thread‑pool misconfiguration, lock design flaws, and machine problems—and presents practical Java‑based optimization techniques such as pagination fixes, index tuning, multithreading, proper thread‑pool sizing, lock refinement, caching, and asynchronous callbacks.

DatabasePerformancebackend
0 likes · 18 min read
Common Causes of Backend Interface Performance Issues and Their Optimization Strategies
Laravel Tech Community
Laravel Tech Community
Aug 17, 2022 · Databases

Comprehensive SQL Server Database Operations and Techniques Guide

This article provides a comprehensive collection of SQL Server commands and techniques, covering database creation, table manipulation, queries, indexing, backup, replication, and advanced operations, offering practical examples and code snippets for developers and database administrators.

DatabaseSQLSQL Server
0 likes · 23 min read
Comprehensive SQL Server Database Operations and Techniques Guide
Top Architect
Top Architect
Aug 16, 2022 · Databases

How to Perform Fuzzy Queries on Encrypted Data: Methods, Trade‑offs, and Recommendations

This article examines the difficulty of fuzzy searching encrypted fields and compares three solution families—naïve memory‑loading or tag‑table tricks, conventional token‑based encryption with indexable columns, and advanced algorithmic designs—highlighting their security, performance, and storage implications while recommending the most practical approach.

AlgorithmDatabaseEncryption
0 likes · 10 min read
How to Perform Fuzzy Queries on Encrypted Data: Methods, Trade‑offs, and Recommendations
StarRocks
StarRocks
Aug 10, 2022 · Databases

How 58 Group Scaled AP Analytics with StarRocks: Benchmarks, Ops Tools, and Cloud Deployment

Facing massive AP‑heavy analytics workloads, 58 Group evaluated TiFlash, ClickHouse and StarRocks, chose StarRocks for its superior write/read performance and ease of operation, built internal tools for topology, cluster, Kafka import and slow‑SQL management, and migrated to cloud‑native Docker deployments, achieving up to 90% query speedup and massive data‑volume reductions.

DatabasePerformance
0 likes · 17 min read
How 58 Group Scaled AP Analytics with StarRocks: Benchmarks, Ops Tools, and Cloud Deployment
Java Architect Essentials
Java Architect Essentials
Aug 9, 2022 · Backend Development

Master MyBatis-Plus in Spring Boot: Quick Start, Configuration, and Advanced Features

This guide walks through integrating MyBatis-Plus with Spring Boot, covering environment setup, Maven dependencies, configuration of data sources, entity annotations, CRUD services, pagination, logical deletion, enum handling, automatic field filling, multi‑data‑source strategies, and testing with full code examples.

DatabaseJavaORM
0 likes · 20 min read
Master MyBatis-Plus in Spring Boot: Quick Start, Configuration, and Advanced Features
Xiaolei Talks DB
Xiaolei Talks DB
Aug 8, 2022 · Databases

Mastering TiDB Upgrades: Strategies, Risks, and Real‑World Case Studies

This comprehensive guide explains why TiDB upgrades are essential, compares offline, forced, and smooth upgrade methods, outlines detailed step‑by‑step procedures, highlights advantages and risks, and shares practical check‑points and real‑world case studies to help DBAs ensure a safe, performant migration.

DatabasePerformanceRollback
0 likes · 21 min read
Mastering TiDB Upgrades: Strategies, Risks, and Real‑World Case Studies
HomeTech
HomeTech
Aug 4, 2022 · Information Security

Preventing SQL Injection: Principles, Practices, and Safe MyBatis Usage

This article explains the fundamentals of SQL injection attacks, outlines their severe consequences, and provides a comprehensive set of prevention principles and practical measures—including parameterized queries, strong typing, input validation, and secure MyBatis configurations—to help developers safeguard backend applications and databases.

DatabaseMyBatisPreparedStatement
0 likes · 10 min read
Preventing SQL Injection: Principles, Practices, and Safe MyBatis Usage
Java Architect Essentials
Java Architect Essentials
Aug 3, 2022 · Databases

Comprehensive SQL Server Database Operations and Replication Guide

This article provides an extensive collection of SQL Server commands and techniques covering basic database creation, table manipulation, advanced queries, backup and maintenance, as well as detailed steps for setting up linked servers, snapshot replication, and synchronization procedures between servers.

DatabaseLinked ServerSQL
0 likes · 23 min read
Comprehensive SQL Server Database Operations and Replication Guide
IT Architects Alliance
IT Architects Alliance
Jul 31, 2022 · Databases

Why Redis Uses Dual Data Structures for Sets and Sorted Sets

This article explains how Redis internally stores set and sorted‑set objects using intset, hashtable, ziplist, and skiplist encodings, the conditions that trigger each representation, the upgrade process, and the essential Redis commands for manipulating these data structures.

Data StructuresDatabaseRedis
0 likes · 16 min read
Why Redis Uses Dual Data Structures for Sets and Sorted Sets
DataFunTalk
DataFunTalk
Jul 30, 2022 · Databases

StarRocks-Based Unified Data Service and Analytics Platform at JD Logistics

JD Logistics leverages StarRocks to create the Udata unified query engine, addressing data silos, low performance, and high maintenance costs by integrating data services and analytics, enabling low‑code data service generation, high‑speed federated queries, real‑time updates, and future data‑lake and resource isolation capabilities.

Data IntegrationDatabaseReal-Time Analytics
0 likes · 14 min read
StarRocks-Based Unified Data Service and Analytics Platform at JD Logistics
Top Architect
Top Architect
Jul 29, 2022 · Backend Development

Implementing API Idempotency in Spring Boot Using Tokens, Database Primary Keys, Optimistic Locks, and Redis

This article explains the concept of idempotency in computing and HTTP, why it is essential for APIs, the impact on system design, which RESTful methods are idempotent, and presents four practical implementation strategies—including database primary keys, optimistic locking, anti‑repeat tokens, and downstream sequence numbers—accompanied by complete Spring Boot code examples and testing procedures.

APIDatabaseJava
0 likes · 22 min read
Implementing API Idempotency in Spring Boot Using Tokens, Database Primary Keys, Optimistic Locks, and Redis
Liangxu Linux
Liangxu Linux
Jul 28, 2022 · Databases

Why Your MySQL Queries Are Slow and How to Fix Common Mistakes

This article examines frequent MySQL performance pitfalls—such as misuse of LIMIT, implicit type conversion, sub‑query updates, mixed sorting, EXISTS clauses, and condition push‑down failures—and demonstrates how rewriting queries with proper indexes, JOINs, early range reduction, and WITH statements can dramatically reduce execution time.

DatabaseMySQLQuery Rewrite
0 likes · 15 min read
Why Your MySQL Queries Are Slow and How to Fix Common Mistakes
DataFunTalk
DataFunTalk
Jul 28, 2022 · Databases

ClickHouse Overview and the Top 5 Features Released in 2021

This article provides a comprehensive overview of ClickHouse, covering its origins, core characteristics, and the five most important features introduced in 2021—including JIT acceleration, Lambda‑based UDFs, native window functions, zero‑copy replication for S3/HDFS, and the Projection mechanism—highlighting why it remains a leading high‑performance OLAP database for big‑data analytics.

ClickHouseDatabaseOLAP
0 likes · 15 min read
ClickHouse Overview and the Top 5 Features Released in 2021
政采云技术
政采云技术
Jul 28, 2022 · Databases

Analyzing and Resolving MySQL Next‑Key Lock Deadlocks: A Practical Case Study

This article walks through a real MySQL deadlock scenario, explaining the four necessary deadlock conditions, illustrating how Next‑Key locks on non‑unique indexes cause gap locks, and presenting step‑by‑step analysis, experimental verification, and practical recommendations to avoid such deadlocks in production systems.

DatabaseDeadlockMySQL
0 likes · 15 min read
Analyzing and Resolving MySQL Next‑Key Lock Deadlocks: A Practical Case Study
JavaEdge
JavaEdge
Jul 24, 2022 · Databases

Understanding Database Transactions: ACID, Isolation, and Real-World Pitfalls

The article examines why robust fault‑tolerance is essential for data stores, explains how transactions simplify error handling, breaks down the ACID guarantees, illustrates isolation and durability with concrete examples and diagrams, and discusses when multi‑object transactions are truly needed.

ACIDDatabaseIsolation
0 likes · 20 min read
Understanding Database Transactions: ACID, Isolation, and Real-World Pitfalls
Senior Brother's Insights
Senior Brother's Insights
Jul 24, 2022 · Databases

Understanding Redis High Availability: Master‑Slave, Sentinel, and Cluster Explained

This article explains why single‑node Redis suffers from single‑point failures, describes the master‑slave replication model, details the Sentinel automatic failover mechanism, compares various sharding solutions like client‑side sharding, Twemproxy, Codis, and outlines the features and deployment considerations of Redis Cluster.

ClusterDatabaseHigh Availability
0 likes · 19 min read
Understanding Redis High Availability: Master‑Slave, Sentinel, and Cluster Explained
dbaplus Community
dbaplus Community
Jul 22, 2022 · Databases

Why MongoDB Is Adding Native Analytics and What It Means for Developers

The article examines MongoDB’s evolution toward built‑in analytics, detailing new features like native search, time‑series support, change streams, Atlas analytics nodes, and the upcoming Atlas SQL interface, while arguing that these capabilities aim to empower developers rather than replace dedicated data‑warehouse solutions.

ATLASAnalyticsDatabase
0 likes · 10 min read
Why MongoDB Is Adding Native Analytics and What It Means for Developers
DataFunSummit
DataFunSummit
Jul 22, 2022 · Databases

Future of Databases: Cloud‑Native Innovations, Amazon Aurora, and Migration Tools

The presentation explores the rapid growth of data, challenges of traditional on‑premise databases, and how cloud‑native solutions such as Amazon Aurora, Aurora Serverless, Aurora Global Database, and Babelfish for Aurora PostgreSQL provide high‑performance, scalable, and cost‑effective migration paths for modern applications.

Amazon AuroraBabelfishDatabase
0 likes · 14 min read
Future of Databases: Cloud‑Native Innovations, Amazon Aurora, and Migration Tools
Open Source Linux
Open Source Linux
Jul 22, 2022 · Databases

What New SQL Features Did SQLite Add in 2018? A Deep Dive

This article reviews SQLite's 2018 enhancements, covering Boolean literals, window functions, the FILTER clause, upsert support, column renaming, and related API changes, while highlighting limitations and compatibility notes compared with other major databases.

Boolean LiteralsDatabaseSQL
0 likes · 12 min read
What New SQL Features Did SQLite Add in 2018? A Deep Dive
FunTester
FunTester
Jul 18, 2022 · Databases

Why MySQL’s MysqlConnectionPoolDataSource Isn’t a Real Connection Pool (And How to Use It)

The article examines the MySQL class com.mysql.cj.jdbc.MysqlConnectionPoolDataSource, revealing that despite its name it creates new connections each request and only recycles idle ones, provides a practical Groovy example, highlights pitfalls such as duplicate setURL methods, and concludes it’s unsuitable as a true pool for testing.

DatabaseGroovyJava
0 likes · 5 min read
Why MySQL’s MysqlConnectionPoolDataSource Isn’t a Real Connection Pool (And How to Use It)
Architects' Tech Alliance
Architects' Tech Alliance
Jul 17, 2022 · Databases

Comprehensive Overview of Database Evolution, Architecture, and Core Technologies

This article provides a detailed survey of database fundamentals, historical evolution from early relational systems to modern distributed and cloud‑native solutions, explains various architectural components and core technologies such as query processing, indexing, transaction management, and discusses business‑driven classifications, distributed designs, SMP versus MPP, and resource‑access models.

DatabaseHTAPNoSQL
0 likes · 34 min read
Comprehensive Overview of Database Evolution, Architecture, and Core Technologies
Architect
Architect
Jul 17, 2022 · Operations

Performance Monitoring and Optimization Techniques for Backend Systems

The article discusses practical methods for monitoring and diagnosing performance issues in backend applications, covering database slow‑query logs, interface latency, message‑queue backlogs, segment‑timing analysis, and optimization strategies such as request merging, caching, multithreading, and database tuning.

DatabaseOptimization
0 likes · 9 min read
Performance Monitoring and Optimization Techniques for Backend Systems
Selected Java Interview Questions
Selected Java Interview Questions
Jul 15, 2022 · Databases

New SQLite SQL Features Introduced in 2018 (Versions 3.22.0–3.26.0)

The article reviews SQLite's 2018 enhancements—including boolean literals, window functions, FILTER clause, UPSERT syntax, and column‑renaming—explaining their syntax, behavior with NULLs, and practical examples, while also noting SQLite's reliability and deployment advantages despite lacking a network layer.

Boolean LiteralsDatabaseFILTER clause
0 likes · 10 min read
New SQLite SQL Features Introduced in 2018 (Versions 3.22.0–3.26.0)
Ops Development Stories
Ops Development Stories
Jul 15, 2022 · Databases

Unlock Redis Mastery: 40+ Diagrams & 30k Words of Interview Essentials

This comprehensive guide covers everything from Redis fundamentals, data structures, and thread model to persistence strategies, clustering, memory eviction policies, cache design patterns, and advanced use‑cases like delayed queues, large‑key handling, pipelines, transactions, and distributed locking, providing interview‑ready knowledge for developers.

ClusterDatabasePersistence
0 likes · 66 min read
Unlock Redis Mastery: 40+ Diagrams & 30k Words of Interview Essentials
Top Architect
Top Architect
Jul 14, 2022 · Databases

Understanding Redis Memory Model and Its Applications

This article explains Redis's memory model, covering memory statistics, internal structures such as redisObject, SDS, and various object types, their encoding schemes, memory allocation, fragmentation, and provides practical examples for estimating memory usage, optimizing consumption, and monitoring fragmentation in high‑performance applications.

DatabasePerformance OptimizationRedis
0 likes · 30 min read
Understanding Redis Memory Model and Its Applications
JavaEdge
JavaEdge
Jul 10, 2022 · Databases

How to Partition Massive Datasets: Strategies, Trade‑offs, and Hotspot Prevention

This article explains why large‑scale systems need data partitioning beyond replication, defines partitions and sharding, compares key‑range and hash‑based partitioning methods, discusses load‑balancing and hotspot avoidance, and shows how replication works together with partitioning to improve scalability.

DatabaseHashingSharding
0 likes · 12 min read
How to Partition Massive Datasets: Strategies, Trade‑offs, and Hotspot Prevention
Architecture Digest
Architecture Digest
Jul 10, 2022 · Databases

Redis High Availability: Master‑Slave, Sentinel, and Cluster Solutions

Redis provides multiple high‑availability solutions—including master‑slave replication, Sentinel automatic failover, client‑side sharding, proxy‑based sharding (Twemproxy, Codis), and the native Redis Cluster—each with distinct architectures, advantages, and trade‑offs for scaling, fault tolerance, and operational complexity.

ClusterDatabaseRedis
0 likes · 17 min read
Redis High Availability: Master‑Slave, Sentinel, and Cluster Solutions
Programmer DD
Programmer DD
Jul 8, 2022 · Databases

Why Auto‑Increment Beats UUID in MySQL: Performance Test & Deep Dive

This article investigates MySQL’s recommendation against UUIDs, comparing auto‑increment, UUID, and Snowflake‑style random keys through insertion and query benchmarks, analyzing their index structures, performance impacts, and trade‑offs, and concludes why sequential primary keys generally outperform non‑sequential identifiers.

DatabaseIndexMySQL
0 likes · 12 min read
Why Auto‑Increment Beats UUID in MySQL: Performance Test & Deep Dive
JD Tech
JD Tech
Jul 8, 2022 · Backend Development

Designing High‑Concurrency Inventory Systems with Redis, Database Transactions, and a Task Engine

This article presents a comprehensive solution for building an e‑commerce inventory system that prevents overselling under high concurrency by combining database transactions, Redis‑based stock deduction, idempotent anti‑repeat mechanisms, pipeline optimization, and a task‑engine driven eventual‑consistency architecture.

DatabaseInventoryRedis
0 likes · 13 min read
Designing High‑Concurrency Inventory Systems with Redis, Database Transactions, and a Task Engine
Top Architect
Top Architect
Jul 7, 2022 · Databases

Understanding InnoDB Logical Storage Structure and B+Tree Indexes in MySQL

The article explains MySQL InnoDB's logical storage architecture, including tablespaces, pages, segments, and B+‑tree indexes, demonstrates how primary and secondary indexes are organized and accessed, and shows how to calculate index tree height and data capacity using SQL queries and hexdump analysis.

B+ treeDatabaseIndex
0 likes · 10 min read
Understanding InnoDB Logical Storage Structure and B+Tree Indexes in MySQL
IT Services Circle
IT Services Circle
Jul 6, 2022 · Databases

Understanding MySQL COUNT() Performance and Strategies for Large Tables

This article explains how MySQL COUNT() works under different storage engines, why counting rows becomes slow on large InnoDB tables, and presents practical methods such as using EXPLAIN rows, auxiliary count tables, batch processing, and transaction‑based updates to obtain approximate or exact row counts efficiently.

COUNTDatabaseInnoDB
0 likes · 12 min read
Understanding MySQL COUNT() Performance and Strategies for Large Tables
Su San Talks Tech
Su San Talks Tech
Jul 6, 2022 · Databases

Master Redis Memory: 7 Proven Techniques to Store More Data with Less RAM

This article explains Redis's internal storage mechanisms and presents seven practical optimization techniques—including key‑value compression, small‑collection encoding, object sharing, bitmap usage, hash structuring, memory‑fragment defragmentation, and 32‑bit deployment—to dramatically reduce memory consumption while increasing data capacity.

CacheData StructuresDatabase
0 likes · 21 min read
Master Redis Memory: 7 Proven Techniques to Store More Data with Less RAM
ITPUB
ITPUB
Jul 4, 2022 · Databases

Why Wanli Database Became the Dark Horse Leader in China’s Critical‑Application Market

The article analyzes Wanli Database’s rise to the leader quadrant in the CCID “14th Five‑Year Plan” key‑application database market report, detailing its technical advancement, security credentials, distributed architecture, industry collaborations, and open‑source initiatives that underpin its competitive edge.

Critical ApplicationsDatabaseMarket Analysis
0 likes · 15 min read
Why Wanli Database Became the Dark Horse Leader in China’s Critical‑Application Market
Xiaohongshu Tech REDtech
Xiaohongshu Tech REDtech
Jul 4, 2022 · Databases

RedKV: Xiaohongshu's Distributed NoSQL KV Storage System

RedKV, Xiaohongshu’s self‑developed distributed NoSQL key‑value store, combines a Redis‑compatible interface, RocksDB‑backed storage, and a shard‑managed multi‑cloud architecture that delivers three‑times higher write throughput, 1.5‑times read throughput, 40 % cost savings versus HBase, and sub‑5 ms P999 latency for petabyte‑scale workloads.

DatabaseDistributed KVLZ4 compression
0 likes · 25 min read
RedKV: Xiaohongshu's Distributed NoSQL KV Storage System
Sanyou's Java Diary
Sanyou's Java Diary
Jun 30, 2022 · Databases

Mastering Redis High Availability: Sharding, Consistent Hashing, and Sentinel Explained

This article explains Redis high‑availability strategies, covering basic hash sharding, the advantages of consistent hashing, client‑side versus proxy‑based partitioning, master‑slave replication, and the Sentinel failover mechanism, with diagrams illustrating node addition, removal, and failover decision processes.

DatabaseHigh AvailabilityRedis
0 likes · 10 min read
Mastering Redis High Availability: Sharding, Consistent Hashing, and Sentinel Explained
Tencent Cloud Developer
Tencent Cloud Developer
Jun 30, 2022 · Databases

Redis Overview: Architecture, Persistence, Replication, Sentinel, and Cluster

Redis is a single‑threaded, in‑memory data store offering rich structures, configurable expiration, multiple eviction policies, asynchronous master‑slave replication with Sentinel failover, durable RDB snapshots plus AOF logging, and native clustering that shards data across many masters for horizontal scalability and high availability.

CacheClusterDatabase
0 likes · 18 min read
Redis Overview: Architecture, Persistence, Replication, Sentinel, and Cluster
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 30, 2022 · Databases

Handling Replication Anomalies in MySQL Slave IO Thread

This article analyzes MySQL replication anomalies caused by master failures or network interruptions that lead to incomplete transaction replay on slaves, demonstrates a reproducible experiment using network delay and iptables, and provides practical guidance for both recovering and permanently handling stalled slave IO threads.

DatabaseGTIDMySQL
0 likes · 6 min read
Handling Replication Anomalies in MySQL Slave IO Thread
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 29, 2022 · Databases

Understanding Multi-Column Partition Tables in MySQL: Implementation, Performance Comparison, and Best Practices

This article explains MySQL's support for multi‑column partition tables, provides a stored‑procedure to create them, compares performance against single‑column partitions under various query conditions, discusses partition column order impact, and offers practical guidance for when and how to use multi‑column partitions.

DatabaseMulti-ColumnMySQL
0 likes · 10 min read
Understanding Multi-Column Partition Tables in MySQL: Implementation, Performance Comparison, and Best Practices
Open Source Linux
Open Source Linux
Jun 29, 2022 · Databases

Top MySQL Interview Questions & Answers Every DBA Should Know

This article compiles essential MySQL interview questions covering primary and candidate keys, date functions, trigger limits, index column counts, data copying techniques, core MySQL concepts, feature highlights, transaction ACID properties, heap versus clustered tables, numeric type differences, and objects creatable with CREATE statements.

DatabaseHeap TableInterview Questions
0 likes · 9 min read
Top MySQL Interview Questions & Answers Every DBA Should Know
MaGe Linux Operations
MaGe Linux Operations
Jun 28, 2022 · Databases

How Indexes Can Speed Up MySQL Queries by 50,000×: A Deep Dive

This article walks through a MySQL scenario with large tables, demonstrates why a sub‑query that took over eight hours runs in just a second after adding appropriate single‑column and composite indexes, and explains how to read and interpret execution plans for further tuning.

DatabaseMySQLSQL
0 likes · 11 min read
How Indexes Can Speed Up MySQL Queries by 50,000×: A Deep Dive
ITPUB
ITPUB
Jun 28, 2022 · Backend Development

Mastering Distributed Locks: Database, Redis, and Zookeeper Strategies

This article explains the design and implementation of distributed locks, covering database pessimistic and optimistic locks, various Redis lock patterns, Redisson and RedLock, as well as Zookeeper's lock mechanism, and compares their advantages, drawbacks, and suitable use cases.

DatabaseZookeeperbackend
0 likes · 20 min read
Mastering Distributed Locks: Database, Redis, and Zookeeper Strategies
php Courses
php Courses
Jun 24, 2022 · Databases

Comprehensive List of MySQL Interview Questions

This article compiles 66 MySQL interview questions covering fundamentals such as joins, data types, indexes, storage engines, transaction properties, locking mechanisms, replication, sharding, performance tuning, and high‑availability concepts for interview preparation.

DatabaseMySQLPerformance
0 likes · 3 min read
Comprehensive List of MySQL Interview Questions
Baidu Geek Talk
Baidu Geek Talk
Jun 22, 2022 · Databases

Analyzing Go SQL Connection Pool Resource Release and Transaction Management

The article explains how Go's database/sql pool retains connections until Rows, Stmt, or Tx objects are explicitly closed or a timeout context is cancelled, demonstrates experiments showing blocked goroutines when resources aren't released, and offers practical guidelines—using QueryContext with timeouts, deferring Close/Cancel, and always committing or rolling back transactions—to prevent pool exhaustion and improve MySQL reliability.

DatabaseGoSQL
0 likes · 19 min read
Analyzing Go SQL Connection Pool Resource Release and Transaction Management
Open Source Linux
Open Source Linux
Jun 21, 2022 · Operations

Top 150 Must‑Know Linux & DevOps Interview Questions (Answers Inside)

This article compiles a comprehensive list of over a hundred Linux, networking, load‑balancing, database, caching, monitoring, container and cloud‑native interview questions, providing candidates with essential knowledge to ace system‑administration and DevOps job interviews.

DatabaseDevOpsInterview
0 likes · 11 min read
Top 150 Must‑Know Linux & DevOps Interview Questions (Answers Inside)
Top Architect
Top Architect
Jun 14, 2022 · Databases

Understanding MySQL Execution Process: Connectors, Cache, Parser, Optimizer, and Executor

This article explains MySQL's internal execution process—including the connector, cache, parser, optimizer, and executor—describes privilege tables and verification, discusses query caching removal, outlines logical SQL execution order, and provides practical tips for ordering WHERE conditions to improve performance.

DatabaseDatabase InternalsMySQL
0 likes · 12 min read
Understanding MySQL Execution Process: Connectors, Cache, Parser, Optimizer, and Executor
Top Architect
Top Architect
Jun 13, 2022 · Databases

Comprehensive MySQL Performance Optimization Guide

This article provides a detailed guide on optimizing MySQL performance, covering SQL statement tuning, index usage, table design normalization, system configuration, hardware choices, and the internal architecture of MySQL to help developers write faster and more efficient queries.

DatabaseMySQLPerformance Tuning
0 likes · 19 min read
Comprehensive MySQL Performance Optimization Guide
Top Architect
Top Architect
Jun 12, 2022 · Databases

Best Practices for Using Alibaba Cloud Redis: Key Design, Command Usage, Client Configuration, and Tooling

This article outlines comprehensive guidelines for Alibaba Cloud Redis, covering readable and concise key naming, value size limits, appropriate data types, key lifecycle management, safe command usage, client connection pooling, encryption, eviction policies, and tools for synchronization, big‑key detection, and efficient deletion.

Alibaba CloudCommand OptimizationDatabase
0 likes · 8 min read
Best Practices for Using Alibaba Cloud Redis: Key Design, Command Usage, Client Configuration, and Tooling
Qunar Tech Salon
Qunar Tech Salon
Jun 8, 2022 · Backend Development

Design and Implementation of a Systematic Cache Architecture for High‑Performance Business Systems

This article describes how a multi‑layered cache system—including a DAO‑level Redis cache, shared cache components, and global cache planning—was designed, implemented, and deployed to reduce database QPS by over 80%, cut response latency, and improve overall system stability in a high‑traffic e‑commerce platform.

DatabasePerformancecaching
0 likes · 30 min read
Design and Implementation of a Systematic Cache Architecture for High‑Performance Business Systems
Tencent Cloud Developer
Tencent Cloud Developer
Jun 7, 2022 · Databases

Mastering MongoDB: From Basics to Advanced Performance Tuning

This comprehensive guide explores MongoDB’s core features—including schema flexibility, high availability, sharding, storage engine internals, indexing, and performance tuning—while providing practical examples, configuration tips, and best‑practice recommendations for developers and architects seeking to efficiently deploy and operate MongoDB in production environments.

DatabaseMongoDBPerformance
0 likes · 40 min read
Mastering MongoDB: From Basics to Advanced Performance Tuning
政采云技术
政采云技术
Jun 7, 2022 · Databases

Understanding MySQL Auto‑Increment Locks and Their Behaviors

This article explains the concept of MySQL auto‑increment locks, describes different insertion methods and lock modes, analyzes how InnoDB allocates and manages auto‑increment IDs—including simple, bulk, and mixed inserts—and provides source‑code insights, practical experiments, and mitigation strategies for ID continuity issues.

DatabaseInnoDBMySQL
0 likes · 21 min read
Understanding MySQL Auto‑Increment Locks and Their Behaviors
MaGe Linux Operations
MaGe Linux Operations
Jun 6, 2022 · Databases

What Is a Schema? From Databases to Kubernetes Explained

This article explains the concept of a schema—from its Greek origins and psychological meaning to its role as metadata in databases and Kubernetes—detailing different database schema models, Kubernetes resource definitions, and how to extend and register custom schemas in Go.

Databasegolangmetadata
0 likes · 8 min read
What Is a Schema? From Databases to Kubernetes Explained