{"id":30457,"date":"2025-12-01T04:46:29","date_gmt":"2025-12-01T12:46:29","guid":{"rendered":"https:\/\/www.pingcap.com\/?post_type=event&#038;p=30457"},"modified":"2025-12-19T05:30:29","modified_gmt":"2025-12-19T13:30:29","slug":"tidb-use-case-lab-scale-out-mysql-with-less-ops-toil","status":"publish","type":"event","link":"https:\/\/www.pingcap.com\/ko\/event\/tidb-use-case-lab-scale-out-mysql-with-less-ops-toil\/","title":{"rendered":"TiDB Use Case Lab: Scale Out MySQL With Less Ops Toil"},"content":{"rendered":"<p><strong>Date: <\/strong>December 18, 2025 <br><strong>Time: <\/strong>10:00 &#8211; 10:40 AM PST<\/p>\n\n\n\n<p style=\"font-size:22px\">MySQL applications hit scaling ceilings: hot shards, schema-change windows, and operational sprawl from too many replicas. In this hands-on lab, we\u2019ll show you how to modernize MySQL workloads onto TiDB to unlock horizontal scale, online schema evolution, and operational simplicity without major code rewrites.<\/p>\n\n\n\n<p style=\"font-size:22px\">You\u2019ll see how TiDB\u2019s MySQL-compatible, distributed SQL architecture separates compute and storage, scales linearly, and keeps applications online during migrations and upgrades. We\u2019ll walk through how to migrate from MySQL to TiDB using TiDB Data Migration tooling, including setting up the migration task and verifying the migration result.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li style=\"font-size:22px\">How to lift-and-shift MySQL schemas and data with minimal code changes using TiDB\u2019s MySQL compatibility and migration tooling.<\/li>\n\n\n\n<li style=\"font-size:22px\">Executing online DDL on hot tables without downtime and reducing lock contention under peak load.<\/li>\n\n\n\n<li style=\"font-size:22px\">Horizontally scaling reads and writes by distributing data automatically, with elastic capacity and no application-side sharding.<\/li>\n\n\n\n<li style=\"font-size:22px\">Strategies for zero- or near-zero-downtime cutover, verification, and safe rollback.<\/li>\n\n\n\n<li style=\"font-size:22px\">Consolidating OLTP + operational analytics via TiDB\u2019s columnar engine and secondary indexes to simplify your stack.<br><\/li>\n<\/ul>\n\n\n\n<p style=\"font-size:22px\"><strong>What you&#8217;ll learn:<\/strong><\/p>\n\n\n\n<p style=\"font-size:22px\"><strong>Speakers<\/strong><\/p>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-vertically-aligned-center is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:33.33%\">\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"1080\" src=\"https:\/\/static.pingcap.com\/files\/2025\/11\/13031508\/Untitled-design-32.png\" alt=\"\" class=\"wp-image-30460\" style=\"width:248px;height:auto\" srcset=\"https:\/\/static.pingcap.com\/files\/2025\/11\/13031508\/Untitled-design-32.png 1080w, https:\/\/static.pingcap.com\/files\/2025\/11\/13031508\/Untitled-design-32-300x300.png 300w, https:\/\/static.pingcap.com\/files\/2025\/11\/13031508\/Untitled-design-32-1024x1024.png 1024w, https:\/\/static.pingcap.com\/files\/2025\/11\/13031508\/Untitled-design-32-150x150.png 150w, https:\/\/static.pingcap.com\/files\/2025\/11\/13031508\/Untitled-design-32-768x768.png 768w\" sizes=\"auto, (max-width: 1080px) 100vw, 1080px\" \/><\/figure>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:66.66%\">\n<p class=\"has-medium-font-size\"><strong><strong>Ben Sherrill<\/strong>, Senior Sales Engineer, TiDB<\/strong><\/p>\n\n\n\n<p class=\"has-medium-font-size\"><strong>Ben Sherrill<\/strong> is a Senior Sales Engineer at TiDB, where he focuses on competitive differentiation, query optimization, performance testing, and integrations across the broader ecosystem. Backed by a strong foundation in cloud infrastructure and networking, Ben brings deep technical expertise in distributed SQL and NewSQL, system design, and cloud architecture. He frequently works across Kubernetes environments, data streaming platforms, infrastructure as code (IaC), and observability stacks to help customers unlock the full potential of TiDB.<br><\/p>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:33.33%\"><\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:66.66%\"><\/div>\n<\/div>\n\n\n\n<p><br><\/p>","protected":false},"excerpt":{"rendered":"<p>Date: December 18, 2025 Time: 10:00 &#8211; 10:40 AM PST MySQL applications hit scaling ceilings: hot shards, schema-change windows, and operational sprawl from too many replicas. In this hands-on lab, we\u2019ll show you how to modernize MySQL workloads onto TiDB to unlock horizontal scale, online schema evolution, and operational simplicity without major code rewrites. You\u2019ll [&hellip;]<\/p>\n","protected":false},"featured_media":30458,"template":"","categories":[13,145],"tags":[138,391,147,16,250,301,162,9,111,31],"region":[216],"location":[207],"class_list":["post-30457","event","type-event","status-publish","has-post-thumbnail","hentry","category-product","category-thought-leadership","tag-ai","tag-artificial-intelligence","tag-distributed-sql","tag-distributed-system","tag-distributed-transactions","tag-nosql","tag-saas","tag-scalability","tag-tidb","tag-tidb-cloud","region-north-america","location-virtual"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Modernize MySQL: Online DDL, Elastic Scale, and Zero Downtime<\/title>\n<meta name=\"description\" content=\"Modernize MySQL on TiDB hands-on demo: migration, online DDL, horizontal scale, and zero downtime. Ship faster with less ops toil.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.pingcap.com\/ko\/event\/tidb-use-case-lab-scale-out-mysql-with-less-ops-toil\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Modernize MySQL: Online DDL, Elastic Scale, and Zero Downtime\" \/>\n<meta property=\"og:description\" content=\"Modernize MySQL on TiDB hands-on demo: migration, online DDL, horizontal scale, and zero downtime. Ship faster with less ops toil.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pingcap.com\/ko\/event\/tidb-use-case-lab-scale-out-mysql-with-less-ops-toil\/\" \/>\n<meta property=\"og:site_name\" content=\"TiDB\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/facebook.com\/pingcap2015\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-19T13:30:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/static.pingcap.com\/files\/2025\/11\/13031236\/tidb_twitter_1600x900-7.png\" \/>\n\t<meta property=\"og:image:width\" content=\"3200\" \/>\n\t<meta property=\"og:image:height\" content=\"1800\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@PingCAP\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.pingcap.com\/event\/tidb-use-case-lab-scale-out-mysql-with-less-ops-toil\/\",\"url\":\"https:\/\/www.pingcap.com\/event\/tidb-use-case-lab-scale-out-mysql-with-less-ops-toil\/\",\"name\":\"Modernize MySQL: Online DDL, Elastic Scale, and Zero Downtime\",\"isPartOf\":{\"@id\":\"https:\/\/www.pingcap.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.pingcap.com\/event\/tidb-use-case-lab-scale-out-mysql-with-less-ops-toil\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.pingcap.com\/event\/tidb-use-case-lab-scale-out-mysql-with-less-ops-toil\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/static.pingcap.com\/files\/2025\/11\/13030715\/tidb_feature_1800x600-6.png\",\"datePublished\":\"2025-12-01T12:46:29+00:00\",\"dateModified\":\"2025-12-19T13:30:29+00:00\",\"description\":\"Modernize MySQL on TiDB hands-on demo: migration, online DDL, horizontal scale, and zero downtime. Ship faster with less ops toil.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.pingcap.com\/event\/tidb-use-case-lab-scale-out-mysql-with-less-ops-toil\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.pingcap.com\/event\/tidb-use-case-lab-scale-out-mysql-with-less-ops-toil\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.pingcap.com\/event\/tidb-use-case-lab-scale-out-mysql-with-less-ops-toil\/#primaryimage\",\"url\":\"https:\/\/static.pingcap.com\/files\/2025\/11\/13030715\/tidb_feature_1800x600-6.png\",\"contentUrl\":\"https:\/\/static.pingcap.com\/files\/2025\/11\/13030715\/tidb_feature_1800x600-6.png\",\"width\":3600,\"height\":1200},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.pingcap.com\/event\/tidb-use-case-lab-scale-out-mysql-with-less-ops-toil\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.pingcap.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Events\",\"item\":\"https:\/\/www.pingcap.com\/event\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"TiDB Use Case Lab: Scale Out MySQL With Less Ops Toil\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.pingcap.com\/#website\",\"url\":\"https:\/\/www.pingcap.com\/\",\"name\":\"TiDB\",\"description\":\"TiDB | SQL at Scale\",\"publisher\":{\"@id\":\"https:\/\/www.pingcap.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.pingcap.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.pingcap.com\/#organization\",\"name\":\"PingCAP\",\"url\":\"https:\/\/www.pingcap.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png\",\"contentUrl\":\"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png\",\"width\":811,\"height\":232,\"caption\":\"PingCAP\"},\"image\":{\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/facebook.com\/pingcap2015\",\"https:\/\/x.com\/PingCAP\",\"https:\/\/linkedin.com\/company\/pingcap\",\"https:\/\/youtube.com\/channel\/UCuq4puT32DzHKT5rU1IZpIA\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Modernize MySQL: Online DDL, Elastic Scale, and Zero Downtime","description":"Modernize MySQL on TiDB hands-on demo: migration, online DDL, horizontal scale, and zero downtime. Ship faster with less ops toil.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.pingcap.com\/ko\/event\/tidb-use-case-lab-scale-out-mysql-with-less-ops-toil\/","og_locale":"ko_KR","og_type":"article","og_title":"Modernize MySQL: Online DDL, Elastic Scale, and Zero Downtime","og_description":"Modernize MySQL on TiDB hands-on demo: migration, online DDL, horizontal scale, and zero downtime. Ship faster with less ops toil.","og_url":"https:\/\/www.pingcap.com\/ko\/event\/tidb-use-case-lab-scale-out-mysql-with-less-ops-toil\/","og_site_name":"TiDB","article_publisher":"https:\/\/facebook.com\/pingcap2015","article_modified_time":"2025-12-19T13:30:29+00:00","og_image":[{"width":3200,"height":1800,"url":"https:\/\/static.pingcap.com\/files\/2025\/11\/13031236\/tidb_twitter_1600x900-7.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_site":"@PingCAP","twitter_misc":{"Est. reading time":"1\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.pingcap.com\/event\/tidb-use-case-lab-scale-out-mysql-with-less-ops-toil\/","url":"https:\/\/www.pingcap.com\/event\/tidb-use-case-lab-scale-out-mysql-with-less-ops-toil\/","name":"Modernize MySQL: Online DDL, Elastic Scale, and Zero Downtime","isPartOf":{"@id":"https:\/\/www.pingcap.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.pingcap.com\/event\/tidb-use-case-lab-scale-out-mysql-with-less-ops-toil\/#primaryimage"},"image":{"@id":"https:\/\/www.pingcap.com\/event\/tidb-use-case-lab-scale-out-mysql-with-less-ops-toil\/#primaryimage"},"thumbnailUrl":"https:\/\/static.pingcap.com\/files\/2025\/11\/13030715\/tidb_feature_1800x600-6.png","datePublished":"2025-12-01T12:46:29+00:00","dateModified":"2025-12-19T13:30:29+00:00","description":"Modernize MySQL on TiDB hands-on demo: migration, online DDL, horizontal scale, and zero downtime. Ship faster with less ops toil.","breadcrumb":{"@id":"https:\/\/www.pingcap.com\/event\/tidb-use-case-lab-scale-out-mysql-with-less-ops-toil\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pingcap.com\/event\/tidb-use-case-lab-scale-out-mysql-with-less-ops-toil\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.pingcap.com\/event\/tidb-use-case-lab-scale-out-mysql-with-less-ops-toil\/#primaryimage","url":"https:\/\/static.pingcap.com\/files\/2025\/11\/13030715\/tidb_feature_1800x600-6.png","contentUrl":"https:\/\/static.pingcap.com\/files\/2025\/11\/13030715\/tidb_feature_1800x600-6.png","width":3600,"height":1200},{"@type":"BreadcrumbList","@id":"https:\/\/www.pingcap.com\/event\/tidb-use-case-lab-scale-out-mysql-with-less-ops-toil\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pingcap.com\/"},{"@type":"ListItem","position":2,"name":"Events","item":"https:\/\/www.pingcap.com\/event\/"},{"@type":"ListItem","position":3,"name":"TiDB Use Case Lab: Scale Out MySQL With Less Ops Toil"}]},{"@type":"WebSite","@id":"https:\/\/www.pingcap.com\/#website","url":"https:\/\/www.pingcap.com\/","name":"\ud2f0DB","description":"TiDB | SQL at Scale","publisher":{"@id":"https:\/\/www.pingcap.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.pingcap.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Organization","@id":"https:\/\/www.pingcap.com\/#organization","name":"PingCAP","url":"https:\/\/www.pingcap.com\/","logo":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/","url":"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png","contentUrl":"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png","width":811,"height":232,"caption":"PingCAP"},"image":{"@id":"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/facebook.com\/pingcap2015","https:\/\/x.com\/PingCAP","https:\/\/linkedin.com\/company\/pingcap","https:\/\/youtube.com\/channel\/UCuq4puT32DzHKT5rU1IZpIA"]}]}},"card_markup":"<a class=\"card-resource bg-white\" href=\"https:\/\/www.pingcap.com\/ko\/event\/tidb-use-case-lab-scale-out-mysql-with-less-ops-toil\/\"><div class=\"card-event__image-container\"><img class=\"card-event__image\" alt=\"tidb_feature_1800x600 (6)\" src=\"https:\/\/static.pingcap.com\/files\/2025\/11\/13030715\/tidb_feature_1800x600-6.png\" loading=\"lazy\" width=3600 height=1200 \/><\/div><div class=\"card-event__content-container\"><div class=\"card-resource__content-status\"><div class=\"card-resource__status completed\">Completed<\/div><div class=\"card-resource__webinar\"><i><\/i>On-Demand<\/div><\/div><h5 class=\"card-resource__title\">TiDB Use Case Lab: Scale Out MySQL With Less Ops Toil<\/h5><p class=\"card-resource__date\"><i class=\"icon-calendar-check\"><\/i>Jan 1 12:00 am - 12:00 am PST<\/p><p class=\"card-resource__location\"><i class=\"icon-map-pin\"><\/i>Virtual<\/p><\/div><\/a>","_links":{"self":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/event\/30457","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/event"}],"about":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/types\/event"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/media\/30458"}],"wp:attachment":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/media?parent=30457"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/categories?post=30457"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/tags?post=30457"},{"taxonomy":"region","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/region?post=30457"},{"taxonomy":"location","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/location?post=30457"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}