Tag: ShardingSphere
7 articles
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 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 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...
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...