Samsung Groupware(Knox Portal), Microservices-based Migration to MariaDB & Zero Downtime Upgrade

on YouTube ↗23m

" summary

Samsung Knox Portal moves from Oracle to MariaDB Enterprise across microservices with zero-downtime migration and a homegrown CDC called async CDC that uses Maxwell to read binlogs, stages table CSVs to object storage, fixes timestamps/NULLs, and builds indexes post-import. Real deployments cover ~80 companies and 500,000 users, grow from ~25 Oracle DBs to hundreds of MariaDB servers, sustain 1500 QPS extraction in tests, support bi‑directional sync with tx‑name loop prevention, and allow instant rollback by switching DB access IPs.

AI-written summary · about

" chapters (6)

1. 0:00Intro
2. 0:24Agenda
3. 1:08Samsung Knox Portal
4. 4:20Requirements
5. 5:13Zero-downtime use case
6. 15:47Summary

" related talks

• 22mMigration from Oracle to MariaDB with no application changePickup Li · FOSDEM 2021
• 22mMigrating from Monolithic to Cloud Native Distributed SQL Database with Zero DowntimeSUHENDRA AHMAD · Distributed SQL Summit Asia 2022
• 28mMove to Managed DatabasesJohn Winford · AWS Summit Online EMEA 2020
• 30mAccelerate Modernization with Confluent and YugabyteDBAnanda Bose, Amey Banarse · Distributed SQL Summit 2022
• 42mBBM’s 150M+ users Oracle to Postgres migration without downtimeÁlvaro Hernández · HighLoad++ Moscow 2018
• 15mModern data platforms: AWS and MariaDB SkySQLEllen McKenney, Kevin Farley · AWS re:Invent 2022
• 16mMigrating from other databases to MariaDBMichael Widenius · FOSDEM 2021
• 37mDatabase Modernization at Cloud Scale: Minimizing Risk and DisruptionRama Chandra Murthy · Distributed SQL Summit Asia 2022