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

Backend DevelopmentDatabaseJeecg-boot
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.

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

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

APMDatabaseJVM
0 likes · 15 min read
Analyzing and Optimizing Business System Performance: A Comprehensive Guide
Architect
Architect
Nov 18, 2021 · Operations

Business System Performance Issue Analysis, Diagnosis, and Optimization

This article explains how to analyze, diagnose, and optimize performance problems in production business systems, covering root causes such as high concurrency, data growth, environment changes, hardware limits, database and middleware tuning, JVM settings, code inefficiencies, and the role of monitoring and APM tools.

DatabaseOptimizationdiagnostics
0 likes · 16 min read
Business System Performance Issue Analysis, Diagnosis, and Optimization
NiuNiu MaTe
NiuNiu MaTe
Nov 17, 2021 · Databases

Mastering MySQL Disaster Recovery: Replication Modes and Strategies

This article explains MySQL disaster‑recovery techniques, covering cold and hot backups, same‑city versus remote setups, master‑slave topologies, async, semi‑sync and full‑sync replication, the MAR strong‑sync approach, and practical recommendations for building resilient two‑city three‑center architectures.

DatabaseMySQLdisaster recovery
0 likes · 10 min read
Mastering MySQL Disaster Recovery: Replication Modes and Strategies
macrozheng
macrozheng
Nov 16, 2021 · Backend Development

Master Enterprise Data Management with MyBatis‑Mate: Sharding, Encryption & Auditing

This article introduces MyBatis‑Mate, an official MyBatis‑Plus extension that provides enterprise‑grade features such as sharding, data auditing, field encryption, sensitive data masking, dictionary binding, dynamic DDL maintenance, and flexible data‑source switching, complete with usage examples and code snippets.

Data AuditingDatabaseField Encryption
0 likes · 10 min read
Master Enterprise Data Management with MyBatis‑Mate: Sharding, Encryption & Auditing
FunTester
FunTester
Nov 16, 2021 · Databases

Using LevelDB with Java and Go: Basic API Operations

This article introduces LevelDB, a Google‑built key/value store, and demonstrates how to integrate it in Java and Go projects by showing dependency setup, basic operations such as opening, putting, getting, deleting, iterating, and closing the database, and explains the typical use cases and file layout.

APIDatabaseJava
0 likes · 8 min read
Using LevelDB with Java and Go: Basic API Operations
Programmer DD
Programmer DD
Nov 16, 2021 · Backend Development

Why @Transactional Might Fail in Spring and How to Fix It

This article explains common reasons why Spring's @Transactional annotation can become ineffective—such as self‑invocation, non‑public methods, multiple data sources, incorrect rollback settings, and unsupported database engines—and provides concrete code examples and solutions to ensure proper transaction management.

AOPBackendDatabase
0 likes · 7 min read
Why @Transactional Might Fail in Spring and How to Fix It
Tencent Architect
Tencent Architect
Nov 10, 2021 · Databases

How Tencent’s TDSQL‑C Achieves PB‑Scale Storage and Serverless Elasticity

The article details Tencent Cloud's TDSQL‑C cloud‑native database, explaining traditional database bottlenecks, its four standout features—PB‑level storage, second‑level scaling, rapid snapshot backup, and serverless pay‑as‑you‑go—and the deep kernel optimizations that enable these capabilities while outlining future performance and cross‑region goals.

DatabaseScalabilityperformance
0 likes · 7 min read
How Tencent’s TDSQL‑C Achieves PB‑Scale Storage and Serverless Elasticity
Su San Talks Tech
Su San Talks Tech
Nov 10, 2021 · Databases

15 Proven SQL Optimization Techniques to Boost Query Performance

This article presents fifteen practical SQL optimization tips—including avoiding SELECT *, using UNION ALL, driving large tables with small ones, batch operations, LIMIT usage, index control, proper data types, and efficient GROUP BY—to help developers improve query speed, reduce resource consumption, and avoid common performance pitfalls.

DatabaseMySQLQuery Tuning
0 likes · 20 min read
15 Proven SQL Optimization Techniques to Boost Query Performance
Top Architect
Top Architect
Nov 8, 2021 · Databases

MySQL Scheduled Backup and Restoration Using mysqldump and Crontab

This article explains how to use the mysqldump command to back up MySQL databases, provides various command examples for full or partial backups, demonstrates a Bash script for automated daily backups with log management, and shows how to schedule these tasks using crontab.

BashDatabaseMySQL
0 likes · 11 min read
MySQL Scheduled Backup and Restoration Using mysqldump and Crontab
Top Architect
Top Architect
Nov 8, 2021 · Backend Development

Global Unique ID Generation Strategies: Overview, Advantages, Disadvantages, and Optimizations

The article provides a comprehensive overview of global unique ID generation in distributed systems, detailing the characteristics of a good ID, comparing five common strategies—database auto‑increment, UUID, Redis, Zookeeper, and Twitter Snowflake—along with their pros, cons, and practical optimization tips.

Databasedistributed-systemsglobal ID
0 likes · 11 min read
Global Unique ID Generation Strategies: Overview, Advantages, Disadvantages, and Optimizations
Java Captain
Java Captain
Nov 6, 2021 · Databases

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

The article presents mybatis-mate, an enterprise‑grade MyBatis module that provides sharding, data auditing, sensitive‑word filtering, field encryption, dictionary write‑back, data permission, automatic DDL maintenance, dynamic multi‑datasource switching, and distributed transaction logging, offering developers a more agile and elegant way to handle data.

Data AuditingDatabaseSharding
0 likes · 15 min read
Introducing mybatis-mate: Enterprise‑Level MyBatis Extension for Sharding, Data Encryption, Auditing, and More
Java Architect Essentials
Java Architect Essentials
Nov 4, 2021 · Databases

Why MySQL UPDATE Fails with AND and How to Fix It

The article explains a common MySQL UPDATE mistake where developers use AND between column assignments, shows the unexpected result of owner_code becoming 0, analyzes the logical expression behind it, and provides the correct comma‑separated syntax to reliably update multiple fields.

DatabaseDebuggingMySQL
0 likes · 4 min read
Why MySQL UPDATE Fails with AND and How to Fix It
21CTO
21CTO
Nov 3, 2021 · Databases

Master MySQL Full‑Text Search: Index Creation, Modes, and Internals

This tutorial explains how MySQL implements full‑text search, covering the creation of full‑text indexes (including Chinese ngram support), the three query modes (natural language, boolean, and query expansion), relevance ranking, underlying inverted‑index structures, cache handling, and common DML operations.

Boolean ModeDatabaseFull-Text Search
0 likes · 14 min read
Master MySQL Full‑Text Search: Index Creation, Modes, and Internals
Top Architect
Top Architect
Oct 27, 2021 · Databases

Understanding MySQL InnoDB Deadlocks: Types, Causes, and Prevention Strategies

This article explains MySQL InnoDB lock types, analyzes common deadlock scenarios with detailed SQL examples, describes the underlying locking mechanisms such as next‑key and gap locks, and provides practical prevention and resolution techniques for developers working with transactional databases.

ConcurrencyDatabaseInnoDB
0 likes · 13 min read
Understanding MySQL InnoDB Deadlocks: Types, Causes, and Prevention Strategies
JD Tech
JD Tech
Oct 27, 2021 · Backend Development

Understanding Idempotency: When and How to Implement It in Backend Systems

This article examines the concept of idempotency, illustrates typical business scenarios such as order placement and fund transfer, analyzes which layers of a classic system architecture should enforce idempotency, and provides concrete database‑level strategies and code examples to achieve reliable, repeatable operations.

BackendCRUDDatabase
0 likes · 8 min read
Understanding Idempotency: When and How to Implement It in Backend Systems
StarRocks
StarRocks
Oct 27, 2021 · Databases

How StarRocks 1.19 Boosts Join Performance and Adds Primary Key Support

StarRocks 1.19 introduces a Global Runtime Filter that speeds up joins up to six‑fold, adds BE‑level disk balancing, launches an experimental Primary Key table type with near‑duplicate‑key read performance, enables external‑table writes between clusters, and includes a host of CPU‑cache and query‑optimizations.

DatabaseExternal TableOptimization
0 likes · 7 min read
How StarRocks 1.19 Boosts Join Performance and Adds Primary Key Support
政采云技术
政采云技术
Oct 26, 2021 · Backend Development

Analysis and Resolution of Frequent Full GC in an Online Service

The article details a real‑world incident where a Java backend service suffered frequent full garbage collections, describes how the problematic instance was identified and isolated, and presents JVM tuning and MyBatis interceptor code changes that eliminated the issue while sharing key lessons learned.

DatabaseJVMJava
0 likes · 9 min read
Analysis and Resolution of Frequent Full GC in an Online Service
IT Architects Alliance
IT Architects Alliance
Oct 25, 2021 · Databases

Designing a High‑Availability Redis Service with Sentinel

This article explains how to build a highly available Redis service using Redis Sentinel, discusses common failure scenarios, compares several architectural options from a single instance to a three‑node Sentinel setup, and provides practical tips such as using virtual IPs for seamless client access.

Databasearchitecturefailover
0 likes · 11 min read
Designing a High‑Availability Redis Service with Sentinel
Programmer DD
Programmer DD
Oct 18, 2021 · Databases

Master Redis Monitoring: Key Metrics, Commands, and Performance Tips

This article explains how to monitor Redis by categorizing essential performance, memory, activity, persistence, and error metrics, provides detailed tables of metric names and descriptions, lists common monitoring tools, shows configuration snippets, and demonstrates useful Redis CLI commands for real‑time insight.

CLIDatabaseMetrics
0 likes · 7 min read
Master Redis Monitoring: Key Metrics, Commands, and Performance Tips
Liangxu Linux
Liangxu Linux
Oct 17, 2021 · Databases

Why MySQL Eats CPU and How to Slash Its Usage

This article explains which components—user processes, I/O wait, and system interrupts—consume most CPU in MySQL, describes the performance impact of high CPU, and provides concrete strategies such as reducing I/O, simplifying calculations, optimizing indexes, and judiciously scaling hardware to lower CPU usage.

CPU optimizationDatabaseIO Wait
0 likes · 6 min read
Why MySQL Eats CPU and How to Slash Its Usage
Architect
Architect
Oct 15, 2021 · Databases

Performance Analysis and Optimization of Redis Cluster CLUSTER SLOTS Command

This article investigates the high CPU usage and latency observed after expanding a large Redis cluster, analyzes the root cause in the CLUSTER SLOTS implementation and client MOVED handling, proposes an optimized slot‑traversal algorithm, and demonstrates significant performance improvements through benchmarking and profiling.

C++ClusterDatabase
0 likes · 18 min read
Performance Analysis and Optimization of Redis Cluster CLUSTER SLOTS Command
ITPUB
ITPUB
Oct 12, 2021 · Databases

How to Handle Pagination After MySQL Sharding: Pitfalls and Solutions

When a MySQL table is sharded into multiple databases or tables, the usual LIMIT offset, pagesize pagination breaks, and this article examines why simple merge fails, then presents three practical approaches—global limit, secondary queries, and jump‑page restriction—highlighting their trade‑offs and limitations.

DatabaseMySQLSharding
0 likes · 13 min read
How to Handle Pagination After MySQL Sharding: Pitfalls and Solutions
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Oct 11, 2021 · Databases

Understanding MVCC and Transaction Isolation Levels in InnoDB

This article explains the fundamentals of MVCC, transaction isolation levels, and related concepts such as ACID properties, dirty reads, non‑repeatable reads, phantom reads, hidden columns, undo logs, version chains, read views, and demonstrates how InnoDB implements these mechanisms with practical SQL examples and diagrams.

DatabaseInnoDBMVCC
0 likes · 21 min read
Understanding MVCC and Transaction Isolation Levels in InnoDB
Architect
Architect
Oct 11, 2021 · Databases

How to Efficiently Read Redis Source Code: A Step-by-Step Guide

This article presents a practical, seven‑step methodology for efficiently reading Redis source code, covering project mapping, prerequisite knowledge, starting from basic modules, identifying the core execution path, balancing overall structure with detailed logic, handling auxiliary features, and performing targeted gap‑filling to master the codebase.

DatabaseRedisSoftware Architecture
0 likes · 14 min read
How to Efficiently Read Redis Source Code: A Step-by-Step Guide
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Oct 10, 2021 · Databases

Understanding InnoDB Locking Mechanisms: Record Lock, Gap Lock, and Next-Key Lock

This article explains MySQL InnoDB's locking mechanisms—including record locks, gap locks, and next‑key locks—detailing how they work, their interaction with isolation levels such as Repeatable Read, and the principles, optimizations, and examples that illustrate their impact on concurrency and phantom reads.

ConcurrencyDatabaseInnoDB
0 likes · 12 min read
Understanding InnoDB Locking Mechanisms: Record Lock, Gap Lock, and Next-Key Lock
21CTO
21CTO
Oct 6, 2021 · Databases

Master MySQL 8.0 JSON Functions: Practical Tips and Code Samples

This article introduces MySQL 8.0's enhanced JSON capabilities, covering key constraints, storage functions, GeoJSON support, indexing, in‑place updates, essential JSON utilities, path expressions, extraction, modification techniques, and the powerful JSON_TABLE feature with clear code examples.

BackendData TypesDatabase
0 likes · 7 min read
Master MySQL 8.0 JSON Functions: Practical Tips and Code Samples
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 29, 2021 · Databases

Using MySQL 8.0 JSON Schema Validation Functions

This article explains how MySQL 8.0 introduces strict JSON schema validation, demonstrates the json_schema_valid and json_schema_validation_report functions with array and object examples, and shows how to enforce schema checks in tables using CHECK constraints.

DatabaseMySQLjson-schema
0 likes · 11 min read
Using MySQL 8.0 JSON Schema Validation Functions
IT Architects Alliance
IT Architects Alliance
Sep 28, 2021 · Backend Development

Designing Data Architecture for Microservices: Principles, Patterns, and Database Choices

This article explains microservice fundamentals, their advantages, technical characteristics, and provides a comprehensive guide to data design in microservice architectures, covering decoupling, lightweight APIs, continuous delivery, database per service versus shared databases, polyglot persistence, scaling strategies, and why MongoDB is a suitable choice.

DatabaseMicroservicesScalability
0 likes · 16 min read
Designing Data Architecture for Microservices: Principles, Patterns, and Database Choices
Architecture Digest
Architecture Digest
Sep 28, 2021 · Backend Development

Ensuring Idempotency with Unique IDs: UUID, Snowflake, and Shared Storage Strategies

The article explains why idempotency is essential for reliable services, describes how unique identifiers such as UUIDs and Snowflake-generated IDs can guarantee idempotent operations, and outlines practical storage and query techniques using databases or Redis to prevent duplicate orders, inventory deductions, and payments.

DatabaseIdempotencyUnique ID
0 likes · 6 min read
Ensuring Idempotency with Unique IDs: UUID, Snowflake, and Shared Storage Strategies
Code Ape Tech Column
Code Ape Tech Column
Sep 26, 2021 · Databases

MySQL Index Optimization: Fundamentals, Types, and Practical Cases

This article explains MySQL index fundamentals, B+‑tree implementation, the left‑most prefix rule, back‑to‑table issues, and provides three practical optimization cases with code examples to help developers design efficient composite indexes and avoid performance pitfalls.

DatabaseIndex Optimizationsql
0 likes · 15 min read
MySQL Index Optimization: Fundamentals, Types, and Practical Cases
php Courses
php Courses
Sep 26, 2021 · Backend Development

Implementation Guide for Student QR Code Seat Selection Feature in PHP

This article explains how to implement a student QR‑code seat‑selection feature using PHP, detailing database schema design, URL parsing, seat‑allocation logic, attendance tracking, and daily cleanup tasks, enabling teachers to monitor seating without login while automatically recording student attendance.

AttendanceBackendDatabase
0 likes · 9 min read
Implementation Guide for Student QR Code Seat Selection Feature in PHP
Java Architect Essentials
Java Architect Essentials
Sep 23, 2021 · Backend Development

MyBatis Dynamic SQL: Using if, choose, foreach, trim, and bind Tags with Practical Code Samples

This article demonstrates how MyBatis dynamic SQL simplifies conditional query building by explaining the usage of if, choose, foreach, trim, and bind tags, providing Maven project setup, table creation scripts, mapper interfaces, XML snippets, and unit test examples for SELECT, UPDATE, INSERT, and batch operations.

BackendDatabaseDynamic SQL
0 likes · 19 min read
MyBatis Dynamic SQL: Using if, choose, foreach, trim, and bind Tags with Practical Code Samples
Laravel Tech Community
Laravel Tech Community
Sep 23, 2021 · Databases

Common MySQL Commands and Basic Database/Table Operations

This article presents a concise guide to the most frequently used MySQL commands, covering how to list databases and tables, create and drop databases and tables, and perform essential CRUD operations such as inserting, querying, updating, and deleting records.

CRUDDatabaseMySQL
0 likes · 5 min read
Common MySQL Commands and Basic Database/Table Operations
Programmer DD
Programmer DD
Sep 22, 2021 · Databases

Master MySQL 8.0 JSON Functions: Practical Tips and Code Samples

This article summarizes the most useful MySQL 8.0 JSON features—including storage limits, indexing, in‑place updates, path expressions, merging, and table functions—providing clear code examples and guidance for developers who need to work with JSON data in MySQL.

DatabaseJSONJSON Functions
0 likes · 8 min read
Master MySQL 8.0 JSON Functions: Practical Tips and Code Samples
Java Interview Crash Guide
Java Interview Crash Guide
Sep 22, 2021 · Databases

Boost Redis Performance: Proven Tips to Eliminate Latency Bottlenecks

This article examines the fundamental characteristics of Redis, explains why network latency often dominates performance, and presents practical optimization strategies such as using Unix IPC, multi-key commands, transactions, scripts, pipelining, avoiding slow commands, tuning persistence, adjusting OS settings, and adopting distributed architectures to achieve higher throughput and lower latency.

DatabasePerformance OptimizationRedis
0 likes · 17 min read
Boost Redis Performance: Proven Tips to Eliminate Latency Bottlenecks
MaGe Linux Operations
MaGe Linux Operations
Sep 17, 2021 · Backend Development

Master Django ORM: 10 Powerful QuerySet Methods You Need to Know

This tutorial walks through ten advanced Django ORM QuerySet methods—exclude, values, values_list, select_related, order_by, exists, count, first/last, in_bulk, and explain—showing how each works with practical code examples using Student and School models.

DatabaseDjangoQuerySet
0 likes · 11 min read
Master Django ORM: 10 Powerful QuerySet Methods You Need to Know
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Sep 14, 2021 · Databases

Common MySQL Interview Questions and Answers

This article provides a comprehensive collection of typical MySQL interview questions covering storage engines, lock types, gap locks, deadlock avoidance, isolation levels, index types, covering indexes, left‑most prefix rule, replication, distributed transactions, optimization techniques, sharding challenges and solutions, and global unique ID generation.

DatabaseIndexesLocks
0 likes · 15 min read
Common MySQL Interview Questions and Answers
Top Architect
Top Architect
Sep 10, 2021 · Databases

Optimizing MySQL LIMIT Queries by Reducing Unnecessary Row Scans

This article explains why using a large OFFSET with MySQL LIMIT can cause severe performance degradation, demonstrates the problem with a real‑world 9.5 million‑row table, and shows how rewriting the query with a sub‑query that selects only primary keys can cut execution time from seconds to milliseconds.

DatabaseInnoDBLIMIT
0 likes · 8 min read
Optimizing MySQL LIMIT Queries by Reducing Unnecessary Row Scans
Programmer DD
Programmer DD
Sep 8, 2021 · Backend Development

How to Keep Redis Cache Consistent with Database: Strategies and Pitfalls

This article examines the consistency challenges when using Redis as a cache for database data, compares three update strategies, and presents practical solutions such as delayed double‑delete, retry mechanisms, and handling cache penetration, avalanche, and thread‑safety issues in Java.

Cache ConsistencyConcurrencyDatabase
0 likes · 18 min read
How to Keep Redis Cache Consistent with Database: Strategies and Pitfalls
Laravel Tech Community
Laravel Tech Community
Sep 7, 2021 · Databases

Handling Backslashes in MySQL INSERT and SELECT Statements

This article explains how MySQL treats backslashes as escape characters in INSERT and SELECT queries, demonstrates the effect of different numbers of backslashes through practical tests, and clarifies the double‑escaping required when using LIKE patterns.

DatabaseInsertMySQL
0 likes · 6 min read
Handling Backslashes in MySQL INSERT and SELECT Statements
Code Ape Tech Column
Code Ape Tech Column
Sep 7, 2021 · Databases

20 Classic Redis Interview Questions and Answers

This article compiles 20 classic Redis interview questions covering its definition, data structures, performance mechanisms, caching challenges, high‑availability setups, persistence options, distributed locking techniques, and best‑practice solutions, providing developers with comprehensive insights into Redis architecture and practical usage.

DatabaseDistributedLockInterview
0 likes · 50 min read
20 Classic Redis Interview Questions and Answers
High Availability Architecture
High Availability Architecture
Sep 3, 2021 · Backend Development

MyBatis Complete Example and Internal Architecture Overview

This article provides a thorough introduction to MyBatis, including a complete beginner example with database schema, Maven configuration, XML and Java mapper files, and a demo program, followed by an in‑depth explanation of MyBatis’s lifecycle, core components such as SqlSession, Executor, StatementHandler, ParameterHandler, ResultSetHandler, and their interactions.

DatabaseExecutorJava
0 likes · 27 min read
MyBatis Complete Example and Internal Architecture Overview
Wukong Talks Architecture
Wukong Talks Architecture
Sep 2, 2021 · Databases

Step-by-Step Guide to Building and Benchmarking a Redis Master‑Slave Architecture

This article provides a comprehensive tutorial on setting up a one‑master‑one‑slave Redis replication environment, configuring read‑write separation, verifying data synchronization, testing read‑only behavior, and performing performance benchmarking with redis‑benchmark, complete with command examples and result analysis.

CachingDatabasebenchmark
0 likes · 9 min read
Step-by-Step Guide to Building and Benchmarking a Redis Master‑Slave Architecture
ByteDance ADFE Team
ByteDance ADFE Team
Aug 31, 2021 · Big Data

Evolution of the Big Data Technology Stack Over the Past Five Years

This article reviews the evolution of big data technologies in the last five years, covering streaming and batch processing frameworks, column‑store NoSQL databases, programming language trends, the cloud‑native multi‑model database Lindorm, and practical Flink/Blink usage with code examples.

Big DataData engineeringDatabase
0 likes · 24 min read
Evolution of the Big Data Technology Stack Over the Past Five Years
Alibaba Cloud Developer
Alibaba Cloud Developer
Aug 30, 2021 · Databases

Master SQL: Discover the 6 Core Language Components in One Course

This article introduces the six fundamental parts of Structured Query Language (SQL)—DQL, DML, TPL, DCL, DDL, and CCL—while promoting a comprehensive Alibaba Cloud developer course that covers each component with detailed lessons and practical examples.

Data Manipulation LanguageData Query LanguageDatabase
0 likes · 4 min read
Master SQL: Discover the 6 Core Language Components in One Course
Programmer DD
Programmer DD
Aug 28, 2021 · Databases

How Redis Master‑Slave Replication Works: Handshake, Sync, and Code Walkthrough

Redis, the high‑performance open‑source key‑value store, uses a master‑slave replication mechanism that ensures data redundancy, read/write separation, fault recovery, and high‑availability; this article explains its handshake process, synchronization phases, replication states, and key source‑code functions in detail.

Code WalkthroughDatabaseMaster‑Slave
0 likes · 12 min read
How Redis Master‑Slave Replication Works: Handshake, Sync, and Code Walkthrough
Top Architect
Top Architect
Aug 26, 2021 · Databases

Understanding MySQL Locks: Table, Row, and Page Locking Mechanisms

This article explains why MySQL uses locks, describes table‑level, row‑level, and page‑level locking, outlines lock types such as shared, exclusive, and intention locks, and provides practical usage examples and common troubleshooting tips for InnoDB and other storage engines.

ConcurrencyDatabaseInnoDB
0 likes · 7 min read
Understanding MySQL Locks: Table, Row, and Page Locking Mechanisms
FunTester
FunTester
Aug 26, 2021 · Databases

Master MySQL Interview Questions: 33 Essential Queries and Answers

This article presents a complete MySQL interview guide, including a script to create and populate tables for students, teachers, courses, scores, and grades, followed by 33 common interview questions with detailed SQL solutions covering selection, aggregation, joins, subqueries, and ordering.

DatabaseInterviewMySQL
0 likes · 19 min read
Master MySQL Interview Questions: 33 Essential Queries and Answers
Top Architect
Top Architect
Aug 24, 2021 · Databases

Redis Architecture Options and Deployment Guide

This article reviews Redis's latest features and compares various deployment architectures—including single‑replica, dual‑replica, cluster, and read‑write‑separation modes—detailing their reliability, performance characteristics, suitable use cases, and provides a Java Jedis example for configuring a direct‑connect cluster.

ClusterDatabaseJava
0 likes · 12 min read
Redis Architecture Options and Deployment Guide
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 24, 2021 · Databases

Troubleshooting MySQL Group Replication Transaction Certification Errors and Recovery

An in‑depth analysis of MySQL Group Replication (MGR) transaction certification failures, covering error symptoms, root‑cause investigation, replication‑group transaction set mismatches, and step‑by‑step recovery procedures with code examples and best‑practice recommendations to keep MGR clusters clean.

DatabaseGroup ReplicationMySQL
0 likes · 19 min read
Troubleshooting MySQL Group Replication Transaction Certification Errors and Recovery
Top Architect
Top Architect
Aug 22, 2021 · Databases

Why Using Stored Procedures for Simple Existence Checks Can Be Problematic

The article examines a real‑world scenario where a developer tried to reuse existing stored procedures to merely check the presence of Job, Certification, and Disclosure records, discusses the pitfalls of such an approach, and explains why storing this logic in T‑SQL is often fragile and hard to maintain.

Code ReuseDatabaseStored Procedures
0 likes · 6 min read
Why Using Stored Procedures for Simple Existence Checks Can Be Problematic
macrozheng
macrozheng
Aug 20, 2021 · Databases

Beyond Caching: How Redis Can Serve as a Full‑Featured Database

Redis, traditionally seen as a high‑performance cache, also offers rich data structures, persistence options, and clustering modes that enable it to function as a primary database for many internet services, supporting use cases such as user profiles, counters, leaderboards, friend relationships, distributed locks, rate limiting, and more.

CachingDatabaseRedis
0 likes · 19 min read
Beyond Caching: How Redis Can Serve as a Full‑Featured Database
ITPUB
ITPUB
Aug 19, 2021 · Databases

Why Does MySQL LIMIT with ORDER BY Return Duplicate Rows on Page 2?

When using MySQL pagination with LIMIT together with ORDER BY, the second page can unexpectedly contain rows from the first page because MySQL 5.6's priority‑queue optimization performs an unstable heap sort, causing nondeterministic ordering for equal values and leading to duplicate results.

DatabaseLIMITMySQL
0 likes · 7 min read
Why Does MySQL LIMIT with ORDER BY Return Duplicate Rows on Page 2?
Sohu Tech Products
Sohu Tech Products
Aug 18, 2021 · Databases

Understanding Slow Queries, Index Optimization, and Search Solutions with MySQL, Elasticsearch, and HBase

This article explains why MySQL queries become slow, how proper indexing and index‑pushdown can improve performance, discusses common index‑failure causes, and then introduces Elasticsearch and HBase as complementary search and storage solutions for large‑scale data, including practical usage tips and architectural considerations.

DatabaseElasticsearchHBase
0 likes · 18 min read
Understanding Slow Queries, Index Optimization, and Search Solutions with MySQL, Elasticsearch, and HBase
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 17, 2021 · Databases

Design and Implementation of a Cloud‑Native MySQL Container Platform for High Availability and Resource Efficiency

The article describes how a bank built a Kubernetes‑based, containerized MySQL service platform (CDD) to improve database high availability, resource utilization, automated operations, and agile delivery by addressing network, storage, scheduling, and management challenges through custom networking, hybrid storage, scheduler extensions, and multi‑AZ deployment.

ContainerizationDatabaseMySQL
0 likes · 16 min read
Design and Implementation of a Cloud‑Native MySQL Container Platform for High Availability and Resource Efficiency
IT Xianyu
IT Xianyu
Aug 17, 2021 · Databases

Key New Features of MySQL 8.0 for Relational Databases

MySQL 8.0 introduces several relational‑database enhancements, including invisible indexes for performance tuning, persistent configuration via SET PERSIST, default utf8mb4 character set, support for Common Table Expressions, and window functions, each illustrated with practical SQL examples.

8.0CTEDatabase
0 likes · 7 min read
Key New Features of MySQL 8.0 for Relational Databases
Java Interview Crash Guide
Java Interview Crash Guide
Aug 16, 2021 · Backend Development

When to Update Redis Cache: DB‑First vs Cache‑First Strategies Explained

This article examines the consistency challenges of using Redis as a cache, compares three update strategies—updating the database before the cache, deleting the cache before updating the database, and updating the database then deleting the cache—analyzes their pitfalls, and presents practical solutions such as delayed double‑delete, asynchronous retries, and binlog‑driven cache invalidation.

Backend DevelopmentCache ConsistencyDatabase
0 likes · 17 min read
When to Update Redis Cache: DB‑First vs Cache‑First Strategies Explained