Tag: Shardingsphere
7 articles
MySQL ShardingSphere: SQL Parse, Route, Rewrite and Execution Flow
Deep dive into ShardingSphere's sharding flow including SQL parsing, query optimization, SQL routing, SQL rewriting, SQL execution and result merging six major stages wit...
MySQL Read-Write Separation: Master-Slave Architecture Design and Routing
Read-write separation is a common database architecture optimization technique that separates write operations to master and read operations to slaves through master-slav...
MySQL ShardingSphere: SQL Support, Limitations and Optimization Practices
Deep dive into ShardingSphere's SQL support scope, limitations, and optimization practices in sharding scenarios. Learn about supported SQL types, pagination subquery res...
MySQL ShardingSphere Saga: Flexible Transaction Implementation
ShardingSphere's flexible transactions are implemented through the third-party servicecomb-saga component, using SPI mechanism for dynamic injection.
MySQL XA Distributed Transactions: ShardingSphere Integration and Practice
Traditional approaches rely on database vendor XA drivers and application server transaction managers. Modern systems use embedded transaction managers.
ShardingSphere Data Masking: Transparent Encryption and Compliance
Data masking is a key data security technology that balances data utility and privacy protection by replacing, encrypting or perturbing sensitive information.
ShardingSphere Saga Flexible Transaction Implementation
ShardingSphere's flexible transactions are implemented through the third-party servicecomb-saga component, using SPI mechanism for dynamic injection.