BestHub
Sign in
Tagged articles
2678 articles
Page 14 of 27
Architects' Tech Alliance
Architects' Tech Alliance
Mar 21, 2022 · Databases

Oracle Real Application Cluster (RAC) Architecture, Components, Storage Options and Management

The article provides a comprehensive overview of Oracle Real Application Cluster (RAC), detailing its two‑part architecture of Clusterware and RAC instances, shared storage configurations, key Clusterware processes, storage options, benefits such as load balancing and high availability, as well as its management and planning considerations.

ClusterwareDatabaseOracle
0 likes · 13 min read
Oracle Real Application Cluster (RAC) Architecture, Components, Storage Options and Management
Java Interview Crash Guide
Java Interview Crash Guide
Mar 18, 2022 · Databases

Mastering MyBatis Streaming Queries: Keep Connections Open and Avoid Cursor Errors

Streaming queries return an iterator instead of a full result set, reducing memory usage, but require the database connection to stay open; this guide explains MyBatis’s Cursor interface, its methods, common pitfalls like premature closure, and three practical solutions using SqlSessionFactory, TransactionTemplate, or @Transactional to ensure reliable streaming.

CursorDatabaseJava
0 likes · 6 min read
Mastering MyBatis Streaming Queries: Keep Connections Open and Avoid Cursor Errors
Code Ape Tech Column
Code Ape Tech Column
Mar 17, 2022 · Databases

Understanding the Druid Connection Pool Lifecycle and Management

This article provides a comprehensive walkthrough of Druid's connection pool lifecycle, detailing how getConnection initiates the process, the role of initialization, filter chains, connection validation, thread‑blocking strategies, and the various guardian threads that add, evict, and recycle connections to ensure performance and stability.

Connection PoolDatabaseDruid
0 likes · 24 min read
Understanding the Druid Connection Pool Lifecycle and Management
Java High-Performance Architecture
Java High-Performance Architecture
Mar 17, 2022 · Backend Development

Mastering MyBatis Streaming Queries: Reduce Memory Usage and Avoid Cursor Closure Errors

This article explains what streaming queries are, why they save memory compared to pagination, details the MyBatis Cursor interface and its methods, demonstrates how to implement streaming queries with code examples, and presents three solutions—using SqlSessionFactory, TransactionTemplate, and @Transactional—to keep the database connection open and prevent cursor‑closed errors.

CursorDatabaseJava
0 likes · 7 min read
Mastering MyBatis Streaming Queries: Reduce Memory Usage and Avoid Cursor Closure Errors
政采云技术
政采云技术
Mar 17, 2022 · Databases

InnoDB Lock System: Types, Modes, Structures, and Compatibility

This article explains InnoDB's lock system in MySQL, covering lock granularity, intent, shared, exclusive and auto‑increment locks, row‑lock types, the underlying C++ structures, lock mode and type encoding, and the compatibility and strength matrices that govern lock acquisition and waiting.

C++ConcurrencyDatabase
0 likes · 13 min read
InnoDB Lock System: Types, Modes, Structures, and Compatibility
Programmer DD
Programmer DD
Mar 16, 2022 · Backend Development

Implement Custom Annotation Logging with Spring AOP

This guide explains how to create a custom annotation and an Aspect in Spring to capture detailed operation logs—including description, table name, parameters, user info, and execution result—and persist them to a database, covering AOP terminology, configuration styles, and complete code examples.

AspectJCustom AnnotationDatabase
0 likes · 15 min read
Implement Custom Annotation Logging with Spring AOP
Cloud Native Technology Community
Cloud Native Technology Community
Mar 15, 2022 · Databases

How to Build a High‑Availability MySQL PXC Cluster: Installation & Features

This guide explains the Percona XtraDB Cluster (PXC) architecture, its advantages and limitations, and provides step‑by‑step commands for removing MariaDB, opening firewall ports, disabling SELinux, downloading packages, configuring MySQL, bootstrapping the first node, adding additional nodes, and verifying the cluster status.

ClusterDatabaseInstallation
0 likes · 8 min read
How to Build a High‑Availability MySQL PXC Cluster: Installation & Features
Sanyou's Java Diary
Sanyou's Java Diary
Mar 14, 2022 · Databases

Why Is My Redis Slowing Down? Comprehensive Diagnosis & Optimization Guide

This article provides a thorough step‑by‑step guide to identify why Redis latency spikes, covering baseline performance testing, slowlog analysis, big‑key handling, expiration patterns, memory limits, fork overhead, huge pages, AOF settings, CPU binding, swap usage, memory fragmentation, network bandwidth, and practical optimization techniques.

DatabaseLatencyOptimization
0 likes · 39 min read
Why Is My Redis Slowing Down? Comprehensive Diagnosis & Optimization Guide
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 14, 2022 · Databases

Understanding ClickHouse-Keeper: Features, Configuration, Commands, and Migration from ZooKeeper

ClickHouse‑Keeper, a C++‑based ZooKeeper replacement using the Raft algorithm, offers linearizable reads, compression, and easier deployment; this article explains its advantages, configuration template, startup command, parameter details, health checks, and step‑by‑step migration from ZooKeeper using the ClickHouse‑Keeper‑Converter tool.

ClickHouseDatabaseKeeper
0 likes · 6 min read
Understanding ClickHouse-Keeper: Features, Configuration, Commands, and Migration from ZooKeeper
IT Architects Alliance
IT Architects Alliance
Mar 13, 2022 · Databases

Understanding Redis Persistence Mechanisms: RDB and AOF

This article explains Redis's persistence mechanisms, detailing the snapshot-based RDB approach and the append‑only file (AOF) method, their configuration commands, advantages, disadvantages, and how to choose between them for reliable data durability.

AOFDatabasePersistence
0 likes · 14 min read
Understanding Redis Persistence Mechanisms: RDB and AOF
IT Architects Alliance
IT Architects Alliance
Mar 12, 2022 · Databases

Redis Data Persistence: AOF and RDB Mechanisms Explained

This article explains how Redis ensures data durability through two persistence methods—Append‑Only File (AOF) and Redis Database (RDB) snapshots—covering their principles, configuration options, risks, rewrite processes, recovery procedures, handling of expired keys, and the hybrid approach introduced in Redis 4.0.

AOFDatabasePersistence
0 likes · 15 min read
Redis Data Persistence: AOF and RDB Mechanisms Explained
Open Source Linux
Open Source Linux
Mar 9, 2022 · Databases

Mastering Redis Persistence: RDB vs AOF Explained

This article explains Redis's two persistence mechanisms—RDB snapshots and AOF append‑only logs—detailing how they work, how to enable them via commands or configuration, their advantages and drawbacks, and guidance on choosing the right method for your workload.

AOFDatabaseNoSQL
0 likes · 13 min read
Mastering Redis Persistence: RDB vs AOF Explained
Selected Java Interview Questions
Selected Java Interview Questions
Mar 8, 2022 · Databases

Understanding and Using CASE Expressions in SQL

This article explains the concept, syntax, and practical applications of SQL CASE expressions, covering simple and searched forms, row‑to‑column pivots, statistical transformations, conditional SELECT and UPDATE statements, and CHECK constraints, with detailed code examples and best‑practice tips.

CASE expressionConditional LogicDatabase
0 likes · 14 min read
Understanding and Using CASE Expressions in SQL
DaTaobao Tech
DaTaobao Tech
Mar 7, 2022 · Databases

MySQL InnoDB Lock Types and Deadlock Analysis

The article explains MySQL InnoDB lock scopes and modes—including record, gap, next‑key and insert‑intention locks—illustrates a deadlock caused by concurrent inserts on a distributed lock table, and recommends limiting concurrency, sharding by business key, and splitting lock operations into smaller sub‑transactions to avoid such deadlocks.

DatabaseInnoDBLock
0 likes · 16 min read
MySQL InnoDB Lock Types and Deadlock Analysis
macrozheng
macrozheng
Mar 7, 2022 · Databases

Mastering RedisOM: Elegant ORM for Spring Boot with Full-Text Search

RedisOM, the official Redis ORM for Java, lets Spring Boot developers replace RedisTemplate with object‑oriented data handling and built‑in full‑text search, covering JDK 11 setup, Maven dependencies, configuration, entity annotations, repository interfaces, and REST controller examples for managing product data.

DatabaseFull-Text SearchJava
0 likes · 11 min read
Mastering RedisOM: Elegant ORM for Spring Boot with Full-Text Search
Architect's Tech Stack
Architect's Tech Stack
Mar 3, 2022 · Databases

Understanding MySQL InnoDB Full-Text Search and Inverted Index

This article explains why traditional B‑Tree indexes fail for keyword searches, introduces the concept of inverted indexes, shows how to create and use MySQL InnoDB full‑text indexes with MATCH‑AGAINST in various modes, and covers index maintenance and query‑expansion techniques.

Boolean ModeDatabaseFull-Text Search
0 likes · 12 min read
Understanding MySQL InnoDB Full-Text Search and Inverted Index
dbaplus Community
dbaplus Community
Mar 1, 2022 · Databases

MHA Re-Edition: Modern MySQL HA with GTID Failover and Auto Switch

The MHA Re-Edition tool revives the discontinued MHA manager for MySQL, adding GTID‑based failover, password‑only SSH authentication, lightweight binaries, VIP migration, WeChat alerts, remote‑card reboot, and detailed configuration options, with step‑by‑step deployment instructions and sample app1.cnf parameters for high‑availability clusters.

DatabaseGTIDMHA
0 likes · 11 min read
MHA Re-Edition: Modern MySQL HA with GTID Failover and Auto Switch
Efficient Ops
Efficient Ops
Feb 28, 2022 · Databases

Mastering Redis Persistence: RDB vs AOF Explained

This article explores Redis's persistence mechanisms, detailing how RDB snapshots and AOF logs work, how to configure and trigger them, their advantages and drawbacks, and guidance on choosing the appropriate method for reliable data storage.

AOFDatabasePersistence
0 likes · 13 min read
Mastering Redis Persistence: RDB vs AOF Explained
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 28, 2022 · Databases

Understanding and Using UNION in MySQL 8.0

This article explains the purpose, syntax rules, and practical examples of the UNION operator in MySQL, covering distinct and ALL modes, ORDER BY restrictions, new TABLE and VALUES usages introduced in MySQL 8.0.19, and differences from MySQL 5.7.

CodeExamplesDatabaseMySQL
0 likes · 8 min read
Understanding and Using UNION in MySQL 8.0
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 25, 2022 · Databases

SQLE 1.2202.0 Release Notes

The SQLE 1.2202.0 release introduces new user group and permission management, scoring for audit results, expanded support for MySQL, Oracle, Java application SQL capture, Db2 audit plugins, additional MySQL audit rules, UI optimizations, and several critical bug fixes.

DB2DatabaseMySQL
0 likes · 4 min read
SQLE 1.2202.0 Release Notes
IT Services Circle
IT Services Circle
Feb 24, 2022 · Databases

Diagnosing and Solving Redis Performance Issues

This article explains how to detect Redis latency problems, measure baseline performance, monitor slow commands, and address common causes such as network round‑trip delays, fork‑generated RDB snapshots, transparent huge pages, swap usage, AOF settings, key expiration, and big‑key handling, providing practical troubleshooting steps and solutions.

DatabaseLatencyRedis
0 likes · 20 min read
Diagnosing and Solving Redis Performance Issues
IT Services Circle
IT Services Circle
Feb 24, 2022 · Databases

Understanding InnoDB Data Pages, Index Directories, and B+ Tree Indexing

This article explains how InnoDB stores data in 16 KB pages, links pages via a double‑linked list, uses page directories and primary‑key directories for binary search, and builds B+‑tree index pages to accelerate MySQL queries, covering free space, page splits, and the overall search flow.

B+TreeData PageDatabase
0 likes · 8 min read
Understanding InnoDB Data Pages, Index Directories, and B+ Tree Indexing
Architect's Tech Stack
Architect's Tech Stack
Feb 21, 2022 · Databases

Why MySQL May Not Be Suitable for Containerization

The article examines the drawbacks of running MySQL in Docker containers, highlighting data safety, performance, state management, and resource isolation concerns while also discussing scenarios where containerizing MySQL might be feasible.

ContainersData SafetyDatabase
0 likes · 6 min read
Why MySQL May Not Be Suitable for Containerization
Top Architect
Top Architect
Feb 21, 2022 · Databases

Comprehensive Redis Technical Guide and Interview Q&A

This extensive guide covers Redis fundamentals, data structures, persistence mechanisms, clustering, sentinel high‑availability, performance tuning, common pitfalls, and practical use‑case implementations, providing detailed answers and code examples for interview preparation and real‑world development.

CachingDatabaseMessageQueue
0 likes · 66 min read
Comprehensive Redis Technical Guide and Interview Q&A
Sanyou's Java Diary
Sanyou's Java Diary
Feb 19, 2022 · Databases

Redis Persistence Explained: RDB vs AOF and Hybrid Strategies

This article explores Redis persistence mechanisms, detailing the purpose of data durability, the two primary methods—RDB snapshots and AOF logs—their operation, strategies, advantages, drawbacks, and the newer hybrid persistence mode, while also addressing common questions and best‑practice recommendations for reliable deployment.

AOFDatabaseHybrid
0 likes · 20 min read
Redis Persistence Explained: RDB vs AOF and Hybrid Strategies
Efficient Ops
Efficient Ops
Feb 16, 2022 · Databases

Master Redis: Core Concepts, Commands, and Data Types Explained

Redis is an open‑source, in‑memory data‑structure store that serves as a database, cache, and message broker; this guide introduces its fundamentals, explains why NoSQL emerged, details its five primary data types, common commands, and advanced features like transactions and pipelines.

CacheData StructuresDatabase
0 likes · 15 min read
Master Redis: Core Concepts, Commands, and Data Types Explained
Java Architect Essentials
Java Architect Essentials
Feb 15, 2022 · Databases

mybatis-mate: An Enterprise‑Level MyBatis‑Plus Extension for Sharding, Data Auditing, Encryption, and More

This article introduces mybatis-mate, an official MyBatis‑Plus extension that provides enterprise‑grade features such as sharding, multi‑datasource support, data auditing, field encryption, sensitive‑data masking, automatic DDL maintenance, dynamic datasource switching, distributed transaction logging, and fine‑grained data permission control, with detailed usage examples and configuration snippets for Spring Boot projects.

Data AuditingDatabaseJava
0 likes · 15 min read
mybatis-mate: An Enterprise‑Level MyBatis‑Plus Extension for Sharding, Data Auditing, Encryption, and More
dbaplus Community
dbaplus Community
Feb 13, 2022 · Databases

Mastering SQL Execution Order and Optimization: Practical Tips and Best Practices

This guide walks through MySQL's query execution sequence, then presents concrete optimization techniques—from selecting specific columns and avoiding OR conditions to proper indexing, using EXPLAIN, handling VARCHAR vs CHAR, limiting result sets, and improving joins, GROUP BY, and UNION operations—complete with code examples and visual explain plans.

DatabaseMySQLindexing
0 likes · 20 min read
Mastering SQL Execution Order and Optimization: Practical Tips and Best Practices
Top Architect
Top Architect
Feb 8, 2022 · Backend Development

Why Database Connection Pools Do Not Use IO Multiplexing

The article explains why traditional Java database connection pools rely on blocking I/O instead of IO multiplexing, covering JDBC's design, session management, resource constraints, and the practical challenges of adopting non‑blocking approaches in mainstream backend systems.

Connection PoolDatabaseJDBC
0 likes · 9 min read
Why Database Connection Pools Do Not Use IO Multiplexing
Su San Talks Tech
Su San Talks Tech
Feb 7, 2022 · Databases

Essential MySQL Interview Q&A: Locks, Indexes, Replication, and Optimization

A comprehensive collection of MySQL interview questions and answers covering storage engines, lock types, gap locks, deadlock avoidance, isolation levels, index types, covering indexes, the left‑most prefix rule, SQL tuning, master‑slave replication, latency handling, sharding challenges, and global ID generation.

DatabaseInterviewMySQL
0 likes · 15 min read
Essential MySQL Interview Q&A: Locks, Indexes, Replication, and Optimization
Top Architect
Top Architect
Feb 6, 2022 · Databases

Understanding MySQL InnoDB Full‑Text Search and Inverted Index

This article explains why InnoDB full‑text search is needed for keyword‑based queries, introduces inverted index structures, shows how to create, use, and delete full‑text indexes in MySQL, and demonstrates natural language, boolean, and query‑expansion search modes with practical SQL examples.

DatabaseFull-Text SearchMySQL
0 likes · 15 min read
Understanding MySQL InnoDB Full‑Text Search and Inverted Index
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 28, 2022 · Databases

SQLE 1.2201.0 Release Notes

The SQLE 1.2201.0 release introduces workflow optimizations, new MySQL and SQL Server audit rules, enhanced pre‑check capabilities, several UI improvements, and numerous bug fixes, while providing links to the source repository, documentation, and plugin development guide.

DatabaseMySQLReleaseNotes
0 likes · 5 min read
SQLE 1.2201.0 Release Notes
政采云技术
政采云技术
Jan 28, 2022 · Databases

Redis Bitmaps Tutorial: Concepts, Commands, and Real‑World Applications

This tutorial explains Redis Bitmaps, covering their underlying concept, core commands such as SETBIT, GETBIT, BITCOUNT, BITOP, BITPOS, BITFIELD, and demonstrates practical uses like online‑status tracking, daily active‑user counting, Bloom filters, marketing segmentation, collaborative drawing, and handling non‑sequential IDs.

BitfieldBitmap OperationsBitmaps
0 likes · 21 min read
Redis Bitmaps Tutorial: Concepts, Commands, and Real‑World Applications
ITPUB
ITPUB
Jan 26, 2022 · Backend Development

How to Choose the Right Distributed Unique ID Strategy for Your System

This article explains why globally unique identifiers are essential in distributed systems, outlines the key characteristics of a good ID scheme, and compares several generation methods—including UUID, database auto‑increment, segmented DB ranges, Redis INCR, Zookeeper, Meituan Leaf, Snowflake, and Baidu uid‑generator—highlighting their advantages, drawbacks, and practical implementation details.

Databasedistributed-idhigh-availability
0 likes · 18 min read
How to Choose the Right Distributed Unique ID Strategy for Your System
Laravel Tech Community
Laravel Tech Community
Jan 25, 2022 · Databases

Understanding LEFT JOIN ON vs WHERE Conditions in SQL

This article explains why adding conditions after a LEFT JOIN's ON clause does not filter rows, contrasts ON and WHERE behavior, and demonstrates the differences with multiple SQL examples and visual illustrations of intermediate result tables.

DatabaseLEFT JOINON clause
0 likes · 5 min read
Understanding LEFT JOIN ON vs WHERE Conditions in SQL
Architecture Digest
Architecture Digest
Jan 25, 2022 · Backend Development

Distributed Lock Implementation Approaches in Java: Database, Redis, and Zookeeper

This article explains the concept of distributed locks, compares three implementation methods—database unique indexes, Redis (using SETNX), and Zookeeper—provides detailed SQL table design and Java code examples for acquiring and releasing locks, and discusses reentrancy, lock release timing, and single‑point failure considerations.

DatabaseJavaRedis
0 likes · 14 min read
Distributed Lock Implementation Approaches in Java: Database, Redis, and Zookeeper
Programmer DD
Programmer DD
Jan 21, 2022 · Databases

Why Java DB Connection Pools Skip IO Multiplexing (And What It Means)

This article explains why Java database connection pools typically use blocking I/O and connection pooling instead of IO multiplexing, covering JDBC's design, session management, ecosystem constraints, and the trade‑offs between performance and code complexity.

Connection PoolDatabaseIO Multiplexing
0 likes · 8 min read
Why Java DB Connection Pools Skip IO Multiplexing (And What It Means)
Java Architect Essentials
Java Architect Essentials
Jan 20, 2022 · Databases

Understanding the Difference Between ${} and #{} in MyBatis and Their Impact on SQL Injection

This article explains how MyBatis' ${} and #{} placeholders differ in SQL generation, demonstrates their usage with code examples, analyzes the SQL injection risks of ${} versus the safety of #{} through prepared statements, and provides practical guidelines for choosing the appropriate placeholder in various scenarios.

DatabaseJavaMyBatis
0 likes · 10 min read
Understanding the Difference Between ${} and #{} in MyBatis and Their Impact on SQL Injection
Top Architect
Top Architect
Jan 15, 2022 · Backend Development

Distributed Lock Implementation Strategies: Database, Redis, and Zookeeper

This article explains why distributed locks are needed beyond Java's JVM‑level locks, compares three common implementation approaches—database unique indexes, Redis SETNX, and Zookeeper ephemeral sequential nodes—and provides concrete SQL and Java code examples with analysis of re‑entrancy, release timing, and single‑point risks.

BackendDatabaseJava
0 likes · 15 min read
Distributed Lock Implementation Strategies: Database, Redis, and Zookeeper
IT Architects Alliance
IT Architects Alliance
Jan 14, 2022 · Backend Development

Designing a Scalable Architecture for Million‑Level DAU User Systems

The article outlines a comprehensive backend architecture for handling million‑level daily active users, covering DNS routing, L4/L7 load balancing, monolithic versus microservice deployment, caching, database sharding, hybrid‑cloud deployment, elastic scaling, and multi‑level degradation strategies to ensure high availability under sudden traffic spikes.

BackendCachingDatabase
0 likes · 12 min read
Designing a Scalable Architecture for Million‑Level DAU User Systems
FunTester
FunTester
Jan 11, 2022 · Backend Development

Mastering GORM: A Beginner’s Guide to Go ORM CRUD Operations

This article walks through setting up GORM in a Go project, covering dependency management, database initialization, model definition, and practical examples of select, insert, update, delete, raw SQL execution, and transaction handling with detailed code snippets.

BackendCRUDDatabase
0 likes · 9 min read
Mastering GORM: A Beginner’s Guide to Go ORM CRUD Operations
Architects Research Society
Architects Research Society
Jan 8, 2022 · Databases

Understanding Database Isolation Levels and Dirty Reads

This article explains database isolation levels, including read committed, repeatable read, serializable, and snapshot isolation, discusses dirty reads, phantom reads, and how various systems such as SQL Server, PostgreSQL, MySQL, Oracle, MongoDB, and others implement or differ in these isolation semantics.

DatabaseIsolation Leveldirty read
0 likes · 19 min read
Understanding Database Isolation Levels and Dirty Reads
Tencent Cloud Developer
Tencent Cloud Developer
Dec 27, 2021 · Databases

Design and Implementation of a Simple Go ORM for MySQL

The article introduces a lightweight Go ORM for MySQL, explains native connection setup, details the SmallormEngine design with chainable methods for Table, Where, Insert, Update, Delete, and BatchInsert, and demonstrates how reflection builds SQL fragments while handling errors and supporting fluent query composition.

CRUDDatabaseGo
0 likes · 32 min read
Design and Implementation of a Simple Go ORM for MySQL
Java Backend Technology
Java Backend Technology
Dec 21, 2021 · Backend Development

Implement Custom Logging with Spring AOP and Annotations

This guide explains how to create a custom Spring AOP annotation for detailed logging, defines the necessary annotation and aspect classes, shows how to extract method details, parameters and user info, store them in a database, and demonstrates required Spring XML configuration and usage examples.

AspectJCustom AnnotationDatabase
0 likes · 16 min read
Implement Custom Logging with Spring AOP and Annotations
Top Architect
Top Architect
Dec 16, 2021 · Fundamentals

Object‑Oriented Modeling: From Data Model to Object Model, Composition, Aggregation and Practical Java Examples

This article explains the fundamentals of object‑oriented modeling, contrasting data‑model and object‑model designs, illustrating attribute‑method composition, composition versus aggregation, and providing concrete Java and SQL examples such as a simple Account domain, an eating‑process model, and an open‑source e‑commerce reference.

DatabaseObject-Orientedaggregation
0 likes · 14 min read
Object‑Oriented Modeling: From Data Model to Object Model, Composition, Aggregation and Practical Java Examples
Architecture Digest
Architecture Digest
Dec 16, 2021 · Operations

System Performance Issue Analysis, Diagnosis, and Optimization Process

This article outlines a comprehensive approach to diagnosing and optimizing performance problems in production business systems, covering common causes such as concurrency spikes, data growth, and environment changes, and detailing hardware, middleware, database, JVM, code-level analyses, monitoring tools, and APM strategies.

DatabaseJVMOptimization
0 likes · 15 min read
System Performance Issue Analysis, Diagnosis, and Optimization Process
Practical DevOps Architecture
Practical DevOps Architecture
Dec 15, 2021 · Databases

Redis AOF Persistence Configuration Guide

This guide explains Redis AOF persistence settings, including default options, the three synchronization strategies (no, always, everysec), and practical recommendations such as enabling AOF on slaves for critical data while keeping masters free of persistence work.

AOFDatabaseDevOps
0 likes · 3 min read
Redis AOF Persistence Configuration Guide
HomeTech
HomeTech
Dec 14, 2021 · Databases

TiDB Cross-Data-Center High Availability Using Binlog Bidirectional Replication

This article summarizes the design, working principle, deployment steps, testing results, and future outlook of a TiDB cross-data-center high‑availability solution based on Binlog bidirectional replication, aiming to ensure rapid failover and continuous service between two data‑center clusters.

Bidirectional ReplicationCross‑Data‑CenterDatabase
0 likes · 5 min read
TiDB Cross-Data-Center High Availability Using Binlog Bidirectional Replication
IT Architects Alliance
IT Architects Alliance
Dec 11, 2021 · Databases

Mastering Redis Replication and Sentinel: Solving Failover Challenges

This article examines the limitations of Redis master‑slave replication, explains how Redis Sentinel addresses those issues with monitoring, notification, and automatic failover, and provides detailed configuration commands, discovery mechanisms, and step‑by‑step failover procedures for building a highly available Redis deployment.

DatabaseRedisconfiguration
0 likes · 12 min read
Mastering Redis Replication and Sentinel: Solving Failover Challenges
Code Ape Tech Column
Code Ape Tech Column
Dec 10, 2021 · Databases

13 Redis Performance Optimization Rules

This article presents thirteen practical Redis performance optimization rules, covering avoidance of slow commands, proper key expiration handling, data structure selection, persistence strategies, hardware considerations, pipelining, client optimization, and clustering to maximize throughput and minimize latency in high‑volume deployments.

DatabaseRedis
0 likes · 11 min read
13 Redis Performance Optimization Rules
NiuNiu MaTe
NiuNiu MaTe
Dec 7, 2021 · Databases

Master‑Slave Replication in Redis: How It Works and How to Prevent Data Loss

This article explains why a single‑instance Redis can cause outages, introduces the master‑slave architecture, details the full and incremental synchronization processes, shows how to configure replication, addresses multi‑slave scaling, network interruptions, and automatic failover with Sentinel.

DatabaseMaster‑SlaveRedis
0 likes · 11 min read
Master‑Slave Replication in Redis: How It Works and How to Prevent Data Loss
政采云技术
政采云技术
Dec 7, 2021 · Databases

Analysis of MySQL Connector/J Character Set Handling and UTF8MB4 Support

This article examines how MySQL Connector/J determines the character set during connection initialization, explains the transition from UTF8MB3 to UTF8MB4, analyzes source code of versions 5.1.46 and 5.1.47, and provides practical methods to enable UTF8MB4 without upgrading the driver.

Character SetConnector/JDatabase
0 likes · 10 min read
Analysis of MySQL Connector/J Character Set Handling and UTF8MB4 Support
Java Interview Crash Guide
Java Interview Crash Guide
Dec 7, 2021 · Databases

Why Traditional Pagination Fails After Sharding and How to Solve It

When a table grows beyond ten million rows, sharding it across multiple databases improves performance, but the usual LIMIT offset, pagesize pagination breaks, leading to missing or incorrect records; this article examines why simple merge approaches fail and evaluates global, secondary query, and no‑skip paging strategies, highlighting their trade‑offs.

DatabaseMySQLSharding
0 likes · 12 min read
Why Traditional Pagination Fails After Sharding and How to Solve It
Java Architect Essentials
Java Architect Essentials
Dec 6, 2021 · Databases

Facebook’s MySQL 5.6‑to‑8.0 Migration: Challenges, Process, and Lessons Learned

The article details Facebook’s multi‑year effort to migrate its heavily customized MySQL 5.6 deployment—including the MyRocks storage engine—to MySQL 8.0, describing the technical challenges, patch‑porting strategy, replication changes, automated verification, and application validation performed during the upgrade.

DatabaseFacebookMigration
0 likes · 17 min read
Facebook’s MySQL 5.6‑to‑8.0 Migration: Challenges, Process, and Lessons Learned
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 6, 2021 · Databases

MySQL Time Zone Configuration: Installation Standards, Session Variables, and Their Impact on Data

This article explains how to set the correct time zone for MySQL during installation, describes the relevant startup parameters and system variables, demonstrates their effect on functions like NOW() and TIMESTAMP columns, and provides practical solutions for Java applications, data migration, and dump utilities.

DatabaseMySQLTimezone
0 likes · 11 min read
MySQL Time Zone Configuration: Installation Standards, Session Variables, and Their Impact on Data
Architects' Tech Alliance
Architects' Tech Alliance
Dec 5, 2021 · Cloud Computing

Evolution of Taobao’s Architecture and Cloud Migration Best Practices

The article chronicles Taobao’s architectural evolution from a LAMP stack to an Oracle‑IBM mainframe setup, then to a Java‑centric distributed system, and finally to a cloud‑native solution on Alibaba Cloud, highlighting key design decisions, scalability challenges, and migration best practices across storage, services, OLTP and OLAP workloads.

DatabaseTaobaoarchitecture
0 likes · 9 min read
Evolution of Taobao’s Architecture and Cloud Migration Best Practices
Practical DevOps Architecture
Practical DevOps Architecture
Dec 5, 2021 · Databases

Deploying MHA for MySQL High Availability – Part 1

This guide walks through the step‑by‑step deployment of MHA on a MySQL cluster, covering package installation on all nodes, copying and installing the MHA RPMs, creating the required MySQL user, configuring MHA, testing SSH connectivity, and reviewing the failover script.

DatabaseLinuxMHA
0 likes · 6 min read
Deploying MHA for MySQL High Availability – Part 1
Selected Java Interview Questions
Selected Java Interview Questions
Dec 4, 2021 · Backend Development

Common Scenarios Where Spring @Transactional Does Not Take Effect

This article explains eight typical situations—such as using non‑transactional storage engines, missing Spring bean registration, non‑public methods, self‑invocation, absent transaction manager, incorrect propagation settings, swallowed exceptions, and wrong exception types—that cause the @Transactional annotation in Spring to appear ineffective, and provides practical solutions for each.

BackendDatabaseException Handling
0 likes · 7 min read
Common Scenarios Where Spring @Transactional Does Not Take Effect
AntTech
AntTech
Dec 1, 2021 · Databases

Maxwell High‑Performance Accounting Database: Architecture, Performance, and Real‑World Deployment at Alipay

The article presents Maxwell, a C/assembly‑based high‑performance accounting database designed for Alipay, detailing its architecture, hotspot account challenges, performance optimizations such as Raft and a custom storage engine, and real‑world results showing thousand‑fold throughput gains and robust operation during massive promotional events.

AlipayDatabasePerformance Optimization
0 likes · 12 min read
Maxwell High‑Performance Accounting Database: Architecture, Performance, and Real‑World Deployment at Alipay
Top Architect
Top Architect
Nov 29, 2021 · Backend Development

Design and Implementation of a High‑Concurrency Flash Sale (Seckill) System

This article presents a comprehensive analysis of flash‑sale (seckill) business characteristics, technical challenges, and architectural principles, offering detailed backend design solutions—including request interception, queue management, database sharding, caching strategies, optimistic locking, and anti‑cheating measures—to achieve high‑throughput, low‑latency processing for millions of concurrent users.

BackendDatabaseQueue
0 likes · 36 min read
Design and Implementation of a High‑Concurrency Flash Sale (Seckill) System
Programmer DD
Programmer DD
Nov 29, 2021 · Backend Development

Boost MyBatis Efficiency with the PageHelper Pagination Plugin

This article introduces MyBatis-PageHelper, a universal pagination plugin that supports a wide range of databases, explains how to configure custom dialect aliases, shows Maven and Spring integration, details numerous plugin parameters, and provides multiple code examples for various usage patterns.

BackendDatabaseJava
0 likes · 9 min read
Boost MyBatis Efficiency with the PageHelper Pagination Plugin
Programmer DD
Programmer DD
Nov 27, 2021 · Databases

Deploy MangoDB: An Open‑Source MongoDB Alternative with Docker

This guide introduces MangoDB, an open‑source MongoDB‑compatible database built on PostgreSQL, and walks you through a three‑step Docker‑Compose setup, service startup, and connection using mongosh, enabling developers to quickly try a true open‑source MongoDB replacement.

DatabaseDockerMangoDB
0 likes · 4 min read
Deploy MangoDB: An Open‑Source MongoDB Alternative with Docker
Qingyun Technology Community
Qingyun Technology Community
Nov 26, 2021 · Cloud Native

How RadonDB MySQL Operator Simplifies MySQL Deployment on Kubernetes

This article introduces the RadonDB MySQL Operator, explaining its design goals, deployment topology on Kubernetes, detailed architecture—including RBAC, manager, custom resources, and services—and provides a visual overview to help engineers simplify MySQL high‑availability deployments in cloud‑native environments.

DatabaseMySQLOperator
0 likes · 4 min read
How RadonDB MySQL Operator Simplifies MySQL Deployment on Kubernetes
Cloud Native Technology Community
Cloud Native Technology Community
Nov 25, 2021 · Databases

Why Is My Redis Slowing Down? A Complete Troubleshooting Guide

This article provides a systematic, step‑by‑step methodology for diagnosing Redis latency spikes, covering baseline performance testing, slow‑log analysis, high‑complexity commands, big‑key handling, expiration patterns, memory limits, fork overhead, huge‑page settings, AOF configurations, CPU binding, swap usage, memory fragmentation, network saturation, and practical monitoring tips.

DatabaseLatencyOptimization
0 likes · 42 min read
Why Is My Redis Slowing Down? A Complete Troubleshooting Guide