Tag: Database
28 articles
MySQL Database Sharding: Vertical vs Horizontal Partitioning
Database sharding explained: vertical partitioning, horizontal partitioning, vertical sharding, vertical table splitting, horizontal table splitting.
MySQL Read-Write Separation: Principles and Implementation
Read-write separation principles, implementation methods, master-slave lag solutions, database middleware.
MySQL Transaction and Lock Mechanism: ACID Properties
ACID properties: atomicity, consistency, isolation, durability, WAL mechanism.
MySQL Slow Query Analysis and Optimization Guide
Slow query log, mysqldumpslow, EXPLAIN analysis, common optimization solutions.
MySQL Index Optimization: Table Lookup, Covering Index, Leftmost Prefix and LIKE
Table lookup queries, covering index, leftmost prefix principle, LIKE queries, NULL value handling.
MySQL EXPLAIN: Index Analysis and Query Optimization
EXPLAIN command: selecttype, type, possiblekeys, key, rows, key_len, Extra.
MySQL Clustered vs Secondary Index: Structure, Principle and Performance Deep Dive
Clustered index (secondary index, primary key index), secondary index, table lookup query, covering index.
MySQL Index Principles: B+Tree, Hash, Binary Search
Index principles: B+Tree, Hash index, binary search, InnoDB adaptive hash index.
MySQL Index Types: BTree, Hash, FULLTEXT, RTree Explained
Index types: BTree, Hash, FULLTEXT, RTree, regular index, unique index, primary key index, composite index, clustered index.
MySQL Binlog: Recording Modes, Replication, Data Recovery
Binlog three recording modes: STATEMENT, ROW, MIXED, file format, write mechanism, master-slave replication.
MySQL InnoDB Storage Structure: Tablespace, Segment, Extent, Page and Row Format Deep Dive
InnoDB storage structure: Tablespace, Segment, Extent, Page, Row. Row formats: REDUNDANT, COMPACT, DYNAMIC, COMPRESSED
MySQL Architecture to Threads: Storage Engine and Thread Model Deep Dive
MySQL 5.7/8.0 storage engine optimization, InnoDB thread model: IO Thread, Purge Thread, Page Cleaner Thread, Master Thread
MySQL InnoDB Disk Structure: Tablespace, Log System and Data Dictionary Deep Dive
InnoDB disk structure: system tablespace, file-per-table tablespace, general tablespace, temporary tablespace, Doublewrite Buffer, Redo Log, Undo Log - complete storage a...
MySQL InnoDB Storage Structure: Buffer Pool, Write Buffer and Log Mechanism Deep Dive
InnoDB memory structure: Buffer Pool, Change Buffer, Adaptive Hash Index, Log Buffer
MySQL Storage Engines: InnoDB vs MyISAM Deep Comparison
MySQL storage engine comparison: InnoDB, MyISAM, Memory, Archive - transactions, locking mechanisms, index structures.
MySQL Connection, Thread, Query Cache and Optimizer Deep Dive
MySQL connection mechanism, half-duplex communication, query cache, query optimizer explained.
MySQL Internal Architecture: Service Layer, Storage Engine and File System Coverage
MySQL four-layer architecture: network connection layer, service layer, storage engine layer, system file layer.
MySQL Evolution: From Standalone to Cloud Database
MySQL development history, main branches, architecture evolution (standalone -> master-slave -> sharding -> cloud database).
MyBatis Quick Start - POM, Mapper, Core Files, CRUD Operations and Annotation Mapping
MyBatis quick start tutorial covering MyBatis development steps including POM dependency configuration, Mapper mapping files, SqlMapConfig core configuration file...
MyBatis Deep Dive - ORM Concepts, Mapping Relations and Quick Start
ORM stands for Object/Relation Mapping: an abbreviation for object-relation mapping.
MySQL Master-Slave Replication: Read-Write Separation and Semi-Sync Replication
This article provides an in-depth explanation of MySQL master-slave replication: master-slave mode, read-write separation, semi-sync replication principles and configurat...
MySQL Design Guide: Availability, Scalability, Consistency
This article provides an in-depth explanation of MySQL database design: availability (redundancy, failover), scalability (sharding, read-write separation), consistency.
MySQL Deadlock: Principles, Scenarios and Prevention
This article provides an in-depth explanation of MySQL deadlocks: deadlock definition, necessary conditions, table lock deadlocks, row-level deadlocks, shared to exclusiv...
MySQL Lock Mechanism: From Table Locks to Row Locks
Pessimistic locking is a concurrency control mechanism based on a conservative "lock first, then modify" strategy.
MySQL Parallel Replication: From 5.6 to 8.0 Evolution
This article provides an in-depth explanation of MySQL parallel replication technology: from 5.6 database-based parallel to 5.7 group commit-based to 8.
MySQL Dual-Master Architecture and MMM High Availability
MySQL dual-master mode is a common high-availability database architecture solution, particularly suitable for the following business scenarios:
MySQL MHA Master-Slave Failover: Architecture and Implementation
Deep dive into MySQL MHA high availability solution: MHA architecture, fault handling, primary-standby switch, lag issues and solutions. This article analyzes principles...
MySQL Transaction Isolation Levels: Read Uncommitted to Serializable
This article provides an in-depth explanation of MySQL transaction isolation levels: Read Uncommitted, Read Committed, Repeatable Read, and Serializable...