Design and Implementation of MySQL High Availability Using Orchestrator and DBProxy

This article presents a comprehensive design and implementation for achieving MySQL high availability by replacing the single‑master architecture with Orchestrator‑driven automatic failover, integrating DBProxy for transparent routing, and addressing topology changes and data compensation to ensure continuous, reliable service.

DBProxyData CompensationDatabase Replication

0 likes · 16 min read

Design and Implementation of MySQL High Availability Using Orchestrator and DBProxy

Architecture & Thinking

Dec 20, 2023 · Databases

Choosing the Right MySQL Middleware: Features, Use Cases, and Business Requirements

This article examines the storage challenges faced by large‑scale internet services and evaluates popular MySQL middleware solutions—ProxySQL, MaxScale, DBProxy, MyCat, and TDDL—by mapping business requirements to their core features and capabilities.

DBProxyMaxScaleMycat

0 likes · 14 min read

Choosing the Right MySQL Middleware: Features, Use Cases, and Business Requirements

Meituan Technology Team

Jan 5, 2017 · Databases

Inside DBProxy: Open‑Source High‑Availability Database Middleware and Its Key Enhancements

DBProxy, an open‑source MySQL middleware derived from Atlas, offers horizontal scaling, read/write separation, load balancing, advanced blacklist filtering, dynamic configuration, and numerous bug fixes, positioning it as a mature, high‑availability solution for enterprise database environments.

DBProxyDatabase Middlewarehigh availability

0 likes · 12 min read

Inside DBProxy: Open‑Source High‑Availability Database Middleware and Its Key Enhancements