Search across authors, categories, and technical themes. The layout mirrors the editorial references while staying responsive and fast.
This article demonstrates how to create a lightweight, offline MySQL CVE scanning and reporting tool by cloning the CVEProject JSON repository, leveraging DuckDB for fast JSON parsing and SQL queries, and providing simple shell commands for data updates, version scanning, and vulnerability matching.
This article provides a comprehensive overview of database transactions, explaining ACID properties, transaction states, explicit and implicit transaction control, isolation levels, and how to configure and use them in MySQL with practical SQL examples and code snippets.
This article explains how to combine Elasticsearch and MySQL in a Spring Boot backend by selecting the technology stack, creating a shared Elasticsearch package, defining ES and MySQL entity classes, implementing repository and mapper interfaces, writing service logic, and demonstrating query testing.
This article discusses the motivations, comparative analysis, and practical steps for refactoring a Java backend project by replacing MongoDB with MySQL, covering pain points, selection criteria, schema redesign, entity mapping, and sample query code.
This article explains MySQL's index limits for InnoDB and MyISAM engines, detailing the maximum number of indexes per table, the maximum columns per index, and provides practical recommendations on how many indexes a table should have to balance performance and maintenance.
This article combines a Meituan salary update with detailed explanations of MySQL indexing strategies, B‑tree variations, ACID transaction properties, isolation levels, caching, handling high‑traffic queries, the Raft consensus algorithm, and an overview of gRPC, providing comprehensive backend development knowledge for interview preparation.
This article provides a comprehensive, step‑by‑step tutorial on deploying a MySQL master‑slave replication architecture using Docker containers, covering prerequisite checks, container setup, configuration files, replication user creation, master‑slave linking, testing data sync, and troubleshooting common issues.
This article examines a real‑world MySQL master‑slave replication lag issue caused by massive multi‑table transactions during a sharding operation, details the investigative steps using system tables, binlog parsing, and my2sql analysis, and proposes three practical mitigation strategies.
The article examines the challenges of generating short, user‑friendly numeric account IDs, evaluates Snowflake and MySQL auto‑increment approaches, discusses deadlock issues with REPLACE INTO, and presents a final segment‑based solution that allocates ID blocks per login server while avoiding waste and concurrency problems.
This article analyzes a puzzling case where data consistency checks between a MySQL source and an OceanBase target report matching results despite visible record differences, explains the OMS ordinary and Inmode validation modes, and outlines scenarios that trigger Inmode verification.