May 28, 2020 · Databases

How UPSQL Proxy Implements MySQL Streaming to Boost Performance

This article explains the MySQL communication protocol, result‑set structure, client library interfaces, and the difference between store‑result and streaming modes, then details how UPSQL Proxy 2.4.0 adopts streaming to reduce latency and memory usage in distributed database environments.

Database MiddlewareResultSetStreaming

0 likes · 6 min read

How UPSQL Proxy Implements MySQL Streaming to Boost Performance

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