BestHub
Sign in
Tagged articles
5000 articles
Page 26 of 50
iQIYI Technical Product Team
iQIYI Technical Product Team
Dec 16, 2022 · Databases

Database Mesh 2.0 and Pisanix: Cloud‑Native Database Governance at iQIYI

iQIYI adopts SphereEx’s Database Mesh 2.0 by extending ShardingSphere‑JDBC and integrating the cloud‑native Pisanix proxy, creating a unified, encrypted configuration center that enables dynamic sharding, load‑balancing, read‑write separation, hot‑updates and observability, dramatically simplifying database governance and cloud migration.

Data GovernanceDatabase MeshPisanix
0 likes · 14 min read
Database Mesh 2.0 and Pisanix: Cloud‑Native Database Governance at iQIYI
Java High-Performance Architecture
Java High-Performance Architecture
Dec 15, 2022 · Backend Development

How to Build a High‑Performance Follow Service with MySQL, Redis, and Spring Boot

This article explains how to design and implement a friend/follow microservice using MySQL for persistence and Redis sets for efficient set operations, covering database schema, Spring Boot configuration, Redis template setup, service and controller logic, and testing of follow, unfollow, and mutual‑follow features.

Follow ServiceMicroserviceSpring Boot
0 likes · 19 min read
How to Build a High‑Performance Follow Service with MySQL, Redis, and Spring Boot
JavaEdge
JavaEdge
Dec 14, 2022 · Backend Development

Designing Scalable Shopping Cart Storage: Principles and Choices

This article explains how to design the storage layer for an e‑commerce shopping cart, covering core functionalities, required attributes, client‑side temporary storage, server‑side persistence options with MySQL and Redis, and the trade‑offs between reliability, performance, and complexity.

Shopping Cartclient-side storagedata synchronization
0 likes · 12 min read
Designing Scalable Shopping Cart Storage: Principles and Choices
Efficient Ops
Efficient Ops
Dec 13, 2022 · Databases

How ClickHouse Replicates MySQL in Real-Time: A Step-by-Step Guide

This article explains how to configure ClickHouse as a MySQL replica using the MaterializeMySQL engine, covering code acquisition, MySQL master setup, ClickHouse slave configuration, handling of delete and update operations, and the underlying replication mechanism with practical code examples.

Database SyncMaterializeMySQLReal-Time
0 likes · 10 min read
How ClickHouse Replicates MySQL in Real-Time: A Step-by-Step Guide
Open Source Linux
Open Source Linux
Dec 13, 2022 · Databases

Boost MySQL Performance: 20 Proven SQL Optimization Techniques

This article presents a comprehensive collection of MySQL optimization tips, covering everything from avoiding SELECT * and OR conditions to proper use of indexes, joins, UNION, batch operations, and query planning, each illustrated with clear examples and practical reasons for better performance.

mysqlperformance tuningquery best practices
0 likes · 19 min read
Boost MySQL Performance: 20 Proven SQL Optimization Techniques
ITPUB
ITPUB
Dec 9, 2022 · Databases

Mastering Sharding: When and How to Split Databases and Tables with ShardingSphere

This article explains the fundamentals of database sharding, why and when to apply it, various vertical and horizontal splitting strategies, routing algorithms, common pitfalls such as pagination and distributed transactions, and compares client‑side and proxy‑based ShardingSphere deployment patterns.

ShardingSpheredatabase partitioningmysql
0 likes · 19 min read
Mastering Sharding: When and How to Split Databases and Tables with ShardingSphere
Zhuanzhuan Tech
Zhuanzhuan Tech
Dec 9, 2022 · Databases

Implementing a MySQL Data Consistency Check Tool Based on pt-table-checksum

This article describes the design, implementation, and usage of a custom MySQL data consistency checking tool that extends pt-table-checksum, handling composite primary keys, network throttling, scheduled execution, and detailed logging for both successful and failed verification scenarios.

Data ConsistencyScriptingchecksum
0 likes · 21 min read
Implementing a MySQL Data Consistency Check Tool Based on pt-table-checksum
Java Captain
Java Captain
Dec 8, 2022 · Backend Development

Design and Implementation of a Friend Follow Microservice Using MySQL and Redis

This article explains how to design and implement a friend follow microservice by combining MySQL for persistent storage with Redis sets for efficient follow/unfollow operations and mutual follow queries, covering database schema, Maven dependencies, Spring Boot configuration, RedisTemplate setup, service and controller logic, and testing procedures.

Follow FeatureMicroserviceSpring Boot
0 likes · 15 min read
Design and Implementation of a Friend Follow Microservice Using MySQL and Redis
vivo Internet Technology
vivo Internet Technology
Dec 7, 2022 · Databases

vivo's Database Operations Platform: Challenges and Solutions in the Cloud-Native Era

Vivo’s Database‑as‑a‑Service platform tackles cloud‑native challenges by automating massive instance management with self‑service work orders and self‑healing, enabling elastic scaling through mixed‑deployment and multi‑threaded Redis tools, optimizing costs via automatic package shrinkage, and safeguarding personal data with full‑chain encryption, while outlining a roadmap toward AI‑driven fault handling, container‑based resources, and advanced privacy governance.

DaaSOperationscloud-native
0 likes · 14 min read
vivo's Database Operations Platform: Challenges and Solutions in the Cloud-Native Era
Zhuanzhuan Tech
Zhuanzhuan Tech
Dec 6, 2022 · Databases

Migrating MySQL Monitoring from Zabbix to Prometheus Using mysqld_exporter: Multi‑Instance Setup and Troubleshooting

This article explains how to replace Zabbix with Prometheus for MySQL monitoring by configuring mysqld_exporter to collect metrics from multiple MySQL instances, details the required user accounts, shows common errors, and provides step‑by‑step solutions including building a newer exporter, adjusting configuration files, and using auth_module for password management.

ConfigurationExporterMulti-Instance
0 likes · 14 min read
Migrating MySQL Monitoring from Zabbix to Prometheus Using mysqld_exporter: Multi‑Instance Setup and Troubleshooting
Liangxu Linux
Liangxu Linux
Dec 5, 2022 · Databases

How Does MySQL Store a Row? Inside InnoDB Files, Pages, and Row Formats

This article explains where MySQL keeps its data files, how InnoDB organizes tablespaces into segments, extents, pages and rows, details the Compact row format—including variable‑length field length lists, NULL‑value lists, and hidden fields—and clarifies the limits of VARCHAR and row‑overflow handling.

Database StorageExtentInnoDB
0 likes · 22 min read
How Does MySQL Store a Row? Inside InnoDB Files, Pages, and Row Formats
Laravel Tech Community
Laravel Tech Community
Dec 5, 2022 · Databases

Using MySQL Built‑in Commands for Comprehensive Database Monitoring

This article explains how to collect extensive MySQL performance metrics—including connections, buffer cache, locks, SQL status, statement counts, throughput, server configuration, and slow‑query logs—using only MySQL's native SHOW commands and the performance_schema, providing practical code snippets and optimization tips.

Performance Schemadatabasemonitoring
0 likes · 10 min read
Using MySQL Built‑in Commands for Comprehensive Database Monitoring
Top Architect
Top Architect
Dec 5, 2022 · Backend Development

Integrating Spring Batch with Spring Boot: Full Tutorial and Example

This article provides a comprehensive step‑by‑step guide on integrating Spring Batch with Spring Boot, covering configuration, entity and mapper definitions, job, step, reader, processor, writer implementations, database setup, error handling, and execution via a REST controller, complete with code examples.

Batch ProcessingMyBatisSpring Batch
0 likes · 22 min read
Integrating Spring Batch with Spring Boot: Full Tutorial and Example
Java High-Performance Architecture
Java High-Performance Architecture
Dec 5, 2022 · Backend Development

How to Build a High‑Performance, Highly Available Membership System with ES, Redis, and MySQL

This article explains how a large‑scale membership system achieves high performance and high availability by using a dual‑center Elasticsearch cluster, traffic‑isolated three‑cluster architecture, Redis caching with dual‑center clusters, and a MySQL partitioned dual‑center setup, while also detailing optimization, migration, and fine‑grained flow‑control strategies.

Backend ArchitectureElasticsearchScalability
0 likes · 21 min read
How to Build a High‑Performance, Highly Available Membership System with ES, Redis, and MySQL
macrozheng
macrozheng
Dec 3, 2022 · Databases

Top 11 MySQL GUI Tools Every Developer Should Know

This article introduces eleven popular MySQL graphical management tools—including DBeaver, DataGrip, phpMyAdmin, MySQLDumper, Navicat, MySQL GUI Tools, MySQL ODBC Connector, MySQL Workbench, SQLyog, MySQL‑Front, and dbForge Studio—detailing their features, platform support, and official download links to help developers choose the right solution.

DBeaverDataGripgui-tools
0 likes · 9 min read
Top 11 MySQL GUI Tools Every Developer Should Know
IT Xianyu
IT Xianyu
Dec 2, 2022 · Databases

How MySQL InnoDB Implements ACID: Locks, MVCC, and Logging

This article explains how MySQL's InnoDB engine guarantees ACID properties by describing the four components of ACID, the four isolation levels, lock granularity and types, the MVCC mechanism with version chains and read views, and the roles of undo, redo, and bin logs in ensuring atomicity, consistency, isolation, and durability.

ACIDInnoDBLock
0 likes · 14 min read
How MySQL InnoDB Implements ACID: Locks, MVCC, and Logging
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 30, 2022 · Databases

Understanding Index Condition Pushdown (ICP) in MySQL and Its Impact on Query Cost

Index Condition Pushdown (ICP) in MySQL pushes filter conditions to the storage engine to reduce row lookups, but this article demonstrates through experiments that while ICP lowers runtime by decreasing back‑table accesses, the optimizer’s cost model often ignores its benefits, leading to suboptimal plan choices.

Cost Modeldatabaseindex condition pushdown
0 likes · 10 min read
Understanding Index Condition Pushdown (ICP) in MySQL and Its Impact on Query Cost
ITPUB
ITPUB
Nov 29, 2022 · Databases

When MySQL Hits Its Limits: Scaling with Horizontal and Vertical Sharding

This article explains MySQL's theoretical row limits, why performance degrades long before reaching them, and how horizontal and vertical database sharding can distribute massive datasets across multiple instances to improve load handling and enable seamless scaling.

Vertical Partitioninghorizontal partitioningmysql
0 likes · 7 min read
When MySQL Hits Its Limits: Scaling with Horizontal and Vertical Sharding
Architecture Digest
Architecture Digest
Nov 29, 2022 · Databases

MySQL InnoDB Deadlock Analysis and Resolution for a Video‑Conference Service

The article details a step‑by‑step investigation of an intermittent deadlock occurring during session creation in a video‑conference system, explains how InnoDB lock types caused the conflict between DELETE and INSERT statements on the session and session_endpoint tables, reproduces the issue, debugs MySQL source code, and presents a simple code‑order fix to eliminate the deadlock.

InnoDBdatabasedeadlock
0 likes · 21 min read
MySQL InnoDB Deadlock Analysis and Resolution for a Video‑Conference Service
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Nov 28, 2022 · Backend Development

Design and Implementation of the Service Backend Architecture for Editor, Component Platform, and C‑End Application

This article details the overall backend architecture, module relationships, RESTful API design, database schemas, authentication flow, activity creation process, JSON schema validation, component platform APIs, and server‑side rendering considerations for a Node.js‑based service supporting editors, components, and end‑user pages.

JWTMongoDBNode.js
0 likes · 22 min read
Design and Implementation of the Service Backend Architecture for Editor, Component Platform, and C‑End Application
dbaplus Community
dbaplus Community
Nov 27, 2022 · Databases

Unraveling MySQL InnoDB Deadlocks in Video Conference Sessions

A detailed investigation of intermittent MySQL InnoDB deadlocks occurring during video‑conference session creation, covering log extraction, lock analysis, source‑code debugging, reproducible test cases, and a simple code change that eliminates the deadlock while explaining the underlying locking mechanisms.

InnoDBLock Analysisdatabase
0 likes · 22 min read
Unraveling MySQL InnoDB Deadlocks in Video Conference Sessions
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 26, 2022 · Databases

Weekly Tech Community Digest – Database and SQL Updates

This weekly digest curates top industry technical shares, featuring articles on database cloud migration, MySQL hash join evolution, OceanBase distributed query performance, MySQL subquery execution, and the latest SQLE SQL audit tool release, along with community development progress and upcoming plans.

OceanBaseSQL auditcommunity newsletter
0 likes · 3 min read
Weekly Tech Community Digest – Database and SQL Updates
Selected Java Interview Questions
Selected Java Interview Questions
Nov 24, 2022 · Databases

Common MySQL Index Failure Scenarios and Optimization Techniques

This article explains why many MySQL queries cause index inefficiency, details the leftmost prefix rule for composite indexes, illustrates common index‑breaking patterns such as SELECT *, functions, range queries, LIKE, OR, IN, ORDER BY, and introduces Index Condition Pushdown (ICP) as an optimization to reduce row lookups.

Leftmost Prefixdatabasemysql
0 likes · 19 min read
Common MySQL Index Failure Scenarios and Optimization Techniques
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 24, 2022 · Databases

Understanding Orchestrator's RegroupReplicasGTID and Candidate Replica Selection in MySQL Failover

This article explains how Orchestrator selects a candidate replica during MySQL master failover, detailing the GetCandidateReplica and RegroupReplicasGTID functions, their sorting logic, promotion rules, GTID-based regrouping, and differences from MHA, while highlighting potential data loss issues and related bugs.

GTIDOrchestratorReplication
0 likes · 22 min read
Understanding Orchestrator's RegroupReplicasGTID and Candidate Replica Selection in MySQL Failover
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 23, 2022 · Databases

Migrating MySQL Monitoring to Prometheus with mysqld_exporter: Multi‑Instance Support and Troubleshooting

This article describes how to replace Zabbix with Prometheus for MySQL monitoring by configuring mysqld_exporter to collect metrics from multiple MySQL instances, including environment setup, user creation, exporter configuration, troubleshooting common errors, and Prometheus job adjustments, providing step‑by‑step commands and code examples.

ConfigurationExporterPrometheus
0 likes · 15 min read
Migrating MySQL Monitoring to Prometheus with mysqld_exporter: Multi‑Instance Support and Troubleshooting
Architecture Digest
Architecture Digest
Nov 23, 2022 · Databases

Using MySQL Built‑in SHOW Commands for Comprehensive Database Monitoring

This article explains how to collect a wide range of MySQL performance metrics—including connections, buffer pool usage, locks, SQL statistics, statement counts, throughput, server variables, and slow‑query logs—using only MySQL's native SHOW commands and performance_schema tables, while also offering practical tuning tips and analysis tools.

Database MonitoringPerformance SchemaSlow Query Log
0 likes · 11 min read
Using MySQL Built‑in SHOW Commands for Comprehensive Database Monitoring
Java Architect Essentials
Java Architect Essentials
Nov 21, 2022 · Databases

MySQL Query Optimization Best Practices: Avoid SELECT *, Use Specific Fields, Index Strategies, Joins, and Other Performance Tips

This article presents a comprehensive set of MySQL optimization guidelines, covering the avoidance of SELECT *, proper use of specific columns, eliminating OR and != in WHERE clauses, preferring numeric types, choosing VARCHAR over CHAR, using TRUNCATE, batch operations, index design, join selection, GROUP BY efficiency, and other practical tips to improve query performance.

Query PerformanceSQL Optimizationdatabase indexing
0 likes · 18 min read
MySQL Query Optimization Best Practices: Avoid SELECT *, Use Specific Fields, Index Strategies, Joins, and Other Performance Tips
Laravel Tech Community
Laravel Tech Community
Nov 20, 2022 · Databases

11 Popular MySQL Graphical Management Tools

This article introduces eleven widely used graphical tools for MySQL administration, describing each tool's features, platform support, and official download links, helping developers and DBAs choose the most suitable solution for managing MySQL databases efficiently.

Administration ToolsData ManagementDatabase GUI
0 likes · 8 min read
11 Popular MySQL Graphical Management Tools
dbaplus Community
dbaplus Community
Nov 20, 2022 · Databases

Master MySQL Performance: From Tuning Pyramid to Explain Plans

This guide walks through MySQL performance tuning, covering the architectural tuning pyramid, query optimization techniques, slow‑query logging, detailed EXPLAIN execution‑plan analysis, and high‑performance indexing strategies to help you diagnose and accelerate database workloads.

Slow Query Logexplainmysql
0 likes · 43 min read
Master MySQL Performance: From Tuning Pyramid to Explain Plans
dbaplus Community
dbaplus Community
Nov 19, 2022 · Databases

How to Speed Up MySQL Queries: Indexing and Execution Plan Optimization

This article walks through a MySQL performance case study, showing how nested subqueries on large tables can take hours, and demonstrates step‑by‑step how creating single‑column, composite, and covering indexes, as well as rewriting queries as joins, reduces execution time from tens of thousands of seconds to milliseconds.

execution planindexingmysql
0 likes · 12 min read
How to Speed Up MySQL Queries: Indexing and Execution Plan Optimization
Tencent Cloud Developer
Tencent Cloud Developer
Nov 18, 2022 · Backend Development

Cache Consistency Strategies and Best Practices

The article explains how using a Redis cache can boost read performance but introduces consistency challenges, compares four cache‑aside write strategies, and recommends the reliable “update database then delete cache” approach combined with short expiration times and asynchronous message‑queue invalidation to keep data fresh.

BackendConsistencyDistributed Systems
0 likes · 20 min read
Cache Consistency Strategies and Best Practices
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 17, 2022 · Databases

DeadMaster Recovery Process in Orchestrator

This article explains the complete DeadMaster recovery workflow of Orchestrator, detailing how the system selects the appropriate check‑and‑recover function, handles emergency grace periods, reads topology information, registers recovery attempts, validates promotion constraints, executes the actual failover, and runs post‑recovery hooks, with extensive Go code examples.

GoOrchestratorRecovery
0 likes · 18 min read
DeadMaster Recovery Process in Orchestrator
Su San Talks Tech
Su San Talks Tech
Nov 16, 2022 · Databases

Why count(*) Slows Down MySQL and How to Optimize It

This article explains why MySQL's count(*) can become a performance bottleneck, especially with InnoDB, and presents practical optimization techniques such as Redis caching, second‑level in‑memory caches, parallel execution, reducing unnecessary joins, and using column‑store databases like ClickHouse.

_countclickhousemysql
0 likes · 10 min read
Why count(*) Slows Down MySQL and How to Optimize It
Su San Talks Tech
Su San Talks Tech
Nov 16, 2022 · Databases

Why count(*) Is Slow in MySQL InnoDB and How to Speed It Up

This article explains why MySQL's count(*) can be slow on InnoDB, compares different count variations, and presents practical optimization techniques such as Redis caching, second‑level caches, multithreading, reducing joins, and using ClickHouse for massive datasets.

InnoDB_countclickhouse
0 likes · 12 min read
Why count(*) Is Slow in MySQL InnoDB and How to Speed It Up
ITPUB
ITPUB
Nov 15, 2022 · Databases

How MySQL Executes an UPDATE: Inside InnoDB Pages, Buffer Pool, and Logs

This article walks through the complete lifecycle of a MySQL UPDATE statement, covering InnoDB page structure, tablespaces, the buffer pool, redo and undo logs, binlog, and the two‑phase commit process, illustrating each step with examples and command outputs.

BinlogInnoDBUPDATE
0 likes · 19 min read
How MySQL Executes an UPDATE: Inside InnoDB Pages, Buffer Pool, and Logs
Top Architect
Top Architect
Nov 15, 2022 · Backend Development

Scaling a Personal Blog: Caching, Load Balancing, Read/Write Splitting, Sharding, and NewSQL

This article explains how to transform a simple personal‑blog backend into a high‑performance, horizontally scalable system by introducing caching with Redis, load balancing with Nginx/LVS, read/write separation, database sharding, and modern NewSQL solutions such as TiDB, while also discussing related challenges like cache consistency and data migration.

NewSQLmysqlread/write splitting
0 likes · 14 min read
Scaling a Personal Blog: Caching, Load Balancing, Read/Write Splitting, Sharding, and NewSQL
Top Architect
Top Architect
Nov 14, 2022 · Databases

Performance Comparison of Auto‑Increment ID vs UUID Primary Keys in MySQL

The article presents a detailed performance comparison between auto‑increment integer primary keys and UUID string primary keys in MySQL, including table definitions, 5‑million‑row and 10‑million‑row test results for read, range, write, backup, and storage efficiency, and offers practical recommendations for choosing the appropriate key strategy in distributed environments.

auto_incrementmysqlperformance
0 likes · 13 min read
Performance Comparison of Auto‑Increment ID vs UUID Primary Keys in MySQL
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 14, 2022 · Databases

Performance Impact of Dropping Large Tables in MySQL 5.7 and 8.0: Bug Analysis and Mitigation

This article investigates a historical MySQL bug where dropping large tables with a sizable buffer pool and Adaptive Hash Index (AHI) can cause severe latency, presents test configurations for 5.7.29 and 8.0.28, compares AHI‑on/off results, shows stack traces, and explains the lazy‑delete fix introduced in 8.0.23.

Adaptive Hash Indexbuffer poolbug
0 likes · 24 min read
Performance Impact of Dropping Large Tables in MySQL 5.7 and 8.0: Bug Analysis and Mitigation
ITPUB
ITPUB
Nov 13, 2022 · Databases

Inside MySQL: How the Server Handles Connections, Parsing, and Storage Engines

This article explains MySQL's client‑server architecture and walks through the three main stages—connection handling, query parsing and optimization, and storage engine selection—detailing protocols, authentication, cache behavior, optimizer mechanics, and engine characteristics with practical commands and examples.

Connection HandlingDatabase InternalsStorage Engine
0 likes · 21 min read
Inside MySQL: How the Server Handles Connections, Parsing, and Storage Engines
ITPUB
ITPUB
Nov 13, 2022 · Databases

Why Does MySQL Hang on Startup? Deep Dive into InnoDB Truncate Bug and Fix

A MySQL DBA recounts a 4‑TB InnoDB instance that stalled during startup, analyzes top, stack traces, and source code to pinpoint a bug involving truncate operations and the buf_flush_event, then presents three practical solutions—including adjusting innodb_flush_sync, using GDB to break the wait loop, or removing truncate logs—to restore normal operation.

InnoDBTRUNCATEdebugging
0 likes · 16 min read
Why Does MySQL Hang on Startup? Deep Dive into InnoDB Truncate Bug and Fix
ITPUB
ITPUB
Nov 12, 2022 · Databases

How to Speed Up Large Pagination Queries in MySQL: Delayed Join and Bookmark Techniques

This article explains why traditional ORDER BY … LIMIT pagination becomes slow on tens of millions of rows, analyzes the underlying index scan cost, and presents two practical optimizations—delayed join using covering indexes and a bookmark‑based approach—showing how they can cut execution time to a third or even a tenth of the original.

bookmark paginationdelayed joinmysql
0 likes · 8 min read
How to Speed Up Large Pagination Queries in MySQL: Delayed Join and Bookmark Techniques
ITPUB
ITPUB
Nov 12, 2022 · Databases

Understanding MySQL ORDER BY: Default vs Rowid Algorithms and Optimization Tips

This article explains how MySQL executes ORDER BY queries, compares the default sorting algorithm with the rowid method, and provides practical optimization steps such as indexing, adjusting sort_buffer settings, and choosing the appropriate algorithm based on data size and memory.

Order ByRowidSorting Algorithm
0 likes · 7 min read
Understanding MySQL ORDER BY: Default vs Rowid Algorithms and Optimization Tips
Selected Java Interview Questions
Selected Java Interview Questions
Nov 12, 2022 · Databases

MySQL Large‑Table Index Optimization and Maintenance Strategies

This article analyzes performance problems of a massive MySQL table, demonstrates how to use pt‑query‑digest and EXPLAIN to identify inefficient composite indexes, proposes index redesign, compares online DDL with pt‑osc for index rebuilding, and presents batch‑delete techniques to reduce SLA‑impacting latency.

Batch DeleteDDLIndex Optimization
0 likes · 14 min read
MySQL Large‑Table Index Optimization and Maintenance Strategies
ITPUB
ITPUB
Nov 11, 2022 · Databases

Master‑Slave Replication & Read/Write Splitting in MySQL: Benefits, Pitfalls, Tips

This article explains how MySQL master‑slave replication enables read/write splitting, details the asynchronous replication process, discusses latency and its impact on business logic, and presents practical mitigation strategies along with middleware options for accessing replicated databases.

DB middlewareReplication Lagmaster-slave replication
0 likes · 13 min read
Master‑Slave Replication & Read/Write Splitting in MySQL: Benefits, Pitfalls, Tips
Architect's Guide
Architect's Guide
Nov 11, 2022 · Databases

Database Sharding: Table Partitioning, Horizontal and Vertical Splitting, and Implementation with Sharding-JDBC and Mycat

This article explains why high‑concurrency big‑data systems need database sharding, describes table‑level partitioning methods (modulus and range), shows how to implement them with MySQL and Java code, compares vertical and horizontal database splitting, and evaluates middleware solutions such as Sharding‑JDBC and Mycat.

database partitioninghorizontal scalingjava
0 likes · 11 min read
Database Sharding: Table Partitioning, Horizontal and Vertical Splitting, and Implementation with Sharding-JDBC and Mycat
ITPUB
ITPUB
Nov 10, 2022 · Databases

How to Turn MySQL Slow Queries from Passive Pain to Proactive Risk Scores

This article presents a systematic approach to transform MySQL slow‑query handling from reactive troubleshooting to proactive risk management by defining a scoring model, selecting key metrics, calculating weighted risk indices, and testing the model to prioritize and reduce harmful queries.

mysqlrisk scoringslow-query
0 likes · 15 min read
How to Turn MySQL Slow Queries from Passive Pain to Proactive Risk Scores
Top Architect
Top Architect
Nov 10, 2022 · Databases

Database Sharding and Partitioning Strategy for High‑Volume Order Systems

This article explains how to handle billions of order records by classifying data into hot and cold tiers, using MySQL sharding with database‑and‑table partitioning, storing cold data in Elasticsearch and Hive, and outlines combined routing formulas for scalable backend architecture.

database partitioningmysqlsharding
0 likes · 8 min read
Database Sharding and Partitioning Strategy for High‑Volume Order Systems
dbaplus Community
dbaplus Community
Nov 8, 2022 · Databases

Mastering MySQL Performance: 5 Key Issues and Proven Tuning Strategies

This comprehensive guide outlines five common MySQL performance problems, a step‑by‑step investigation methodology, detailed Java middleware and database analyses, practical tuning tactics such as index optimization and sharding, and a governance framework for sustainable performance management.

DevOpsTuningaiops
0 likes · 23 min read
Mastering MySQL Performance: 5 Key Issues and Proven Tuning Strategies
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 7, 2022 · Databases

Orchestrator Failover Process Source Code Analysis – Simulating Faults and Understanding ContinuousDiscovery

This article walks through a simulated MySQL 3307 cluster failure, examines Orchestrator's source code to explain the ContinuousDiscovery loop, discovery queues, health ticks, caretaking tasks, raft coordination, topology snapshots, and the logic distinguishing UnreachableMaster from DeadMaster states.

ContinuousDiscoveryDatabase HAGo
0 likes · 20 min read
Orchestrator Failover Process Source Code Analysis – Simulating Faults and Understanding ContinuousDiscovery
dbaplus Community
dbaplus Community
Nov 6, 2022 · Databases

Master MySQL Slow Query Optimization: Proven Techniques & Real-World Cases

This guide explains how to enable and read MySQL's slow query log, use EXPLAIN, profiling, and optimizer trace to pinpoint inefficient SQL, and presents ten classic problem patterns—such as implicit conversion, left‑most prefix violations, deep pagination, large IN lists, and file‑sort order‑by—with concrete code examples and practical optimization steps.

Profilingexplainindex
0 likes · 24 min read
Master MySQL Slow Query Optimization: Proven Techniques & Real-World Cases
ITPUB
ITPUB
Nov 6, 2022 · Databases

Why Can’t You Read Your Recent Write? Understanding Master‑Slave Lag and Fixes in MySQL

The article explains why a recent write may be invisible when reading from a MySQL replica, analyzes the replication threads and latency causes, and presents practical solutions such as forcing master reads, lag detection, semi‑sync mode, and GTID‑based waiting, with examples from Sharding‑JDBC, MyCat and MaxScale.

Database MiddlewareGTIDMaster‑Slave
0 likes · 10 min read
Why Can’t You Read Your Recent Write? Understanding Master‑Slave Lag and Fixes in MySQL
Wukong Talks Architecture
Wukong Talks Architecture
Nov 4, 2022 · Databases

Understanding MySQL Implicit Type Conversion and Its Pitfalls

This article explains how MySQL performs implicit type conversion during queries, demonstrates the unexpected results caused by joining mismatched column types, outlines the conversion rules, and provides practical tips to avoid performance degradation and incorrect data retrieval.

Implicit Conversionmysqlsql
0 likes · 10 min read
Understanding MySQL Implicit Type Conversion and Its Pitfalls
ITPUB
ITPUB
Nov 3, 2022 · Databases

How to Diagnose and Resolve MySQL InnoDB Deadlocks in Production

This guide explains how to detect MySQL deadlock exceptions, retrieve and interpret InnoDB deadlock logs and binlog files, and use the information to pinpoint conflicting SQL statements and fix the underlying lock issues in live systems.

BinlogInnoDBdatabase troubleshooting
0 likes · 9 min read
How to Diagnose and Resolve MySQL InnoDB Deadlocks in Production
Qunar Tech Salon
Qunar Tech Salon
Nov 2, 2022 · Databases

Design of a Next‑Generation Qunar Database Automation Platform: Architecture, Communication Protocol, and Security

This article describes the layered architecture of Qunar's next‑generation database automation platform, outlines the design goals for secure Agent/Plugin‑Server communication, compares communication and encryption methods, and details the authentication and request flow using symmetric encryption and token‑based security.

Agent-Server CommunicationGoSecurity Protocol
0 likes · 9 min read
Design of a Next‑Generation Qunar Database Automation Platform: Architecture, Communication Protocol, and Security
Selected Java Interview Questions
Selected Java Interview Questions
Nov 1, 2022 · Databases

Understanding MySQL Unique Index Pitfalls and Practical Solutions

This article examines why a MySQL InnoDB table with a unique index can still store duplicate rows—especially when indexed columns contain NULL values or when logical deletion is used—and presents several practical strategies such as adjusting delete status, adding timestamp or auxiliary ID fields, using hash columns, and leveraging proper bulk‑insert techniques to enforce uniqueness effectively.

Database designHashLogical Delete
0 likes · 13 min read
Understanding MySQL Unique Index Pitfalls and Practical Solutions
政采云技术
政采云技术
Nov 1, 2022 · Databases

Understanding How Indexes Influence MySQL JOIN Queries and the Mechanics of Index and Block Nested-Loop Joins

This article explains how MySQL uses indexes during JOIN operations, compares indexed and non‑indexed join execution, introduces Index Nested‑Loop Join and Block Nested‑Loop Join algorithms, discusses the role of the join buffer, and provides practical guidance on choosing the optimal driving table for efficient query performance.

Block Nested-Loop JoinDatabase OptimizationJOIN
0 likes · 14 min read
Understanding How Indexes Influence MySQL JOIN Queries and the Mechanics of Index and Block Nested-Loop Joins
dbaplus Community
dbaplus Community
Oct 31, 2022 · Databases

Why MySQL Picks the Wrong Index for ORDER BY LIMIT Queries and How to Fix It

This article investigates a recurring MySQL CPU‑100% alarm caused by a slow SELECT with ORDER BY id ASC LIMIT, explains why the optimizer mistakenly chooses the primary‑key index over a suitable composite index, and presents six practical experiments—including force‑index, ORDER BY tweaks, and LIMIT adjustments—that reliably restore optimal index usage.

Cost ModelIndex OptimizationQuery Optimizer
0 likes · 14 min read
Why MySQL Picks the Wrong Index for ORDER BY LIMIT Queries and How to Fix It
DeWu Technology
DeWu Technology
Oct 31, 2022 · Databases

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

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

BinlogMaster‑SlaveReplication
0 likes · 10 min read
Analysis of Order Query Failures Caused by MySQL Master‑Slave Replication Lag and Mitigation Strategies