LINEヤフーの新しいプライベートクラウドであるFlavaで、MySQLをDBaaSとして提供する製品、DBS for MySQLを紹介します。
DBS for MySQLが提供する機能、MySQLクラスターの構造、および高可用性(HA)がどのように提供されるかについて説明します。
また、Kubernetesを基盤としたオペレーターパターンで開発されたDBS for MySQLのアーキテクチャについても説明します。
on Flava ⎯ Similar Products ⎯ Create MySQL Clusters easily in just a few clicks. DBS for MySQL ⎯ RDS for MySQL(AWS) ⎯ Cloud SQL for MySQL(Google) ⎯ Azure Database for MySQL(Microsoft)
Infra Team DB Team Create Server Request Many Tasks… Servers Servers MySQL Cluster Configuration Request Many Tasks … MySQL Clusters MySQL Clusters Developer Flava Click MySQL Clusters
controller Standby Primary Watch Watch MySQL Server MySQL Server Health Check Health Check C-Plane D-Plane 2. Update 3. Reconcile Logic (Failover) 4. Update 5. Update the DNS endpoint HA controller 5. Reconcile Logic (Becomes the new primary) Replication 5. Reconcile Logic (Recover the server) 1. Failure Occurred
Flava ⎯ Kubernetes + Operator SDK(golang) ⎯ FKE(Control-Plane) + Flava IaaS(Data-Plane) ⎯ In-house developed HA System ⎯ Create MySQL Clusters easily in just a few clicks.
- Career • 2015 ~ 2017 • Seoul National University • Master degree of Computer Science and Engineering • Distributed Computing System LAB • 2017 ~ 2022 • TmaxSoft • Cloud-Based systems, Linux Server, System Management Agent • 2022.06 ~ now • LinePlus • CloudDBS – MySQL • Verda MySQL / Flava DBS for MySQL
Future versions planned • Server Type • Multiple options • Any server type will be supported • Multi-AZ • 3 availability zones • Multi-region support coming soon • API For Management • CRUD Service / Cluster ... • Full Run API support Support Support Capabilities
Group (Optional) • Auto / Manual Failover • Maintenance Healing mechanisms • Incident and planned maintenance • Replace node before maintenance start High Availability Built-in High Availability and Maintenance
• Safety: Replicas -> Standby -> Primary • Failover: Auto / Manual • MySQL Version upgrade • Simple: One click, all nodes upgrades • Safety: Replicas -> Standby -> Primary • Failover: Auto / Manual • Server spec upgrade • CPU/Memory/Disk change Rolling update Rolling maintenance and upgrades
backup • Keep last backup forever • When service is deleted • Backup file • Store on Flava Object Store Backup and Recovery Reliable Backup and Recovery