blob: 8c6d3d9304831bd6d32661a5a0214511566ef154 [file] [log] [blame]
<!doctype html>
<html lang="en" dir="ltr" class="docs-wrapper docs-doc-page docs-version-current plugin-docs plugin-id-default docs-doc-id-quick_start/data_sync/mysql_starrocks_example">
<head>
<meta charset="UTF-8">
<meta name="generator" content="Docusaurus v2.3.1">
<title data-rh="true">MySQL to StarRocks Example | Apache InLong</title><meta data-rh="true" name="viewport" content="width=device-width,initial-scale=1"><meta data-rh="true" name="twitter:card" content="summary_large_image"><meta data-rh="true" property="og:url" content="https://inlong.apache.org/docs/next/quick_start/data_sync/mysql_starrocks_example"><meta data-rh="true" name="docusaurus_locale" content="en"><meta data-rh="true" name="docsearch:language" content="en"><meta data-rh="true" name="docusaurus_version" content="current"><meta data-rh="true" name="docusaurus_tag" content="docs-default-current"><meta data-rh="true" name="docsearch:version" content="current"><meta data-rh="true" name="docsearch:docusaurus_tag" content="docs-default-current"><meta data-rh="true" property="og:title" content="MySQL to StarRocks Example | Apache InLong"><meta data-rh="true" name="description" content="Here we use an example to introduce how to use Apache InLong creating MySQL -&gt; StarRocks data synchronization."><meta data-rh="true" property="og:description" content="Here we use an example to introduce how to use Apache InLong creating MySQL -&gt; StarRocks data synchronization."><link data-rh="true" rel="icon" href="/img/logo.svg"><link data-rh="true" rel="canonical" href="https://inlong.apache.org/docs/next/quick_start/data_sync/mysql_starrocks_example"><link data-rh="true" rel="alternate" href="https://inlong.apache.org/docs/next/quick_start/data_sync/mysql_starrocks_example" hreflang="en"><link data-rh="true" rel="alternate" href="https://inlong.apache.org/zh-CN/docs/next/quick_start/data_sync/mysql_starrocks_example" hreflang="zh-CN"><link data-rh="true" rel="alternate" href="https://inlong.apache.org/docs/next/quick_start/data_sync/mysql_starrocks_example" hreflang="x-default"><link data-rh="true" rel="preconnect" href="https://YUW9QEL53E-dsn.algolia.net" crossorigin="anonymous"><link rel="alternate" type="application/rss+xml" href="/blog/rss.xml" title="Apache InLong RSS Feed">
<link rel="alternate" type="application/atom+xml" href="/blog/atom.xml" title="Apache InLong Atom Feed">
<link rel="search" type="application/opensearchdescription+xml" title="Apache InLong" href="/opensearch.xml">
<script src="https://www.apachecon.com/event-images/snippet.js" async></script><link rel="stylesheet" href="/assets/css/styles.c64edd51.css">
<link rel="preload" href="/assets/js/runtime~main.63c98e82.js" as="script">
<link rel="preload" href="/assets/js/main.070aef2a.js" as="script">
</head>
<body class="navigation-with-keyboard">
<script>!function(){function e(e){document.documentElement.setAttribute("data-theme",e)}var t=function(){var e=null;try{e=localStorage.getItem("theme")}catch(e){}return e}();null!==t?e(t):window.matchMedia("(prefers-color-scheme: dark)").matches?e("dark"):(window.matchMedia("(prefers-color-scheme: light)").matches,e("light"))}()</script><div id="__docusaurus">
<div role="region" aria-label="Skip to main content"><a class="skipToContent_fXgn" href="#docusaurus_skipToContent_fallback">Skip to main content</a></div><nav aria-label="Main" class="navbar navbar--fixed-top"><div class="navbar__inner"><div class="navbar__items"><button aria-label="Toggle navigation bar" aria-expanded="false" class="navbar__toggle clean-btn" type="button"><svg width="30" height="30" viewBox="0 0 30 30" aria-hidden="true"><path stroke="currentColor" stroke-linecap="round" stroke-miterlimit="10" stroke-width="2" d="M4 7h22M4 15h22M4 23h22"></path></svg></button><a class="navbar__brand" href="/"><div class="navbar__logo"><img src="/img/logo.svg" alt="Apache" class="themedImage_ToTc themedImage--light_HNdA"><img src="/img/logo.svg" alt="Apache" class="themedImage_ToTc themedImage--dark_i4oU"></div><b class="navbar__title text--truncate">Apache InLong</b></a></div><div class="navbar__items navbar__items--right"><div class="navbar__item dropdown dropdown--hoverable dropdown--right"><a class="navbar__link" aria-haspopup="true" aria-expanded="false" role="button" href="/docs/introduction">Docs</a><ul class="dropdown__menu"><li><a class="dropdown__link" href="/docs/next/introduction">Next</a></li><li><a class="dropdown__link" href="/docs/introduction">1.11.0</a></li><li><a class="dropdown__link" href="/docs/1.10.0/introduction">1.10.0</a></li><li><a class="dropdown__link" href="/docs/1.9.0/introduction">1.9.0</a></li><li><a class="dropdown__link" href="/docs/1.8.0/introduction">1.8.0</a></li><li><a class="dropdown__link" href="/versions/">All versions</a></li></ul></div><a class="navbar__item navbar__link" href="/downloads">Download</a><a class="navbar__item navbar__link" href="/community/how-to-contribute">Community</a><a class="navbar__item navbar__link" href="/blog">Blog</a><a class="navbar__item navbar__link" href="/team">Team</a><div class="navbar__item dropdown dropdown--hoverable dropdown--right"><a href="#" aria-haspopup="true" aria-expanded="false" role="button" class="navbar__link">ASF</a><ul class="dropdown__menu"><li><a href="https://www.apache.org/" target="_blank" rel="noopener noreferrer" class="dropdown__link">Apache Software Foundation</a></li><li><a href="https://www.apache.org/licenses/" target="_blank" rel="noopener noreferrer" class="dropdown__link">License</a></li><li><a href="https://www.apache.org/events/current-event" target="_blank" rel="noopener noreferrer" class="dropdown__link">Events</a></li><li><a href="https://www.apache.org/security/" target="_blank" rel="noopener noreferrer" class="dropdown__link">Security</a></li><li><a href="https://www.apache.org/foundation/sponsorship.html" target="_blank" rel="noopener noreferrer" class="dropdown__link">Sponsorship</a></li><li><a href="https://www.apache.org/foundation/policies/privacy.html" target="_blank" rel="noopener noreferrer" class="dropdown__link">Privacy</a></li><li><a href="https://www.apache.org/foundation/thanks.html" target="_blank" rel="noopener noreferrer" class="dropdown__link">Thanks</a></li></ul></div><div class="navbar__item dropdown dropdown--hoverable dropdown--right"><a href="#" aria-haspopup="true" aria-expanded="false" role="button" class="navbar__link"><svg viewBox="0 0 24 24" width="20" height="20" aria-hidden="true" class="iconLanguage_nlXk"><path fill="currentColor" d="M12.87 15.07l-2.54-2.51.03-.03c1.74-1.94 2.98-4.17 3.71-6.53H17V4h-7V2H8v2H1v1.99h11.17C11.5 7.92 10.44 9.75 9 11.35 8.07 10.32 7.3 9.19 6.69 8h-2c.73 1.63 1.73 3.17 2.98 4.56l-5.09 5.02L4 19l5-5 3.11 3.11.76-2.04zM18.5 10h-2L12 22h2l1.12-3h4.75L21 22h2l-4.5-12zm-2.62 7l1.62-4.33L19.12 17h-3.24z"></path></svg>English</a><ul class="dropdown__menu"><li><a href="/docs/next/quick_start/data_sync/mysql_starrocks_example" target="_self" rel="noopener noreferrer" class="dropdown__link dropdown__link--active" lang="en">English</a></li><li><a href="/zh-CN/docs/next/quick_start/data_sync/mysql_starrocks_example" target="_self" rel="noopener noreferrer" class="dropdown__link" lang="zh-CN">简体中文</a></li></ul></div><a href="https://github.com/apache/inlong" target="_blank" rel="noopener noreferrer" class="navbar__item navbar__link">GitHub<svg width="13.5" height="13.5" aria-hidden="true" viewBox="0 0 24 24" class="iconExternalLink_nPIU"><path fill="currentColor" d="M21 13v10h-21v-19h12v2h-10v15h17v-8h2zm3-12h-10.988l4.035 4-6.977 7.07 2.828 2.828 6.977-7.07 4.125 4.172v-11z"></path></svg></a><div class="toggle_vylO colorModeToggle_DEke"><button class="clean-btn toggleButton_gllP toggleButtonDisabled_aARS" type="button" disabled="" title="Switch between dark and light mode (currently light mode)" aria-label="Switch between dark and light mode (currently light mode)" aria-live="polite"><svg viewBox="0 0 24 24" width="24" height="24" class="lightToggleIcon_pyhR"><path fill="currentColor" d="M12,9c1.65,0,3,1.35,3,3s-1.35,3-3,3s-3-1.35-3-3S10.35,9,12,9 M12,7c-2.76,0-5,2.24-5,5s2.24,5,5,5s5-2.24,5-5 S14.76,7,12,7L12,7z M2,13l2,0c0.55,0,1-0.45,1-1s-0.45-1-1-1l-2,0c-0.55,0-1,0.45-1,1S1.45,13,2,13z M20,13l2,0c0.55,0,1-0.45,1-1 s-0.45-1-1-1l-2,0c-0.55,0-1,0.45-1,1S19.45,13,20,13z M11,2v2c0,0.55,0.45,1,1,1s1-0.45,1-1V2c0-0.55-0.45-1-1-1S11,1.45,11,2z M11,20v2c0,0.55,0.45,1,1,1s1-0.45,1-1v-2c0-0.55-0.45-1-1-1C11.45,19,11,19.45,11,20z M5.99,4.58c-0.39-0.39-1.03-0.39-1.41,0 c-0.39,0.39-0.39,1.03,0,1.41l1.06,1.06c0.39,0.39,1.03,0.39,1.41,0s0.39-1.03,0-1.41L5.99,4.58z M18.36,16.95 c-0.39-0.39-1.03-0.39-1.41,0c-0.39,0.39-0.39,1.03,0,1.41l1.06,1.06c0.39,0.39,1.03,0.39,1.41,0c0.39-0.39,0.39-1.03,0-1.41 L18.36,16.95z M19.42,5.99c0.39-0.39,0.39-1.03,0-1.41c-0.39-0.39-1.03-0.39-1.41,0l-1.06,1.06c-0.39,0.39-0.39,1.03,0,1.41 s1.03,0.39,1.41,0L19.42,5.99z M7.05,18.36c0.39-0.39,0.39-1.03,0-1.41c-0.39-0.39-1.03-0.39-1.41,0l-1.06,1.06 c-0.39,0.39-0.39,1.03,0,1.41s1.03,0.39,1.41,0L7.05,18.36z"></path></svg><svg viewBox="0 0 24 24" width="24" height="24" class="darkToggleIcon_wfgR"><path fill="currentColor" d="M9.37,5.51C9.19,6.15,9.1,6.82,9.1,7.5c0,4.08,3.32,7.4,7.4,7.4c0.68,0,1.35-0.09,1.99-0.27C17.45,17.19,14.93,19,12,19 c-3.86,0-7-3.14-7-7C5,9.07,6.81,6.55,9.37,5.51z M12,3c-4.97,0-9,4.03-9,9s4.03,9,9,9s9-4.03,9-9c0-0.46-0.04-0.92-0.1-1.36 c-0.98,1.37-2.58,2.26-4.4,2.26c-2.98,0-5.4-2.42-5.4-5.4c0-1.81,0.89-3.42,2.26-4.4C12.92,3.04,12.46,3,12,3L12,3z"></path></svg></button></div><div class="searchBox_ZlJk"><button type="button" class="DocSearch DocSearch-Button" aria-label="Search"><span class="DocSearch-Button-Container"><svg width="20" height="20" class="DocSearch-Search-Icon" viewBox="0 0 20 20"><path d="M14.386 14.386l4.0877 4.0877-4.0877-4.0877c-2.9418 2.9419-7.7115 2.9419-10.6533 0-2.9419-2.9418-2.9419-7.7115 0-10.6533 2.9418-2.9419 7.7115-2.9419 10.6533 0 2.9419 2.9418 2.9419 7.7115 0 10.6533z" stroke="currentColor" fill="none" fill-rule="evenodd" stroke-linecap="round" stroke-linejoin="round"></path></svg><span class="DocSearch-Button-Placeholder">Search</span></span><span class="DocSearch-Button-Keys"></span></button></div></div></div><div role="presentation" class="navbar-sidebar__backdrop"></div></nav><div id="docusaurus_skipToContent_fallback" class="main-wrapper mainWrapper_z2l0 docsWrapper_BCFX"><button aria-label="Scroll back to top" class="clean-btn theme-back-to-top-button backToTopButton_sjWU" type="button"></button><div class="docPage__5DB"><aside class="theme-doc-sidebar-container docSidebarContainer_b6E3"><div class="sidebarViewport_Xe31"><div class="sidebar_njMd"><nav aria-label="Docs sidebar" class="menu thin-scrollbar menu_SIkG"><ul class="theme-doc-sidebar-menu menu__list"><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-1 menu__list-item"><a class="menu__link" href="/docs/next/introduction">Introduction</a></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret" aria-expanded="false" href="/docs/next/design_and_concept/basic_concept">Design and Concept</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret menu__link--active" aria-expanded="true" href="/docs/next/quick_start/how_to_build">Quick Start</a></div><ul style="display:block;overflow:visible;height:auto" class="menu__list"><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/next/quick_start/how_to_build">How to Build</a></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-2 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret" aria-expanded="false" tabindex="0" href="/docs/next/quick_start/data_ingestion/file_pulsar_clickhouse_example">Data Ingestion</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-2 menu__list-item"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret menu__link--active" aria-expanded="true" tabindex="0" href="/docs/next/quick_start/data_sync/mysql_clickhouse_example">Data Synchronization</a></div><ul style="display:block;overflow:visible;height:auto" class="menu__list"><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/next/quick_start/data_sync/mysql_clickhouse_example">MySQL to ClickHouse Example</a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class="menu__link menu__link--active" aria-current="page" tabindex="0" href="/docs/next/quick_start/data_sync/mysql_starrocks_example">MySQL to StarRocks Example</a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/next/quick_start/data_sync/mysql_iceberg_example">MySQL to Iceberg Example</a></li></ul></li></ul></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret" aria-expanded="false" href="/docs/next/deployment/standalone">Deployment</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret" aria-expanded="false" href="/docs/next/modules/agent/overview">Components</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret" aria-expanded="false" href="/docs/next/data_node/extract_node/overview">Data Nodes</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret" aria-expanded="false" href="/docs/next/sdk/dataproxy-sdk/cpp">SDK</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret" aria-expanded="false" href="/docs/next/user_guide/dashboard_usage">User Guide</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret" aria-expanded="false" href="/docs/next/development/inlong_msg">Development</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret" aria-expanded="false" href="/docs/next/administration/user_management">Administration</a></div></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-1 menu__list-item"><a class="menu__link" href="/docs/next/contact">Contact Us</a></li></ul></nav></div></div></aside><main class="docMainContainer_gTbr"><div class="container padding-top--md padding-bottom--lg"><div class="row"><div class="col docItemCol_VOVn"><div class="theme-doc-version-banner alert alert--warning margin-bottom--md" role="alert"><div>This is unreleased documentation for <!-- -->Apache InLong<!-- --> <b>Next</b> version.</div><div class="margin-top--md">For up-to-date documentation, see the <b><a href="/docs/quick_start/data_sync/mysql_starrocks_example">latest version</a></b> (<!-- -->1.11.0<!-- -->).</div></div><div class="docItemContainer_Djhp"><article><nav class="theme-doc-breadcrumbs breadcrumbsContainer_Z_bl" aria-label="Breadcrumbs"><ul class="breadcrumbs" itemscope="" itemtype="https://schema.org/BreadcrumbList"><li class="breadcrumbs__item"><a aria-label="Home page" class="breadcrumbs__link" href="/"><svg viewBox="0 0 24 24" class="breadcrumbHomeIcon_YNFT"><path d="M10 19v-5h4v5c0 .55.45 1 1 1h3c.55 0 1-.45 1-1v-7h1.7c.46 0 .68-.57.33-.87L12.67 3.6c-.38-.34-.96-.34-1.34 0l-8.36 7.53c-.34.3-.13.87.33.87H5v7c0 .55.45 1 1 1h3c.55 0 1-.45 1-1z" fill="currentColor"></path></svg></a></li><li class="breadcrumbs__item"><span class="breadcrumbs__link">Quick Start</span><meta itemprop="position" content="1"></li><li class="breadcrumbs__item"><span class="breadcrumbs__link">Data Synchronization</span><meta itemprop="position" content="2"></li><li itemscope="" itemprop="itemListElement" itemtype="https://schema.org/ListItem" class="breadcrumbs__item breadcrumbs__item--active"><span class="breadcrumbs__link" itemprop="name">MySQL to StarRocks Example</span><meta itemprop="position" content="3"></li></ul></nav><span class="theme-doc-version-badge badge badge--secondary">Version: Next</span><div class="tocCollapsible_ETCw theme-doc-toc-mobile tocMobile_ITEo"><button type="button" class="clean-btn tocCollapsibleButton_TO0P">On this page</button></div><div class="theme-doc-markdown markdown"><header><h1>MySQL to StarRocks Example</h1></header><p>Here we use an example to introduce how to use Apache InLong creating <code>MySQL -&gt; StarRocks</code> data synchronization.</p><h2 class="anchor anchorWithStickyNavbar_LWe7" id="deployment">Deployment<a href="#deployment" class="hash-link" aria-label="Direct link to Deployment" title="Direct link to Deployment"></a></h2><h3 class="anchor anchorWithStickyNavbar_LWe7" id="install-inlong">Install InLong<a href="#install-inlong" class="hash-link" aria-label="Direct link to Install InLong" title="Direct link to Install InLong"></a></h3><p>Before we begin, we need to install InLong. Here we provide two ways:</p><ul><li><a href="/docs/next/deployment/docker">Docker Deployment</a> (Recommended)</li><li><a href="/docs/next/deployment/bare_metal">Bare Metal Deployment</a></li></ul><h3 class="anchor anchorWithStickyNavbar_LWe7" id="add-connectors">Add Connectors<a href="#add-connectors" class="hash-link" aria-label="Direct link to Add Connectors" title="Direct link to Add Connectors"></a></h3><p>Download the <a href="https://inlong.apache.org/downloads/" target="_blank" rel="noopener noreferrer">connectors</a> corresponding to Flink version, and after decompression, place <code>sort-connector-starrocks-[version]-SNAPSHOT.jar</code> in <code>/inlong-sort/connectors/</code> directory.</p><h3 class="anchor anchorWithStickyNavbar_LWe7" id="install-starrocks">Install StarRocks<a href="#install-starrocks" class="hash-link" aria-label="Direct link to Install StarRocks" title="Direct link to Install StarRocks"></a></h3><p>Please refer to the <a href="https://docs.starrocks.io/docs/quick_start/" target="_blank" rel="noopener noreferrer">Installation Tutorial</a> on the Apache StarRocks official website</p><h2 class="anchor anchorWithStickyNavbar_LWe7" id="cluster-initialize">Cluster Initialize<a href="#cluster-initialize" class="hash-link" aria-label="Direct link to Cluster Initialize" title="Direct link to Cluster Initialize"></a></h2><p>When all containers are successfully started, you can access the InLong dashboard address http://localhost, and use the following default account to log in.</p><div class="codeBlockContainer_Ckt0 theme-code-block" style="--prism-color:#F8F8F2;--prism-background-color:#282A36"><div class="codeBlockContent_biex"><pre tabindex="0" class="prism-code language-text codeBlock_bY9V thin-scrollbar"><code class="codeBlockLines_e6Vv"><span class="token-line" style="color:#F8F8F2"><span class="token plain">User: admin</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain">Password: inlong</span><br></span></code></pre><div class="buttonGroup__atx"><button type="button" aria-label="Copy code to clipboard" title="Copy" class="clean-btn"><span class="copyButtonIcons_eSgA" aria-hidden="true"><svg class="copyButtonIcon_y97N" viewBox="0 0 24 24"><path d="M19,21H8V7H19M19,5H8A2,2 0 0,0 6,7V21A2,2 0 0,0 8,23H19A2,2 0 0,0 21,21V7A2,2 0 0,0 19,5M16,1H4A2,2 0 0,0 2,3V17H4V3H16V1Z"></path></svg><svg class="copyButtonSuccessIcon_LjdS" viewBox="0 0 24 24"><path d="M21,7L9,19L3.5,13.5L4.91,12.09L9,16.17L19.59,5.59L21,7Z"></path></svg></span></button></div></div></div><h3 class="anchor anchorWithStickyNavbar_LWe7" id="create-cluster-tag">Create Cluster Tag<a href="#create-cluster-tag" class="hash-link" aria-label="Direct link to Create Cluster Tag" title="Direct link to Create Cluster Tag"></a></h3><p>Click <!-- -->[Clusters]<!-- --> -&gt; <!-- -->[ClusterTags]<!-- --> -&gt; <!-- -->[Create]<!-- --> on the page to specify the cluster label name and responsible person.
<img loading="lazy" alt="Create Cluster Tag" src="/assets/images/create_cluster_tag-83079ba435eef25964075381c405c176.png" width="532" height="373" class="img_ev3q"></p><div class="theme-admonition theme-admonition-caution alert alert--warning admonition_LlT9"><div class="admonitionHeading_tbUL"><span class="admonitionIcon_kALy"><svg viewBox="0 0 16 16"><path fill-rule="evenodd" d="M8.893 1.5c-.183-.31-.52-.5-.887-.5s-.703.19-.886.5L.138 13.499a.98.98 0 0 0 0 1.001c.193.31.53.501.886.501h13.964c.367 0 .704-.19.877-.5a1.03 1.03 0 0 0 .01-1.002L8.893 1.5zm.133 11.497H6.987v-2.003h2.039v2.003zm0-3.004H6.987V5.987h2.039v4.006z"></path></svg></span>caution</div><div class="admonitionContent_S0QG"><p><code>default_cluster</code> is the default ClusterTags reported by each component. If you decide to use a different name, make sure to update the corresponding tag configuration accordingly.</p></div></div><h3 class="anchor anchorWithStickyNavbar_LWe7" id="register-pulsar-cluster">Register Pulsar Cluster<a href="#register-pulsar-cluster" class="hash-link" aria-label="Direct link to Register Pulsar Cluster" title="Direct link to Register Pulsar Cluster"></a></h3><p>Click <!-- -->[Clusters]<!-- --> -&gt; <!-- -->[Cluster]<!-- --> -&gt; <!-- -->[Create]<!-- --> on the page to register Pulsar Cluster.
<img loading="lazy" alt="Create Pulsar Cluster" src="/assets/images/create_pulsar_cluster-8931f8b43da437e42a266e4443003b48.png" width="527" height="650" class="img_ev3q"></p><div class="theme-admonition theme-admonition-note alert alert--secondary admonition_LlT9"><div class="admonitionHeading_tbUL"><span class="admonitionIcon_kALy"><svg viewBox="0 0 14 16"><path fill-rule="evenodd" d="M6.3 5.69a.942.942 0 0 1-.28-.7c0-.28.09-.52.28-.7.19-.18.42-.28.7-.28.28 0 .52.09.7.28.18.19.28.42.28.7 0 .28-.09.52-.28.7a1 1 0 0 1-.7.3c-.28 0-.52-.11-.7-.3zM8 7.99c-.02-.25-.11-.48-.31-.69-.2-.19-.42-.3-.69-.31H6c-.27.02-.48.13-.69.31-.2.2-.3.44-.31.69h1v3c.02.27.11.5.31.69.2.2.42.31.69.31h1c.27 0 .48-.11.69-.31.2-.19.3-.42.31-.69H8V7.98v.01zM7 2.3c-3.14 0-5.7 2.54-5.7 5.68 0 3.14 2.56 5.7 5.7 5.7s5.7-2.55 5.7-5.7c0-3.15-2.56-5.69-5.7-5.69v.01zM7 .98c3.86 0 7 3.14 7 7s-3.14 7-7 7-7-3.12-7-7 3.14-7 7-7z"></path></svg></span>note</div><div class="admonitionContent_S0QG"><p>The ClusterTags selects the newly created <code>default_cluster</code>, the Pulsar cluster deployed by docker:</p><p>Service URL is <code>pulsar://pulsar:6650</code>, Admin URL is <code>http://pulsar:8080</code>.</p></div></div><h3 class="anchor anchorWithStickyNavbar_LWe7" id="register-starrocks-datanodes">Register StarRocks DataNodes<a href="#register-starrocks-datanodes" class="hash-link" aria-label="Direct link to Register StarRocks DataNodes" title="Direct link to Register StarRocks DataNodes"></a></h3><p>Click <!-- -->[DataNodes]<!-- --> -&gt; <!-- -->[Create]<!-- --> on the page to register StarRocks DataNodes.
<img loading="lazy" alt="Create StarRocks DataNode" src="/assets/images/create_starrocks_datanode-131ae4e7246dc203128eac941bd33e50.png" width="729" height="593" class="img_ev3q"></p><div class="theme-admonition theme-admonition-note alert alert--secondary admonition_LlT9"><div class="admonitionHeading_tbUL"><span class="admonitionIcon_kALy"><svg viewBox="0 0 14 16"><path fill-rule="evenodd" d="M6.3 5.69a.942.942 0 0 1-.28-.7c0-.28.09-.52.28-.7.19-.18.42-.28.7-.28.28 0 .52.09.7.28.18.19.28.42.28.7 0 .28-.09.52-.28.7a1 1 0 0 1-.7.3c-.28 0-.52-.11-.7-.3zM8 7.99c-.02-.25-.11-.48-.31-.69-.2-.19-.42-.3-.69-.31H6c-.27.02-.48.13-.69.31-.2.2-.3.44-.31.69h1v3c.02.27.11.5.31.69.2.2.42.31.69.31h1c.27 0 .48-.11.69-.31.2-.19.3-.42.31-.69H8V7.98v.01zM7 2.3c-3.14 0-5.7 2.54-5.7 5.68 0 3.14 2.56 5.7 5.7 5.7s5.7-2.55 5.7-5.7c0-3.15-2.56-5.69-5.7-5.69v.01zM7 .98c3.86 0 7 3.14 7 7s-3.14 7-7 7-7-3.12-7-7 3.14-7 7-7z"></path></svg></span>note</div><div class="admonitionContent_S0QG"><ul><li>Please do not fill in <code>http://</code> for LOAD URL, just fill in <code>IP:PORT</code>.</li></ul></div></div><h2 class="anchor anchorWithStickyNavbar_LWe7" id="create-task">Create Task<a href="#create-task" class="hash-link" aria-label="Direct link to Create Task" title="Direct link to Create Task"></a></h2><h3 class="anchor anchorWithStickyNavbar_LWe7" id="create-data-streams-group">Create Data Streams Group<a href="#create-data-streams-group" class="hash-link" aria-label="Direct link to Create Data Streams Group" title="Direct link to Create Data Streams Group"></a></h3><p>Click <!-- -->[Synchronization]<!-- --><!-- -->[Create]<!-- --> on the page and input the Group ID, Stream ID and Full database migration:
<img loading="lazy" alt="Create Group Stream" src="/assets/images/create_group_stream-059a25f60385e00ee92ee4087228b128.png" width="1537" height="416" class="img_ev3q"></p><h3 class="anchor anchorWithStickyNavbar_LWe7" id="create-data-source">Create Data Source<a href="#create-data-source" class="hash-link" aria-label="Direct link to Create Data Source" title="Direct link to Create Data Source"></a></h3><p>In the data source, click <!-- -->[New]<!-- --><!-- -->[MySQL]<!-- --> to configure the source name, address, databases and tables information.
<img loading="lazy" alt="Create Stream_Source" src="/assets/images/create_source-da4e632f787d0e4e0def0b7ffb0833fc.png" width="675" height="635" class="img_ev3q"></p><div class="theme-admonition theme-admonition-note alert alert--secondary admonition_LlT9"><div class="admonitionHeading_tbUL"><span class="admonitionIcon_kALy"><svg viewBox="0 0 14 16"><path fill-rule="evenodd" d="M6.3 5.69a.942.942 0 0 1-.28-.7c0-.28.09-.52.28-.7.19-.18.42-.28.7-.28.28 0 .52.09.7.28.18.19.28.42.28.7 0 .28-.09.52-.28.7a1 1 0 0 1-.7.3c-.28 0-.52-.11-.7-.3zM8 7.99c-.02-.25-.11-.48-.31-.69-.2-.19-.42-.3-.69-.31H6c-.27.02-.48.13-.69.31-.2.2-.3.44-.31.69h1v3c.02.27.11.5.31.69.2.2.42.31.69.31h1c.27 0 .48-.11.69-.31.2-.19.3-.42.31-.69H8V7.98v.01zM7 2.3c-3.14 0-5.7 2.54-5.7 5.68 0 3.14 2.56 5.7 5.7 5.7s5.7-2.55 5.7-5.7c0-3.15-2.56-5.69-5.7-5.69v.01zM7 .98c3.86 0 7 3.14 7 7s-3.14 7-7 7-7-3.12-7-7 3.14-7 7-7z"></path></svg></span>note</div><div class="admonitionContent_S0QG"><ul><li>When the read mode is selected as <code>Full + Incremental</code>, the existing data in the table will also be collected, but not in the <code>Incremental</code> mode.</li><li>The table white list format is <code>&lt;dbName&gt;.&lt;tableName&gt;</code> and supports regular expressions.</li></ul></div></div><h3 class="anchor anchorWithStickyNavbar_LWe7" id="create-data-sink">Create Data Sink<a href="#create-data-sink" class="hash-link" aria-label="Direct link to Create Data Sink" title="Direct link to Create Data Sink"></a></h3><p>In the data sink, click <!-- -->[New]<!-- --><!-- -->[StarRocks]<!-- --> to configure the sink name, database name, table name and created StarRocks data node.</p><p><img loading="lazy" alt="Create data object" src="/assets/images/create_sink-08c2a0e1b950e2a5ec0132ccb20d2b0f.png" width="1210" height="400" class="img_ev3q"></p><h3 class="anchor anchorWithStickyNavbar_LWe7" id="approve-data-stream">Approve Data Stream<a href="#approve-data-stream" class="hash-link" aria-label="Direct link to Approve Data Stream" title="Direct link to Approve Data Stream"></a></h3><p>Click <!-- -->[Approval]<!-- --> -&gt; <!-- -->[MyApproval]<!-- --> -&gt; <!-- -->[Approval]<!-- --> -&gt; <!-- -->[Ok]<!-- -->.</p><p><img loading="lazy" alt="Approve" src="/assets/images/approve-a3a25765c5d535ba250cd80156b1f315.png" width="2274" height="706" class="img_ev3q"></p><p>Back to <!-- -->[Synchronization]<!-- --> page, wait for <!-- -->[success]<!-- -->.</p><p><img loading="lazy" alt="Success" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAACFMAAABGCAIAAACFCN46AAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAEXRFWHRTb2Z0d2FyZQBTbmlwYXN0ZV0Xzt0AABrXSURBVHic7d1/VFTnuejxRxQY0GGEHsMPf8DFEDTx0ErAnsWJmui1JybEWJqz0o4xXTfHalOXaEjS5nJWFfUcmxNrlLnLNlpN14kNtz8MpQZj7uKI8Sbl9iglhksTFZmLglDUOA4jMIDg/eOd7Bln9sCo/Bgm38/yD+bl3Xu/e4YZZz/Pfp93XEdHhwyot7fXZDIN3AcAAAAAAAAAACAYhI32AAAAAAAAAAAAAIYMmQ8AAAAAAAAAABA6Jozkwex2+0geDgAAAAAAAAAAfNmMaOaD9UIAAAAAAAAAAMCwotoVAAAAAAAAAAAIHWQ+AAAAAAAAAABA6CDzAQAAAAAAAAAAQgeZDwAAAAAAAAAAEDrIfAAAAAAAAAAAgNBB5gMAAAAAAAAAAIQOMh8AAAAAAAAAACB0kPkAAAAAAAAAAAChg8wHAAAAAAAAAAAIHWQ+AAAAAAAAAABA6CDzAQAAAAAAAAAAQgeZDwAAAAAAAAAAEDrIfAAAAAAAAAAAgNBB5gMAAAAAAAAAAIQOMh8AAAAAAAAAACB0kPkAAAAAAAAAAAChg8wHAAAAAAAAAAAIHWQ+AAAAAAAAAABA6CDzAQAAAAAAAAAAQgeZDwAAAAAAAAAAEDomjPYAAABA6Ou/ebOrr7e7v7e3v7/vZv9oD+dujR8XFh4WFhkWHjU+PGzcuNEeDgAAAAAAuAWZDwAAMLzae53Xb3SP9iiGUt/N/r6+fmffDXtv16QJkTHhhtEeEQAAAAAAcCPzAQAAhsuNm/22ns7e/r7RHsgwun6ju7v/RmxE9IRxFBEFAAAAACAocIkOAACGxY2b/Z93d4R22kPp7e/7vLvjxtiv4gUAAAAAQGhgzgcAABgWtp5Of0t6XO3p3F3/0aftbZ+1t4nI7Jj4+2Pi16Y9FBcRPbJjHDJ9N/ttPZ1TIieN9kAAAAAAAICM6+joGLhHb2+vyWQamdEAAIDQMMDaHv/5+fnnTv76Wk+XV/vkiKg3s7/99a8kD//ohgtrfgAAAAAAEAyodjWaaprE/Etx+MSFapokrUjK67zbV5fIEz/37u+vMzDWlZWVWSyWADtbrdaVK1dardZhHRKAAPXfvOkv7fHbplN5f/ylb9pDRK71dOX98Ze/bTo18M431b0/9VCR+rep7v0hGO7QuX6ju//mzdEeBYA75HQ6CwsLU1JSUlJSCgsLnU6nb3tZWZnWv6ysTDUuXbpU+xJitVqXLl2q2gP5JmOxWKqrqwfepz82m62wsNBms/mO09/R/Z2L56E9z12prq7Wdus5MK392Wef1YYx6D4tFkvg5wgMLYvF4vWXP4CysjLftwOCls1mW7duXeCfKhaLJfDrTQQVFQeLf8X9b0hiYjuOumJure2ycKfUNAW6YXndLYNJKxp82/I6nfjeMNlx1D22HUdH4oji85ysLhmh4w5qJJ95BINgz3zsOHonb48722qErS6RpbvFofcl6o0Ppd2nvaZJjp0NtDPwZZOamnrgwIHU1NTRHggAEZGuvl7d9qbOa/9c+97A2/5z7XtNndf8/XbFn3517vqVi8uKLi4r+sujPzKGR97VQIeBv3MHEPzq6ury8vIaGxsbGxsTEhL27t2r2vfu3ZuQkNDY2Pjxxx+XlpaqRIXNZuvq6lKdt27dWlRUpEL/DQ0Nu3fvVp2rq6s9sxpeVI7k9ddf11r87VNXWVnZ3Llzm5ubtZauri6Hw1FZWan2kJ+f77uV7rmIiMViOXHixOnTpxsbG7dt22Yw3DJ9rbm5uaCgQO32yJEj6huX1WotLi5Wh8vLy9u+fbtvvqS0tPTjjz/2fD5tNtuUKVPUrtasWbNv3z7Cyghay5cv9307IGTk5+frfk5iTEgyyalCaXtV2l6VI2vlhYODhAEDSWa8uFjefV6Md3R5MS9Zzm12jWfnU7J0993mGIYqsLm6RM60uQZ2brPEGEREappk4U5pbR+C/Q/A8znZax6uo9xumgpfNsGe+QhV6vNr/zM6v6ppkla7zIr3bn/jQ3nkvkA7AwAwirr79aP/bzWe7Ozr8W1PnfSVgvSH1c+dfT1vNZ7U3fxaT9cl5/XHE+9XDydHRL2U/sgQDHdI+Tt3AMEvKysrKytL/Zybm1tfX2+z2Ww2W319fW5urojExsbm5eVVVVWpn7/zne+oznPmzJk2bVpDQ4OILFmyRCUGYmNjs7KyPDMTnqxW66ZNm3bs2GE2u4MB/vbpq6ys7MSJE++9955XXWKj0RgbG+vvBP2di9Vqra+vf/nllweI8M6YMcOrpba2Njs7W53swoULHQ5HS0uLZ4eqqqq8vDw1Hu359DzHjIwMh8PR1aUzCxAAgABlTpf/XSBn2oIl/J07R46slUO1w55aGJSjW1rtsizD9dAYKd/7+1EdEDDigjrzsbpEXquQP9S6Z661tkvmq95TtLR5W5mvSmu7zla+tFlXT/xcig678hAqT1h02D0Py/Nwaufik07U5kmp9vI61yYDz27ba9ZPeDq6ZVO5mLNdaVjPAbfavTMf/joDwc9msz377LO+1Q88ayZ8/vnnWud169ZVVFSo2hFlZWXa5lppBW1qs6rhUFFRoTpQRQEYFb39+gub1zsu67a/9tUnPItE+es2OSLqHsOkw62ferUfv9yQc9RyvuOqerip7v0Vf/qV+vlaT9eSD95QpbGWfPCGqrK14k+/Ui1f+18/VVuVnK9RLWmHtx2/3KDtx6ubtqG2q8DPHcDYcvXqVaPRGBUV1dDQYDQak5KSVHtGRoaK4Ht2VpMt4uLiPBtVOmHhwoW6+x90uqruPjW6t6LbbDaHwzHASfk7l9ra2sWLF3ulTDxLiV64cMFrV06n88SJEzk5OephbGxsWlpabW2t+iamvq3V19dnZLjCLUlJSUaj0SuRU15e7ntc4I75u8TwrLqmLXRaXV1dWFhYUlKiXTJoVyJaBSTVx+l0cokRDLTXMSUlRZuv5lnBr7S01LOzKmalXTNqm2vlzrTqyp5/DAEWKkSwSYyR9Hh3oRSvOGFNkyx4XU63ydLd7gieFu7Tah8NYR2ktHskxiB/viAi4uiWJ34+UNEn31BngOHQQRkjJdEkh2pvaSyvk6W75XSbfG2bazyeI9SCmarxf1a7f3WXJcXUKaidqJ37hl49T82zXlZ5nfc8FTUnxveVFZ9Xf9Ah+Xb2fEJ+8UfmlIxtQZ352GuWHy6RJzOk7VXJnSOt7fL4z2RLrrS9KqcK5VCt1DRJTZMcqnXNcdu/QmcrX+V1srHctcnmXHnb475SR7e02F3zsNThVmS7ZmatyJbVbw/yCejolo3lcvgHrtltq96+7QTv3o8k0SS5f3tLY2u7bK+QzbliNAzeGRgTGhoa8vPzVaWF5ubmuro6EamurrZYLKokQlFR0cGDB7X+drv92LFjv//97ysrK/fs2bN+/fri4uLTp09Pmzbt+PHjvvs/cOBAcXFxY2Pj0qVLqaIAjLy+m/rR/1p7q/ohwRDzYvrDC6bMFJHC+/9rb3/frrPHfbv52p35rUvO61MPFZWcrxl0GNd6uv6x6t9z/iZFVcf6h8R0EVFJEdXy/L05IlJyvua105VVi/MvLivaPOfRf/lLxbWeruOXGyrazqrG/5GZp7pdcl7/y6M/urisaP1982/33AGMIU6ns7S0dN68eQFWuTl+/LiWUdDCcPv27du+ffsdh/U99xm4c+fOzZ07V3etjgFcuHBh4sSJWshYt0LXhg0bBvjtbdHiyzk5OcuXL7/LvQEa3UsMNUFKVXLLy8vbs2eP1r+kpCQ6OloVXlu0aFFVVVVjY2NlZeXJkyd1ExtcYowip9PZ2dmpXsddu3aVlpaqjNSWLVvmzZunCuh1dHScO3dO2+T111/PyclpbGzMysqaO3euiDQ2Nh48eLC0tNS3kKD2x1BZWXnkyJG7/6DDyEuPlzNtIiI7jsoHZ111llZky6Zy16SQWfFyZK2rntWfL7ijixftcrx+iAejUg5n2sTRLeY35eH7XMWmWu3e+QPdUGcg4dAA7fiWtNpvyVuoKSmz4uVUoew1u0aYaHKX6vIMZm4sl825rpJiG9+9vQTAifNy7yZ36iIxRvatkO0V0truesJ3fMvvqXlGbo+s9VuCzPeV9X31/fEX9fV8ydpelZPnpcV+G2eNYBPUmQ8vf74gU02yME1EJDFGlmW40rkOp7TaRUTmTpfEmMH3c6hWVmS7emZOl+97xC6Mke6H6nCrH3I9NGdLu1PqLw20Z2Ok7Fvh2vPCNJlqciV4A6SyOJtzvds3lcuyDMmcHlBnYEzQqkl4FoLwLImQmpq6Zs0arb/JZFq1apXBYEhKSpo7d67qZjAY5s2b53sToojk5+drpRWoogAEob862z9tb3tp1iPfSEhflfp3r3zi/zvprSZHRFU8/P2qxfmvna7UpmL4817rZyLywn2uG65fSn/kE3vL/+u4uu1vH1Mta2bmJE+MO9z66ZNT5yRPjBORxxJnT5wQ8Ym9RUQ6bnQ3dtpEZP6UVPXby93X7b1dIpKb9MDkiKg7O3cAQU6F0hISEgIMypeVlZWWlmqlogwGw7Zt2xobG1etWvXNb37zzsJnXvsMUGpq6pEjR7R1SrZs2RJ4ZFYL6VZWVhYXF1utVs9ZKSqarH774x//eICTUqc/8FOXlZWl9lZVVcXy0RhCvpcYanJSXl6eeitlZWUVFBRo/c1m86OPPioiGRkZ8+fPV4XgkpKSpk+ffvWqzhcMLjFGkcFgMJvN6nXUCuW1tLQ4HA5tat3KlSvvvfdebZOCggL195CTk7NgwQLVbebMmSaTyTfzof0xpKamLl261F+hQgQ/R7d8cFbWzHfFys3Z0mrXuSk5d47rVunEGMma4UqZDIf6S9LuFHO2iIgxUtbM956B4S/Uebt9/DFGyrvPy6lC2ViuPwdCjVCLLnoFM3c+5YpGZk6XrOTbOK7cus6HerYzp0t6vPz0P764vTtS/9Qc3bLnQ9mS647cqg6DCvDVV/xFfT1fMhHZnCtJJv09YEyYMNoDuA1n2lwJQ82TGfLiYtn3jDy9X9qdsv8Z/UkenryK3A18uESTO684KVJiDNJil8TA/uJVgjdwre2y6m3XG9tzZsmOo9Jqlx3fCqgzMFaomEJJiWuq565du5xO51//+letZoI/BoMhISFh2rRpwz9GAHdu/Lgw3akPGabECqerEsuR1s++NnnqurT5L506dL7T5tVt4P0nT4w79Q8vbap7f9XJ3/4u57v+up1xXLrHMMkzRXGx0z5xfIQp3N2i1g754NK5fdY/eXYzJ2daMvNWnfhNZ1/P9q8uMydnmpMzRSTnqCV6fMS+eU8vnDLT37kPPHgAwcxqta5du3br1q3agh++kpKSoqKixCNH8tZbb/l2S01N3bp1a2lp6Zw5c1paWtauXfvZZ5+JSEFBwQBr6urus6ysbMOGDerngwcPDjA2zcqVKzdu3NjS0jJAQS3Pc/G8+yQ7O7u2tlZ3Q3VvSlVV1Zw5OtddA39DMxqNXsW7Vq9evWXLlrq6ukDOCBiU7yXGwFXjNLGxsdOnT6fwWpCrrq5+6qmn1M8LFiwQj7KEA28YFxc3e/bsQbthrDvTJunxcr1bLtrln37lbo8xSKtPKE/d13/ivOvhD5cM8WC02GOL3VVXSjMv+ZY4nm6o00sgfQaWGCM1r8iOo7L6bSl57pZftdglxiCTvgh+arNVfJMN6UOxxvDmXNdMC5VQ0T21693S7ryTfIPfV1/vLnl/UV+11aQ7WugeQWgsZT7S4+XJDJ3lMTKnS32Ra5qSyODJDxE50+bu5i+1mx4vH5wVR7f7bWA03MYbT33MBe7PF+TitVvenyfOy+MPyOXr3p8CmT+RdQ/rdNZ9coAgpK5J8vLytm3bJiKqjqpKaTQ3N2uXvrqTOQCMCeFhYX19OpmPNOOUijb3nUI/+ew/8qZllDbX+nYL5CiL4tMq2s6qSRi60o33VF1pvNbTpSU/pkabOvp67L3uFrV2yH/7L8tUYsPTwikz6x8vPN9x9cmP3hQRlfwwJ2cev9yQX1NqyczTTX6Eh5H5AMYqq9W6c+fOkpISzwBoXFycurlY3WtcW1s7ceJEg8GgfZ8JJGqvZmMM2s3fPpcvX34HVaF8Vzv3dy6+q5cPbMaMGV7f3DzXTleioqKMRuPVq1dVBqWlpaWlpYXIMoaP7iWG19+hutfqdv/gEQyqq6tLS0tPnz5tMBjUZ7X4fKbZbLZr166N9kgxOmqa5EybbM6VSZEyK172rfCum+J5479Ke6yZL+8+LyL6a2/cJVXNaWGa1F+Sxemyx+y3XpO/UOft9gnEI/fJoVq5fuv900kmaXfK9e5bRqib5FC5pbtUclJmxcuhWjFnu1Zn8T01R7crCeH1Ig7K36uvy1/Ut8UuF+3uJ6TVLg7mpo5lY+ni/MEZUn3BuyJeeZ2rZVKkTA0gLWGMlIfvk7dPuj71apr8ztV6cIZctMvej1wP934kDqek3eNKA6qtWttlo0d9Dke3vPGhu79IoBOyRCR3jmsKmKr9Ny9Z9j8jb66Ud593t+9/RuYlS81/l/yHdTqT9sBY4Xnvlc1m0womzJgxQyu6arVaAwkQAAhOkWHhuu3PpmRHj4/wbPFNe0SPj3g2JVv0XOvpKjj1B21p8cq2ejWBIyU6tvNGzx+vNIrI8csN2hIgf/83KZe7r+/8YgWRn545lhIdN3F8ROH/fU+17GmoOt9x9fHE+187XelVOKvkfI3ajyk8akrkJLW5Wvw8JTp24gS/dwH5O3cAwU93we3U1NS0tLQDBw6IiM1mKy0tVVNU1RICXlMfnE5nSUmJKt9ks9ksFkvgi4X422fgPv30U21xggMHDiQkJAR4LhkZGe+8847a1mq1njx5MiMjQ1vh3Ol0VlRUqD1YrdZ33nlHrVuem5urbaWtSqKtcG4wGPLy8iwWi/pqV15enpaWFhsbW11drX33e//995ubm2fO1J9CB9wW3UsMlaJTa0KISF1dnTYjBGNLc3NzQkKClrW12+0iEhsba7fbtXUfy8vLr1y5MpqjxChRS3a/vEQSY8QYKQ/OkE3lA9VH8ZxS0Nou1UN9y+WOo/LCQVc1p7R7xOF0hxZ96YY676CPLke3FB12PxXHzurMZlCLsWvrYZTXSfUFefCLBPGeD93Lv1dfcNeAujPldfLBWdljlmUZriPqnpqK3G4sd0duj9dLokkc3a4yXDVN7uir14aDvvoaf1Ffde4lX6wJ/caH1NoZ24J9zoc5Wx7/mcS/4qpktW+FPL3fNdchxiC/+SdJMrlbfrjENZPDaysvLy6WM1/MNZuXLCuy9RerSYyRwz+Qx38mr1W4epY858r4bc6Vp/fLaxUydbI871GkzxgpSSaJf0VEZOpkOfwDv0ld4MssNjZ28eLFixYtEpEFCxZohRHUzYxq9Tmz2bxy5Uq+uQJjVNT4cN2pGNOjJ/9rxmMvfFw2wLb/mvHY9OjJur+aHBHV5nQ88P6/qYf3xyT8Lue7kyOiJkdE/XDWopc/OfTyJ4fuj0l4YuoDbU6HiCRPjPvDQ889+dGbqpLVw/fc+1L6I7/L+e4/Vv371ENFag9PT59rTs4847iUc9Tiudup0aZVJ37z8ieHRGRV6t+ZkzNLzteY/88B1Wf7V5f5q3YVNZ7MBzCGbdiwQasrJV+UllJFmVJSUuTWYlMlJSWeUVRVxurKlSuzZs1SLbt27brduRq6+wxw287Ozscee2zgDXXPJTU1dfPmzaoe1+zZs3fv3p2amuq5wvOxY8e+973viYj2W7XV+vXr1Tc6s9m8ceNGNRVG2yorKysvL099tdPGExcXpxX+WrBgQXFxMRNBMCT8XWLk5+dbLBb1riwoKPBc5wNjyMKFC9evX68+u9asWWMymUQkNja2uLh4/fr16nP7F7/4RX39UC9UjWDVYneXkFLrSWjxNxX000qnqCkFag2JpbtdwT31s4hMnRzQXdSD8izW8mSG1Be5fjZGyt4V7tCiiHegUq377RXqzJw+eDg0kGkNxkhpsbsHpgU21XobX9vmenJKnhPzm7cEM7XS+g/OkMyfSLvTddBAFlfWfU7mJcuPviEvHJSdT4kxUlY/JOY3ZXWJ7DXrn9qLi0XE9RJrh96S6+rmGcv1emV1X31d/qK+aglnFfUVkX95YhiXgcEIGNfR0TFwj97eXvWfSqhaXSLp8a431d1obZdv73cv/gMAwJdZe6/z+g3922P+8/Pzz538tTZ1QzM5IurN7G9//SvJwz+64TJpQmRM+G0sRwwAAAAAwUarCRbImgIhrKZJXjgov77NrA+CR7DP+bhLNU2uxc81Xum+8jo5dla+P3+4BqBWH7noUWrSc+4IAAChKibc0N1/o7e/z/dXX/9K8oeL1u2u/+jT9rbP2ttEZHZM/P0x8WvTHoqLiB7xkQ6Z8LDxpD0AAAAAIAQ4umVTuaTHk/YYw0I886EWP/dSXudeGzzwOWJ3JjFGal4Zrp0DABDMYiOiP+/u6Lups9R5XET0jx/4xsgPafiMHxcWO5bTNgAAAADwJacmu5w473o4JGvLYxRR7QoAAAyXGzf7bT2dujM/Qkl42PjYiOgJ48JGeyAAAAAAAEBEhEt0AAAwXCaMC5sSOWnShFAu8jhpQuSUyEmkPQAAAAAACB4hXu0KAACMuphww6QJkV19vd39vb39/br1r8aW8ePCwsPCIsPCo8aHh40bN9rDAQAAAAAAtyDzAQAAhl3YuHETJ0RMlIjRHggAAAAAAAh9VGYAAAAAAAAAAAChg8wHAAAAAAAAAAAIHWQ+AAAAAAAAAABA6CDzAQAAAAAAAAAAQgeZDwAAAAAAAAAAEDrIfAAAAAAAAAAAgNBB5gMAAAAAAAAAAIQOMh8AAAAAAAAAACB0kPkAAAAAAAAAAAChg8wHAAAAAAAAAAAIHWQ+AAAAAAAAAABA6CDzAQAAAAAAAAAAQgeZDwAAAAAAAAAAEDrIfAAAAAAAAAAAgNBB5gMAAAAAAAAAAIQOMh8AAAAAAAAAACB0kPkAAAAAAAAAAAChg8wHAAAAAAAAAAAIHWQ+AAAAAAAAAABA6CDzAQAAAAAAAAAAQseEkTyY3W4fycMBAAAAAAAAAIAvmxHNfJhMppE8HAAAAAAAAAAA+LL5/zwNDHly8nJGAAAAAElFTkSuQmCC" width="2131" height="70" class="img_ev3q"></p><h2 class="anchor anchorWithStickyNavbar_LWe7" id="test-data">Test Data<a href="#test-data" class="hash-link" aria-label="Direct link to Test Data" title="Direct link to Test Data"></a></h2><h3 class="anchor anchorWithStickyNavbar_LWe7" id="send-data">Send Data<a href="#send-data" class="hash-link" aria-label="Direct link to Send Data" title="Direct link to Send Data"></a></h3><div class="codeBlockContainer_Ckt0 theme-code-block" style="--prism-color:#F8F8F2;--prism-background-color:#282A36"><div class="codeBlockContent_biex"><pre tabindex="0" class="prism-code language-text codeBlock_bY9V thin-scrollbar"><code class="codeBlockLines_e6Vv"><span class="token-line" style="color:#F8F8F2"><span class="token plain">#!/bin/bash</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain" style="display:inline-block"></span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"># MySQL info</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain">DB_HOST=&quot;mysql&quot;</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain">DB_USER=&quot;root&quot;</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain">DB_PASS=&quot;inlong&quot;</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain">DB_NAME=&quot;test&quot;</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain">DB_TABLE=&quot;source_table&quot;</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain" style="display:inline-block"></span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"># Insert data in a loop</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain">for ((i=1; i&lt;=1000; i++))</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain">do</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> # Generate data</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> id=$i</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> name=&quot;name_$i&quot;</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain" style="display:inline-block"></span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> # Build an insert SQL</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> query=&quot;INSERT INTO $DB_TABLE (id, name) VALUES ($id, &#x27;$name&#x27;);&quot;</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain" style="display:inline-block"></span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> # Execute insert SQL</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> mysql -h $DB_HOST -u $DB_USER -p$DB_PASS $DB_NAME -e &quot;$query&quot;</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain">done</span><br></span></code></pre><div class="buttonGroup__atx"><button type="button" aria-label="Copy code to clipboard" title="Copy" class="clean-btn"><span class="copyButtonIcons_eSgA" aria-hidden="true"><svg class="copyButtonIcon_y97N" viewBox="0 0 24 24"><path d="M19,21H8V7H19M19,5H8A2,2 0 0,0 6,7V21A2,2 0 0,0 8,23H19A2,2 0 0,0 21,21V7A2,2 0 0,0 19,5M16,1H4A2,2 0 0,0 2,3V17H4V3H16V1Z"></path></svg><svg class="copyButtonSuccessIcon_LjdS" viewBox="0 0 24 24"><path d="M21,7L9,19L3.5,13.5L4.91,12.09L9,16.17L19.59,5.59L21,7Z"></path></svg></span></button></div></div></div><p>Modify the variables in the script according to the actual environment, and add a total of 1000 pieces of data to the <code>source_table</code>:</p><p><img loading="lazy" alt="Result Source" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAYcAAAC6CAIAAADK7xbuAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAEXRFWHRTb2Z0d2FyZQBTbmlwYXN0ZV0Xzt0AABnLSURBVHic7d1PaCJbvgfwM+9dvYsi4E1EtEmBIPdt8qcCMwjZNBKyEWkEZ5NLWmphL5JNZpNAdWcRetHdgtl0YJi76YWY0FkFwiBuGpHLQCBwQdORuxiEQAUUiV4hFPNa34O3+NHn1fin1Iom1fH7WSVVnvLUsernOaeO5/zhxx//i/Xw5ct/6/+VJGl7e1sQBL6lWq2+efNGVdVeR2hLWywW4/F43xcTRVHm5ub29/cLhcKASe6ZNXMYCoWi0Wgmk0kmkw+dFwAz/mPYBOfn55FIJBKJ/OUvf2GMJRKJUCg0howBwIT6znRKVVX/9re/bW9vP3v2LJ1Os6/f0na7nTHWbDZTqVQ6nVYUxe/3UxK/339yckJ/n5+fU72payr+LrOzs7yCxpMYp9LX6dp2iaK4u7vrcrm6vpcBWZbD4TD9XSqVdnZ2TOdQURSv1/vx48cXL14YpyLNZnNtbc04853VWIBvl/moxBgrFArFYnFpaYkxJklSIBDY2dmhBl0ikYhGo4wxut96teB6peL3G2+MUFyQZTmZTBqkojeqVCoUOCRJev78+cXFhaqqfNfGxgZjTFGUtvfqJZFI+Hy+09NTahPJskzZYIwJghCLxWiXLMvBYDAUClE2DM7L5XJtbm5SWNGfF4WkfD4fj8cpBgmCsL+/zwuwa+b1qdjXuHaXjxXgYQ3dgutEX+yFQoHfhIyxXC7HGFtYWDBOa5xKEATeP5LNZqvV6vLysnGq2dlZm812eXnZefxgMMgYOzw8pF1HR0eNRiMQCBjnMBQKiaLIQxJjLJlM6rts+K58Pt9qtSgbfUsjk8lQhMrn85qmeTweekGr1cpkMowxVVXPzs4EQaCgb5D5QCDQaDSOjo6MTwTgW3HXqFQul7tuv76+brVawx6tLZWmafl8nv5WVfX29rZrI0Wfiv6m2of+NaIoer3eSqXCe6bpgFNTU8ZZokjBs9FGn0Nz56U3MzPTtqXZbN7c3BhkXpIkt9t9dXU1yDMHgG/CnVpwjDH6kif6LqTBDZ6qVqu53W7jVIVC4dWrV7u7u+FwOBwO8/6X6elpQRBcLhfv2CLVatX4TWdmZjRNq9frg53N/zNRGrlcLhqNBoPBQqEgiuLy8nKj0bi4uDCdeYBv0V2jEt207OtNyJsz1A/SN/lQqQZ8L1VVqfOFeliok+Xi4kLTNN7fNDgKhdPT00NVRsyVhtPptNvt/JmAfuBFr8xLkjTEyQB8C+4UlajPRVVVamJUq9VsNtv1lfV6XdO0thZK31R61FSpVCqDp6KOm2g06nQ6eZOHMjzwKbJyuez3+5eWlgYflDTUeelTLS8vtz3gIwaZ7yzYQCCgf4QH8M0x369ENZFWq3V4eEi3jcPhWFxcpF0vX77U9wHRC0RR1A9u6ptK7/nz54yxvu8ly7KiKDwVdTDf3NwwxnK5nMPh2NraGuo0qZedHq7xt2jrtGoz1Hm1paLQ07m3V+ZVVb26uuIFqyiK2+1uNpuDnyCA1fzhLmO79U+m9KNpNE07Pj5eW1vTDwXQv4B9HaRjkKpt5I6+OWP8XvoOHU3T9GOvjU/BAA0OoL95daZtbLd+9INBDg1SdR121NYM7Jp5nr1SqXR4eLi9vf3p0yeM7YZv1BBRCcaKgo6mafof8SQSCVEUaRQlwIQYwXglGAkaadX2jL9Wqz1glgAeBKKSVdCYJq/Xy/uVQqHQ0tJSo9F42IwB3DO04Cyks+dI/xM5gAmBqAQA1oIWHABYC6ISAFgLohIAWAuiEgBYy11/nTs++rHdg08Q/lizYUE0fv3q6qrtKWEikajVap0bGWPD/jSatM3qiTGl42YwIf393A7WrSul0+m1tbVIJFIqlR5ZNiRJSqVS+t/rWc0gOdza2qJp+ehfWZYp9NRqtXK5LEnShw8f+I8Hc7mcKIomTpluA1VVabZ4hKRhjfZiu5+70rpRCaxMURRRFI+Pj/nXaTabnZqaOj4+fvLkyfz8/N7eXr1e57MPp9PpTCbj9/uNf9jciX5fTZN5woT4JqOS9esaj5skSXNzc/l8Xj/lOU1rtbOzQ9X7SCTS1l5LJpOlUml1dXXYOaFardb19fVIcg7fhCH6lUKh0Nra2qdPn1ZXV202WyqVCgQCPp+vWq2enZ2Fw+G2gciJRMLtdtOkawbrjpj4HT+tYuD3+xOJxFBdFSNf/sQ4VefKKH1XfDHWa6mVXudlMD9Br6VWBskhTSLO2276onA4HDRD5snJSedJ6Sfb7HuyxuUQDAb5Fcj+fXKIrqVhcPXSHIEGBrx6Byx548yz3p/ysJfomJYXMmCcQ94Y73vPDt3b/fTp07///e8rKyuRSKRer5+engaDwWw2u7y8TL/hot4vPkkb063P0bnuiOn1OejTDYfDP//881ArZY5w+RPjVF1XRjFe8cVYr6VWqBz4daMoSiwWczqdfWcy6brUSt8cdk4iTlZWVm5vbzc2NhKJxOXl5eHh4dbWFq34wl9zcXHRaDT010kv+juTMba3t0d/8LvUbrfHYrFSqRSJROhm2Nzc3NjY6FUaNMdW16vXuJQMLhvTJd8r86z3p2ziEh3H8kKDFFSvHC4sLNjtdrfbLUmS8dfScC04m81Wr9fPzs4YY3a7nZbcsNvtNPcYn+eMMba0tGSz2ag7wGDdkbusz5FMJj98+OBwON6+fTtIo2Dky58YpOq7Msqweh2Qz2DJr7mjoyO+GExfXZdaMba4uOhwOHgxcslkkn8HejyeQqEQi8Xa7hm6TgRBmJ6eNn6XZDJJ3dvn5+eapr1+/Zr+1X/Nnp+f07/8sMal0evqNc5Jr8vmjiXfmXlmeNmYu0QNmFteyEDfHH7+/LnZbHZ+n3Uaul+Jfzxtc+x//vyZ6c5qfn6eZsJnvdcdufv6HOl0+t27d4yxly9f9l3Cd7TLnxinMl4ZxYReB6QYoZ/wRH+VGxtwgZY2TqeTfZ3es6udnR2DOmC5XLbZbLOzs8O+b9dD8b/j8Xg0Gu1bGr2uXgO9Lpu7lHzXzLPen7LpFXoGZ255oaFySM/vBulyGdl4pXQ6HQgEqHI+PT3tdrs/ffpE4abXuiOjemvGmN1uDwQCxscc7fInxqlMr4zSi/EBO9e/stlso3rrb85oS8P46h3te/X6lMe0yI255YW6Gm0ORzmK8vLyMhgMLi4u0tepPuR3XXfk7g9W+Nzhr1+/HqQDdYTLn9A0/r1SmVsZxcCwBzSxGN8jdsfS6HrZjOO9en3KxhebOeaWF+pltDkc5ciAbDbbaDQWFhbm5+d7tR7T6XQqlWKMOZ3OO67PIctyLBZrNBqvXr0a9pmOPhvG0/j3YpyqXC7zZW87dV3xxVivA1L/8fz8PN/C69KdB1laWhqwfWGQQ2q70RePCR6PZ3xP+ocqDRP0l804Sr7Xp2zuEiWjWl7o9vbW4DWD5JAG9KRSqb69wKOMStSu9vv9oijqh731WnfkLutzKIoSDodLpdLGxsaA1YeRL39ikMp4ZZSuK74Y63VAWvjb5/Pxg6+vrzscDip//VXe9lTLmEEOO+/GwdHNMNq2rZ5xaZhjcPWOvOQNLhtzlygb6fJCxm/UN4cUmgVB6Pvcc8S/g/v8+TNN6kr93CSZTCqKwhucmqa9e/eOajfxeDyRSMRiMXpQenx8zKvHbY3e9+/fs6/jJmgU37DzNBpkI51OX19fb29v61vFVLk1yIZBKqrz81Nj/z7whDF2cHCwu7vL9/Y9F4MDUg2cej3aziuZTHo8Htqladr79+9/+umnAYurVw7pu2Rubq7v891O1EOcyWTG91vCXqUx+BdA5wF7XTYjL3mDT9ngYut72K4fpX6jpmmpVIr/mofuYj4ao1qtvnr1ij4yc7cD/U3jh1wuV99Wwojnomwbf2QuOX8kCdbUNoRncIlEYmpqCr9wnlhtnVm9jPgXJ/Ros23ULzwyNLZe33gZhCzLPp/v7OwMIWkyURNnkM6sUUYlWZb9fv+nT5/u+HsCsL54PF4qlfQ9IMZCoVAwGDw/P0cteAKJovjzzz/v7e0Vi8VBOoJH06/EW5sDNnThEaCOiYWFhUGGngUCAVVVsV7LyKVSqV691JFI5J4z0wsfWjEgrHECANbyTc5kAgCPGKISAFgLohIAWAuiEgBYC6ISAFgLohIAWAuiEgBYC6ISAFiLmahE48dpSUIwgIICMAF1JQCwFkQlALAWRCUAsJYhfp3ba6LPZrNJs9jRAnt8u35+xYna1begAMCAmTkDaLXP29vbEa648CihoABMQAsOAKwFUQkArAVRCQCsBXNRAoC1oK4EANaCqAQA1oKoBADWgqgEANaCqAQA1oKoBADWgqgEANaCWd/GCAUFYMKE1pUoXiiK0rY9kUh03YjIAnBvHmFUkiQplUp1Bhe9ra0tQRAymQz9K8syxZ1arVYulyVJ+vDhQygUor25XE4UReMDAsCoPMKo1JeiKKIoHh8fFwoF2pLNZqempo6Pj588eTI/P7+3t1ev19PpNO1Np9OZTMbv98uy/HC5BpgU3z10Bu6bJElzc3P5fJ4HHcaYqqobGxs0HdKXL18ikUhbqmQyOT8/v7q6ms/neSwDgHG4v6ikn6GxVCrxidAkSdre3hYEgTHWbDZTqRTFC0VR5ubm9vf3KQrQy4rFYjweVxTF6/V+/PjxxYsXlJAmgVQUxe/302H9fv/JyQn9rZ89MhgMMsZ4241QPHI4HNVqlTF2cnKiT0JyuVw0Gg0Gg4hKAGN1Ty24RCIRDodPT08jkUgkErm8vKTWkCzLe3t7xWKRtufz+VgsNkhDyeVybW5uHh8fRyKR09NTal7F4/FIJPL69WtN087PzyNf8fgiiqLX661UKm2RZWVl5fb2dm1t7cuXL5eXl69fv/7xxx95vxK5uLhoNBper1cUxdEVDAC0u4+6UigUEkXx9PQ0mUzSFvpDFMXl5eVSqcSjxtHRkdfrXV5e5q80kMlkqFaVz+dXV1c9Hk/fJIuLiw6H4+zsrG27/u08Hk8ymYzFYm2vUVX16upqbm5uenpaVdW+7wUA5txHXWlhYaHVauXz+bbtFCNqtRrfQnc+NcqMaZrWecC+nE4nY+zm5qbXC3Z2dtoabnrlctlms83Ozg77vgAwuPuISjMzM5qm1ev1rnvL5XLbFpvNNv5MAYBF3UdUqtVqgiBMT08P+PpWqzXW/ACAld1HVCqXy4IgLC0ttW2n/uP5+Xm+hfdGdx5kaWlpkJYdY6xer2uaNjMz07mL2m7UjjPB4/G0Wq3r62tzyQFgEPcRlbLZbLVaDQaD/KmWLMuyLKuqenZ25vP5+EO39fV1h8ORy+XYv8eyXus+dqWq6u3trSiKbQ/RWLc4ODiKmAZNUQAYift4BkdjFBOJRCwWo2dbfLwSPfwKh8MUdDRNe/fuHT22TyaTHo+Hdmma9v79+59++mnAdzw4ONjd3eVvxwcf8edokiQNO+yI+uYzmQwewAGM1cStnUujMSuVyrCZTyQSU1NTb968GTwqfdMFBfBQJu53cIVCoVgs6puNg5Bl2efznZ2doaIEMG4TF5UYY/F4vFQq6fu5jIVCoWAweH5+PsjYTgC4o0mMSoyxg4ODRqOxsLAwyIsDgYCqqgajKwFghLB2LgBYy4TWlQDAshCVAMBaEJUAwFoQlQDAWhCVAMBaEJUAwFoQlQDAWhCVAMBasKL3GKGgAExAXQkArAVRCQCsBVEJAKxliF/n9pqmttlsrq2tMcYSiYTP5+Pb9cvPTtSuvgUFAAYmbi7K+4SCAjABLTgAsBZEJQCwFkQlALAWzEUJANaCuhIAWAuiEgBYC6ISAFgLohIAWAuiEgBYC6ISAFgLohIAWAtmfRsjFBSACagrAYC1ICoBgLV899AZGItQKBSNRhljqVQqnU7z7ZIkbW9vC4LAGGs2m/q95nYBwMg9troSdeU8e/bst99+a9sVCoVevnxZqVQikUgkElFVNRqNhkIh07sAYBweW1Ta2tq6urra2Nj48uVL265AINBoNA4ODujfg4ODRqMRCARM7wKAcXhsLbhesz5KkuR2u4vFoqqqtGVlZcXlcgmCYG7XPZwLwGR6bHWlXmZnZ202W7lcpn8VRVldXf3ll19sNpu5XQ9zGgATYFKiEkcdTzMzM9Fo9Pfff7/7LgAYrcmKSj/88MPbt2+vrq46G3rmdgHAyD22fqVerq+vW63W06dPT09Pk8kkbfR4PK1Wy9yuhzkNgAkwKVGpUChUKpWpqalsNktbRFH0er2VSsXcroc5DYAJMEEtuFwu53A41tfX6d+trS1BEA4PD03vAoBxeGx1JUVR/H4//zcWi8VisWq1urGxQQOyo9HoyckJY0zTtP39/UKhwBgztwsAxuGxRSW+1nZX6XS6149FzO0CgJGboBYcAHwTEJUAwFoQlQDAWrB2LgBYC+pKAGAtiEoAYC2ISgBgLYhKAGAtiEoAYC2ISgBgLYhKAGAtiEoAYC1Y0XuMUFAAJqCuBADWgqgEANaCqAQA1jLEr3NlWQ6Hw50vazaba2trjLFEIuHz+fj28/NzPgfbRO3qW1AAYMDMnAGiKO7u7t7e3mIlImMoKAAT0IIDAGtBVAIAa0FUAgBrwVyUAGAtqCsBgLUgKgGAtSAqAYC1ICoBgLUgKgGAtSAqAYC1ICoBgLUgKgGAtTzOqBQKhY6Pj1OplCRJD50Xk2geS0VRHjojY5dIJDBdJ+g9zqhkBZIkpVIp02Fla2tLEIRMJjPaXFlQLpcTRXES4i8M6DsTaUKhUDQaZYylUql0Oj3qLI1AOp22ZsYGpCiKKIqpVKpQKPCNkiRtb28LgsAYazabAxa+QSpzBxy5dDrtdDrD4bAsy8lk8v4zAFYzXF2JmhXPnj377bffxpQhkCRpbm4un8/rY0QoFHr58mWlUolEIpFIRFXVaDQaCoWMD2WQytwBxySZTJZKpdXV1W+3xQ0jNFxdaWtr6+rqKh6PD1XflmU5GAymUqlAIEAzN2qatr+/TxWBrt/YiURiamrqzZs3qqry49ArqZrWC9Xj7HY7Y6xareqPoCiK1+v9+PHjixcv6O30s0oaMKhT0LxuLpdLv0tRFL/fTy/w+/0nJyf094BvFwwGGWNtbbdAINBoNA4ODujfg4OD3d3dQCBgXLsxSGXugCZKgyfUT9FZKpXaZsLL5XLRaDQYDOqrhzCZhotKpudUtNvtsVisVCpFIhG6djc3Nzc2NuhK5beroiixWMzpdNZqNbfbPT09rY9Kg+BtN4prbXtdLtfm5ibdLfTWfVsNdBNWKhU6d0mSnj9/fnFxoaoq37WxsUGZp4hJ50J7i8XiIJGIE0XR6/VWKpW2tpvb7S4Wi7w0VlZWXC4XhQaDnPdKZe6A5kqDfxw+n+/09JRKW5bltpK/uLhoNBper1cUxWE/dHhk7q+3+/z8nC5lVVWvrq4EQRBFcXl5uVQq8fv26OioWq0uLy+Xy2Xaol9SbXZ29u7ZyGQydJ/k83lN0zwej/HrZ2dnbTbb5eUl/VsoFHZ2dui2oUrN4eEhz3yj0QgEAnfJ3uLiosPh4G+nzwMvE0VRVldXf/nlF5vN1jfnXVOZOyAzWxqhUEgURR6SGGPJZLLty4BfFdPT08Z5gEfv/qISvwcYY/F4PBqN0h1Yq9X4dn5p3tzcMMZmZ2enp6cFQXC73ZIkOZ3OvreNMU3T8vn8UEmur69brRbVqvTbOys1qqre3t52VtCG4nQ6GWN0+p0oRs/MzESj0d9//33AYxqkGvaA5kpjYWGh1Wr1LflyuUwRc8DzgsfKzDO40dJHK2Kz2a6vrxljTqfT6XTS3UIXa6vVuufsFQqFV69e7e7uhsPhcDjMu0soXLpcLt5tRKrV6phy8sMPP7x9+3bYJqFBKhMHNFcaMzMzmqbV6/XBsw2T7OGjUiceeqh59euvv87Pzy8sLDDGNE27//yoqkp9JdSVTt0lFxcXmqbxHpaxohrK06dP9Y0gj8djHKMNUpk7IDFRGqZ7CWEyPeQoSurgnJ+f51t4Q6Ber2ua9v333z958uTm5uby8tLr9X7//fe3t7cPmOF0Op1KpRhjTqeTt1BEUez6YjqFmZmZod6C2m7UjuMKhUKlUqlWq9lslrbwguKv6RzObpBqkAP2NXhplMtlQRCWlpaMD8gj5uB5gEfpIaOSqqpnZ2c+n493UqyvrzscjlwuR1e5JEl2u/3i4iKfz9OTI30n1P2QZVk/DIKqbBQ7crmcw+HY2trqmpBOQRTFoQYBdUZqQu+1vr5O/9LIb961TBmz2+1tN79Bqr4H7MpcaWSz2Wq1GgwGeVHQMzj9aygsoqEHbNgWnH4kDmMsFovFYrFqtUpVehOo+UCdFIwxTdPevXtHPaa1Ws3n811dXamqqqpqpVLx+XydnVDGOXz//j0beKBQrxwqisK7S/Q5TKfT19fX29vb+s4UfZuIBgFRKQ2YDervn5ubkyRJPziAnhtGo1F6L/2AL/L58+elpaW2TmWDVH0POMLSoEZfIpHgRdE5XokefWQyGbTyAGucWE7bmKAJ0XXcLEwm/DrXcgqFQrFY1DdsHz1Zln0+39nZGUISMMb+06A79n//93/uMyvA/eMf//jTn/70xz/+8V//+tc///nPh87OeIVCoT//+c+//vrrX//614fOC1gC6koWdXBw0Gg0qDv5cQsEAqqqmu74g8cH/UoAYC2oKwGAtSAqAYC1ICoBgLUgKgGAtSAqAYC1ICoBgLUgKgGAtSAqAYC1ICoBgLUgKgGAtSAqAYC1ICoBgLUgKgGAtSAqAYC1ICoBgLUgKgGAtfwfR7mNya2VYIAAAAAASUVORK5CYII=" width="391" height="186" class="img_ev3q"></p><h3 class="anchor anchorWithStickyNavbar_LWe7" id="verify-data">Verify Data<a href="#verify-data" class="hash-link" aria-label="Direct link to Verify Data" title="Direct link to Verify Data"></a></h3><p>Enter StarRocks, check data in <code>sink_table</code>.</p><p><img loading="lazy" alt="Result Sink" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAcQAAACkCAIAAACGvsmmAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAEXRFWHRTb2Z0d2FyZQBTbmlwYXN0ZV0Xzt0AAB4hSURBVHic7d19UFNX/j/wg5D4cLHGBDDY3BYN0h15CHZcVqpLKeusYnQypm4XVzHrxo643XHtDnSi/sG4syq7cWyluusftZqJjuhuadluSrUOw7huUaY7JQh1twpl57KCUR4U79okoN8/zq937i+QmxAuD8L79Ve4Dyefe3Lzueece3KJWrQohUjyer+V3gAAAKaNdwAAAJMBkikAgAyQTAEAZIBkCgAgg5jxDmC0GAyG4uJihmHon1VVVQ6HY+zDsNlsWVlZ9LXH49m/fz/HcWMcg9FoLCwsVCqV4xjDxMSy7N69e9va2srKysTL7XZ7V1fX4IWEkJKSkgjeSPwR+Hy+goKCEUQtPxqe3+8/dOiQ2+0Oub3FYsnPz3c6nS6Xa7Rjs9lsqampQwY20U7sSd4yra+vN5vNZrNZnEkNBoPT6bTZbHK9i0SBZWVlNICWlha53m64XC5XQUGBvDHIXoeyCyfCnTt3MgxTXV1N/7RYLDRjdnV1dXR0GAyGEydOGI1Gura2tpZl2QgOmX7nOY6jZ8JEy6RjSd7TZjRO7JEYdsuUtvgIIcK1QrisFRYWSu8bcH0WX9mCNSTp8s7OzshaBADB2Gw2lmWdTqfQ5KmpqcnOzq6oqPB4PBqNxmQytbS0CKeoy+WKi4szmUwWi2VYvZz09HRCSG1trdxHIBuXyzUGbcxJL8KWKcMwmZmZ9HV6ejrNj9IsFovVam1oaKDX55KSktzcXIPBQFeVlpY2NzfTVfX19SaTaSK3ekZu4rfsJjeDwZCamtrQ0CBOIhzHFRUVlZSU0POZnqXivRwOR0tLy8qVK+l5Gz6/39/e3i5L5DBhDbtlqtPpCCFutzstLY0QwrLs/Pnz3W53cnKyxWIxmUz19fXiwSa73a7Vavfs2ZOdne3xeM6cOUOXcxxHz1SWZQNWlZWV2e321NTUkR9eAPEIZlZWVmVlJX0txEwH0RISEohk21lYFbLAYNxud3Nzc1ZWlt1uH1aje8gw6CqJ4CVI70U/U/q6paWlpKQk4kMOVqD0cQUMmdHNmpuby8rKbDZbUlLS2bNnt23bRnekMYQTYX5+PiFE6OCLq0KlUnk8HkJIZWXl4IOqra0tLCzMz88PZ2xRuh7osGNubq5eryeE8DwfcJgBtWE0GgsKCi5durRy5UqFQiHs6/F4ioqKpN8uWPVKDDsGq97BhdMK53leom8a8kOR6LYSQnQ6nRB/mGea9IktjL3I2OWN8AZUW1tbTk6O0WiMi4vzer1ffPFFcnIy7SUlJSWxLEs/EoPBoNVqOzs76V4Mw6jV6oBB4oyMDJVKVV1dLV7e1NREzzB50c9A/IUUrxWGFOipabPZ6MnhcrkCRhsMBsPmzZsbGxulCwwZDM0sx48fD3PsPFgYHMdJBB9OgUPuZbfb9Xq9MORisVgsFstIDnnIAh0OR8Bl2GazWa3WuLi4kL3phISEHTt20O8JLSScCFmWTUpK6uzsDEiIeXl5fX19RUVFdru9qanp9OnTO3fuNBqN4jpsbGzs7e0Vn+TBiC8bhJDS0lL6QriEKJVKq9Xa0tJiNpvpN3/Hjh1FRUXBauPevXuEkJycnI8//jgvL89sNnd3d1dVVdELgwSJ00bo4Nvt9tmzZ4dTvQEfCs2SIRNcyK9ebm5uSUkJrVK73R5w9hYWFlZXVwunSsiRlpBfB9qf1mq1BoNhhNdFQYTd/Hv37nV3d6enp6elpTU1NdGFHMe1tbWpVKqMjAy6JDMzU6FQ1NbWchxXV1fHMExpaSkd4xfQESV6oojL9/l8kcUWMXpSnj59mv555syZ3t7e3NxcQohOp1MoFMKRut1u4YMfCYfDceLECZVKdeDAgXB6jhJhSAQvQWIvo9HIsqx4FoTD4RjJjIhgBdKuSUtLi/AFO3PmjMfjyc7ODqfY6upq+g1paGjgeT4xMTHkLvT6LVSjwOFwCO2UxMREt9tttVoDrkb0JKfNAul3cTgcwrAVz/P79u0TBriEberr6+mfQrHStaFQKLq7u+vq6gghSqWSfnAhB9lGcvZKV6/FYgknk4YUEBIdX6aZgRBCbxLS06ampiaccyPk1+H69es+n2/wBXUkhp1M4+LiCCHt7e21tbWLFi1Sq9UNDQ3iEImoFtLS0np7exsbGwkhDofj17/+tcfj0ev1lZWVTqdzuANPo2pwa4XjuL6+Pnq5bm9v9/v99JIo7/u6XK6DBw8SQnbv3i3cOA4mWBjSwQcjvVd6errf7xd/uCMUrECa2rq6uoQlQmYJWSbP8xFESM/hgOu3WElJiUR26OjoUCgUdLxrhDo6OoTXZWVlhYWFIWtDyIk8z3d3d4fzLhGfvdLVu3Tp0sHDerKgAQ8ZBj1Fpc+NcL4OdCaAvLe1I59n2tjYuG7dura2NrfbTS99hBCXy5Wbm0s7QWq1WqvVXrp0Sbjg0AF+8l0PqLS0tKqqihCiVCrp+T2O1Go1wzAJCQnCaA5Fh8/cbveePXv27t1rMplMJlP4I5LhUyqVubm50mUGC0M6+GCk99JoNOF/XcMhXaA4rVD0jJqa5K2N0Th7lUolbQwNDjUy4kFVaV1dXVqtVmKDyL4OIxd5MhUyY4Cmpqb8/PyMjAyaH4e8sjkcjoaGhuLi4uzsbNpnCRAXFxfODAEZdXd38zwvMQdLOF46dB3OiGQ4hIll+/btC6fHMWQYjY2N0sEPSfqQ6Sk7eIw7YsMtUNw2gRHWhuxnL83Iubm5dFx4hL+IoZk0YEJksI3pVVmitJDf5VEy7G5+yDGpmpqa3t5eOpwazpAEHYuhcwMo4f7+cGMLE61rjUYjXih0BFiWld7d5XI5nU7yXW8xWIHhoNPFent79+zZM9yxG3EY4QcvJr1XR0eHeAJcgAgOOViB9JZOwAlAu2mDC8nMzAyn+y8dIe3gR9wZSkxMHL2pTsOqjQgMPntHory83OPx5Ofnhxyhoob8UOgBejyempqakCXQe9p9fX0S24TzdaBzE+UdbJTnF1DiMQ46xJOVlcWyrDBR2WAw2O128bHl5+czDFNXV0cnCen1emHS5aZNmxISEoZsscqC1jXLsgFnQG1trUql2rlz5+BdLBaLeE5owE2zYAVKs9lsdFp4UVFRmI01iTAkgpcgsRcd6Rd/T+jNd/o6gkMOViC9OanX64XCN23apFKp6MkjTsEB98elSUQ4OGGFj37z5R0AEZOujchIn70jwXHcn/70J7/fX1BQEE5WGvJDoQuFG9dGo3H37t3BLpmbN28mojtLwYT8OtCrMsMwIedChG9Ufpt//fr1zMxM4dYTIYSOq9rtdqHzTu9v0uaYMEmIjnH4fL4TJ06I+yD0npXwp3h+YmTKy8v37t1rtVqtViv5buaay+Vqb28vLi4WvxftejgcDpvNJiznef7gwYPituSQBUoEQCeND3fwXiIMieADRqOOHDkSziHTjqHdbhcOKqDah3vIEgXSzh0d0Qs4LofDkZiYSFfxPH/kyJGNGzeGWV3BIqTX+9TU1AimxQw5k09ewWpjWJfqgAKDnTYS50aYhbvd7oqKisLCwt27d4fzS9khPxTxQp7nnU6nUBRNJsLEMo/Hs2fPHlr5kZ3Y9DWdx5mQkBBBhzKYqNF40j4dl2loaBhWpqBT7QghsjywILKJkKOHzuMb92cxABXxz5TxOU4aAQO1IzcqDzqhk2ACfl4SEu3gJCQk5OXlEUIivg4DhCQMLg1rtpDFYtHr9XV1dcikTzvaNQxzoDZM8nfz6TzeqqqqCGbDivt0RI575QDB0F8t5+fn37t3L5wzzWg05ufn19fXj8uzHEEuws9MZZ8hK2c3XxjCGK+Hh4rheaYQUrDnmQ5pJM8znSKcTmewG0dms3mMgxl7ozJmCgAw1Uzyh0MDAIwNJFMAABkgmQIAyADJFABABkimAAAyQDIFAJABkikAgAyQTAEAZBB5MmVZ9vjx4wH/0AkGQ0UBTAVomQIAyADJFABABkimAAAyGPaDToL96wifz0cfjm232/V6vbBc/JyrKbUqZEUBwGQS+VOj6OPL+vr68FAyaagogKkA3XwAABkgmQIAyADJFABABnjSPgCADNAyBQCQAZIpAIAMkEwBAGSAZAoAIAMkUwAAGSCZAgDIAMkUAEAGeDj0qENFAUwFU7plStOczWYLWG6324dciIQIAMFM2mRqMBicTufgnCi2c+dOhmGqq6vpnxaLhabLrq6ujo4Og8Fw4sQJo9FI19bW1rIsK10gAExZkzaZhmSz2ViWraiocLvddElNTc3s2bMrKirmz5+flpZWWlra3d3tcrnoWpfLVV1dnZWVZbFYxi9qAJigYsY7gPFhMBhSU1MbGhqEXEkI4TiuqKiIPn7U6/WazeaAvRwOR1pa2sqVKxsaGoQUDABAxj6Zip8/39LSIjwv2WAwFBcXMwxDCPH5fE6nk6Y5m82Wmpp66NAhmrzoZs3NzWVlZTabLSkp6ezZs9u2baM70kfc22y2rKwsWmxWVlZlZSV9LX42fn5+PiFE6OBTNI2qVCqPx0MIqaysFO9C1dbWFhYW5ufnI5kCgNiYdvPtdrvJZKqqqjKbzWazuampiXaZLRZLaWlpc3MzXd7Q0GC1WsPpTSckJOzYsaOiosJsNldVVdE+eFlZmdls3rdvH8/z9fX15u8IaZFl2aSkpM7OzoCEmJeX19fXV1BQ4PV6m5qa9u3bt2jRImHMlGpsbOzt7U1KSmJZVr6KAYCn3ti1TI1GI8uyVVVVDoeDLqEvWJbNzs5uaWkRkt2ZM2eSkpKys7OFLSVUV1fTNmxDQ8PKlSsTExND7pKRkaFSqerq6gKWi98uMTHR4XBYrdaAbTiOa2trS01NVavVHMeFfC8AmCLGrmWanp7u9/sbGhoCltPU1tXVJSyhCYv23KXxPD+4wJDi4uIIIffu3Qu2QUlJSUDvXqyjo0OhUOh0uuG+LwBMYmOXTDUaDc/z3d3dQ67t6OgIWKJQKEY/KAAAeYxdMu3q6mIYRq1Wh7m93+8f1XgAAGQ0dsm0o6ODYZjMzMyA5fSWTlpamrBEuEE0uJDMzMxwuv+EkO7ubp7nNRrN4FW0g087+xFITEz0+/3t7e2R7Q4Ak9LYJdOamhqPx5Ofny/cH7dYLBaLheO4uro6vV4v3L7ftGmTSqWqra0l/38KFk+rConjuL6+PpZlA27Hk6HSd/hoopcYrwCAqWns7ubTKfF2u91qtdK75MI8U3ob3WQy0VzJ8/zBgwfpvCWHw5GYmEhX8Tx/5MiRjRs3hvmO5eXle/fuFd5OmDQq3JE3GAzDnS5Kb5dVV1fjVj4AiEX+30npFPe+vj5h4v1ThE7+7+zsHG7wdrt99uzZ+/fvDz+ZPtUVBQBhmqK/zXe73c3NzeKxhXBYLBa9Xl9XV4dmKQAEmKLJlBBSVlbW0tIiHsOVZjQa8/Pz6+vrw/kpAQBMNVM3mRJCysvLe3t709PTw9k4NzeX4ziJyfwAMJVFPmYKAACCKd0yBQCQC5IpAIAMkEwBAGSAZAoAIAMkUwAAGSCZAgDIAMkUAEAGSKYAADKIPJmyLHv8+HG73S5jNJMSKgpgKkDLFABABkimAAAyQDIFAJDBsB90Eux/h/h8voKCAkKI3W7X6/XCcuH59lNtVciKAoDJZIo+aX8soaIApgJ08wEAZIBkCgAgAyRTAAAZ4En7AAAyQMsUAEAGSKYAADJAMgUAkAGSKQCADJBMAQBkgGQKACADJFMAABng4dCjDhUFMBWgZQoAIAMkUwAAGcSMdwCjyGg0FhYWEkKcTqfL5RKWGwyG4uJihmEIIT6fT7w2slUAAJOzZUqHKdetW3fjxo2AVUajcffu3Z2dnWaz2Ww2cxxXWFhoNBojXgUAQCZrMt25c2dbW1tRUZHX6w1YlZub29vbW15eTv8sLy/v7e3Nzc2NeBUAAJms3fxgz7Q3GAxarba5uZnjOLokLy8vISGBYZjIVo3BsQDAU2FytkyD0el0CoWio6OD/mmz2VauXHn58mWFQhHZqvE5DACYeKZWMhXQQVWNRlNYWNjT0zPyVQAwxU3FZDp37twDBw60tbUNHg2IbBUAwOQcMw2mvb3d7/fn5ORUVVU5HA66MDEx0e/3R7ZqfA4DACaeqZVM3W53Z2fn7Nmza2pq6BKWZZOSkjo7OyNbNT6HAQATz5Tr5tfW1qpUqk2bNtE/d+7cyTDM6dOnI14FAEAma8vUZrNlZWUJf1qtVqvV6vF4ioqK6M+WCgsLKysrCSE8zx86dMjtdhNCIlsFAEAmazItKyuTWOtyuYL9EjSyVQAAU66bDwAwGpBMAQBkgGQKACCDqEWLUqS38Hq/HZtQAACeXmiZAgDIAMkUAEAGSKYAADJAMgUAkAGSKQCADJBMAQBkgGQKACADJFMAABlEnkzp//Cw2+0yRjMpoaIApgK0TAEAZIBkCgAgAyRTAAAZDPtBJxaLxWQyDd7M5/MVFBQQQux2u16vF5bX19cLj2qeUqtCVhQATCaRPzWKZdm9e/f29fXhXx9LQ0UBTAXo5gMAyADJFABABkimAAAywJP2AQBkgJYpAIAMkEwBAGSAZAoAIAMkUwAAGSCZAgDIAMkUAEAGSKYAADJAMgUAkAGS6YSWkpJy+PDh9evXj3cgo279+vWHDx9OSQnxExKACStao9FIbzEw0D82ochu9erVpaWlP/3pT2fOnNnY2DguMcybN+/NN9/csmWL3++/devWsPZduHDhb37zG51ON3PmzKtXr/p8vlEKctzNnz9/48aNSUlJaWlpN27c6OnpGe+IAIYtJoJ9vve9761YsWLJkiXx8fExMTHiJ3tCAK1W+8ILLygUimnThtcJmDNnzvbt27Va7c2bNw8ePPjw4UO63Gw2r169Wq1WR0VF9fX1/f3vfz958uTjx4+lSwu2l81my8rKotv09/f39PRcuHChsrIygiMdidu3bx89erS4uFir1W7fvv3AgQP3798f4xgARmjYyZRl2V27diUkJIxGNPL69NNPP/300/GOIkJr1qxZsGDBgwcPPvzwQyGzWK3WVatWxcT8v0/tmWeeWbNmjUaj+cMf/iBRVJh7xcTExMfHb9iw4cGDB5cuXRqFY5LS2tpaWVn5i1/8YsGCBWvWrDl79uwYBwAwQsNOphzH/etf/3r48GFtbe3atWvDz6q0EVRfX//ZZ59t3749Li7uwYMH586dq66unjZtmtls/vGPfyw0nf7xj384nc6jR4/GxsaeOnVKnBPXrl27efNm6YfVixtchJCqqiqHw0G+e06zSqW6cOFCRkYGy7KPHz/+6quv3n77bemmUECE9+/fv3Dhwp///GfaJMzLyzObzQkJCdHR0cKqt956SxyD1Wq1Wq2EkJaWlpBPiZ43b96KFSuio6OvXbt29epVujAtLW358uUxMTHffPPNu+++29PT8/rrr2dlZS1evFiiKOm9xF2KvLy8n//857Gxsc8++6x0eBHUBl01b968zZs3GwwGhmEGBgZaW1vff//9r7/+mhZ76dKl7OzsJUuWrFixoqam5s6dO9JhAEwokdyAeuedd4qLi91udwT7KhQKi8USFxdHCHnmmWc2bNhACNm6detrr70WFxc3bdq0qKioZ555ZvXq1bt27fr2228JIUKTitJoNEqlMoK3FsdgNBqff/75adOmxcTEpKenh/w/Ilu2bBFHqFKp1q5dm56eTghZt27d66+/Pn/+/JiYGLrq1Vdf3bJly0giXLp0qUaj4Xn+2rVrwsL09PTZs2fzPP/BBx+0tbXNnTt33rx50dHRs2fPligqzL1mzJgxa9asqKgor9fr8Xikw4usNliWtdlsy5cvj42NjYqKiomJSUlJMZvN4pKvXr3q9XrVanVqaupwKw1gfEUyZjoSWq12xowZhw8fVqvVP/vZzxiGycjI+OEPfxgTE9PY2Pjee+8RQrZt25aRkbF48eLOzk6lUqnRaF588cVdu3b5fL6ysjKVShXyXWiDi7ZDB7edo6KiBgYGLl++fPbs2bfeekuv1ycnJ0sXuHjx4piYGI7jfvvb3/I8n5OTk5ub++TJk9jY2FdeeSUmJuby5csnT54khGzdunX58uVLly791a9+RQgxGAzFxcUKhcLpdLpcrjBrKTk5WalU3rlzR2i1EUJ0Oh1t6928efMnP/nJ2rVrpdNomHuJ/1fVo0ePPvroo+rqatlr49SpU2vWrHnuuef6+/uvXLlCOwobN24MuC42Nzf39PRotdqUlJSamprwagtgQhiHZHrp0qUrV64QQv76178SQjZu3MgwDM/zH3/8cXt7OyHk4sWLycnJM2fOvHv3bnJyskqleuGFF2bOnKlUKumLJ0+ejDCML7/88ujRo48fP+7q6hL/L7xg/vvf/yYnJ+t0ut///vdXr16tqam5ePEiIcRgMMTHx0dHR+fk5OTk5Ajbz5kzZyTh0QvGnTt3hPtOhJDo6GhCyMDAwPbt2zMzMwkhTU1Nc+bMYVlWoqhh7TVz5kyTycTz/N/+9jeJMiOojWnTpqWkpERFRf3nP/+hNU8IOX78eEDJt2/f5nleqAGAp8hYzzOl46HiJUqlMjo6mud5oXfJ8/yTJ0+io6PpkpkzZ6akpNAuf3Jyskaj8fv9Iwzj9u3bIe+Ai1VUVFy/fn1gYECtVq9Zs8Zut7/99tsLFy7U6XQKhWKEwQwWGxtLCAmIcGBggBDCsuyLL7746NGjc+fOvfvuuzRXSgi5l8PhMJvNGzZsOHz48O3bt2fMmDHkP1UVi6A2nn32WYZhCCFdXV3SNd/V1SX97gAT01i3TL/99tuAWYQDAwNPnjyZNWtWfHw8x3GEEIZhoqKi+vv779275/P5tFptTEzM7du3GYahrciRJ9PhunPnTmlp6Zw5c1555ZUVK1YkJSU9//zzr7322uXLl/v7+588efL+++9/9tlncr0dbZBOnz5dvLCjo4M2yVtbW48dO9bW1vbSSy/NmTOHpstgwtzr8ePHV65c0ev1JpNpxowZ0uFFUBvx8fH9/f2EkISEhNjYWHGLO4BarZZ+d4CJafx/AdXa2vro0SOGYdatW6fT6XQ63fr162fNmtXX19fZ2en3+1UqlUajuXHjxu3btxMSEubOnUt7gmOptLT0jTfe0Gg0H3300Xvvvdfd3U0IUavVHMc9fPhw+vTp69ate+mll4LtHh0drdPpwp9q2tvbS8unTVSqsbGxr6/v8ePH9+7d6+npSUpKevXVVxmG6evrE7bZunVrRUWF0+lcu3Zt+HsRQqZNm7ZkyZKMjAxCSMjqjaA27t6929raSgjR6XRWqzU+Pp5OpH3jjTfEm8XHx8+aNYtuH2ZdAUwQkbRM7Xa7eJwxKyursrKS5/nCwsIISrt69WpOTs73v/99g8FQXl5OF/b393/++ef379+n93b/97//ff31116vd8mSJUqlUvp28+D7TiaTyWQyeTye/fv3RxAhISQ2NtZgMPzoRz8SlvT393/55Zccx129enXNmjU6na64uFhYK/yQobOz88GDBwzDrFq1atWqVSS8qVG3bt3Kzs5Wq9UZGRmff/45XdjY2PjVV1/94DtCGMKwCcuyP/jBD5RKpVKpXLFiBR33lNhryBt0/f39dXV1o1EbFy9eXLx4sVqtfvnll19++WVhlbjkRYsWqVQqr9f7zTffSMcAMNGMf8v08ePH77zzzsWLFx8+fPjkyRPahjp//vzJkyfv379Ph0ofPnzIcdy///3vR48eEUIePHgwxkGePn26ubnZ6/USQvr7++/evXv+/Plz584RQk6dOlVRUXH37l3ajQ1w584dp9PZ3t4+5Npgvvjii66uLoZhli1bJl5+6NChTz755MGDB0JFVVRUnDhxgq7lOO7atWs+n4/neXqLL5y9BF6vt6Wl5dixY/RWu+y10dTU9Lvf/e769evCjjdv3vzkk0/E2yxbtmzWrFkdHR0BSRZg4sN/J52grFbr6tWrHz169Mc//lGYtz+5LVu27Je//OX06dPPnz//wQcfjHc4AMMz/i1TGNJf/vKX1tbW2NjYLVu2LFy4cLzDGXULFy7csmVLbGzsrVu3Pvzww/EOB2DYJvNTo55qXq+3tbU1IyNDq9UuWLDgn//8Jx3xmJQ0Gs2bb7753HPPdXZ2Hjt2jN7RAni6IJlOXD09PRzHLVy4sLa2drweITg2Hj16FBcXN2vWrCNHjtCb/gBPHYyZAgDIAGOmAAAyQDIFAJABkikAgAyQTAEAZIBkCgAgAyRTAAAZIJkCAMgAyRQAQAZIpgAAMvg/tQMgT4c1FqEAAAAASUVORK5CYII=" width="452" height="164" class="img_ev3q"></p><p>You can also view audit data on the page:</p><p><img loading="lazy" alt="Result Sink" src="/assets/images/audit_starrocks-30af1c19d2d6a3e22eba4732e4736e20.png" width="2256" height="707" class="img_ev3q"></p></div><footer class="theme-doc-footer docusaurus-mt-lg"><div class="theme-doc-footer-edit-meta-row row"><div class="col"><a href="https://github.com/apache/inlong-website/edit/master/docs/quick_start/data_sync/mysql_starrocks_example.md" target="_blank" rel="noreferrer noopener" class="theme-edit-this-page"><svg fill="currentColor" height="20" width="20" viewBox="0 0 40 40" class="iconEdit_Z9Sw" aria-hidden="true"><g><path d="m34.5 11.7l-3 3.1-6.3-6.3 3.1-3q0.5-0.5 1.2-0.5t1.1 0.5l3.9 3.9q0.5 0.4 0.5 1.1t-0.5 1.2z m-29.5 17.1l18.4-18.5 6.3 6.3-18.4 18.4h-6.3v-6.2z"></path></g></svg>Edit this page</a></div><div class="col lastUpdated_vwxv"></div></div></footer></article><nav class="pagination-nav docusaurus-mt-lg" aria-label="Docs pages navigation"><a class="pagination-nav__link pagination-nav__link--prev" href="/docs/next/quick_start/data_sync/mysql_clickhouse_example"><div class="pagination-nav__sublabel">Previous</div><div class="pagination-nav__label">MySQL to ClickHouse Example</div></a><a class="pagination-nav__link pagination-nav__link--next" href="/docs/next/quick_start/data_sync/mysql_iceberg_example"><div class="pagination-nav__sublabel">Next</div><div class="pagination-nav__label">MySQL to Iceberg Example</div></a></nav></div></div><div class="col col--3"><div class="tableOfContents_bqdL thin-scrollbar theme-doc-toc-desktop"><ul class="table-of-contents table-of-contents__left-border"><li><a href="#deployment" class="table-of-contents__link toc-highlight">Deployment</a><ul><li><a href="#install-inlong" class="table-of-contents__link toc-highlight">Install InLong</a></li><li><a href="#add-connectors" class="table-of-contents__link toc-highlight">Add Connectors</a></li><li><a href="#install-starrocks" class="table-of-contents__link toc-highlight">Install StarRocks</a></li></ul></li><li><a href="#cluster-initialize" class="table-of-contents__link toc-highlight">Cluster Initialize</a><ul><li><a href="#create-cluster-tag" class="table-of-contents__link toc-highlight">Create Cluster Tag</a></li><li><a href="#register-pulsar-cluster" class="table-of-contents__link toc-highlight">Register Pulsar Cluster</a></li><li><a href="#register-starrocks-datanodes" class="table-of-contents__link toc-highlight">Register StarRocks DataNodes</a></li></ul></li><li><a href="#create-task" class="table-of-contents__link toc-highlight">Create Task</a><ul><li><a href="#create-data-streams-group" class="table-of-contents__link toc-highlight">Create Data Streams Group</a></li><li><a href="#create-data-source" class="table-of-contents__link toc-highlight">Create Data Source</a></li><li><a href="#create-data-sink" class="table-of-contents__link toc-highlight">Create Data Sink</a></li><li><a href="#approve-data-stream" class="table-of-contents__link toc-highlight">Approve Data Stream</a></li></ul></li><li><a href="#test-data" class="table-of-contents__link toc-highlight">Test Data</a><ul><li><a href="#send-data" class="table-of-contents__link toc-highlight">Send Data</a></li><li><a href="#verify-data" class="table-of-contents__link toc-highlight">Verify Data</a></li></ul></li></ul></div></div></div></div></main></div></div><footer class="footer"><div class="container container-fluid"><div class="row footer__links"><div class="col footer__col"><div class="footer__title">Events</div><ul class="footer__items clean-list"><li class="footer__item"><a href="https://www.apachecon.com/" target="_blank" rel="noopener noreferrer" class="footer__link-item">ApacheCon<svg width="13.5" height="13.5" aria-hidden="true" viewBox="0 0 24 24" class="iconExternalLink_nPIU"><path fill="currentColor" d="M21 13v10h-21v-19h12v2h-10v15h17v-8h2zm3-12h-10.988l4.035 4-6.977 7.07 2.828 2.828 6.977-7.07 4.125 4.172v-11z"></path></svg></a></li><li class="footer__item"><a class="acevent" data-format="square" data-mode="dark" data-event="random"></a></li></ul></div><div class="col footer__col"><div class="footer__title">Community</div><ul class="footer__items clean-list"><li class="footer__item"><a href="https://twitter.com/ApacheInlong" target="_blank" rel="noopener noreferrer" class="footer__link-item">Twitter<svg width="13.5" height="13.5" aria-hidden="true" viewBox="0 0 24 24" class="iconExternalLink_nPIU"><path fill="currentColor" d="M21 13v10h-21v-19h12v2h-10v15h17v-8h2zm3-12h-10.988l4.035 4-6.977 7.07 2.828 2.828 6.977-7.07 4.125 4.172v-11z"></path></svg></a></li><li class="footer__item"><a href="https://inlong.apache.org/img/apache-inlong-wechat.jpg" target="_blank" rel="noopener noreferrer" class="footer__link-item">WeChat<svg width="13.5" height="13.5" aria-hidden="true" viewBox="0 0 24 24" class="iconExternalLink_nPIU"><path fill="currentColor" d="M21 13v10h-21v-19h12v2h-10v15h17v-8h2zm3-12h-10.988l4.035 4-6.977 7.07 2.828 2.828 6.977-7.07 4.125 4.172v-11z"></path></svg></a></li><li class="footer__item"><a href="mailto:dev@inlong.apache.org" target="_blank" rel="noopener noreferrer" class="footer__link-item">Email</a></li></ul></div><div class="col footer__col"><div class="footer__title">More</div><ul class="footer__items clean-list"><li class="footer__item"><a class="footer__link-item" href="/blog">Blog</a></li><li class="footer__item"><a href="https://github.com/apache/inlong" target="_blank" rel="noopener noreferrer" class="footer__link-item">GitHub<svg width="13.5" height="13.5" aria-hidden="true" viewBox="0 0 24 24" class="iconExternalLink_nPIU"><path fill="currentColor" d="M21 13v10h-21v-19h12v2h-10v15h17v-8h2zm3-12h-10.988l4.035 4-6.977 7.07 2.828 2.828 6.977-7.07 4.125 4.172v-11z"></path></svg></a></li></ul></div></div><div class="footer__bottom text--center"><div class="margin-bottom--sm"><img src="/img/asf_logo.svg" alt="Apache InLong" class="themedImage_ToTc themedImage--light_HNdA footer__logo"><img src="/img/asf_logo.svg" alt="Apache InLong" class="themedImage_ToTc themedImage--dark_i4oU footer__logo"></div><div class="footer__copyright"><div style="font-family: Avenir-Medium;font-size: 14px;color: #999;">
<div>Copyright © 2020-2024 The Apache Software Foundation. Licensed under the Apache License, Version 2.0.</div>
<div style="margin-top: 20px; padding-top: 20px; border-top: 1px solid #666;line-height: 20px;">The Apache Software Foundation Apache InLong, InLong, Apache, the Apache feather, and the Apache InLong project logo are either registered trademarks or trademarks of the Apache Software Foundation.</div>
</div></div></div></div></footer></div>
<script src="/assets/js/runtime~main.63c98e82.js"></script>
<script src="/assets/js/main.070aef2a.js"></script>
</body>
</html>