MySQL 在 Uber
At Uber, our MySQL® fleet is the backbone of our data infrastructure, supporting a vast array of operations critical to our platform. Uber operates an extensive MySQL fleet, consisting of over 2,300 independent clusters. Building a control plane to manage this fleet at such a massive scale, while ensuring zero downtime and no data loss, is among the most challenging problems in the industry.
在 Uber，我们的 MySQL® 车队是我们数据基础设施的支柱，支持我们平台上大量关键操作。Uber 运营着一个庞大的 MySQL 车队，由超过 2,300 个独立集群组成。在如此大规模管理这一车队的控制平面，同时确保零停机和无数据丢失，是行业中最具挑战性的问题之一。
In the last couple of years, we embarked on improving MySQL fleet availability from 99.9% to 99.99% through various optimizations and a re-architecture of the control plane. This is the first post in a multi-part blog series exploring MySQL deployment and operations at Uber. In this blog, we’ll talk about Uber’s MySQL fleet architecture, control plane operations, and some of the improvements brought in the last couple of years at the MySQL control plane layer.
在过去的几年里，我们着手通过各种优化和控制平面的重新架构，将MySQL的可用性从99.9%提高到99.99%。这是一个多部分博客系列的第一篇，探讨Uber的MySQL部署和操作。在这篇博客中，我们将讨论Uber的MySQL集群架构、控制平面操作，以及在过去几年中MySQL控制平面层带来的一些改进。
The MySQL fleet at Uber consists of multiple clusters, each with numerous nodes. There are two major flows: the data flow, where clients/services interact with the MySQL cluster, and the control flow, which manages the life cycle of clusters.
Uber 的 MySQL 集群由多个集群组成，每个集群有多个节点。主要有两个流程：数据流，客户端/服务与 MySQL 集群交互，以及控制流，管理集群的生命周期。
For the data flow, stateless services hosted in Kubernetes® connect to its MySQL cluster via a standard client. Each server has a reverse proxy, which stores routing mapping for MySQL nodes based on roles (primary/replica/batch). This enables the client to discover and connect to the appropriate cluster using the JDBC™ protocol based on the query to execute.
对于数据流，托管在 Kubernetes® 中的无状态服务通过标准客户端连接到其 MySQL 集群。每个服务器都有一个反向代理，根据角色（主/副/批处理）存储 MySQL 节点的路由映射。这使得客户端能够根据要执行的查询使用 JDBC™ 协议发现并连接到适当的集群。
The control flow manages the provisioning, maintenance, and decommissioning of c...