Dec 6, 2019 · Databases

DBLE Query Process: Simple and Complex Queries Overview

This article explains DBLE's query workflow, covering basic DML handling, simple query routing and result merging, as well as complex query processing with JOIN, UNION, sub‑queries, and sharding strategies, illustrated with diagrams and code examples.

Complex QueryDBLEQuery Processing

0 likes · 6 min read

DBLE Query Process: Simple and Complex Queries Overview

ITPUB

Aug 21, 2018 · Databases

Inside UnionPay’s Distributed MySQL Middleware: Architecture, Transactions & SQL Optimizations

This article summarizes UnionPay’s evolution of a distributed MySQL middleware platform, detailing its multi‑stage architecture, 2‑phase commit transaction handling, deadlock detection, SQL parsing optimizations, complex query strategies, and deployment considerations for high‑availability and performance.

Complex QueryDeadlock DetectionSQL Optimization

0 likes · 13 min read

Inside UnionPay’s Distributed MySQL Middleware: Architecture, Transactions & SQL Optimizations