{"id":6775,"date":"2022-05-31T22:47:23","date_gmt":"2022-06-01T05:47:23","guid":{"rendered":"https:\/\/en.pingcap.com\/?post_type=event&#038;p=6775"},"modified":"2024-08-21T22:58:05","modified_gmt":"2024-08-22T05:58:05","slug":"the-future-of-modern-distributed-sql-databases-data-placement-and-queue","status":"publish","type":"event","link":"https:\/\/www.pingcap.com\/ko\/event\/the-future-of-modern-distributed-sql-databases-data-placement-and-queue\/","title":{"rendered":"The Future of Modern Distributed SQL Databases: Data Placement and Queue"},"content":{"rendered":"\n<p><strong>Time: <\/strong>June 9, door will open at 5:30PM Pacific Daylight Time; talk will start at 6:00 PM Pacific Daylight Time<\/p>\n\n\n\n<p>Join us at our Sunnyvale office for dinner and drinks! If you can\u2019t make it in person, then check out our livestream. &nbsp;&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-4-3 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"[PingCAP Meetup] Microservice: The TiDB way\" width=\"500\" height=\"375\" src=\"https:\/\/www.youtube.com\/embed\/xLMpx9AaJzI?list=PLlGz8dzgfp-6dxSnUpCCqSGT87QApNWHM\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>Speakers:<\/strong><\/p>\n\n\n\n<p><strong>Ed Huang<\/strong><\/p>\n\n\n\n<p><strong>Co-founder and CTO, PingCAP<\/strong><\/p>\n\n\n\n<p><strong>Liquan Pei<\/strong><\/p>\n\n\n\n<p><strong>Senior Database Engineer, PingCAP<\/strong><\/p>\n\n\n\n<p>This meetup is part of the meetup series \u201cThe Future of Modern Distributed SQL Databases.\u201d This meetup will cover two topics: data placement and queue.<\/p>\n\n\n\n<p>Liquan Pei will introduce Placement Rules. Introduced in v5.0, Placement Rules is a replica rule system which enables users to control data placement. Typical user scenarios include:&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Merging databases running different applications to reduce the cost of database maintenance<\/li>\n\n\n\n<li>Increasing the replica count for important data to improve application availability and data reliability<\/li>\n\n\n\n<li>Storing new data on solid-state drives (SSDs) and storing old data into hard disk drives (HDDs) to lower the cost of data archiving and storage<\/li>\n\n\n\n<li>Scheduling the leaders of hotspot data to high-performance TiKV instances<\/li>\n\n\n\n<li>Separating cold data to lower-cost storage mediums to improve cost efficiency<\/li>\n<\/ul>\n\n\n\n<p>Ed will talk about the TiDB queue. When you build a modern application in the cloud, the three main pillars are compute, messaging, and database. There are several messaging models including queue and publish\/subscribe. In this talk, Ed will focus on how TiDB supports the queue.<\/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-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:33.33%\"><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"420\" height=\"404\" src=\"https:\/\/www.pingcap.com\/core\/uploads\/2022\/05\/Ed-Picture.png\" alt=\"\" class=\"wp-image-6776\" srcset=\"https:\/\/static.pingcap.com\/files\/2022\/05\/Ed-Picture.png 420w, https:\/\/static.pingcap.com\/files\/2022\/05\/Ed-Picture-300x289.png 300w\" sizes=\"auto, (max-width: 420px) 100vw, 420px\" \/><\/figure>\n<\/div><\/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><strong>Ed Huang<\/strong><\/p>\n\n\n\n<p><strong>Co-founder and CTO, PingCAP<\/strong><\/p>\n\n\n\n<p>Ed Huang is co-founder and CTO of PingCAP, one of the creators of the TiDB distributed database and the TiKV key value store. While he was at Wandou Labs, Ed worked on clustering Redis and created and open-sourced Codis, a proxy-based, high-performance Redis cluster solution. He decided to focus on the next generation database and went on to found PingCAP and create TiDB and TiKV.<\/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 class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"722\" height=\"722\" src=\"https:\/\/www.pingcap.com\/core\/uploads\/2022\/05\/Liquan-Profile-Picture-modified.png\" alt=\"\" class=\"wp-image-6777\" srcset=\"https:\/\/static.pingcap.com\/files\/2022\/05\/Liquan-Profile-Picture-modified.png 722w, https:\/\/static.pingcap.com\/files\/2022\/05\/Liquan-Profile-Picture-modified-300x300.png 300w, https:\/\/static.pingcap.com\/files\/2022\/05\/Liquan-Profile-Picture-modified-150x150.png 150w\" sizes=\"auto, (max-width: 722px) 100vw, 722px\" \/><\/figure>\n<\/div><\/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><strong>Liquan Pei<\/strong><\/p>\n\n\n\n<p><strong>Senior Database Engineer, PingCAP<\/strong><\/p>\n\n\n\n<p>Liquan is a Senior Database Engineer at PingCAP. Before PingCAP, he was the tech lead of the ads stream processing system at Pinterest. Prior to that, he worked at Confluent, focusing on Kafka and Kafka Connect. He is an open-source contributor to Apache Kafka and Apache Spark and was a speaker at Kafka Summit 2018 and 2019.<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Time: June 9, door will open at 5:30PM Pacific Daylight Time; talk will start at 6:00 PM Pacific Daylight Time Join us at our Sunnyvale office for dinner and drinks! If you can\u2019t make it in person, then check out our livestream. &nbsp;&nbsp; Speakers: Ed Huang Co-founder and CTO, PingCAP Liquan Pei Senior Database Engineer, [&hellip;]<\/p>\n","protected":false},"featured_media":10240,"template":"","categories":[18],"tags":[155,147,16,156],"region":[216],"location":[205],"class_list":["post-6775","event","type-event","status-publish","has-post-thumbnail","hentry","category-community","tag-data-placement","tag-distributed-sql","tag-distributed-system","tag-queue","region-north-america","location-hybrid"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Data Placement and Queue in Distributed SQL Databases<\/title>\n<meta name=\"description\" content=\"Explore data placement and queue topics in this informative meetup. Gain valuable insights and expand your knowledge.\" \/>\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\/the-future-of-modern-distributed-sql-databases-data-placement-and-queue\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Placement and Queue in Distributed SQL Databases\" \/>\n<meta property=\"og:description\" content=\"Explore data placement and queue topics in this informative meetup. Gain valuable insights and expand your knowledge.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pingcap.com\/ko\/event\/the-future-of-modern-distributed-sql-databases-data-placement-and-queue\/\" \/>\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-22T05:58:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/static.pingcap.com\/files\/2022\/05\/69-cover-page.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1848\" \/>\n\t<meta property=\"og:image:height\" content=\"908\" \/>\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\/05\/69-cover-page.jpg\" \/>\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\/event\/the-future-of-modern-distributed-sql-databases-data-placement-and-queue\/\",\"url\":\"https:\/\/www.pingcap.com\/event\/the-future-of-modern-distributed-sql-databases-data-placement-and-queue\/\",\"name\":\"Data Placement and Queue in Distributed SQL Databases\",\"isPartOf\":{\"@id\":\"https:\/\/www.pingcap.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.pingcap.com\/event\/the-future-of-modern-distributed-sql-databases-data-placement-and-queue\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.pingcap.com\/event\/the-future-of-modern-distributed-sql-databases-data-placement-and-queue\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/static.pingcap.com\/files\/2022\/11\/30070816\/img24.jpg\",\"datePublished\":\"2022-06-01T05:47:23+00:00\",\"dateModified\":\"2024-08-22T05:58:05+00:00\",\"description\":\"Explore data placement and queue topics in this informative meetup. Gain valuable insights and expand your knowledge.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.pingcap.com\/event\/the-future-of-modern-distributed-sql-databases-data-placement-and-queue\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.pingcap.com\/event\/the-future-of-modern-distributed-sql-databases-data-placement-and-queue\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.pingcap.com\/event\/the-future-of-modern-distributed-sql-databases-data-placement-and-queue\/#primaryimage\",\"url\":\"https:\/\/static.pingcap.com\/files\/2022\/11\/30070816\/img24.jpg\",\"contentUrl\":\"https:\/\/static.pingcap.com\/files\/2022\/11\/30070816\/img24.jpg\",\"width\":1800,\"height\":600},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.pingcap.com\/event\/the-future-of-modern-distributed-sql-databases-data-placement-and-queue\/#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\":\"The Future of Modern Distributed SQL Databases: Data Placement and Queue\"}]},{\"@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":"Data Placement and Queue in Distributed SQL Databases","description":"Explore data placement and queue topics in this informative meetup. Gain valuable insights and expand your knowledge.","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\/the-future-of-modern-distributed-sql-databases-data-placement-and-queue\/","og_locale":"ko_KR","og_type":"article","og_title":"Data Placement and Queue in Distributed SQL Databases","og_description":"Explore data placement and queue topics in this informative meetup. Gain valuable insights and expand your knowledge.","og_url":"https:\/\/www.pingcap.com\/ko\/event\/the-future-of-modern-distributed-sql-databases-data-placement-and-queue\/","og_site_name":"TiDB","article_publisher":"https:\/\/facebook.com\/pingcap2015","article_modified_time":"2024-08-22T05:58:05+00:00","og_image":[{"width":1848,"height":908,"url":"https:\/\/static.pingcap.com\/files\/2022\/05\/69-cover-page.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_image":"https:\/\/static.pingcap.com\/files\/2022\/05\/69-cover-page.jpg","twitter_site":"@PingCAP","twitter_misc":{"Est. reading time":"3\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.pingcap.com\/event\/the-future-of-modern-distributed-sql-databases-data-placement-and-queue\/","url":"https:\/\/www.pingcap.com\/event\/the-future-of-modern-distributed-sql-databases-data-placement-and-queue\/","name":"Data Placement and Queue in Distributed SQL Databases","isPartOf":{"@id":"https:\/\/www.pingcap.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.pingcap.com\/event\/the-future-of-modern-distributed-sql-databases-data-placement-and-queue\/#primaryimage"},"image":{"@id":"https:\/\/www.pingcap.com\/event\/the-future-of-modern-distributed-sql-databases-data-placement-and-queue\/#primaryimage"},"thumbnailUrl":"https:\/\/static.pingcap.com\/files\/2022\/11\/30070816\/img24.jpg","datePublished":"2022-06-01T05:47:23+00:00","dateModified":"2024-08-22T05:58:05+00:00","description":"Explore data placement and queue topics in this informative meetup. Gain valuable insights and expand your knowledge.","breadcrumb":{"@id":"https:\/\/www.pingcap.com\/event\/the-future-of-modern-distributed-sql-databases-data-placement-and-queue\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pingcap.com\/event\/the-future-of-modern-distributed-sql-databases-data-placement-and-queue\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.pingcap.com\/event\/the-future-of-modern-distributed-sql-databases-data-placement-and-queue\/#primaryimage","url":"https:\/\/static.pingcap.com\/files\/2022\/11\/30070816\/img24.jpg","contentUrl":"https:\/\/static.pingcap.com\/files\/2022\/11\/30070816\/img24.jpg","width":1800,"height":600},{"@type":"BreadcrumbList","@id":"https:\/\/www.pingcap.com\/event\/the-future-of-modern-distributed-sql-databases-data-placement-and-queue\/#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":"The Future of Modern Distributed SQL Databases: Data Placement and Queue"}]},{"@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\/the-future-of-modern-distributed-sql-databases-data-placement-and-queue\/\"><div class=\"card-event__image-container\"><img class=\"card-event__image\" alt=\"img24\" src=\"https:\/\/static.pingcap.com\/files\/2022\/11\/30070816\/img24.jpg\" loading=\"lazy\" width=1800 height=600 \/><\/div><div class=\"card-event__content-container\"><div class=\"card-resource__content-status\"><div class=\"card-resource__status completed\">Completed<\/div><\/div><h5 class=\"card-resource__title\">The Future of Modern Distributed SQL Databases: Data Placement and Queue<\/h5><p class=\"card-resource__date\"><i class=\"icon-calendar-check\"><\/i>Jan 1 12:00 am - 12:00 am PDT<\/p><p class=\"card-resource__location\"><i class=\"icon-map-pin\"><\/i>Hybrid<\/p><\/div><\/a>","_links":{"self":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/event\/6775","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\/10240"}],"wp:attachment":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/media?parent=6775"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/categories?post=6775"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/tags?post=6775"},{"taxonomy":"region","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/region?post=6775"},{"taxonomy":"location","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/location?post=6775"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}