2024-08-03, 10:00–10:30 (Asia/Taipei), TR410
At LY Corporation, we operate a large number of MySQL instances, with over 12,000 instances only for LINE-related services.
As new services are released one after another, the number of instances and the amount of data continues to increase.
In this session, I will show how we streamline the daily operations that occur with large numbers of MySQL instances, such as MySQL upgrades and safe DDL execution.
This session introduces the MySQL platform in LINE, MUH for self-managed MySQL migration and SafeDDL for safe DDL execution, which are tools used in MySQL platform.
-
MUH (MySQL Upgrade Helper)
Lets users handle migration tasks like data export/import and switchover through simple WebUI operations, minimizing downtime. -
SafeDDL
This uses WebUI for easy operation, leveraging tools like pt-online-schema-change and gh-ost for minimal workload impact DDL execution based on DDL content.
I am Database Administrator at LY Corporation from Japan, managing MySQL instances and developing operation tools.