This article introduces database middleware, explains why it’s needed for scaling and performance, and provides a detailed overview of six popular middleware solutions—including ShardingSphere, MyCat, MySQL‑Proxy, DRDS, Atlas, and Zebra—highlighting their core features and use cases.
This article explains what database middleware is, why it’s needed for scaling large data workloads, and provides detailed overviews of six popular middleware solutions—including MyCat, MySQL‑Proxy, DRDS, Atlas, Zebra, and ShardingSphere—highlighting their key features and use cases.
This article explains the concepts of OLTP, OLAP and HTAP, describes the DRDS HTAP architecture—including its engine and storage layers, Fireworks Spark‑based engine, optimizer stages, and streaming capabilities—and demonstrates cross‑database MPP queries and streaming joins while outlining suitable use cases and limitations.
This article traces the evolution of Alibaba’s distributed data layer—from the early Cobar system to the modern TDDL framework and DRDS service—explaining their architectures, limitations, sharding principles, transaction‑boundary strategies, heterogeneous index tables, and the Jingwei data‑replication platform that together enable seamless scaling and high‑performance SQL processing across thousands of databases.
This article recounts Alibaba’s journey from Oracle‑based IOE architecture to a home‑grown MySQL/DRDS solution, detailing the motivations, challenges, technical choices, performance pitfalls, and operational practices that shaped the migration and the lessons learned for large‑scale database engineering.
This article chronicles the historical shift from early hierarchical data models to relational SQL, the rise of NoSQL, and the emergence of NewSQL solutions like Alibaba's DRDS, illustrating key concepts with diagrams, code examples, and a detailed Q&A.
This interview with Alibaba’s DRDS expert Shen Xun reveals how the distributed relational database service evolved from an internal tool to a cloud‑native solution, detailing its architecture, scalability advantages, middleware ecosystem, and real‑world performance during massive events like Double‑11.
