{"id":1043,"date":"2020-09-22T00:00:00","date_gmt":"2020-09-22T00:00:00","guid":{"rendered":"https:\/\/en.pingcap.com\/case-study\/scale-out-database-powers-china-letgo-with-reduced-maintenance-costs\/"},"modified":"2024-07-16T23:12:39","modified_gmt":"2024-07-17T06:12:39","slug":"scale-out-database-powers-china-letgo-with-reduced-maintenance-costs","status":"publish","type":"case-study","link":"https:\/\/www.pingcap.com\/ko\/case-study\/scale-out-database-powers-china-letgo-with-reduced-maintenance-costs\/","title":{"rendered":"A Scale-Out Database Powers China&#8217;s Letgo with Reduced Maintenance Costs"},"content":{"rendered":"<p class=\"wp-block-paragraph\"><strong>Author:<\/strong> Haodong Ji (Head DBA at Zhuan Zhuan)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Zhuan Zhuan is an online used goods trading platform. You can think of us as &#8220;the Letgo of China.&#8221; Since we launched our platform in 2015, we have grown tremendously. In 2018, we had more than 200 million users, with over 50 million monthly active users on our app and WeChat mini-program.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In an earlier post, we talked about why we migrated from MySQL to <a href=\"\/ko\/tidb\/\">\ud2f0DB<\/a>, an open-source, distributed, Hybrid Transactional\/Analytical Processing (HTAP) database, and how TiDB helped our database achieve horizontal scaling.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Today, I&#8217;ll introduce how <a href=\"https:\/\/docs.pingcap.com\/tidb\/stable\/release-4.0-ga\">TiDB 4.0<\/a>&#8216;s new features make TiDB easier to use and reduce our operations and maintenance costs.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"TiDB_more_than_a_horizontally_scalable_database\"><\/span>TiDB: more than a horizontally scalable database<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">When we switched to TiDB, we immediately solved two of our database problems:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Complex application logic caused by sharding.<\/strong> Sharding makes our application logic more complex, and multi-dimensional mapping can decrease our overall performance. With TiDB, we don&#8217;t need to shard or write complicated logic.<\/li>\n\n\n\n<li><strong>Complex database operations and maintenance.<\/strong> TiDB can rapidly scale horizontally. The DBA does not have to migrate data or application traffic. In addition, online Data Definition Language (DDL) operations on large tables have almost no impact.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">When we upgraded to <a href=\"https:\/\/docs.pingcap.com\/tidb\/stable\/whats-new-in-tidb-4.0\">TiDB 4.0<\/a>, we solved even more issues. <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><p><strong>Clusters were slow to deploy and difficult to manage.<\/strong><\/p>TiUP can deploy a cluster in only one minute<br><\/li>\n\n\n\n<li><p><strong>Hotspots were hard to find.<\/strong> Hotspots are fairly common in e-commerce scenarios. In the past, we had to query each node&#8217;s log separately. Investigating hotspots was slow and costly.<\/p>Key Visualizer clearly displays hotspots across the entire cluster<br><\/li>\n\n\n\n<li><p><strong>It was hard to view the status of the entire cluster.<\/strong> Sometimes, we needed to confirm the status of the cluster. Because there are many items to monitor and logs are scattered throughout the cluster, getting status was time-consuming. We couldn&#8217;t locate problems quickly.<\/p>TiDB Dashboard efficiently displays cluster-wide information<br><\/li>\n\n\n\n<li><p><strong>Extracting data often slowed down our online response<\/strong> and affected TiKV, TiDB&#8217;s storage engine.<\/p>TiFlash extracts data without affecting online performance<br><\/li>\n\n\n\n<li><p><strong>It was hard to back up and restore very large clusters.<\/strong> This was an urgent issue for us. We were using logical backup, but it wasn&#8217;t very effective.<\/p>Backup &amp; Restore quickly backs up and restores very large clusters<br><\/li>\n\n\n\n<li><p><strong>Configuring the TiKV thread pool was complicated,<\/strong> and, as our application changed, we had to update it.<\/p>TiKV&#8217;s unified read pool streamlines configuration<br><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"TiUP_can_deploy_a_cluster_in_only_one_minute\"><\/span>TiUP can deploy a cluster in only one minute<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">TiDB 4.0 introduces a new component management tool, <a href=\"https:\/\/docs.pingcap.com\/tidb\/stable\/tiup-overview\">TiUP<\/a>, which makes deploying a TiDB environment faster than ever. If you&#8217;ve wanted to deploy TiDB before, but thought it was too complicated or time consuming, TiUP solves that.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For example, we used TiUP to deploy three TiDB instances, three TiKV instances, three Placement Driver instances, and one TiFlash instance in <em>one minute<\/em>. Besides lightning-fast deployment, TiUP also offers a large number of parameters we can use to <a href=\"https:\/\/docs.pingcap.com\/tidb\/stable\/tiup-component-management#query-the-operating-status-of-a-component\">check the status<\/a> of our cluster.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Key_Visualizer_clearly_displays_hotspots_across_the_entire_cluster\"><\/span>Key Visualizer clearly displays hotspots across the entire cluster<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">In the early days, troubleshooting hotspots was difficult. We had to look through various logs and meticulously analyze them until we could locate the problem. Now, TiDB 4.0 introduces a new visualization tool, <a href=\"https:\/\/docs.pingcap.com\/tidb\/stable\/dashboard-key-visualizer#key-visualizer-page\">Key Visualizer<\/a>, which quickly and intuitively displays <a href=\"https:\/\/docs.pingcap.com\/tidb\/stable\/dashboard-key-visualizer#hotspot\">hotspots<\/a> anywhere in our cluster using a graphical <a href=\"https:\/\/docs.pingcap.com\/tidb\/stable\/dashboard-key-visualizer#heatmap\">heatmap<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Here is an example:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"520\" src=\"https:\/\/www.pingcap.com\/core\/uploads\/2021\/11\/key-viz-heatmap-1024x520.jpeg\" alt=\"\" class=\"wp-image-2721\" srcset=\"https:\/\/static.pingcap.com\/files\/2021\/11\/key-viz-heatmap-1024x520.jpeg 1024w, https:\/\/static.pingcap.com\/files\/2021\/11\/key-viz-heatmap-300x152.jpeg 300w, https:\/\/static.pingcap.com\/files\/2021\/11\/key-viz-heatmap-768x390.jpeg 768w, https:\/\/static.pingcap.com\/files\/2021\/11\/key-viz-heatmap-1536x780.jpeg 1536w, https:\/\/static.pingcap.com\/files\/2021\/11\/key-viz-heatmap-1440x732.jpeg 1440w, https:\/\/static.pingcap.com\/files\/2021\/11\/key-viz-heatmap.jpeg 1626w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">Key Visualizer&#8217;s heatmap<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">In the heatmap:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The x-axis represents time.<\/li>\n\n\n\n<li>The y-axis represents the key ranges, with mappings between key ranges to tables and indices.<\/li>\n\n\n\n<li>The colors represent the read or write volume of key ranges. The brighter the color, the higher the read or write volume.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><iframe loading=\"lazy\" src=\"https:\/\/download.pingcap.com\/images\/blog\/key-visualizer.mp4\" width=\"100%\" height=\"auto\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n\n\n\n<div class=\"caption-center\">Key Visualizer: quickly troubleshoot database performance issues<\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Key Visualizer displays system status graphically, which helps us quickly troubleshoot database performance issues and enables us to <a href=\"https:\/\/www.pingcap.com\/ko\/blog\/observe-distributed-databases-to-discover-unknowns\/\">gain deep insights into our applications<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"TiDB_Dashboard_efficiently_displays_cluster-wide_information\"><\/span>TiDB Dashboard efficiently displays cluster-wide information<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">As I mentioned earlier, it can be difficult to determine a cluster&#8217;s status. <a href=\"https:\/\/docs.pingcap.com\/tidb\/stable\/dashboard-intro#tidb-dashboard-introduction\">TiDB Dashboard<\/a> effectively addresses this issue. TiDB Dashboard is <strong>a graphical interface with<\/strong> <strong>various built-in widgets that let us easily diagnose, monitor, and manage our clusters<\/strong>. In a single interface, we can check a distributed cluster&#8217;s runtime status and manage the cluster, including:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Quickly finding cluster hotspots<\/li>\n\n\n\n<li>Analyzing SQL statements&#8217; execution performance<\/li>\n\n\n\n<li>Viewing slow queries<\/li>\n\n\n\n<li>Generating cluster diagnostic reports<\/li>\n\n\n\n<li>Searching and exporting logs<\/li>\n\n\n\n<li>Profiling instances<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">I think the Dashboard is one of the highlights of the 4.0 release, and it makes an already useful product even better.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1600\" height=\"901\" src=\"https:\/\/www.pingcap.com\/core\/uploads\/2020\/09\/tidb-dashboard-overview.gif\" alt=\"TiDB Dashboard\" class=\"wp-image-1044\"\/><\/figure>\n\n\n\n<div class=\"caption-center\">TiDB Dashboard<\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Understanding the overview page<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The following figure shows the TiDB Dashboard&#8217;s <a href=\"https:\/\/docs.pingcap.com\/tidb\/stable\/dashboard-overview#overview-page\"><strong>Overview<\/strong><\/a> page. It displays:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Database traffic in queries per second (QPS)<\/li>\n\n\n\n<li>Response latency<\/li>\n\n\n\n<li>Node status<\/li>\n\n\n\n<li>Alert-related information<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Through the overview, we can quickly find the status of the cluster, quickly locate problems, and use TiDB better.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Finding slow queries<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">TiDB Dashboard also lets us find slow-running queries. As shown on the <strong><a href=\"https:\/\/docs.pingcap.com\/tidb\/stable\/dashboard-slow-query#slow-queries-page-of-tidb-dashboard\">Slow Queries<\/a><\/strong> page below, we specify the database, the time range, and the number of queries to display. The output includes the query name, execution time, and query description, and you can sort the results. Once we get our list, we can quickly locate the query we&#8217;re interested in. We no longer need our own extract, transform, load (ETL) process, and we don&#8217;t need to go to the machine ourselves.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1600\" height=\"901\" src=\"https:\/\/www.pingcap.com\/core\/uploads\/2020\/10\/slow-queries.gif\" alt=\"Slow query viewing\" class=\"wp-image-77\"\/><\/figure>\n\n\n\n<div class=\"caption-center\">Slow queries<\/div>\n\n\n\n<h3 class=\"wp-block-heading\">SQL statement analysis<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">We can drill down to the specific SQL statement and see the SQL statement template, fingerprint ID, statement sample, <a href=\"https:\/\/docs.pingcap.com\/tidb\/stable\/query-execution-plan\">query execution plan<\/a>, and transaction-related metrics. When we used an ETL process, we didn&#8217;t have a lot of this information. Now, through SQL statement analysis, we can see the execution stages of a slow query and the execution time of each stage. This greatly improves our overall SQL analysis.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1600\" height=\"900\" src=\"https:\/\/www.pingcap.com\/core\/uploads\/2020\/05\/sql-statement-analysis.gif\" alt=\"SQL statement analysis\" class=\"wp-image-376\"\/><\/figure>\n\n\n\n<div class=\"caption-center\">SQL statement analysis<\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Searching logs<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">TiDB&#8217;s new log search feature lets us search for logs on all instances in the cluster, preview search results, and export logs, which greatly reduces our labor and development costs. With the <strong><a href=\"https:\/\/docs.pingcap.com\/tidb\/stable\/dashboard-log-search#tidb-dashboard-log-search-page\">Search Log<\/a><\/strong> page, we can find logs based on the time period, the log level, and instance. We longer have to log on to each machine and go through logs manually. What a time saver.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1600\" height=\"901\" src=\"https:\/\/www.pingcap.com\/core\/uploads\/2020\/05\/log-search.gif\" alt=\"Search and export logs\" class=\"wp-image-378\"\/><\/figure>\n\n\n\n<div class=\"caption-center\">Search and export logs<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"TiFlash_extracts_data_without_affecting_online_performance\"><\/span>TiFlash extracts data without affecting online performance<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">In the past, extracting data increased online response times. <a href=\"https:\/\/docs.pingcap.com\/tidb\/stable\/tiflash-overview#tiflash-overview\">TiFlash<\/a> solves this problem and includes features such as asynchronous replication, consistency, intelligent selection, and calculation acceleration.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">At Zhuan Zhuan, we mainly use TiFlash on shared physical machine hosts and physical isolation. When we add a TiKV node to the new machine, requests are separated. Different requests go to different back-end data nodes, so that when you extract data, it will not affect the overall online performance. Based on the complexity of our application and SQL statements, TiDB automatically chooses to use TiFlash or TiKV to ensure the best performance. If a request is for online data, TiDB chooses TiKV. If a request is for offline data, TiDB chooses TiFlash. This is an intelligent selection mechanism.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"2088\" height=\"1010\" src=\"https:\/\/www.pingcap.com\/core\/uploads\/2020\/10\/tidb-with-tiflash.png\" alt=\"TiFlash for real-time analytics\" class=\"wp-image-731\" srcset=\"https:\/\/static.pingcap.com\/files\/2020\/10\/tidb-with-tiflash.png 2088w, https:\/\/static.pingcap.com\/files\/2020\/10\/tidb-with-tiflash-300x145.png 300w, https:\/\/static.pingcap.com\/files\/2020\/10\/tidb-with-tiflash-1024x495.png 1024w, https:\/\/static.pingcap.com\/files\/2020\/10\/tidb-with-tiflash-768x371.png 768w, https:\/\/static.pingcap.com\/files\/2020\/10\/tidb-with-tiflash-1536x743.png 1536w, https:\/\/static.pingcap.com\/files\/2020\/10\/tidb-with-tiflash-2048x991.png 2048w, https:\/\/static.pingcap.com\/files\/2020\/10\/tidb-with-tiflash-1440x697.png 1440w\" sizes=\"auto, (max-width: 2088px) 100vw, 2088px\" \/><\/figure>\n\n\n\n<div class=\"caption-center\">TiDB including TiFlash<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Backup_Restore_quickly_backs_up_and_restores_very_large_clusters\"><\/span>Backup &amp; Restore quickly backs up and restores very large clusters<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Prior to TiDB 4.0, we struggled to effectively back up our large data clusters. We used logical backups, which really didn&#8217;t meet our needs.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">We tested TiDB 4.0&#8217;s distributed backup and recovery tool, <a href=\"https:\/\/docs.pingcap.com\/tidb\/stable\/backup-and-restore-tool#use-br-to-back-up-and-restore-data\">Backup &amp; Restore<\/a>, and got excellent results. In a 10 Gb network environment, at 120 MB\/sec network speed, it took <strong>less than 10 minutes to back up 300 GB of data to the network file system<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Under the same speed limit of 120 MB\/sec, we restored our data through the network file system in about 12 minutes<\/strong>. Backup &amp; Restore has greatly reduced our backup and restore time.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Another key factor is that the speed of backup depends entirely on the number of TiKV instances we have. The more TiKV instances we have, the faster our backup and restore speeds.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"TiKVs_unified_read_pool_streamlines_configuration\"><\/span>TiKV&#8217;s unified read pool streamlines configuration<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">TiDB 4.0 also introduces a new feature, the <a href=\"https:\/\/docs.pingcap.com\/tidb\/stable\/tikv-configuration-file#readpoolunified\">unified read pool<\/a>. Before 4.0, we had to configure and dynamically adjust our read pool storage and Coprocessor, which may affect the application. We found that configuring and managing these components was frustrating.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>The unified read pool merges the storage and Coprocessor into one thread pool.<\/strong> The SQL query automatically determines whether we use storage or the Coprocessor. This not only improves system usability, but also solves the problem of unevenly distributed resources.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Future_plans\"><\/span>Future plans<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">TiDB 4.0 introduced some experimental features, such as TiDB Dashboard, TiFlash, and the unified thread pool, which make TiDB more robust and easier to use than ever. This release has been a great help to us, and we haven&#8217;t even fully adopted it yet!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In the future, we will fully upgrade to version 4.0. This release promises to streamline database operations and maintenance, which will free up our database team to focus more on innovations.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you&#8217;d like to learn more about our experience with TiDB, you can join the <a href=\"https:\/\/slack.tidb.io\/invite?team=tidb-community&amp;channel=everyone&amp;ref=pingcap-blog\">TiDB community on Slack<\/a>.<\/p>","protected":false},"excerpt":{"rendered":"<p>Zhuan Zhuan embraced TiDB 4.0&#8217;s new features with great results. It&#8217;s a truly HTAP database with one-minute deployment, visual troubleshooting, and reduced maintenance costs.<\/p>","protected":false},"author":109,"featured_media":1045,"template":"","tags":[37,52],"customer":[89],"industry":[8],"class_list":["post-1043","case-study","type-case-study","status-publish","has-post-thumbnail","hentry","tag-backup-and-restore","tag-tiflash","customer-zhuan-zhuan","industry-internet"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>A Scale-Out Database Powers China&#039;s Letgo with Reduced Maintenance Costs | TiDB<\/title>\n<meta name=\"description\" content=\"Read success stories from businesses using TiDB and the TiDB Cloud solutions from PingCAP. Learn more in our latest case study &quot;A Scale-Out Database Powers China&#039;s Letgo with Reduced Maintenance Costs&quot; here.\" \/>\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\/scale-out-database-powers-china-letgo-with-reduced-maintenance-costs\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"A Scale-Out Database Powers China&#039;s Letgo with Reduced Maintenance Costs | TiDB\" \/>\n<meta property=\"og:description\" content=\"Read success stories from businesses using TiDB and the TiDB Cloud solutions from PingCAP. Learn more in our latest case study &quot;A Scale-Out Database Powers China&#039;s Letgo with Reduced Maintenance Costs&quot; here.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pingcap.com\/ko\/case-study\/scale-out-database-powers-china-letgo-with-reduced-maintenance-costs\/\" \/>\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-07-17T06:12:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/static.pingcap.com\/files\/2020\/09\/scale-out-mysql-alternative-database-zhuanzhuan.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2000\" \/>\n\t<meta property=\"og:image:height\" content=\"667\" \/>\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=\"\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04\" \/>\n\t<meta name=\"twitter:data1\" content=\"8\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\\\/scale-out-database-powers-china-letgo-with-reduced-maintenance-costs\\\/\",\"url\":\"https:\\\/\\\/www.pingcap.com\\\/case-study\\\/scale-out-database-powers-china-letgo-with-reduced-maintenance-costs\\\/\",\"name\":\"A Scale-Out Database Powers China's Letgo with Reduced Maintenance Costs | TiDB\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.pingcap.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.pingcap.com\\\/case-study\\\/scale-out-database-powers-china-letgo-with-reduced-maintenance-costs\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.pingcap.com\\\/case-study\\\/scale-out-database-powers-china-letgo-with-reduced-maintenance-costs\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/static.pingcap.com\\\/files\\\/2020\\\/09\\\/scale-out-mysql-alternative-database-zhuanzhuan.jpg\",\"datePublished\":\"2020-09-22T00:00:00+00:00\",\"dateModified\":\"2024-07-17T06:12:39+00:00\",\"description\":\"Read success stories from businesses using TiDB and the TiDB Cloud solutions from PingCAP. Learn more in our latest case study \\\"A Scale-Out Database Powers China's Letgo with Reduced Maintenance Costs\\\" here.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.pingcap.com\\\/case-study\\\/scale-out-database-powers-china-letgo-with-reduced-maintenance-costs\\\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.pingcap.com\\\/case-study\\\/scale-out-database-powers-china-letgo-with-reduced-maintenance-costs\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\\\/\\\/www.pingcap.com\\\/case-study\\\/scale-out-database-powers-china-letgo-with-reduced-maintenance-costs\\\/#primaryimage\",\"url\":\"https:\\\/\\\/static.pingcap.com\\\/files\\\/2020\\\/09\\\/scale-out-mysql-alternative-database-zhuanzhuan.jpg\",\"contentUrl\":\"https:\\\/\\\/static.pingcap.com\\\/files\\\/2020\\\/09\\\/scale-out-mysql-alternative-database-zhuanzhuan.jpg\",\"width\":2000,\"height\":667},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.pingcap.com\\\/case-study\\\/scale-out-database-powers-china-letgo-with-reduced-maintenance-costs\\\/#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\":\"A Scale-Out Database Powers China&#8217;s Letgo with Reduced Maintenance Costs\"}]},{\"@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":"A Scale-Out Database Powers China's Letgo with Reduced Maintenance Costs | TiDB","description":"Read success stories from businesses using TiDB and the TiDB Cloud solutions from PingCAP. Learn more in our latest case study \"A Scale-Out Database Powers China's Letgo with Reduced Maintenance Costs\" here.","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\/scale-out-database-powers-china-letgo-with-reduced-maintenance-costs\/","og_locale":"ko_KR","og_type":"article","og_title":"A Scale-Out Database Powers China's Letgo with Reduced Maintenance Costs | TiDB","og_description":"Read success stories from businesses using TiDB and the TiDB Cloud solutions from PingCAP. Learn more in our latest case study \"A Scale-Out Database Powers China's Letgo with Reduced Maintenance Costs\" here.","og_url":"https:\/\/www.pingcap.com\/ko\/case-study\/scale-out-database-powers-china-letgo-with-reduced-maintenance-costs\/","og_site_name":"TiDB","article_publisher":"https:\/\/facebook.com\/pingcap2015","article_modified_time":"2024-07-17T06:12:39+00:00","og_image":[{"width":2000,"height":667,"url":"https:\/\/static.pingcap.com\/files\/2020\/09\/scale-out-mysql-alternative-database-zhuanzhuan.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_site":"@PingCAP","twitter_misc":{"\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04":"8\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.pingcap.com\/case-study\/scale-out-database-powers-china-letgo-with-reduced-maintenance-costs\/","url":"https:\/\/www.pingcap.com\/case-study\/scale-out-database-powers-china-letgo-with-reduced-maintenance-costs\/","name":"A Scale-Out Database Powers China's Letgo with Reduced Maintenance Costs | TiDB","isPartOf":{"@id":"https:\/\/www.pingcap.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.pingcap.com\/case-study\/scale-out-database-powers-china-letgo-with-reduced-maintenance-costs\/#primaryimage"},"image":{"@id":"https:\/\/www.pingcap.com\/case-study\/scale-out-database-powers-china-letgo-with-reduced-maintenance-costs\/#primaryimage"},"thumbnailUrl":"https:\/\/static.pingcap.com\/files\/2020\/09\/scale-out-mysql-alternative-database-zhuanzhuan.jpg","datePublished":"2020-09-22T00:00:00+00:00","dateModified":"2024-07-17T06:12:39+00:00","description":"Read success stories from businesses using TiDB and the TiDB Cloud solutions from PingCAP. Learn more in our latest case study \"A Scale-Out Database Powers China's Letgo with Reduced Maintenance Costs\" here.","breadcrumb":{"@id":"https:\/\/www.pingcap.com\/case-study\/scale-out-database-powers-china-letgo-with-reduced-maintenance-costs\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pingcap.com\/case-study\/scale-out-database-powers-china-letgo-with-reduced-maintenance-costs\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.pingcap.com\/case-study\/scale-out-database-powers-china-letgo-with-reduced-maintenance-costs\/#primaryimage","url":"https:\/\/static.pingcap.com\/files\/2020\/09\/scale-out-mysql-alternative-database-zhuanzhuan.jpg","contentUrl":"https:\/\/static.pingcap.com\/files\/2020\/09\/scale-out-mysql-alternative-database-zhuanzhuan.jpg","width":2000,"height":667},{"@type":"BreadcrumbList","@id":"https:\/\/www.pingcap.com\/case-study\/scale-out-database-powers-china-letgo-with-reduced-maintenance-costs\/#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":"A Scale-Out Database Powers China&#8217;s Letgo with Reduced Maintenance Costs"}]},{"@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=\"zhuanzhuan-logo.png\" src=\"https:\/\/static.pingcap.com\/files\/2021\/10\/zhuanzhuan-logo.png\" loading=\"lazy\" width=300 height=200 \/><\/div><span class=\"card-case-study__title\">A Scale-Out Database Powers China&#8217;s Letgo with Reduced Maintenance Costs<\/span><div class=\"card-case-study__button\"><a class=\"button--secondary\" href=\"https:\/\/www.pingcap.com\/ko\/case-study\/scale-out-database-powers-china-letgo-with-reduced-maintenance-costs\/\" target=\"_blank\">View Case Study<\/a><\/div><\/div>","_links":{"self":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/case-study\/1043","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\/109"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/media\/1045"}],"wp:attachment":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/media?parent=1043"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/tags?post=1043"},{"taxonomy":"customer","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/customer?post=1043"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/industry?post=1043"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}