{"id":9173,"date":"2022-09-20T01:27:21","date_gmt":"2022-09-20T08:27:21","guid":{"rendered":"https:\/\/www.pingcap.com\/?post_type=case-study&p=9173"},"modified":"2024-08-21T19:55:29","modified_gmt":"2024-08-22T02:55:29","slug":"boost-in-game-advertising-with-a-fully-managed-htap-database-service","status":"publish","type":"case-study","link":"https:\/\/www.pingcap.com\/ko\/case-study\/boost-in-game-advertising-with-a-fully-managed-htap-database-service\/","title":{"rendered":"Boost In-Game Advertising with a Fully-Managed HTAP Database Service"},"content":{"rendered":"

CTW Inc. is a Japanese mobile game and internet service provider founded in 2013. It offers services in seven countries and regions, including Europe, the United States, South Korea, Taiwan, and Japan. G123.jp, CTW\u2019s HTML5 gaming platform, offers a wide selection of high-quality games including Vivid Army and Queen\u2019s Blade. Their service has grown rapidly and now has over 50 million users worldwide.\u00a0<\/p>\n\n\n\n

<\/span>Winning the customer over a second<\/strong><\/span><\/h2>\n\n\n\n

The G123.jp platform lets a user enjoy their game on a web browser as long as they are connected to the internet, regardless of their gaming environment. As CTW\u2019s service expands globally, their need for database capacity expands, too.<\/p>\n\n\n\n

As Zilin Tan, CTW\u2019s Chief Data Architect, explains:<\/p>\n\n\n

\n
Providing users with a better experience is what CTW has been striving for. The advertising business is a core service in CTW, which helps us control customer acquisition costs and grow gamers rapidly. To achieve accurate user positioning, the data service must reflect the user conversion data to the advertising AI system within one second.<\/em><\/div>\n<\/blockquote>\n\n\n

<\/span>Challenges with Aurora-based solution<\/strong><\/span><\/h2>\n\n\n\n

CTW originally used Amazon Aurora as their backend database and Amazon Redshift for analytics. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Original architecture at CTW<\/em><\/p>\n\n\n\n

When the data volume of a single table increased to 100 million rows, maintenance became difficult. The challenges included:<\/p>\n\n\n\n

    \n
  • Amazon Redshift is not good at handling data updates in real time.<\/strong> As data volume increased, the solution couldn\u2019t meet the real-time requirements of advertising.<\/li>\n\n\n\n
  • Updating and maintaining Aurora is hard<\/strong>. Aurora required more than a month’s advance planning each time for downtime maintenance or upgrading. To guarantee service continuity, the CTW team could only do maintenance in the middle of the night. <\/li>\n\n\n\n
  • Online Data Definition Language (DDL) operations with Aurora are inefficient<\/strong>. To provide an uninterrupted gaming experience, the CTW team used online DDL changes for database maintenance. However, online DDL with Aurora usually took hours and sometimes failed due to lack of resources.<\/li>\n\n\n\n
  • Replicating business data takes extra effort<\/strong>. Some Aurora clusters applied Aurora Serverless, the on-demand, autoscaling configuration for Amazon Aurora. However, Aurora Serverless doesn\u2019t support binlog. This makes it impossible to replicate data and causes more maintenance downtime. <\/li>\n<\/ul>\n\n\n\n

    <\/span>Migrating to TiDB<\/strong><\/span><\/h2>\n\n\n\n

    Not only did CTW want to solve these problems, but they also wanted to run their data services and analytics in one database. The cost of migrating data to the new database had to be minimal.  <\/p>\n\n\n\n

    CTW investigated YugaByteDB and TiDB. YugaByteDB only supports PostgreSQL interfaces, so it was not an option. CTW decided to try TiDB because it is:<\/p>\n\n\n\n

      \n
    • MySQL compatible. There is no change on the application side. Migrating data is easy.<\/li>\n\n\n\n
    • Cloud-native. Kubernetes Operator for TiDB makes it easy to deploy TiDB on the cloud. This is also in line with CTW\u2019s cloud strategy. <\/li>\n\n\n\n
    • Horizontally scalable, thanks to its compute-storage decoupling architecture.<\/li>\n\n\n\n
    • Highly available. Data is stored in three replicas across availability zones. There is no risk of a single point of failure. <\/li>\n\n\n\n
    • A Hybrid Transactional and Analytical Processing (HTAP) database. The combination of row store and column store allows TiDB to process data services and analytics in the same database. <\/li>\n<\/ul>\n\n\n\n

      When CTW first deployed TiDB, it worked fine. However, the team soon realized that they didn’t understand TiDB well enough to handle infrastructure issues such as service outages. This led them to TiDB Cloud, the fully-managed TiDB service. <\/p>\n\n\n\n

      As Bin Hou, Chief Engineer at CTW, says,<\/p>\n\n\n

      \n
      Switching to TiDB Cloud from TiDB was seamless. TiDB Cloud was up and running immediately after we connected to the network via Virtual Private Cloud peering. When we encountered failures or performance issues during database migration, PingCAP’s technical service team was able to provide fast and efficient support. Thanks to the direct support from PingCAP, we had more confidence in the migration and were able to quickly resolve some legacy issues. <\/em><\/div>\n<\/blockquote>\n\n\n

      <\/span>Triple the throughput on TiDB Cloud<\/strong><\/span><\/h2>\n\n\n\n

      TiDB Cloud supports three data services on the G123.jp platform: user segment, advertising data, and campaign data. To Zilian Tan, the benefits of using TiDB Cloud were clear.  “The data services run stably with significant performance improvement. This translates into a great user experience. With better advertising data service brought by TiDB Cloud, we are able to reduce our customer acquisition costs.”<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n

      Architecture on TiDB Cloud<\/em><\/p>\n\n\n\n

      Tan added:<\/p>\n\n\n

      \n
      Millions of rows of data are replicated to TiDB Cloud every day. The throughput is three times more than that of Aurora, with query and write capabilities both improved. Thanks to the Raft-based data replication, there is no data latency issue with our platform. At the same time, TiDB’s built-in columnar storage, TiFlash, improves analytics performance without changing the application.<\/em><\/div>\n<\/blockquote>\n\n\n

      <\/span>Wrapping up<\/strong><\/span><\/h2>\n\n\n\n

      CTW tested TiDB Cloud for about a month and finished their migration the following month. TiDB Cloud addresses CTW\u2019s challenges with better advertising data service, reduced customer acquisition costs, and easier maintenance. In the future, CTW expects more data services to run on TiDB Cloud.<\/p>","protected":false},"excerpt":{"rendered":"

      Learn how CTW, a leading Japanese mobile game and internet service provider, use TiDB Cloud to boost their in-game advertising business.<\/p>","protected":false},"author":8,"featured_media":17233,"template":"","tags":[10,11,31],"customer":[171],"industry":[50],"class_list":["post-9173","case-study","type-case-study","status-publish","has-post-thumbnail","hentry","tag-htap","tag-real-time-analytics","tag-tidb-cloud","customer-ctw","industry-gaming"],"acf":[],"yoast_head":"\nHow CTW Boosts In-Game Advertising with an HTAP Database<\/title>\n<meta name=\"description\" content=\"Learn how CTW, a leading Japanese mobile game and internet service provider, use TiDB Cloud to boost their in-game advertising business.\" \/>\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\/boost-in-game-advertising-with-a-fully-managed-htap-database-service\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How CTW Boosts In-Game Advertising with an HTAP Database\" \/>\n<meta property=\"og:description\" content=\"Learn how CTW, a leading Japanese mobile game and internet service provider, use TiDB Cloud to boost their in-game advertising business.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pingcap.com\/ko\/case-study\/boost-in-game-advertising-with-a-fully-managed-htap-database-service\/\" \/>\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-22T02:55:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/static.pingcap.com\/files\/2022\/09\/22202121\/ctw-social-scaled.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1340\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/static.pingcap.com\/files\/2022\/09\/22202121\/ctw-social-scaled.jpg\" \/>\n<meta name=\"twitter:site\" content=\"@PingCAP\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4\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\/boost-in-game-advertising-with-a-fully-managed-htap-database-service\/\",\"url\":\"https:\/\/www.pingcap.com\/case-study\/boost-in-game-advertising-with-a-fully-managed-htap-database-service\/\",\"name\":\"How CTW Boosts In-Game Advertising with an HTAP Database\",\"isPartOf\":{\"@id\":\"https:\/\/www.pingcap.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.pingcap.com\/case-study\/boost-in-game-advertising-with-a-fully-managed-htap-database-service\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.pingcap.com\/case-study\/boost-in-game-advertising-with-a-fully-managed-htap-database-service\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/static.pingcap.com\/files\/2024\/05\/27004023\/CTW.jpg\",\"datePublished\":\"2022-09-20T08:27:21+00:00\",\"dateModified\":\"2024-08-22T02:55:29+00:00\",\"description\":\"Learn how CTW, a leading Japanese mobile game and internet service provider, use TiDB Cloud to boost their in-game advertising business.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.pingcap.com\/case-study\/boost-in-game-advertising-with-a-fully-managed-htap-database-service\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.pingcap.com\/case-study\/boost-in-game-advertising-with-a-fully-managed-htap-database-service\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.pingcap.com\/case-study\/boost-in-game-advertising-with-a-fully-managed-htap-database-service\/#primaryimage\",\"url\":\"https:\/\/static.pingcap.com\/files\/2024\/05\/27004023\/CTW.jpg\",\"contentUrl\":\"https:\/\/static.pingcap.com\/files\/2024\/05\/27004023\/CTW.jpg\",\"width\":1500,\"height\":500,\"caption\":\"CTW\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.pingcap.com\/case-study\/boost-in-game-advertising-with-a-fully-managed-htap-database-service\/#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\":\"Boost In-Game Advertising with a Fully-Managed HTAP Database Service\"}]},{\"@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":"How CTW Boosts In-Game Advertising with an HTAP Database","description":"Learn how CTW, a leading Japanese mobile game and internet service provider, use TiDB Cloud to boost their in-game advertising business.","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\/boost-in-game-advertising-with-a-fully-managed-htap-database-service\/","og_locale":"ko_KR","og_type":"article","og_title":"How CTW Boosts In-Game Advertising with an HTAP Database","og_description":"Learn how CTW, a leading Japanese mobile game and internet service provider, use TiDB Cloud to boost their in-game advertising business.","og_url":"https:\/\/www.pingcap.com\/ko\/case-study\/boost-in-game-advertising-with-a-fully-managed-htap-database-service\/","og_site_name":"TiDB","article_publisher":"https:\/\/facebook.com\/pingcap2015","article_modified_time":"2024-08-22T02:55:29+00:00","og_image":[{"width":2560,"height":1340,"url":"https:\/\/static.pingcap.com\/files\/2022\/09\/22202121\/ctw-social-scaled.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_image":"https:\/\/static.pingcap.com\/files\/2022\/09\/22202121\/ctw-social-scaled.jpg","twitter_site":"@PingCAP","twitter_misc":{"Est. reading time":"4\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.pingcap.com\/case-study\/boost-in-game-advertising-with-a-fully-managed-htap-database-service\/","url":"https:\/\/www.pingcap.com\/case-study\/boost-in-game-advertising-with-a-fully-managed-htap-database-service\/","name":"How CTW Boosts In-Game Advertising with an HTAP Database","isPartOf":{"@id":"https:\/\/www.pingcap.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.pingcap.com\/case-study\/boost-in-game-advertising-with-a-fully-managed-htap-database-service\/#primaryimage"},"image":{"@id":"https:\/\/www.pingcap.com\/case-study\/boost-in-game-advertising-with-a-fully-managed-htap-database-service\/#primaryimage"},"thumbnailUrl":"https:\/\/static.pingcap.com\/files\/2024\/05\/27004023\/CTW.jpg","datePublished":"2022-09-20T08:27:21+00:00","dateModified":"2024-08-22T02:55:29+00:00","description":"Learn how CTW, a leading Japanese mobile game and internet service provider, use TiDB Cloud to boost their in-game advertising business.","breadcrumb":{"@id":"https:\/\/www.pingcap.com\/case-study\/boost-in-game-advertising-with-a-fully-managed-htap-database-service\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pingcap.com\/case-study\/boost-in-game-advertising-with-a-fully-managed-htap-database-service\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.pingcap.com\/case-study\/boost-in-game-advertising-with-a-fully-managed-htap-database-service\/#primaryimage","url":"https:\/\/static.pingcap.com\/files\/2024\/05\/27004023\/CTW.jpg","contentUrl":"https:\/\/static.pingcap.com\/files\/2024\/05\/27004023\/CTW.jpg","width":1500,"height":500,"caption":"CTW"},{"@type":"BreadcrumbList","@id":"https:\/\/www.pingcap.com\/case-study\/boost-in-game-advertising-with-a-fully-managed-htap-database-service\/#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":"Boost In-Game Advertising with a Fully-Managed HTAP Database Service"}]},{"@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=\"CTW\" src=\"https:\/\/static.pingcap.com\/files\/2023\/12\/14203016\/CTW.png\" loading=\"lazy\" width=247 height=103 \/><\/div><span class=\"card-case-study__title\">Boost In-Game Advertising with a Fully-Managed HTAP Database Service<\/span><div class=\"card-case-study__button\"><a class=\"button--secondary\" href=\"https:\/\/www.pingcap.com\/ko\/case-study\/boost-in-game-advertising-with-a-fully-managed-htap-database-service\/\" target=\"_blank\">View Case Study<\/a><\/div><\/div>","_links":{"self":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/case-study\/9173","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\/17233"}],"wp:attachment":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/media?parent=9173"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/tags?post=9173"},{"taxonomy":"customer","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/customer?post=9173"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/industry?post=9173"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}