This article explains how to build distributed locks using three different technologies—database tables, Redis, and Zookeeper—detailing their implementation steps, code examples, advantages, drawbacks, and practical considerations for choosing the right solution in real‑world scenarios.
This article explains how to use MySQL's EXPLAIN statement to view execution plans, describes the meaning of each of the twelve output fields, provides practical examples with sample tables and queries, and offers optimization tips such as index creation and the left‑most prefix rule.
This article explains InnoDB's 16KB page structure, row formats, record metadata, primary key strategies, and how B+Tree indexes—including clustered, secondary, and covering indexes—organize and retrieve data, with practical SQL examples and performance considerations.
This article explores Redis 6.0’s new client‑side caching feature, detailing the tracking command, its options such as BCAST, PREFIX, OPTIN, OPTOUT, REDIRECT and NOLOOP, and provides step‑by‑step examples using telnet and redis‑cli to demonstrate invalidation messages and configuration.
Although Docker has become popular for deploying many applications, this article outlines seven technical reasons—ranging from data safety and performance to networking, statefulness, resource isolation, cloud platform limitations, and environment requirements—that make containerizing databases generally impractical, while also suggesting cautious scenarios where it might work.
This article provides a comprehensive overview of using Lua scripts with Redis, covering Lua basics, advantages of Lua scripting, detailed Redis‑Lua integration syntax, command usage, return‑type mappings, script management commands, and step‑by‑step instructions for installing Lua and executing example scripts.
This article provides an in‑depth overview of MySQL, covering storage engine concepts, selecting appropriate data types, index design and usage, view creation, stored procedure syntax, variable handling, and trigger implementation, with practical examples and SQL code snippets to illustrate each topic.
The article explains that MySQL’s legacy “utf8” character set only supports three‑byte sequences and therefore cannot store true UTF‑8 characters, describes the historical reasons behind this limitation, and advises all MySQL/MariaDB users to migrate to the proper utf8mb4 charset.
This article explains Redis's custom Simple Dynamic String (SDS) implementation, its dynamic expansion mechanism, and the performance benefits such as O(1) length retrieval, buffer overflow avoidance, and efficient memory allocation strategies for high‑throughput applications.
This article explains MySQL master‑slave replication, covering its concepts, asynchronous replication mechanisms, various synchronization strategies, step‑by‑step installation and configuration on CentOS 7, and includes common interview questions with answers; it also provides practical commands, troubleshooting tips, and performance considerations for read‑write separation in production environments.
This article explains what Oracle Active Data Guard (ADG) is, outlines its basic deployment architecture, and provides detailed step‑by‑step emergency response procedures for four common network and server configurations to ensure rapid failover and business continuity.
This article explains the fundamentals of Oracle character sets, how database and national character sets are defined, the role of NLS_LANG, the location and purpose of character set files, and practical guidance for import/export operations and character set conversion across different environments.
The article describes a bug where a user's VIP expiration date cannot exceed a specific day in 2038 because the MySQL INT column storing the timestamp reaches its maximum signed value, explaining the cause, impact, and the pragmatic decision to ignore the issue.
This article provides a thorough, step‑by‑step guide to MySQL, covering how to install and start the server, create databases and tables, use DDL/DML/DQL statements, understand numeric, date/time and string data types, apply arithmetic, comparison, logical and bitwise operators, and leverage common built‑in functions for efficient data manipulation.
This article provides a comprehensive overview of relational database fundamentals and SQL syntax, covering basic concepts, statement categories (DDL, DML, TCL, DCL), CRUD operations, subqueries, joins, unions, functions, ordering, grouping, constraints, transactions, permission management, stored procedures, cursors, and triggers with illustrative code examples.
This article explains PostgreSQL's auto‑increment mechanism, covering built‑in serial data types, manual sequence creation, default value assignment, step‑by‑step code examples, and how to query indexes, offering a clear comparison with MySQL's auto_increment feature.
This article explains MySQL transaction isolation concepts, the four standard isolation levels, their effects on dirty, non‑repeatable, and phantom reads, practical configuration steps, when to use repeatable read, how InnoDB implements isolation, and tips for avoiding long transactions and planning backups.
This guide explains how to upgrade MySQL 5.6 instances to 5.7 on Windows by using the ZIP distribution and an in‑place upgrade, covering preparation, installation, required Visual C++ libraries, common pitfalls, troubleshooting steps, and a complete checklist of post‑upgrade actions.
MySQL 8.0.21 introduces numerous enhancements such as dynamic redo log control, optional tablespace path validation, refined lock system, JSON_VALUE function, atomic CREATE TABLE…AS SELECT, optimizer improvements, reduced group replication cache, multi‑address X Plugin support, and various security and deprecation updates.
This article explains the concept of distributed locks, compares various implementation approaches such as Memcached, Zookeeper, Chubby, and Redis, and details single‑node and multi‑node Redis lock designs—including SETNX, SET with NX/EX options, Redisson, and the Redlock algorithm—while highlighting their advantages, pitfalls, and best‑practice recommendations.
To streamline Oracle SQL script reviews, this guide shows how to adapt the open‑source SOAR tool—originally built for MySQL—by defining custom rules, installing Go and Git, compiling the source, and integrating a web UI, enabling automated, 90% coverage of Oracle SQL checks.
This article explains the principles of short URL generation, compares incremental ID, hash, and random algorithms, analyzes their security and collision characteristics, and presents a complete backend design including database schema, caching strategy, sharding, and Java implementation details.
The article reports on Tencent Cloud’s TVP “complaint conference,” summarizing industry experts’ praise and criticism of its cloud database products, market trend data from Gartner, and the company’s roadmap for open‑source, security, and SaaS enhancements.
This article explains what database transactions are, demonstrates how to use Spring Boot’s @Transactional annotation with unit tests, and dives into transaction isolation levels and propagation behaviors, providing code examples and guidance for effective transaction management in Java backend applications.
This tutorial explains two approaches to achieve MySQL read/write splitting—first by manually implementing routing logic in Spring Boot with MyBatis interceptors and dynamic data sources, and second by configuring the MyCat middleware for automatic load balancing, fault‑tolerance, and multi‑node support, complete with code samples and configuration files.
This article walks through the evolution of MySQL index implementations—from hash tables and binary search trees to AVL, red‑black, B‑trees and finally B+ trees—explaining their performance trade‑offs, disk‑I/O considerations, and how InnoDB and MyISAM store data and indexes differently.
The article explains how a Druid 1.1.20 connection pool was throttled to ~10k RPS by fair‑locking in recycle(), and how enabling the unfair lock (setUseUnfairLock(true)) doubled single‑machine TPS, raised CPU usage to near 100 % and boosted cluster throughput by about 70 %.
This article explains Linux CPU states, identifies typical MySQL queries and configurations that cause high CPU usage, and provides practical optimization techniques—including indexing, buffer tuning, and proper use of system tools—to diagnose and reduce MySQL-related CPU bottlenecks.
This article explains Redis transactions in depth, covering their command workflow, the MULTI/EXEC/DISCARD/WATCH/UNWATCH commands, error handling, practical code demonstrations, and a comparison with MySQL transaction semantics to help readers master Redis transaction usage for interviews and development.
This article explains how to resolve foreign key constraint violations that occur when migrating data from multiple source databases into a target PostgreSQL/Greenplum database by disabling, dropping, or deferring constraints and then re‑enabling them to ensure full data integrity.
This article analyzes the various system‑level and database‑level reasons why SELECT, UPDATE, INSERT, or DELETE statements become slow, covering network issues, OS and hardware constraints, MySQL configuration, indexing, execution plans, and query design, and offers practical mitigation strategies.
This tutorial walks through verifying IPv6 support on Red Hat 7.6, configuring a static IPv6 address, updating the Oracle 19c listener for IPv6, restarting services, and confirming connectivity, providing concrete commands, configuration snippets, and screenshots for a RAC environment.
This article explains the MySQL Memcached API, its evolution from MySQL 5.6 to 8.0, demonstrates how to install the plugin, configure tables, and perform batch and range key retrievals with code examples, highlighting suitable use cases and performance benefits.
This article compiles a series of questions and answers from a recent PostgreSQL live session, covering recommended scenarios, differences with Oracle, backup and recovery, clustering, PostGIS, stored procedures, migration tips, version recommendations, performance tuning, high‑availability, and real‑world adoption across industries.
This guide demonstrates how to create a Laravel 5.4 API project, covering Composer project creation, database and users table setup, model and controller generation, route definition, and API testing, with complete code examples for each step.
Meituan’s KV platform evolved from Memcached and Redis to its own high‑throughput in‑memory Squirrel and durable Cellar systems, each partitioning keys into 16 384 slots, using ZooKeeper routing, Kubernetes scaling, intelligent migration, cross‑region Raft replication, multi‑queue latency isolation, and hotspot management, while planning further optimizations such as Redis‑Gossip tuning, kernel‑bypass I/O, and FPGA acceleration.
This article explains MySQL benchmark testing, the role and metrics of benchmarking, introduces sysbench, provides step‑by‑step installation and usage instructions, and offers practical tips for interpreting results and optimizing database performance in production environments.
This article explains MySQL's support for XA distributed transactions, describes the two‑phase commit process, details the XA syntax, and walks through a complete hands‑on example that transfers money between two databases using XA START, END, PREPARE, RECOVER and COMMIT commands.
This article explains how MySQL processes a SELECT statement—from client request, cache check, parsing, optimization, and execution—to return results, using a sample User table, a detailed query example, and a step‑by‑step walkthrough of the parser, optimizer, and executor components.
The article explains why MySQL’s legacy “utf8” character set only supports three‑byte sequences, causing errors with genuine four‑byte UTF‑8 characters, and shows how the proper “utf8mb4” charset resolves the issue, including historical background, practical examples, and migration guidance.
This article provides a comprehensive MySQL tutorial covering schema concepts, data types, service control, database creation, table manipulation, and complete CRUD operations with practical command‑line examples and code snippets for beginners and intermediate users.
This article explains what database indexes are, their advantages and disadvantages, when to create or avoid them, various index types, and practical SQL optimization techniques, including code examples for efficient pagination in MySQL.
Although most SQL statements begin with SELECT, the actual execution follows a specific order—WHERE, GROUP BY, HAVING, then SELECT—illustrated by a diagram that also clarifies common misconceptions about filtering window functions, column aliases, and how databases may reorder operations for optimization.
This tutorial walks through building a PyQt5 desktop interface with Python 3.7 and MySQL 5 that connects to a local database, displays its tables, allows inline editing, manages table scrolling, and provides a custom right‑click menu for row insertion and deletion.
This article analyzes a financial system's duplicate income‑splitting bug caused by concurrent transactions, explains how MySQL isolation levels and Spring transaction propagation contributed to dirty reads, and presents two corrective approaches—adjusting transaction propagation and repositioning Redis locks—to ensure reliable data consistency.
The article outlines common cache challenges—consistency, breakdown, and avalanche—explains traditional three‑tier architectures, then details Tencent Cloud Redis Hybrid Storage’s unified interface, automatic hot‑data caching, dynamic TTL, atomic updates, and cost‑effective persistence, offering a scalable, reliable cache‑plus‑storage solution.
This guide details Redis monitoring metrics across performance, memory, activity, persistence, and error categories, explains how to retrieve them with the INFO command, outlines useful monitoring tools, provides slowlog configuration examples, and includes command‑line snippets for performance testing and metric inspection.
This article explains how to define and use Laravel Eloquent relationships—including one-to-one, inverse, and default model handling—by showing the necessary model methods, query constraints, and code examples for both sides of the association.
This article explains how to add, update, and manage related Eloquent models in Laravel—including saving single or multiple related records, using associate/dissociate for belongsTo relations, and handling many‑to‑many pivots with attach, detach, sync, toggle, and timestamp propagation.
This article explains how to define and use Laravel Eloquent relationships—including remote one‑to‑many (hasManyThrough), polymorphic, many‑to‑many polymorphic, and various query constraints—by showing required database schemas, model methods, and example code for retrieving and counting related records.
This article presents a detailed fio benchmark comparing sequential and random I/O on a 7‑disk RAID5 array, revealing how I/O size, RAID strip size, and caching affect bandwidth, latency, and IOPS, and explains the implications for database transactions, file copying, and B+‑tree indexing.
This article explains various MongoDB pagination strategies—including skip/limit, range queries, and sorting—covers performance monitoring with profiling, details index creation and design principles, and describes how to interpret explain plans for efficient query optimization.
This article analyzes a production incident where concurrent MySQL transactions caused an over‑deduction of account balance, explains the underlying MVCC mechanism, consistency view rules, and how different isolation levels (RR vs RC) affect data visibility and lead to negative balances.
This tutorial walks through preparing three CentOS 7 servers, installing and compiling Redis 6.0.3, configuring master‑slave replication, setting up Sentinel for high availability, adjusting firewall and Redis configuration, and managing the services to achieve a fully functional Redis cluster.
This article explains HBase compaction—a key operation in the Log‑Structured Merge‑Tree model—covering minor and major compaction differences, trigger conditions, configuration parameters, selection algorithms, thread‑pool handling, and the effects on read and write performance in a big‑data database environment.
This article surveys open‑source MySQL audit plugins, explains their installation and configuration, compares their features, performance impact, and logging formats, and provides practical examples to help you choose the most suitable audit solution for your database environment.
This article explains the MySQL client‑server handshake, details the sequence of packets exchanged during a TCP connection, and provides a complete Python implementation that builds a raw TCP socket to connect, authenticate, and communicate with a MySQL server without using a high‑level driver.
This article provides an extensive overview of MySQL fundamentals for interview preparation, covering primary key concepts, index types and usage, transaction properties and isolation levels, storage engine differences, query execution order, performance tuning with EXPLAIN, lock mechanisms, replication strategies, and high‑concurrency solutions.
The article explains why idempotency is essential for reliable services, describes how unique identifiers such as UUIDs, Snowflake IDs, and database‑generated keys can be used to achieve it, and offers practical guidance on shared storage, avoiding unnecessary queries, and handling duplicate requests in distributed systems.
This article explains MySQL execution order, highlights performance problems with large OFFSET LIMIT queries, demonstrates how implicit type conversion, sub‑query rewriting, EXISTS removal, condition push‑down, and intermediate result push‑down can dramatically improve query speed, and provides practical SQL rewrite examples.
This article explains the internal B+Tree layout of InnoDB indexes, detailing page types, record organization, and how different primary‑key data types affect page density and overall index tree height, illustrated with concrete examples and visual diagrams.
This comprehensive guide explains MySQL's layered architecture, storage engine plugins, index structures, transaction isolation levels, locking mechanisms, performance tuning techniques, partitioning, sharding, and replication, providing practical insights for developers and DBAs to optimize and scale MySQL deployments.
This article examines why MySQL is deployed on Kubernetes, outlines the technical challenges such as service routing, monitoring isolation, storage and high‑availability, highlights the benefits of cloud‑native networking and scheduling, and reviews popular MySQL operators and their implementation details.
This article provides a comprehensive step‑by‑step guide for DBAs to safely upgrade MySQL from version 5.7 to 8.0, covering motivations, compatibility checks, new features, preparation tasks, upgrade commands, post‑upgrade verification, and rollback considerations.
This article describes how to discover Bilibili's comment XML APIs, decode the embedded CRC32‑hashed user IDs, choose an appropriate database schema, and implement a Python‑PHP tool that retrieves, filters, and displays comments based on video CID and keyword.
The article explains the precision loss caused by using float for monetary values, demonstrates the binary representation of floating‑point numbers, and recommends using integer (cents) or MySQL decimal types to store money accurately, providing Java and SQL examples.
The article explains how MySQL Shell 8.0.17+ can be extended using JavaScript or Python to build reusable reports and plugins, describes the directory layout, provides a complete example of registering a report and a plugin that list tables without primary keys, and shows how to invoke them via \show, \watch or direct function calls.
This guide walks through Oracle SQL execution steps, optimizer selection, table access methods, shared SQL caching, join order, index usage, query rewriting techniques, hint usage, and dozens of practical tips that together dramatically improve database performance while avoiding common pitfalls.
This article examines common operation‑log types and compares two implementation approaches—traditional AOP with annotations and a database binlog‑based solution—detailing their advantages, drawbacks, code examples, database design, future enhancements, and practical deployment considerations.
SQLite 3.32.0, the latest release of the world’s most widely used database engine, introduces approximate ANALYZE support, a bytecode virtual table, new SQL functions, expanded parameter limits, numerous CLI enhancements, and behavior changes that align the LIKE operator with PostgreSQL, offering developers richer functionality and improved compatibility.
The article explains how HBase tracks each region's lifecycle states in hbase:meta and ZooKeeper, lists all possible states with their color codes, and describes the master‑region server interactions for opening, closing, splitting, and merging regions.
This article analyzes why Redis service nodes may experience massive TimeoutException errors, covering external influences such as CPU and memory contention, network resource exhaustion, and internal Redis usage issues like slow queries, persistence overhead, and configuration pitfalls, and provides concrete diagnostic commands and mitigation steps.
This article introduces many lesser‑known MySQL client shortcuts—such as \G, \R, \T and others—explaining their syntax, usage examples, and how they can streamline daily database operations for developers and administrators.
The article explains how iQIYI’s order system leverages MySQL binlog and redo log with a two‑phase commit to drive event‑driven processing, reveals hidden consistency gaps where binlog events can precede database state, and proposes retry or direct binlog consumption strategies to ensure reliable order fulfillment.
This tutorial demonstrates how to rapidly set up and use HBase inside a Docker container, covering Docker installation, image pulling, container execution, host configuration, accessing the HBase Web UI and shell, Zookeeper interaction, and a Java API example for beginners.
This tutorial walks through compiling the php‑redis extension, installing Laravel, configuring Redis as a cache and database driver, setting up a Redis cluster, and provides sample PHP code for read/write operations, offering a comprehensive guide for backend developers.
This article examines recurring “connection holder is null” errors in Druid’s connection pool, explains how the holder is assigned and cleared, analyzes two real‑world cases—long‑running transactions and killed connections—and offers practical configuration recommendations to prevent the issue.
This guide walks through preparing three CentOS 7 servers, installing Redis 6.0.3, configuring master‑slave replication, handling common compilation errors, setting up system startup, adjusting firewall and Redis settings, and finally enabling Sentinel for high‑availability monitoring.
This article explains the MySQL group_replication_consistency parameter, describes its five possible values, demonstrates the three most common consistency modes (EVENTUAL, BEFORE, AFTER) with practical multi‑node examples, and discusses their advantages, drawbacks, and impact on query latency and data integrity.
This article explains why MySQL master‑slave replication can suffer from latency, examines the root causes on both master and slave sides, and provides practical architectural, hardware, and configuration solutions—including semi‑sync and parallel replication—to improve data consistency and performance.
Distributed systems need globally unique, often monotonic IDs, and this article examines common ID generation strategies—Snowflake, database auto‑increment, segment allocation, multi‑master databases, and Raft‑based consensus—evaluating each for high availability and high performance, and highlighting trade‑offs and implementation details.
This guide explains how to achieve MySQL high availability and scalability through full and incremental backups, binlog-based point‑in‑time recovery, and both asynchronous and synchronous replication, while highlighting trade‑offs, best practices, and practical command examples.
The article analyzes a MySQL 5.7 upgrade that broke an application due to SSL being enabled by default in version 5.7.28, explains how the JDBC useSSL=true setting triggered handshake errors, and provides several practical solutions such as disabling SSL, adjusting auto‑generation settings, and updating the connection string.
This article provides a comprehensive guide to JDBC, covering its definition, core interfaces (Connection, Statement, ResultSet), the advantages of PreparedStatement, the need for connection pools, pagination techniques for Oracle and MySQL, and practical usage of DBUtils with full code examples.
This article reviews the Text-to-SQL semantic parsing task, covering its motivation, dataset landscape, major model architectures such as pointer networks, sequence‑to‑set, and grammar‑based approaches, evaluation metrics, the newly built DuSQL dataset and DuParser system, real‑world deployments, and remaining research challenges.
This article examines recent database deletion incidents and offers DBA‑level guidance on strengthening processes, technical safeguards, and security policies, covering backup‑restore design, performance optimization, high‑availability strategies, and self‑service automation to avoid future data loss.
This article explains which components consume CPU on a MySQL server, analyzes the impact of user‑space processing and IO wait, and provides practical strategies—such as optimizing indexes, reducing unnecessary calculations, and improving IO handling—to lower CPU usage and improve overall database performance.
This article provides a comprehensive guide to Laravel's query builder, covering basic CRUD commands, selective column retrieval, complex where clauses, joins, aggregations, raw expressions, inserts, updates, deletions, unions, locking mechanisms, and query caching with clear code examples for each feature.
This tutorial walks you through installing MySQL 5.7 on two CentOS 7.6 machines, configuring the master and slave my.cnf files, setting up replication users, starting the services, and verifying synchronization with detailed commands and troubleshooting tips.
This article explains Redis's two persistence mechanisms—RDB snapshot files and AOF append‑only logs—including their operation, configuration commands, advantages, disadvantages, recovery procedures, and performance recommendations for choosing between them.
Redis 6.0.0 GA, the biggest release to date, adds a redesigned client cache, ACL improvements, faster RDB loading, a new STRALGO command, and optional multithreaded I/O that can double network performance, while urging careful testing before production use.
Redis 6.0.0 stable release brings major updates such as redesigned client‑side caching, immediate RDB deletion for replication, enhanced ACL logging, faster PSYNC2 partial resynchronization, decimal timeout support, up to 30% faster RDB loading, and a new STRALGO command for string algorithms.
This guide compiles essential MySQL security steps, master‑slave replication principles, backup scripts, Linux boot overview, common port services, virus mitigation, monitoring tools, nginx optimization, InnoDB lock troubleshooting, replication lag reduction, high‑availability components, data migration utilities, and automation configuration management techniques for operations engineers.
This comprehensive MySQL FAQ covers its definition, implementation language, key features, differences from SQL, storage engines, data types, triggers, security tips, performance considerations, and practical queries such as retrieving the N‑th highest salary, providing a solid reference for developers and DBAs.
This article provides concise answers to common MySQL questions covering default ports, regular expression usage, index limits, query examples for retrieving rows, date functions, savepoints, ENUM types, storage engines, connection functions, ACLs, and other essential database concepts.
The article outlines the historical evolution of IT architecture—from early single‑machine deployments through hot‑standby and multi‑node active clusters to modern distributed systems—explaining the motivations, trade‑offs, and key technologies that drive each generation and offering guidance on selecting the right architecture for business needs.
MySQL 8.0.20 introduces a range of enhancements including new SHOW_ROUTINE privilege, hash join improvements, index‑level optimizer hints, performance schema refinements, SQL syntax changes, InnoDB doublewrite buffer relocation, binary log transaction compression, X Plugin and protocol upgrades, and additional replication options.
This article explains the fundamentals of SQL parsing, describing the roles of lexical analysis, syntax analysis, and visitors, and demonstrates the process with a concrete SELECT statement example, while also mentioning popular parsing libraries such as Druid and ANTLR.
This article explains what Redis Cluster is, how it partitions data and provides redundancy, and walks through installing Redis on CentOS, configuring multiple nodes, and creating a functional cluster using both manual commands and the built‑in cluster management tool.
This article explains database bottlenecks caused by IO and CPU limits, introduces horizontal and vertical sharding for databases and tables, compares popular sharding tools, discusses challenges such as distributed transactions, cross‑node joins, pagination and global ID generation, and offers guidance on when and how to apply sharding in real‑world systems.
