Blog
Technical exploration and thoughts · 655 articles
MySQL Scaling Guide: Triggers, Migration, and Performance...
Explore MySQL database horizontal scaling solutions for capacity, performance, and concurrency bottlenecks. Covers scaling triggers, migration plans, and best practices with detailed technical anal...
MySQL Sharding-JDBC: Lightweight Sharding & Read-Write Se...
A comprehensive guide to Sharding-JDBC, a lightweight Java database middleware solving database sharding, read-write separation and distributed transactions. Learn core principles and practical app...
MySQL Sharding-JDBC: Physical Tables, Logical Tables & Bi...
In distributed databases, sharding is implemented through physical tables, logical tables, data nodes and binding tables. Binding tables ensure master and child tables use the same sharding rules, ...
MySQL ShardingSphere: SQL Parse, Route, Rewrite & Execute...
Deep dive into ShardingSphere's sharding flow including SQL parsing, query optimization, SQL routing, SQL rewriting, SQL execution and result merging six major stages with detailed technical analysis.
MySQL Read-Write Separation: Master-Slave Architecture De...
Read-write separation is a common database architecture optimization technique that separates write operations to master and read operations to slaves through master-slave replication. Learn the fu...
MySQL ShardingSphere: SQL Support, Limitations & Optimiza...
Deep dive into ShardingSphere's SQL support scope, limitations, and optimization practices in sharding scenarios. Learn about supported SQL types, pagination subquery restrictions, and best practices.
MySQL Sharding-JDBC: Physical, Logical & Binding Tables E...
In distributed databases, sharding uses physical tables, logical tables, data nodes and binding tables for efficient data storage and queries. Binding tables ensure master and child tables use same...
MySQL ShardingSphere Saga: Flexible Transaction Implement...
ShardingSphere implements flexible transactions through servicecomb-saga integration, using SPI dynamic injection and reverse SQL technology to automatically generate compensation operations for di...
MySQL Distributed Transactions: TCC, Message Queue & Saga...
Distributed transaction patterns mainly include TCC, message queue, and Saga. TCC divides traditional 2PC into three business-controllable steps, message queue achieves eventual consistency, Saga s...
Seata Framework: Four Transaction Modes & Core Architecture
Seata is Alibaba's open-source distributed transaction solution providing one-stop transaction management with high performance, low intrusion and multi-language support.
MySQL XA Distributed Transactions: ShardingSphere Integra...
Traditional approaches rely on database vendor XA drivers and application server transaction managers. Modern systems use embedded transaction managers. ShardingSphere provides cross-database XA tr...
CAP Theory & Distributed Transactions: From 2PC/3PC to XA
CAP theory reveals that distributed systems cannot simultaneously satisfy consistency, availability and partition tolerance. 2PC ensures strong consistency through coordinator-controlled two-phase ...
ShardingSphere Data Masking: Transparent Encryption & Com...
Data masking is a key data security technology that balances data utility and privacy protection by replacing, encrypting or perturbing sensitive information. ShardingSphere provides complete maski...
ShardingSphere Saga Flexible Transaction Implementation
ShardingSphere implements flexible transactions through integration with third-party servicecomb-saga component, using SPI dynamic injection and reverse SQL technology to automatically generate com...
MySQL MyCat Distributed Database Middleware: Architecture...
MyCat is an open-source distributed database middleware fully compatible with MySQL protocol. Core features include database sharding, read-write separation, and result set merging with multiple sh...
Sharding-Proxy: Zero-Code-Invasive Database Sharding Solu...
Sharding-Proxy in the ShardingSphere ecosystem uses transparent database proxy architecture to implement database sharding, read-write separation, distributed transactions and data encryption witho...
MyCat Sharding Strategies: E-R, Global Tables & Sharding ...
MyCat distributed database sharding strategies include E-R table sharding, global table mechanism, shard nodes, node hosts and sharding rules.
MyCat server.xml: Core Configuration File Guide
server.xml is MyCat's core configuration file that centrally stores key parameters needed for system operation, including system parameters, user permissions, firewall configuration and performance...
MyCat Installation & Configuration: Setup, Service Manage...
MyCAT is an open-source database middleware supporting MySQL protocol, commonly used for database sharding and data sharding management. Installation includes unpacking, configuring environment var...
MySQL Transaction Isolation Levels: From READ UNCOMMITTED...
MySQL transaction isolation levels include READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ and SERIALIZABLE. Each level solves different concurrency problems.