This article examines the various scenarios in which MySQL can lose data, covering InnoDB and MyISAM engine behaviors, flush policies, master‑slave replication pitfalls, XA transaction handling, and practical solutions to improve consistency and availability.
This guide shows how NULL values break numeric calculations in PostgreSQL and demonstrates using the COALESCE function to substitute default numbers, with step‑by‑step SQL examples that turn unexpected NULL results into accurate sums.
This guide shows how to split a delimited string into a one‑dimensional array in Oracle SQL using a custom hierarchical query, avoiding the restrictions of DBMS_UTILITY.UNCL_ARRAY and allowing any delimiter for flexible data processing.
This article explains the legacy java.util.Date class, its limited useful constructors and methods, the more flexible java.util.Calendar API, how to format and parse dates with DateFormat and SimpleDateFormat, and best practices for storing timestamps in databases using long values.
This article explains how WordPress uses the wp_postmeta table for flexible metadata storage and the hook (action) system for dynamic code insertion, illustrating both the benefits and trade‑offs of these extensibility techniques for plugin development.
This article explains how Oracle 12c's In-Memory feature enables hybrid OLTP/OLAP workloads by storing columnar data in a dedicated memory area, covering its architecture, data loading, consistency mechanisms, query acceleration techniques, and integration with RAC for high‑availability deployments.
The article details Stack Overflow’s 2016 infrastructure upgrades—including hardware, networking, load balancing, caching, database, and service layers—that enabled the site to process over 61 million daily requests while reducing processing time by hundreds of hours.
This article explains MySQL InnoDB full-text indexing, covering supported modes, auxiliary tables, creation, DML handling, query processing, transaction management, cache synchronization, optimization, background threads, monitoring, stopwords, plugins, and the built‑in n‑gram parser, with code references from MySQL 5.7.
This article provides a comprehensive overview of Oracle Database architecture, detailing the server components, instance memory structures such as SGA, essential background processes, and the physical and logical storage layers, helping readers understand how Oracle organizes data and manages operations.
This article reports a hands‑on experiment comparing single‑column and composite covered indexes in MySQL, measuring their storage overhead and insert latency on a million‑row table, and reflects on the importance of data‑driven reasoning versus intuition.
This article details Dazhong Dianping's practical approach to sharding its massive order database, covering vertical and horizontal partitioning strategies, specific sharding algorithms, unique ID design, data migration phases, and lessons learned for long‑term scalability.
This article reveals why Oracle’s CREATE TABLE documentation spans dozens of pages and walks readers through essential Oracle database concepts such as tables, indexes, sequences, views, clusters, tablespaces, database links, and synonyms to help master the platform efficiently.
A benchmark comparing Redis performance with and without the MONITOR command shows a substantial drop in throughput—up to 53% for SET operations—highlighting that MONITOR should be used only for short‑term debugging, as illustrated by a real‑world Meituan case study.
This article explains how Redis Lua scripting can make operations faster, cut network overhead, guarantee atomic execution, and enable script reuse, and it provides practical examples including a simple hello‑world script and a URL‑shortening implementation.
The article explains the concepts of vertical and horizontal database splitting, compares their technical difficulties, discusses the impact on joins and transactions, and proposes practical approaches such as careful SQL refactoring, ORM decoupling, and selective use of distributed‑transaction techniques to maintain system stability and scalability.
Redis 3 now officially supports clustering, introducing hash slots and dynamic node management to simplify key distribution, scaling, and fault tolerance, allowing seamless read/write operations across multiple nodes without manual hashing, and offering features like online node addition, automatic slave monitoring, and performance‑aware key allocation.
By leveraging MySQL's asynchronous query capabilities via mysqlnd and PHP's generator-based coroutines, developers can execute multiple SELECT statements concurrently, reducing total query time from around two seconds to roughly one second, though this approach must consider server load and thread overhead.
This article presents the full specifications and solution approaches for a two‑part Oracle SQL challenge that requires inserting every possible terminal Tic‑Tac‑Toe game state into a table and writing a query to determine forced wins from any valid board configuration.
The article details the ITPUB "Shengtou Media Cup" SQL contest, presenting two Oracle‑based Tic‑Tac‑Toe problems—one to list every possible terminal game sequence and insert it into a table, and another to compute forced wins from any valid board—along with solution approaches and extra challenges.
This technical session covers Oracle RAC high‑availability best practices, installation steps, daily operational commands, detailed case studies of auto‑start checks, version‑mix issues, addNode failures, network heartbeat problems, and client connection errors, plus a concise Q&A on uninstall, SCAN vs VIP, and split‑brain detection.
This article explains character sets and encodings, shows why MySQL data can become garbled, and provides step‑by‑step methods—including proper configuration, common pitfalls, and reliable repair techniques—to prevent and correct encoding issues such as emoji storage failures.
An overview of HBase’s 2015 milestones—including the stable 1.0 release, clearer API with BufferedMutator, multi‑region replicas for high availability, family‑level flush improvements, RPC call‑queue separation, online configuration changes, and various Q&A on performance, replication, and best‑practice design considerations.
This guide outlines a structured MySQL DBA interview process, covering self‑introduction, resume deep‑dive, career‑development questions, fundamental knowledge such as index types, core technical skills like backup, replication and performance troubleshooting, and broader potential areas including Linux and programming language proficiency.
This article explains MySQL's indexing mechanisms—including BTREE and hash structures, page layout, index types, and practical query patterns—while showing how to interpret EXPLAIN output and avoid common pitfalls for efficient database performance.
This article reviews real‑world Redis Cluster deployments from Youdao, Qihoo 360 and Mango TV, analyzes its architectural drawbacks, client challenges, implementation limitations, performance impact, and summarizes the overall advantages and disadvantages of using Redis Cluster as a distributed database solution.
This article explains how Redis master‑slave replication works, covering asynchronous copying, partial resynchronization, disk‑less replication, safety considerations when persistence is disabled, read‑only slaves, authentication, and configuration options such as slaveof and write‑restriction based on slave count.
This article details a Redis replication bug where slave offsets exceed the master after network interruptions, explains the root‑cause analysis of offset handling during full and incremental sync, describes the code fix applied by the Redis team, and offers testing and prevention guidance.
In this technical presentation, HP's storage director shares market trends, flash storage evolution, performance metrics, planning considerations, and risk mitigation strategies, highlighting how storage architecture directly impacts database efficiency, reliability, and cost in modern enterprise environments.
Time‑series data, defined by a timestamp field, appears everywhere, and the article explains how to choose an appropriate time‑series database by comparing two schema models, their query patterns, performance trade‑offs, and why modern solutions like Elasticsearch, columnar stores, and Druid excel at real‑time massive aggregation.
The ITPUB SQL Database Programming Contest invites participants to solve two Oracle‑SQL puzzles—generating every possible tic‑tac‑toe end‑game board with moves and determining forced win strategies—following detailed rules, evaluation criteria, and prize information.
This article traces the evolution of database models—from early hierarchical and network structures through the relational revolution and entity‑relationship diagrams to modern distributed and multi‑tenant designs—highlighting key concepts, technical challenges, and the theoretical foundations that shaped today’s data storage systems.
This article explains what split‑brain is in high‑availability systems, compares arbitration and fencing methods, evaluates client‑routing options without fencing devices, discusses data‑loss risks during failover for PostgreSQL and MySQL, and provides concrete implementation guidance using Pacemaker and Corosync.
This article explains why repeated SQL execution can cause library cache: mutex X contention in Oracle, describes the underlying hash‑bucket and handle locking mechanisms, and demonstrates how creating hotcopy objects—using hidden parameters and APIs—can alleviate hotspot mutex waits, with experimental results showing up to 50% reduction in wait time.
This article details a deep‑rooted Redis replication bug where slave offsets become larger than the master after a network interruption, explains the underlying cause in the full‑sync process, describes the code changes made to fix it, and offers testing and prevention guidance.
This guide explains two flash‑sale scenarios—single‑item seckill with a unique index and multi‑item seckill with quantity tracking—detailing table structures, SQL statements, concurrency handling, advantages, drawbacks, and an optimized version without locks, illustrated with step‑by‑step diagrams.
This article explains why concurrent read‑write operations on a shared balance can cause inconsistencies, illustrates the problem with a purchase‑balance example, and shows how a Compare‑And‑Set (CAS) update clause guarantees atomicity and preserves data integrity.
This article provides a comprehensive overview of MySQL indexing, covering the theoretical foundations of B‑Tree and B+Tree data structures, the differences between MyISAM and InnoDB index implementations, and practical optimization techniques such as left‑most prefix usage, selectivity analysis, and prefix indexing.
Formatting SQL statements doesn't speed up execution, but it dramatically enhances readability, maintenance, and development efficiency, making testing easier and reducing errors through clear alias usage, leading commas, and line‑by‑line JOIN placement, as illustrated by practical examples.
An in‑depth guide shows how to illustrate various SQL join types—including inner, full outer, left outer, and cross joins—using Venn diagrams and concrete table examples, highlighting result sets, null handling, and the pitfalls of Cartesian products for large tables.
This article explains the concept, use cases, benefits, and challenges of running multiple MySQL instances on one machine, then provides a detailed, command‑line walkthrough—including environment preparation, compilation, configuration files, startup, security measures, and management scripts—to help you set up and manage multi‑instance MySQL deployments.
This article reviews various MySQL high‑availability architectures—including master‑slave replication with keepalived or MHA, Galera‑based clusters, and other approaches—detailing their deployment methods, advantages, limitations, and practical considerations for selecting an appropriate HA solution.
This article discusses MySQL high‑availability solutions, covering asynchronous and semi‑synchronous replication, monitoring with keepalived, Zookeeper, and custom agents, failover procedures using binlog positions, GTID and pseudo‑GTID techniques, and the author's practical experiences and future plans.
In a lively Q&A session, Oracle experts discuss how China’s “post‑IOE” shift, cloud migration, big‑data collaboration with Hadoop, and the strengths of In‑Memory, TimesTen, and Exadata shape the future direction of Oracle databases.
Redis Sentinel provides a high‑availability solution for Redis by continuously monitoring master and replica servers, automatically promoting a replica to master when the original master fails, and seamlessly handling failover and recovery to keep the system operational without manual intervention.
Redis’s AOF persistence logs every write command, causing the log file to grow, but the AOF rewrite feature creates a compact new file by replaying the current dataset, runs in a child process, and uses a buffer to avoid blocking and ensure data consistency.
Redis offers two persistence strategies—RDB snapshots and AOF command logging—each with distinct generation methods, configuration options, and recovery processes, allowing users to balance speed, safety, and data durability based on workload requirements.
Redis partial resynchronization relies on three components—the master‑slave replication offset, the master’s replication backlog buffer, and the server run ID—to determine whether a slave can receive only missing data after a disconnection or requires a full sync.
This article explains Redis replication's two core mechanisms—synchronization and command propagation—detailing the SYNC workflow, how masters propagate writes to slaves, and how the PSYNC command enables efficient partial resynchronization after disconnections.
This tutorial explains Redis 3.2 GEO capabilities, showing how to add geographic data with GEOADD, retrieve positions, calculate distances, query nearby points with GEORADIUS/GEORADIUSBYMEMBER, and implement practical features like "find nearby users" and an efficient "shake" random selector.
This article explains how MySQL replication works by copying the master’s binlog to the slave and shows eight configuration parameters that let you filter databases and tables to reduce binlog volume, network load, and replication latency.
This article introduces MySQL Cluster’s share‑nothing architecture, explains the NDB storage engine’s advantages and drawbacks, describes the management, data, and API node roles, and provides a step‑by‑step configuration and deployment tutorial with command‑line examples.
The article reviews MySQL InnoDB 5.7’s major performance enhancements—such as transaction pooling, temporary‑table redesign, buffer and DDL optimizations—and introduces new capabilities like native partitioning, dynamic buffer sizing, GIS support, virtual columns, and advanced compression, all illustrated with benchmark graphics.
The article explains MySQL Cluster as a real‑time, ACID‑compliant, in‑memory distributed database, describes its node architecture, transparent sharding for linear scalability, various SQL/NoSQL access methods, and presents a benchmark achieving 200 million queries per second on 32 data nodes.
This guide explains how Redis 3’s native clustering works, details the hash‑slot mechanism, and provides step‑by‑step instructions for installing Redis and its Ruby dependencies, configuring multiple nodes, creating a six‑node cluster, and testing key distribution across the cluster.
This article explains the fundamentals of MySQL Cluster, its shared‑nothing architecture, NDB storage engine advantages and drawbacks, the roles of management, data, and API nodes, and provides a step‑by‑step guide with configuration files and commands to set up a high‑availability MySQL Cluster on multiple servers.
This article compares two SQL counter queries, presenting a detailed MySQL version with CASE statements and variable counters alongside a concise PostgreSQL version using ROW_NUMBER, and includes an explanation of the differences and a brief author biography.
The article explains how to calculate the total number of possible flight‑hotel combinations for travel packages by defining a custom multiplicative aggregate function in PostgreSQL, provides the SQL code, demonstrates its usage with examples, and discusses its practical advantages for flexible grouping.
This article explains how MySQL 5.7 introduced native JSON support with validity checks, performance improvements, and virtual column indexing, compares it to MariaDB's dynamic column and PostgreSQL, and provides step‑by‑step SQL examples for creating, inserting, querying, and indexing JSON data.
This guide outlines a comprehensive learning path for SQL, recommending essential books for beginners, advanced users, and operations, while highlighting key concepts such as EXISTS vs JOIN, row‑column transformations, and capacity planning, plus additional resources like podcasts and blogs.
This article explains a rare MySQL replication scenario where Seconds_Behind_Master stays at zero while the slave cannot receive updates, analyzes the underlying push‑based replication mechanism, and offers practical steps and configuration tweaks to detect and prevent the issue.
The article examines the impact of Oracle's acquisition of MySQL, introduces Percona XtraDB and Percona Server, outlines MariaDB's origins and compatibility, compares their storage engines, performance, and version histories, and provides resources for further comparison of these MySQL alternatives.
This article explains the security risks surrounding Redis, covering access control, authentication, command renaming, network exposure, and code‑execution vulnerabilities, and provides practical configuration steps to protect a Redis deployment from common attacks.
This guide outlines the fundamental topics and resources a novice web developer should master across web concepts, frontend basics, Python programming, Django framework, databases, tooling, development processes, soft skills, and a capstone project to build a functional Django application.
This guide presents a comprehensive collection of Redis configuration directives, covering daemonization, networking, persistence, replication, security, memory management, AOF, Lua scripting, slow log, event notifications, and advanced tuning options, enabling administrators to optimize performance, reliability, and safety of their Redis deployments.
Software maintenance and debugging sharpen analytical and coding skills, expose developers to diverse tools and legacy systems, improve performance optimization and database knowledge, foster client relationships and referrals, provide steady income, and allow quick, focused work that deepens business understanding while avoiding large‑scale outsourcing.
This article provides concise MySQL Q&A covering how to retrieve server version and database name, filter records with NOT operators, combine AND/OR conditions, use IFNULL, limit query results, choose between Oracle and MySQL, obtain the current date, export tables to XML, understand persistent connections, list table indexes, and explain CSV tables.
This guide walks through MongoDB index fundamentals, showing how to view query plans, create single and compound indexes, manage index types like unique, sparse, and multikey, force specific indexes or full scans, and handle in‑memory sorting and index management for optimal performance.
This guide shows how to manage MongoDB indexes, covering creation with ensureIndex, listing with getIndexes, checking total index size, reindexing, and removing specific or all indexes using dropIndex and dropIndexes, complete with code snippets and illustrative screenshots.
An extensive overview of fifteen popular NoSQL databases—including MongoDB, CouchDB, HBase, Cassandra, Redis, and more—detailing their architectures, key features, performance characteristics, and typical applications, helping readers choose the right solution for high‑scale, high‑concurrency data storage needs.
This comprehensive tutorial walks you through Redis Cluster fundamentals, including installation, hash slot sharding, node replication, fault tolerance, configuration files, cluster creation commands, and client testing, all without delving into complex distributed theory.
