BestHub
Sign in
Tagged articles
2671 articles
Page 14 of 27
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.

LatencyPerformance Tuningdatabase
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.

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

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

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

AOFNoSQLPersistence
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 Logicdata transformation
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.

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

Full‑Text SearchORMRedisOM
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 ModeFull‑Text SearchMySQL
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.

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

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

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

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

LatencyPerformancedatabase
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 PageInnoDB
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 SafetyDocker
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.

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

AOFHybridPersistence
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 StructuresNoSQL
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 Auditingdata encryptiondatabase
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.

MySQLPerformancedatabase
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 PoolJDBCdatabase
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.

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

Full‑Text SearchMySQLdatabase
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.

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

LEFT JOINON clauseWHERE 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.

ZooKeeperdatabasedistributed-lock
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 PoolIO MultiplexingJDBC
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.

ORMSQL injectiondatabase
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.

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

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

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

Isolation Leveldatabasedirty 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.

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

Custom Annotationaspectjdatabase
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.

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

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

AOFDevOpsPersistence
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 ReplicationBinlogCross‑Data‑Center
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.

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

Master‑SlaveReplicationdatabase
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/JMySQL
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.

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

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

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

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

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

BackendException Handlingdatabase
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.

AlipayPerformance OptimizationRaft
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.

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

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

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

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

LatencyPerformancedatabase
0 likes · 42 min read
Why Is My Redis Slowing Down? A Complete Troubleshooting Guide
Java High-Performance Architecture
Java High-Performance Architecture
Nov 24, 2021 · Backend Development

Build a Full‑Featured Logistics Management System with Spring Boot and Jeecg‑boot

This guide walks you through setting up a comprehensive logistics and warehouse management system using Spring Boot and Jeecg‑boot, covering required environment versions, technology stack, database configuration, backend and frontend setup, and deployment steps with detailed screenshots and code snippets.

Jeecg-bootLogistics ManagementVue
0 likes · 7 min read
Build a Full‑Featured Logistics Management System with Spring Boot and Jeecg‑boot
macrozheng
macrozheng
Nov 23, 2021 · Databases

15 Essential SQL Optimization Tips to Boost Query Performance

This article presents fifteen practical SQL optimization techniques—including avoiding SELECT *, using UNION ALL, leveraging IN/EXISTS, batching inserts, applying LIMIT, controlling IN list size, incremental queries, efficient pagination, preferring JOINs, limiting join tables, managing indexes, choosing proper column types, improving GROUP BY, and using EXPLAIN—to help developers dramatically improve query speed and resource usage.

MySQLPerformanceQuery Tuning
0 likes · 20 min read
15 Essential SQL Optimization Tips to Boost Query Performance
dbaplus Community
dbaplus Community
Nov 21, 2021 · Databases

15 Proven SQL Optimization Techniques to Boost Query Performance

This article presents fifteen practical SQL optimization tips—including avoiding SELECT *, preferring UNION ALL, leveraging small‑table‑driven queries, batching inserts, applying LIMIT, handling large IN lists, incremental fetching, efficient pagination, join strategies, index management, field‑type choices, and using EXPLAIN—to dramatically improve MySQL query speed and resource usage.

MySQLPerformancedatabase
0 likes · 18 min read
15 Proven SQL Optimization Techniques to Boost Query Performance
Top Architect
Top Architect
Nov 20, 2021 · Operations

Analyzing and Optimizing Business System Performance: A Comprehensive Guide

This article presents a thorough analysis of performance problems in production business systems, covering root causes such as concurrency, data growth, hardware limits, database and middleware bottlenecks, JVM tuning, code inefficiencies, and offers practical diagnostic steps, monitoring tools, and optimization strategies.

APMJVMdatabase
0 likes · 15 min read
Analyzing and Optimizing Business System Performance: A Comprehensive Guide