BestHub
Sign in
Tagged articles
2671 articles
Page 12 of 27
DeWu Technology
DeWu Technology
Oct 31, 2022 · Databases

Analysis of Order Query Failures Caused by MySQL Master‑Slave Replication Lag and Mitigation Strategies

The e‑commerce platform’s order‑query alerts were caused by MySQL master‑slave replication lag—specifically, delayed redo‑log flushing let the slave receive binlog events before the master committed—so queries returned empty, a condition mitigated by retry logic, delayed MQ delivery, or emitting post‑commit business events.

BinlogMaster‑SlaveMySQL
0 likes · 10 min read
Analysis of Order Query Failures Caused by MySQL Master‑Slave Replication Lag and Mitigation Strategies
Top Architect
Top Architect
Oct 27, 2022 · Databases

Techniques for Fuzzy Query on Encrypted Data

This article examines the challenges of performing fuzzy searches on encrypted data and compares three categories of solutions—naïve, conventional, and advanced—detailing their implementation methods, performance trade‑offs, storage costs, and security implications for real‑world applications.

Performancedatabaseencryption
0 likes · 12 min read
Techniques for Fuzzy Query on Encrypted Data
Laravel Tech Community
Laravel Tech Community
Oct 26, 2022 · Databases

Mongoose 6.7 Release Overview

Mongoose 6.7, the asynchronous‑environment MongoDB object‑modeling library for Node.js, introduces driver upgrades, new UUID schema type, $fill pipeline stage, enhanced TypeScript support, aliasing, mergeHooks, and timestamp utilities, while encouraging readers to like and share the article.

MongoDBMongooseNode.js
0 likes · 2 min read
Mongoose 6.7 Release Overview
Code Ape Tech Column
Code Ape Tech Column
Oct 26, 2022 · Databases

In‑Depth Analysis of Druid Connection‑Pool Lifecycle and Internal Processes

This article provides a comprehensive walkthrough of Druid's connection‑pool architecture, detailing the initialization, acquisition, validation, eviction, and recycling of connections, while explaining key configuration options, thread‑safety mechanisms, and performance considerations for Java database applications.

Connection PoolDruidPerformance
0 likes · 23 min read
In‑Depth Analysis of Druid Connection‑Pool Lifecycle and Internal Processes
DaTaobao Tech
DaTaobao Tech
Oct 19, 2022 · Databases

Overview of LSM‑Tree Architecture and Its Use in Modern Databases

LSM‑Tree stores writes in an in‑memory MemTable then flushes ordered SSTables to disk, using Bloom filters and indexes to speed reads, while periodic compactions merge files; modern systems such as LevelDB, HBase, and ClickHouse adopt this design to achieve high write throughput despite slower point and range queries and occasional compaction overhead.

ClickHouseHBaseLSM‑Tree
0 likes · 11 min read
Overview of LSM‑Tree Architecture and Its Use in Modern Databases
dbaplus Community
dbaplus Community
Oct 18, 2022 · Databases

Mastering ClickHouse: Practical Table Engine Choices and Cluster Best Practices

This guide explains ClickHouse’s core concepts, application scenarios, table engine families, detailed engine configurations, SQL development standards, cluster architecture, ZooKeeper’s role, chproxy usage, client tool options, availability considerations, and performance‑tuning parameters for high‑throughput OLAP workloads.

ClickHouseClusterTable Engine
0 likes · 26 min read
Mastering ClickHouse: Practical Table Engine Choices and Cluster Best Practices
Architecture Digest
Architecture Digest
Oct 13, 2022 · Databases

Comprehensive Overview of Redis: Architecture, Data Structures, Persistence, Replication, Clustering and Advanced Features

This article provides an in‑depth technical guide to Redis, covering its single‑threaded model, core data structures (String, Hash, List, Set, ZSet) with practical commands, persistence mechanisms (RDB, AOF, hybrid), master‑slave replication, Sentinel and cluster architectures, cache eviction policies, memory management, progressive rehash, skiplist implementation, bitmap statistics, and consistency challenges when coupling Redis with MySQL.

Data StructuresPersistenceclustering
0 likes · 28 min read
Comprehensive Overview of Redis: Architecture, Data Structures, Persistence, Replication, Clustering and Advanced Features
IT Architects Alliance
IT Architects Alliance
Oct 12, 2022 · Databases

Master MySQL Execution Order: 8 Proven Techniques to Supercharge Query Performance

This article explains MySQL's execution order and presents eight practical optimizations—including smarter LIMIT usage, implicit conversion handling, join‑based updates, mixed sorting, EXISTS rewriting, condition push‑down, early range reduction, and intermediate result push‑down—each illustrated with SQL examples and performance measurements.

MySQLQuery PerformanceSQL optimization
0 likes · 14 min read
Master MySQL Execution Order: 8 Proven Techniques to Supercharge Query Performance
Code Ape Tech Column
Code Ape Tech Column
Oct 11, 2022 · Databases

13 Redis Performance Optimization Rules

This article presents thirteen practical guidelines for optimizing Redis performance, covering command selection, key management, data structures, persistence settings, hardware choices, clustering, and memory fragmentation mitigation to achieve significant speed improvements.

BackendPerformancedatabase
0 likes · 11 min read
13 Redis Performance Optimization Rules
Java Architect Essentials
Java Architect Essentials
Oct 10, 2022 · Backend Development

Implementing MyBatis TypeHandler for Field Encryption in Java

This article demonstrates how to securely store and retrieve sensitive fields such as phone numbers in a MySQL database by creating a custom Java Encrypt class, a MyBatis TypeHandler for automatic encryption/decryption, configuring the mapper XML, and verifying the solution with test results.

TypeHandlerdatabaseencryption
0 likes · 8 min read
Implementing MyBatis TypeHandler for Field Encryption in Java
ITPUB
ITPUB
Oct 3, 2022 · Databases

Understanding Redis Persistence: RDB vs AOF Explained

This article explains how Redis ensures data durability by describing the two persistence mechanisms—RDB snapshots and AOF append‑only logs—including their creation, loading, configuration options, performance trade‑offs, and guidance on choosing the appropriate method for different workloads.

AOFData RecoveryPersistence
0 likes · 11 min read
Understanding Redis Persistence: RDB vs AOF Explained
AntTech
AntTech
Sep 30, 2022 · Artificial Intelligence

Ant Group’s 2022 Technical Highlights: Open‑Source Privacy Computing, OceanBase 4.0, AI Security, and Research Achievements

In 2022 Ant Group announced the open‑source privacy‑computing framework “YinYu”, launched OceanBase 4.0 with a single‑node distributed architecture, earned multiple AI and security awards, released AI risk‑detection platforms, open‑sourced the high‑performance graph database TuGraph, and published several papers at top AI conferences, showcasing its broad innovations across privacy, AI, and data infrastructure.

Ant GroupOpen-sourcedatabase
0 likes · 14 min read
Ant Group’s 2022 Technical Highlights: Open‑Source Privacy Computing, OceanBase 4.0, AI Security, and Research Achievements
Bilibili Tech
Bilibili Tech
Sep 30, 2022 · Databases

Database Failure Management: Types, Mitigation Strategies, and Bilibili’s Practices

The article outlines common database and cache failures—such as instance outages, replication lag, data corruption, and cache avalanches—while detailing Bilibili’s mitigation strategies including high‑availability architectures, scaling, multi‑active designs, proxy controls, slow‑query alerts, fault‑injection drills, and ongoing resilience improvements.

BilibiliCacheMySQL
0 likes · 17 min read
Database Failure Management: Types, Mitigation Strategies, and Bilibili’s Practices
ITPUB
ITPUB
Sep 26, 2022 · Databases

Redis Persistence Explained: RDB Snapshots vs AOF Logging

The article narrates how Redis, personified as a character, discovers data loss risks, implements RDB snapshotting and configurable save intervals, learns from MySQL's binary log, adopts Append‑Only File logging with flush policies, and finally adds AOF rewrite to keep storage efficient.

AOFData RecoveryPersistence
0 likes · 9 min read
Redis Persistence Explained: RDB Snapshots vs AOF Logging
Top Architect
Top Architect
Sep 24, 2022 · Information Security

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

This article examines the challenges of fuzzy searching encrypted data and compares three categories of solutions—naïve (sand‑wich), conventional, and advanced (super)—detailing their implementation ideas, performance implications, and suitability for real‑world applications.

algorithmdata securitydatabase
0 likes · 11 min read
How to Perform Fuzzy Queries on Encrypted Data: Methods and Trade‑offs
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 24, 2022 · Databases

Weekly Database and Big Data Article Highlights

This weekly roundup presents a curated selection of high‑quality technical articles and resources on MySQL, database error‑log analysis, big‑data task optimization, SQL injection case studies, and upcoming SQLE development plans, offering readers up‑to‑date insights into database engineering and performance best practices.

Big DataMySQLSQL Auditing
0 likes · 4 min read
Weekly Database and Big Data Article Highlights
Programmer DD
Programmer DD
Sep 23, 2022 · Backend Development

Scaling a Nationwide ID Lookup Service with Minimal Resources

The article outlines a practical backend design for handling 20 million daily ID lookups across a billion records, showing how modest hardware—20 virtual machines with 16 GB RAM each—can meet the load using simple sharding, in‑memory storage, and basic networking techniques.

BackendScalabilitySystem Design
0 likes · 7 min read
Scaling a Nationwide ID Lookup Service with Minimal Resources
Architect
Architect
Sep 22, 2022 · Information Security

How to Perform Fuzzy Queries on Encrypted Data

This article examines various techniques for enabling fuzzy search on encrypted data, comparing naïve, conventional, and advanced algorithmic approaches, evaluating their security, performance, and storage trade‑offs, and provides practical implementation guidance and reference resources.

Information Securitydata privacydatabase
0 likes · 11 min read
How to Perform Fuzzy Queries on Encrypted Data
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 StructuresMemory Optimization
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 LiteralsFILTER clauseSQLite
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.

Performancealgorithmdata security
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.

ClickHouseTime Zonedatabase
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.

MySQLReplicationShardingJDBC
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.

MySQLSQL optimizationdatabase
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 ComputingNoSQL
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.

Performancebest-practicesdatabase
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.

NoSQLRelationalSelection
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.

ArchitectureCloud NativeContainers
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.

AIFeature StoreOpenMLDB
0 likes · 16 min read
OpenMLDB: An Open‑Source Machine Learning Database for Consistent Online and Offline Feature Serving
DataFunSummit
DataFunSummit
Aug 28, 2022 · Databases

Practical Implementation of TimescaleDB and PostgreSQL at Hytera: Concepts, Deployment, and Performance

This article presents an in‑depth overview of time‑series data concepts and the practical adoption of TimescaleDB built on PostgreSQL at Hytera, covering requirements, core features, hypertable architecture, deployment models, compression, data retention, backup strategies, and performance benchmarks.

DistributedTime-seriesTimescaleDB
0 likes · 14 min read
Practical Implementation of TimescaleDB and PostgreSQL at Hytera: Concepts, Deployment, and Performance
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.

BackupReplicationSQL Commands
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.

GoSegmentdatabase
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 ConsistencyMessage QueueMySQL
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.

aopbackend-developmentdatabase
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.

BackendPerformancecaching
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.

Data ManagementSQL ServerT-SQL
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.

Performancedatabase
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.

BackendORMTutorial
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.

PerformanceTiDBdatabase
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.

PreparedStatementSQL injectionWeb Security
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.

BackupLinked ServerReplication
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 Structuresdatabasehashtable
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 IntegrationStarRocksUnified Query Engine
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.

APIIdempotencyToken
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.

Index UsageMySQLQuery 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.

ClickHouseOLAPProjection
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.

MySQLNext-key LockPerformance
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.

ACIDConsistencyIsolation
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.

ATLASAnalyticsHTAP
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 AuroraBabelfishcloud-native
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 LiteralsSQL featuresSQLite
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.

Connection PoolGroovyMySQL
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.

ArchitectureHTAPNoSQL
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
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.

ClusterPersistencecaching
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.

Memory Managementdatabaseperformance optimization
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.

HashingPartitioningScalability
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.

MySQLauto_incrementdatabase
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.

Idempotencydatabasehigh concurrency
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+TreeInnoDBMySQL
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.

COUNTInnoDBMySQL
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 StructuresMemory Optimization
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 ApplicationsMarket AnalysisOpen-source
0 likes · 15 min read
Why Wanli Database Became the Dark Horse Leader in China’s Critical‑Application Market