{"id":14257,"date":"2023-10-18T19:32:08","date_gmt":"2023-10-19T02:32:08","guid":{"rendered":"https:\/\/www.pingcap.com\/?post_type=case-study&#038;p=14257"},"modified":"2024-08-28T02:27:46","modified_gmt":"2024-08-28T09:27:46","slug":"line-corporation-exploration-mysql-tidb","status":"publish","type":"case-study","link":"https:\/\/www.pingcap.com\/ko\/case-study\/line-corporation-exploration-mysql-tidb\/","title":{"rendered":"From MySQL to TiDB: Inside LINE Corporation&#8217;s Exploration with Distributed SQL"},"content":{"rendered":"<p>LINE Corporation is a leading global technology company known for its LINE communication application and a host of other services, such as LINE manga, LINE GAME, and LINE GIFT. With its expansive MySQL infrastructure of roughly 7,000 instances, the company faces the ongoing challenge of scaling and managing these databases. To solve these challenges, LINE migrated some of its projects from MySQL to <a href=\"https:\/\/www.pingcap.com\/ko\/tidb\/\">\ud2f0DB<\/a>, a distributed SQL database.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"The_Problem_Challenges_with_Sharding\"><\/span>The Problem: Challenges with Sharding<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>As LINE&#8217;s services expanded, their existing MySQL databases became harder to manage, and scaling became a significant challenge.&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Overall operational overload<\/strong>: The MySQL1 team, the team behind LINE\u2019s data infrastructure, manages and operates around 7,000 MySQL instances.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Scaling and managing shards<\/strong>: The LINE team embedded sharding logic in applications to achieve high availability and scalability. This involved logically dividing a table and distributing it across multiple database servers. Sharding added complexity to the client-side programming and operation management.&nbsp;<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Operational automation<\/strong>: With the growing number of instances, the team needed to automate daily operations while still offering time for service development consulting.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"The_Solution_TiDB_a_Distributed_SQL_Database\"><\/span>The Solution: TiDB, a Distributed SQL Database<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>While seeking solutions to their sharding problem, the team discovered TiDB, an advanced open-source, distributed SQL database designed to solve sharding issues. TiDB is MySQL compatible, and effectively combines the advantages of existing relational databases with the scalability of distributed databases. After a thorough evaluation, Mr. Kitagawa, senior DBA at LINE, and his team decided that TiDB resonated well with the team\u2019s requirements.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Benefits of TiDB<\/h3>\n\n\n\n<p>TiDB emerged as the natural choice for LINE Corporation with the following technical benefits:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Automated sharding with horizontal scaling capabilities<\/strong>:&nbsp; TiDB&#8217;s horizontal scalability allows the MySQL1 Team to manage a large number of instances effortlessly. It was natural that the MySQL1 team, who was looking for a solution to the sharding challenge, turned to TiDB.<\/li>\n\n\n\n<li><strong>Enhanced performance<\/strong>: TiDB&#8217;s architecture was designed for high throughput. When the MySQL1 team tested TiDB, they were surprised by the write performance that MySQL would never produce.<\/li>\n\n\n\n<li><strong>High availability in multi-region configurations<\/strong>: With MySQL, the team had to worry about the mechanism to achieve high availability in a multi-region or multi-availability zone (AZ) configuration. TiDB handles this automatically, greatly reducing operational complexity.<\/li>\n<\/ul>\n\n\n<div id=\"ub-testimonial-11e8aefe-cee5-4278-a5a6-b1f0f8c7fac9\">\n    <div class=\"wp-block-ub-testimonial ub_testimonial\" id=\"ub_testimonial_11e8aefe-cee5-4278-a5a6-b1f0f8c7fac9\">\n        <div class=\"ub_testimonial_img\">\n            <img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/static.pingcap.com\/files\/2023\/10\/18070050\/line-testimonial.png\" alt=\"\" height=\"100\" width=\"100\" \/>\n        <\/div>\n        <div class=\"ub_testimonial_content\">\n            <p class=\"ub_testimonial_text\"><em>Scale-in and scale-out in a cluster configuration is also easy, and the ecosystem is very rich, with operation monitoring tools such as Grafana being able to be installed immediately with the installation command (TiUP)<\/em><\/p>\n        <\/div>\n        <div class=\"ub_testimonial_sign\">\n            <p class=\"ub_testimonial_author\"><em>Kentaro Kitagawa, <\/em><\/p>\n            <p class=\"ub_testimonial_author_role\"><em>Senior DBA,\u00a0 LINE Corporation<\/em><\/p>\n        <\/div>\n    <\/div>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"The_Results\"><\/span>The Results<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Starting off cautiously, the MySQL1 Team first deployed TiDB for a smaller-scale project\u2014managing MySQL high availability configurations across three different availability zones. They used TiDB&#8217;s migration tool to make the transition from MySQL smooth and painless.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/static.pingcap.com\/files\/2023\/12\/13005803\/tidb_line_architecture.png\" width=\"545\" height=\"346\" alt=\"TiDB Line architecture\"><figcaption><em>LINE Corporation\u2019s system overview of TiDB<\/em><figcaption><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Looking_Ahead_Evolving_Infrastructure_with_Distributed_SQL\"><\/span>Looking Ahead: Evolving Infrastructure with Distributed SQL&nbsp;&nbsp;<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Some team members were initially skeptical about moving away from a MySQL-only environment. The successful initial implementation of TiDB convinced the team of its merits.<\/p>\n\n\n\n<p>At first, some team members had doubts about moving away from a MySQL-exclusive environment. However, the successful implementation of TiDB won them over.<\/p>\n\n\n\n<p>Looking ahead, Mr. Kitagawa sees the MySQL1 Team handling even more database instances without expanding the team. Additionally, they&#8217;re focusing on optimizing operations further to allow for more time on consulting with service developers and deeper internal research.&nbsp;<\/p>\n\n\n\n<p>By embracing TiDB, LINE Corporation aims to keep pace with the evolving landscape of distributed SQL and is committed to innovating their database management strategies for the future.<\/p>","protected":false},"excerpt":{"rendered":"<p>LINE Corporation is a leading global technology company known for its LINE communication application and a host of other services, such as LINE manga, LINE GAME, and LINE GIFT. With its expansive MySQL infrastructure of roughly 7,000 instances, the company faces the ongoing challenge of scaling and managing these databases. To solve these challenges, LINE [&hellip;]<\/p>\n","protected":false},"author":8,"featured_media":17228,"template":"","tags":[55,9,111],"customer":[231],"industry":[8],"class_list":["post-14257","case-study","type-case-study","status-publish","has-post-thumbnail","hentry","tag-high-availability","tag-scalability","tag-tidb","customer-line","industry-internet"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>From MySQL to TiDB: LINE&#039;s Exploration with Distributed SQL<\/title>\n<meta name=\"description\" content=\"Learn how LINE Corporation solved its scaling and operational issues by migrating from MySQL to TiDB, a distributed SQL database.\" \/>\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\/case-study\/line-corporation-exploration-mysql-tidb\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"From MySQL to TiDB: LINE&#039;s Exploration with Distributed SQL\" \/>\n<meta property=\"og:description\" content=\"Learn how LINE Corporation solved its scaling and operational issues by migrating from MySQL to TiDB, a distributed SQL database.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pingcap.com\/ko\/case-study\/line-corporation-exploration-mysql-tidb\/\" \/>\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=\"2024-08-28T09:27:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/static.pingcap.com\/files\/2024\/05\/27004008\/Line.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1500\" \/>\n\t<meta property=\"og:image:height\" content=\"500\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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=\"3\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.pingcap.com\/case-study\/line-corporation-exploration-mysql-tidb\/\",\"url\":\"https:\/\/www.pingcap.com\/case-study\/line-corporation-exploration-mysql-tidb\/\",\"name\":\"From MySQL to TiDB: LINE's Exploration with Distributed SQL\",\"isPartOf\":{\"@id\":\"https:\/\/www.pingcap.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.pingcap.com\/case-study\/line-corporation-exploration-mysql-tidb\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.pingcap.com\/case-study\/line-corporation-exploration-mysql-tidb\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/static.pingcap.com\/files\/2024\/05\/27004008\/Line.jpg\",\"datePublished\":\"2023-10-19T02:32:08+00:00\",\"dateModified\":\"2024-08-28T09:27:46+00:00\",\"description\":\"Learn how LINE Corporation solved its scaling and operational issues by migrating from MySQL to TiDB, a distributed SQL database.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.pingcap.com\/case-study\/line-corporation-exploration-mysql-tidb\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.pingcap.com\/case-study\/line-corporation-exploration-mysql-tidb\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.pingcap.com\/case-study\/line-corporation-exploration-mysql-tidb\/#primaryimage\",\"url\":\"https:\/\/static.pingcap.com\/files\/2024\/05\/27004008\/Line.jpg\",\"contentUrl\":\"https:\/\/static.pingcap.com\/files\/2024\/05\/27004008\/Line.jpg\",\"width\":1500,\"height\":500,\"caption\":\"Line\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.pingcap.com\/case-study\/line-corporation-exploration-mysql-tidb\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.pingcap.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Case Studies\",\"item\":\"https:\/\/www.pingcap.com\/customers\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"From MySQL to TiDB: Inside LINE Corporation&#8217;s Exploration with Distributed SQL\"}]},{\"@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":"From MySQL to TiDB: LINE's Exploration with Distributed SQL","description":"Learn how LINE Corporation solved its scaling and operational issues by migrating from MySQL to TiDB, a distributed SQL database.","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\/case-study\/line-corporation-exploration-mysql-tidb\/","og_locale":"ko_KR","og_type":"article","og_title":"From MySQL to TiDB: LINE's Exploration with Distributed SQL","og_description":"Learn how LINE Corporation solved its scaling and operational issues by migrating from MySQL to TiDB, a distributed SQL database.","og_url":"https:\/\/www.pingcap.com\/ko\/case-study\/line-corporation-exploration-mysql-tidb\/","og_site_name":"TiDB","article_publisher":"https:\/\/facebook.com\/pingcap2015","article_modified_time":"2024-08-28T09:27:46+00:00","og_image":[{"width":1500,"height":500,"url":"https:\/\/static.pingcap.com\/files\/2024\/05\/27004008\/Line.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_site":"@PingCAP","twitter_misc":{"Est. reading time":"3\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.pingcap.com\/case-study\/line-corporation-exploration-mysql-tidb\/","url":"https:\/\/www.pingcap.com\/case-study\/line-corporation-exploration-mysql-tidb\/","name":"From MySQL to TiDB: LINE's Exploration with Distributed SQL","isPartOf":{"@id":"https:\/\/www.pingcap.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.pingcap.com\/case-study\/line-corporation-exploration-mysql-tidb\/#primaryimage"},"image":{"@id":"https:\/\/www.pingcap.com\/case-study\/line-corporation-exploration-mysql-tidb\/#primaryimage"},"thumbnailUrl":"https:\/\/static.pingcap.com\/files\/2024\/05\/27004008\/Line.jpg","datePublished":"2023-10-19T02:32:08+00:00","dateModified":"2024-08-28T09:27:46+00:00","description":"Learn how LINE Corporation solved its scaling and operational issues by migrating from MySQL to TiDB, a distributed SQL database.","breadcrumb":{"@id":"https:\/\/www.pingcap.com\/case-study\/line-corporation-exploration-mysql-tidb\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pingcap.com\/case-study\/line-corporation-exploration-mysql-tidb\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.pingcap.com\/case-study\/line-corporation-exploration-mysql-tidb\/#primaryimage","url":"https:\/\/static.pingcap.com\/files\/2024\/05\/27004008\/Line.jpg","contentUrl":"https:\/\/static.pingcap.com\/files\/2024\/05\/27004008\/Line.jpg","width":1500,"height":500,"caption":"Line"},{"@type":"BreadcrumbList","@id":"https:\/\/www.pingcap.com\/case-study\/line-corporation-exploration-mysql-tidb\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pingcap.com\/"},{"@type":"ListItem","position":2,"name":"Case Studies","item":"https:\/\/www.pingcap.com\/customers\/"},{"@type":"ListItem","position":3,"name":"From MySQL to TiDB: Inside LINE Corporation&#8217;s Exploration with Distributed SQL"}]},{"@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":"<div class=\"card-case-study\"><div class=\"card-case-study__image-container\"><img class=\"card-case-study__image\" alt=\"LINE\" src=\"https:\/\/static.pingcap.com\/files\/2023\/12\/14203455\/LINE.png\" loading=\"lazy\" width=1000 height=525 \/><\/div><span class=\"card-case-study__title\">From MySQL to TiDB: Inside LINE Corporation&#8217;s Exploration with Distributed SQL<\/span><div class=\"card-case-study__button\"><a class=\"button--secondary\" href=\"https:\/\/www.pingcap.com\/ko\/case-study\/line-corporation-exploration-mysql-tidb\/\" target=\"_blank\">View Case Study<\/a><\/div><\/div>","_links":{"self":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/case-study\/14257","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/case-study"}],"about":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/types\/case-study"}],"author":[{"embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/users\/8"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/media\/17228"}],"wp:attachment":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/media?parent=14257"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/tags?post=14257"},{"taxonomy":"customer","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/customer?post=14257"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/industry?post=14257"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}