打破循环：我们如何将 250+ 个 MySQL 集群的备份目录迁移到 AWS

This post was originally published internally on May 9, 2025 and has been reworked for a public audience.

本文最初于 2025 年 5 月 9 日在内部发布，并已为公众受众重新编辑。

Authors: Ioannis Androulidakis, Mohammed Gaafar

作者： Ioannis Androulidakis， Mohammed Gaafar

Intro

简介

The Database Engineering team at Booking.com is constantly looking for ways to improve database reliability and support scaling our business. In 2025 we completed a major milestone in our effort to modernize our infrastructure: we seamlessly migrated the backend of the orchestrator that schedules and manages the daily backups of 250+ production MySQL clusters. More specifically, we moved from a self-managed MySQL database running on premises to a managed Amazon RDS MySQL database running in the cloud. This blog post delves into the challenges we faced, the solutions we implemented, and some key lessons we learned along the way.

Booking.com 的 Database Engineering 团队始终在寻找改进数据库可靠性和支持业务扩展的方法。2025 年，我们在现代化基础设施的努力中完成了一个重大里程碑：我们无缝迁移了调度和管理 250+ 个生产 MySQL 集群日常备份的 orchestrator 的后端。更具体地说，我们从运行在本地的自管 MySQL 数据库迁移到云端的托管 Amazon RDS MySQL 数据库。本博客文章深入探讨了我们面临的挑战、实施的解决方案以及一路上学到的关键经验教训。

We are moving to the cloud (gradually)

我们正在迁移到云端（逐步进行）

Cloud adoption is a journey, not a switch. Over the past few years the adoption of AWS solutions at Booking.com has been growing rapidly across different business units, allowing teams to be more autonomous, run their databases in the cloud and solve known issues with their old on-premise setup. Like customer teams, we are running our own databases to power the core services that we offer and manage databases efficiently at scale. To name a few: automatic failover of writable primaries, auto-scaling of read-only replicas, service discovery, capacity planning, online schema changes, user access management, volume backups, etc.

云采用是一个旅程，而不是一个开关。在过去几年中，Booking.com 对 AWS 解决方案的采用在不同业务单元中迅速增长，使团队更加自主、在云中运行他们的数据库，并解决旧 on-premise 设置的已知问题。像客户团队一样，我们运行自己的数据库来为我们提供和管理的核心服务提供动力，并高效大规模管理数据库。举几个例子：writable primaries 的自动故障转移、read-only replicas 的 auto-scaling、服务发现、容量规划、onli...