The MySQL Team manages over 6,000 MySQL instances across multiple services.
DBAs spend a lot of time on migrating MySQL instances for updates and sharding.
We have a number of migration plans for MySQL 5.6 EOL, CentOS 6 EOS, IDCRoom renovation, and EOS of older platforms. We also plan to migrate 1,800 instances by March 2023.
This is why we developed the web system MySQL Upgrade Helper (MUH) so that our developers can perform MySQL migration themselves to reduce work costs for DBAs.
MUH provides the following features for safe MySQL migration
- Inspecting configurations before migration
- Changing MySQL parameters
- Syncing data
- Comparing data
- Switching to new instances
In this session, we will share our knowledge of these implementations. I hope this will help you with your MySQL migration.