blob: bd08ad2a22c8a37900190f4f487a3adedb0424f6 [file] [log] [blame]
<!DOCTYPE html>
<html lang="en" class="js csstransforms3d">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="generator" content="Hugo 0.70.0" />
<meta name="description" content="Apache ShardingSphere Document">
<link rel="shortcut icon" href="https://shardingsphere.apache.org/document/current/img/favicon.png" type="image/x-icon" />
<title>Route Engine :: ShardingSphere</title>
<link href="https://shardingsphere.apache.org/document/current/css/nucleus.css?1686302707" rel="stylesheet">
<link href="https://shardingsphere.apache.org/document/current/css/fontawesome-all.min.css?1686302707" rel="stylesheet">
<link href="https://shardingsphere.apache.org/document/current/css/hybrid.css?1686302707" rel="stylesheet">
<link href="https://shardingsphere.apache.org/document/current/css/featherlight.min.css?1686302707" rel="stylesheet">
<link href="https://shardingsphere.apache.org/document/current/css/perfect-scrollbar.min.css?1686302707" rel="stylesheet">
<link href="https://shardingsphere.apache.org/document/current/css/auto-complete.css?1686302707" rel="stylesheet">
<link href="https://shardingsphere.apache.org/document/current/css/atom-one-dark-reasonable.css?1686302707" rel="stylesheet">
<link href="https://shardingsphere.apache.org/document/current/css/theme.css?1686302707" rel="stylesheet">
<link href="https://shardingsphere.apache.org/document/current/css/tabs.css?1686302707" rel="stylesheet">
<link href="https://shardingsphere.apache.org/document/current/css/hugo-theme.css?1686302707" rel="stylesheet">
<link href="https://shardingsphere.apache.org/document/current/css/theme-white.css?1686302707" rel="stylesheet">
<script src="https://shardingsphere.apache.org/document/current/js/jquery-3.3.1.min.js?1686302707"></script>
<script>
var _hmt = _hmt || [];
(function() {
var hm = document.createElement("script");
hm.src = "https://hm.baidu.com/hm.js?d5a1dc8dcf63a64ee55b80de01c7fb1a";
var s = document.getElementsByTagName("script")[0];
s.parentNode.insertBefore(hm, s);
})();
</script>
<script async src="https://www.googletagmanager.com/gtag/js?id=G-HETCF66YL0"></script>
<script>
window.dataLayer = window.dataLayer || [];
function gtag(){window.dataLayer.push(arguments);}
gtag('js', new Date());
gtag('config', 'G-HETCF66YL0');
</script>
<style>
:root #header + #content > #left > #rlblock_left{
display:none !important;
}
</style>
</head>
<body class="" data-url="/en/reference/sharding/route/">
<div class="change-theme">
<div class="wrap">
<span data-item="retro">
<svg t="1649761460834" class="icon" viewBox="0 0 1243 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="2052" width="16" height="16"><path d="M755.093336 61.436797a511.973304 511.973304 0 1 0 207.495466 693.650688l-99.615377-53.757197a398.827204 398.827204 0 1 1-161.637286-540.351253l53.757197-99.615378z" fill="#ffffff" p-id="2053"></path><path d="M1204.971593 188.84501L534.652259 736.217612l-285.242269-364.086159 86.304071-67.653615 216.199012 275.953611 583.649567-476.574007 69.335813 84.987568z" fill="#ffffff" p-id="2054"></path></svg>
Retro
</span>
<span data-item="eyehelp">
<svg t="1649761460834" class="icon" viewBox="0 0 1243 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="2052" width="16" height="16"><path d="M755.093336 61.436797a511.973304 511.973304 0 1 0 207.495466 693.650688l-99.615377-53.757197a398.827204 398.827204 0 1 1-161.637286-540.351253l53.757197-99.615378z" fill="#ffffff" p-id="2053"></path><path d="M1204.971593 188.84501L534.652259 736.217612l-285.242269-364.086159 86.304071-67.653615 216.199012 275.953611 583.649567-476.574007 69.335813 84.987568z" fill="#ffffff" p-id="2054"></path></svg>
Eye care
</span>
<span data-item="haitian">
<svg t="1649761460834" class="icon" viewBox="0 0 1243 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="2052" width="16" height="16"><path d="M755.093336 61.436797a511.973304 511.973304 0 1 0 207.495466 693.650688l-99.615377-53.757197a398.827204 398.827204 0 1 1-161.637286-540.351253l53.757197-99.615378z" fill="#ffffff" p-id="2053"></path><path d="M1204.971593 188.84501L534.652259 736.217612l-285.242269-364.086159 86.304071-67.653615 216.199012 275.953611 583.649567-476.574007 69.335813 84.987568z" fill="#ffffff" p-id="2054"></path></svg>
Haitian
</span>
<span data-item="deep">
<svg t="1649761460834" class="icon" viewBox="0 0 1243 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="2052" width="16" height="16"><path d="M755.093336 61.436797a511.973304 511.973304 0 1 0 207.495466 693.650688l-99.615377-53.757197a398.827204 398.827204 0 1 1-161.637286-540.351253l53.757197-99.615378z" fill="#ffffff" p-id="2053"></path><path d="M1204.971593 188.84501L534.652259 736.217612l-285.242269-364.086159 86.304071-67.653615 216.199012 275.953611 583.649567-476.574007 69.335813 84.987568z" fill="#ffffff" p-id="2054"></path></svg>
Deep
</span>
<span data-item="dark">
<svg t="1649761460834" class="icon" viewBox="0 0 1243 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="2052" width="16" height="16"><path d="M755.093336 61.436797a511.973304 511.973304 0 1 0 207.495466 693.650688l-99.615377-53.757197a398.827204 398.827204 0 1 1-161.637286-540.351253l53.757197-99.615378z" fill="#ffffff" p-id="2053"></path><path d="M1204.971593 188.84501L534.652259 736.217612l-285.242269-364.086159 86.304071-67.653615 216.199012 275.953611 583.649567-476.574007 69.335813 84.987568z" fill="#ffffff" p-id="2054"></path></svg>
Dark
</span>
<span class="active">
<svg t="1649761460834" class="icon" viewBox="0 0 1243 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="2052" width="16" height="16"><path d="M755.093336 61.436797a511.973304 511.973304 0 1 0 207.495466 693.650688l-99.615377-53.757197a398.827204 398.827204 0 1 1-161.637286-540.351253l53.757197-99.615378z" fill="#ffffff" p-id="2053"></path><path d="M1204.971593 188.84501L534.652259 736.217612l-285.242269-364.086159 86.304071-67.653615 216.199012 275.953611 583.649567-476.574007 69.335813 84.987568z" fill="#ffffff" p-id="2054"></path></svg>
Default
</span>
</div>
</div>
<header>
<div class="wrap">
<a href="https://shardingsphere.apache.org/"><img src="https://shardingsphere.apache.org/document/current/img/logo_v3.png" /></a>
<section id="prefooter">
<ul>
<li>
<a class="padding">
<i class="fa fa-fw fa-tags"></i>
<div class="select-style">
<select id="select-version" onchange="location = this.value;">
<option id="current" value="/document/currenthttps://shardingsphere.apache.org/document/current/en/reference/sharding/route/" selected >current</option>
<option id="5.3.0" value="https://shardingsphere.apache.org/document/5.3.0/en/reference/sharding/route/" >5.3.0</option>
<option id="5.2.1" value="https://shardingsphere.apache.org/document/5.2.1/en/reference/sharding/route/" >5.2.1</option>
<option id="5.2.0" value="https://shardingsphere.apache.org/document/5.2.0/en/reference/sharding/route/" >5.2.0</option>
<option id="5.1.2" value="https://shardingsphere.apache.org/document/5.1.2/en/reference/sharding/route/" >5.1.2</option>
<option id="5.1.1" value="https://shardingsphere.apache.org/document/5.1.1/en/reference/sharding/route/" >5.1.1</option>
<option id="5.1.0" value="https://shardingsphere.apache.org/document/5.1.0/en/reference/sharding/route/" >5.1.0</option>
<option id="5.0.0" value="https://shardingsphere.apache.org/document/5.0.0/en/reference/sharding/route/" >5.0.0</option>
<option id="4.1.1" value="https://shardingsphere.apache.org/document/4.1.1/en/reference/sharding/route/" >4.1.1</option>
<option id="4.1.0" value="https://shardingsphere.apache.org/document/4.1.0/en/reference/sharding/route/" >4.1.0</option>
<option id="4.0.1" value="https://shardingsphere.apache.org/document/4.0.1/en/reference/sharding/route/" >4.0.1</option>
<option id="4.0.0" value="https://shardingsphere.apache.org/document/4.0.0/en/reference/sharding/route/" >4.0.0</option>
<option id="3.1.0" value="https://shardingsphere.apache.org/document/3.1.0/en/reference/sharding/route/" >3.1.0</option>
<option id="3.0.0" value="https://shardingsphere.apache.org/document/3.0.0/en/reference/sharding/route/" >3.0.0</option>
<option id="2.0.3" value="https://shardingsphere.apache.org/document/2.0.3/en/reference/sharding/route/" >2.0.3</option>
<option id="2.0.2" value="https://shardingsphere.apache.org/document/2.0.2/en/reference/sharding/route/" >2.0.2</option>
<option id="2.0.1" value="https://shardingsphere.apache.org/document/2.0.1/en/reference/sharding/route/" >2.0.1</option>
<option id="2.0.0" value="https://shardingsphere.apache.org/document/2.0.0/en/reference/sharding/route/" >2.0.0</option>
<option id="1.5.4" value="https://shardingsphere.apache.org/document/1.5.4/en/reference/sharding/route/" >1.5.4</option>
<option id="1.5.3" value="https://shardingsphere.apache.org/document/1.5.3/en/reference/sharding/route/" >1.5.3</option>
<option id="1.5.2" value="https://shardingsphere.apache.org/document/1.5.2/en/reference/sharding/route/" >1.5.2</option>
<option id="1.5.1" value="https://shardingsphere.apache.org/document/1.5.1/en/reference/sharding/route/" >1.5.1</option>
<option id="1.5.0" value="https://shardingsphere.apache.org/document/1.5.0/en/reference/sharding/route/" >1.5.0</option>
<option id="1.4.2" value="https://shardingsphere.apache.org/document/1.4.2/en/reference/sharding/route/" >1.4.2</option>
<option id="1.4.1" value="https://shardingsphere.apache.org/document/1.4.1/en/reference/sharding/route/" >1.4.1</option>
<option id="1.4.0" value="https://shardingsphere.apache.org/document/1.4.0/en/reference/sharding/route/" >1.4.0</option>
<option id="1.3.3" value="https://shardingsphere.apache.org/document/1.3.3/en/reference/sharding/route/" >1.3.3</option>
<option id="1.3.2" value="https://shardingsphere.apache.org/document/1.3.2/en/reference/sharding/route/" >1.3.2</option>
<option id="1.3.1" value="https://shardingsphere.apache.org/document/1.3.1/en/reference/sharding/route/" >1.3.1</option>
<option id="1.3.0" value="https://shardingsphere.apache.org/document/1.3.0/en/reference/sharding/route/" >1.3.0</option>
<option id="1.2.1" value="https://shardingsphere.apache.org/document/1.2.1/en/reference/sharding/route/" >1.2.1</option>
<option id="1.2.0" value="https://shardingsphere.apache.org/document/1.2.0/en/reference/sharding/route/" >1.2.0</option>
<option id="1.1.0" value="https://shardingsphere.apache.org/document/1.1.0/en/reference/sharding/route/" >1.1.0</option>
<option id="1.0.1" value="https://shardingsphere.apache.org/document/1.0.1/en/reference/sharding/route/" >1.0.1</option>
<option id="1.0.0" value="https://shardingsphere.apache.org/document/1.0.0/en/reference/sharding/route/" >1.0.0</option>
</select>
<svg t="1645437162166" class="icon" viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="2449" width="32" height="32"><path d="M483.072 714.496l30.165333 30.208 415.957334-415.829333a42.837333 42.837333 0 0 0 0-60.288 42.538667 42.538667 0 0 0-60.330667-0.042667l-355.541333 355.413333-355.242667-355.413333a42.496 42.496 0 0 0-60.288 0 42.837333 42.837333 0 0 0-0.085333 60.330667l383.701333 383.872 1.706667 1.749333z" fill="#3D3D3D" p-id="2450"></path></svg>
</div>
</a>
<a class="padding">
<i class="fa fa-fw fa-language"></i>
<div class="select-style">
<select id="select-language" onchange="location = this.value;">
<option id="en" value="/document/current/en/reference/sharding/route/" selected>English</option>
<option id="cn" value="/document/current/cn/reference/sharding/route/">简体中文</option>
</select>
<svg t="1645437162166" class="icon" viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="2449" width="32" height="32"><path d="M483.072 714.496l30.165333 30.208 415.957334-415.829333a42.837333 42.837333 0 0 0 0-60.288 42.538667 42.538667 0 0 0-60.330667-0.042667l-355.541333 355.413333-355.242667-355.413333a42.496 42.496 0 0 0-60.288 0 42.837333 42.837333 0 0 0-0.085333 60.330667l383.701333 383.872 1.706667 1.749333z" fill="#3D3D3D" p-id="2450"></path></svg>
</div>
</a>
</li>
</ul>
</section>
</div>
</header>
<div class="wrap">
<nav id="sidebar" class="">
<div id="header-wrapper">
<div class="searchbox">
<label for="search-by"><i class="fas fa-search"></i></label>
<input data-search-input id="search-by" type="search" placeholder="Search...">
<span data-search-clear=""><i class="fas fa-times"></i></span>
</div>
<script type="text/javascript" src="https://shardingsphere.apache.org/document/current/js/lunr.min.js?1686302707"></script>
<script type="text/javascript" src="https://shardingsphere.apache.org/document/current/js/auto-complete.js?1686302707"></script>
<script type="text/javascript">
var baseurl = "https:\/\/shardingsphere.apache.org\/document\/current\/\/en";
</script>
<script type="text/javascript" src="https://shardingsphere.apache.org/document/current/js/search.js?1686302707"></script>
</div>
<div class="highlightable">
<div class="leftMenu">
<ul class="topics">
<li data-nav-id="/en/overview/" title="Overview" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/overview/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
</i>
<b>1. </b>Overview
</a>
</li>
<li data-nav-id="/en/quick-start/" title="Quick Start" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/quick-start/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
<b>2. </b>Quick Start
</a>
<ul>
<li data-nav-id="/en/quick-start/shardingsphere-jdbc-quick-start/" title="ShardingSphere-JDBC" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/quick-start/shardingsphere-jdbc-quick-start/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
<b>2.1. </b>ShardingSphere-JDBC
</a>
</li>
<li data-nav-id="/en/quick-start/shardingsphere-proxy-quick-start/" title="ShardingSphere-Proxy" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/quick-start/shardingsphere-proxy-quick-start/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
<b>2.2. </b>ShardingSphere-Proxy
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/features/" title="Features" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/features/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
<b>3. </b>Features
</a>
<ul>
<li data-nav-id="/en/features/sharding/" title="Sharding" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/features/sharding/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
<b>3.1. </b>Sharding
</a>
<ul>
<li data-nav-id="/en/features/sharding/concept/" title="Core Concept" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/features/sharding/concept/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Core Concept
</a>
</li>
<li data-nav-id="/en/features/sharding/limitation/" title="Limitations" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/features/sharding/limitation/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Limitations
</a>
</li>
<li data-nav-id="/en/features/sharding/appendix/" title="Appendix with SQL operator" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/features/sharding/appendix/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Appendix with SQL operator
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/features/transaction/" title="Distributed Transaction" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/features/transaction/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
<b>3.2. </b>Distributed Transaction
</a>
<ul>
<li data-nav-id="/en/features/transaction/concept/" title="Core Concept" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/features/transaction/concept/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Core Concept
</a>
</li>
<li data-nav-id="/en/features/transaction/limitations/" title="Limitations" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/features/transaction/limitations/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Limitations
</a>
</li>
<li data-nav-id="/en/features/transaction/appendix/" title="Appendix with SQL operator" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/features/transaction/appendix/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Appendix with SQL operator
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/features/readwrite-splitting/" title="Readwrite-splitting" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/features/readwrite-splitting/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
<b>3.3. </b>Readwrite-splitting
</a>
<ul>
<li data-nav-id="/en/features/readwrite-splitting/concept/" title="Core Concept" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/features/readwrite-splitting/concept/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Core Concept
</a>
</li>
<li data-nav-id="/en/features/readwrite-splitting/limitations/" title="Limitations" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/features/readwrite-splitting/limitations/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Limitations
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/features/db-gateway/" title="DB Gateway" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/features/db-gateway/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
<b>3.4. </b>DB Gateway
</a>
<ul>
<li data-nav-id="/en/features/db-gateway/concept/" title="Core Concept" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/features/db-gateway/concept/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Core Concept
</a>
</li>
<li data-nav-id="/en/features/db-gateway/limitations/" title="Limitations" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/features/db-gateway/limitations/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Limitations
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/features/management/" title="Traffic Governance" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/features/management/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
<b>3.5. </b>Traffic Governance
</a>
<ul>
<li data-nav-id="/en/features/management/concept/" title="Core Concept" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/features/management/concept/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Core Concept
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/features/migration/" title="Data Migration" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/features/migration/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
<b>3.6. </b>Data Migration
</a>
<ul>
<li data-nav-id="/en/features/migration/concept/" title="Core Concept" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/features/migration/concept/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Core Concept
</a>
</li>
<li data-nav-id="/en/features/migration/limitations/" title="Limitations" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/features/migration/limitations/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Limitations
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/features/encrypt/" title="Encryption" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/features/encrypt/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
<b>3.7. </b>Encryption
</a>
<ul>
<li data-nav-id="/en/features/encrypt/concept/" title="Core Concept" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/features/encrypt/concept/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Core Concept
</a>
</li>
<li data-nav-id="/en/features/encrypt/limitations/" title="Limitations" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/features/encrypt/limitations/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Limitations
</a>
</li>
<li data-nav-id="/en/features/encrypt/appendix/" title="Appendix with SQL operator" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/features/encrypt/appendix/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Appendix with SQL operator
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/features/mask/" title="Data Masking" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/features/mask/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
<b>3.8. </b>Data Masking
</a>
<ul>
<li data-nav-id="/en/features/mask/concept/" title="Core Concept" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/features/mask/concept/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Core Concept
</a>
</li>
<li data-nav-id="/en/features/mask/limitations/" title="Limitations" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/features/mask/limitations/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Limitations
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/features/shadow/" title="Shadow" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/features/shadow/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
<b>3.9. </b>Shadow
</a>
<ul>
<li data-nav-id="/en/features/shadow/concept/" title="Core Concept" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/features/shadow/concept/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Core Concept
</a>
</li>
<li data-nav-id="/en/features/shadow/limitations/" title="Limitations" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/features/shadow/limitations/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Limitations
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/features/observability/" title="Observability" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/features/observability/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
<b>3.10. </b>Observability
</a>
<ul>
<li data-nav-id="/en/features/observability/concept/" title="Core Concept" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/features/observability/concept/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Core Concept
</a>
</li>
</ul>
</li>
</ul>
</li>
<li data-nav-id="/en/user-manual/" title="User Manual" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
<b>4. </b>User Manual
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/" title="ShardingSphere-JDBC" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
<b>4.1. </b>ShardingSphere-JDBC
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/yaml-config/" title="YAML Configuration" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/yaml-config/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
YAML Configuration
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/yaml-config/mode/" title="Mode" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/yaml-config/mode/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Mode
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/yaml-config/data-source/" title="Data Source" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/yaml-config/data-source/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Data Source
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/yaml-config/rules/" title="Rules" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/yaml-config/rules/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
Rules
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/yaml-config/rules/sharding/" title="Sharding" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/yaml-config/rules/sharding/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Sharding
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/yaml-config/rules/readwrite-splitting/" title="Readwrite-splitting" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/yaml-config/rules/readwrite-splitting/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Readwrite-splitting
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/yaml-config/rules/transaction/" title="Distributed Transaction" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/yaml-config/rules/transaction/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Distributed Transaction
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/yaml-config/rules/encrypt/" title="Encryption" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/yaml-config/rules/encrypt/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Encryption
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/yaml-config/rules/mask/" title="Data Masking" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/yaml-config/rules/mask/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Data Masking
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/yaml-config/rules/shadow/" title="Shadow DB" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/yaml-config/rules/shadow/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Shadow DB
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/yaml-config/rules/sql-parser/" title="SQL-parser" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/yaml-config/rules/sql-parser/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SQL-parser
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/yaml-config/rules/sql-translator/" title="SQL Translator" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/yaml-config/rules/sql-translator/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SQL Translator
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/yaml-config/rules/mix/" title="Mixed Rules" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/yaml-config/rules/mix/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Mixed Rules
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/yaml-config/rules/sharding-cache/" title="Cache for Sharding Route" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/yaml-config/rules/sharding-cache/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Cache for Sharding Route
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/yaml-config/algorithm/" title="Algorithm" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/yaml-config/algorithm/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Algorithm
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/yaml-config/jdbc-driver/" title="JDBC Driver" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/yaml-config/jdbc-driver/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
JDBC Driver
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/yaml-config/jdbc-driver/spring-boot/" title="Spring Boot" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/yaml-config/jdbc-driver/spring-boot/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
</i>
Spring Boot
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/yaml-config/jdbc-driver/spring-namespace/" title="Spring Namespace" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/yaml-config/jdbc-driver/spring-namespace/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
</i>
Spring Namespace
</a>
</li>
</ul>
</li>
</ul>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/java-api/" title="Java API" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/java-api/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
Java API
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/java-api/mode/" title="Mode" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/java-api/mode/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Mode
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/java-api/data-source/" title="Data Source" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/java-api/data-source/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Data Source
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/java-api/rules/" title="Rules" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/java-api/rules/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
Rules
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/java-api/rules/sharding/" title="Sharding" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/java-api/rules/sharding/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Sharding
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/java-api/rules/readwrite-splitting/" title="Readwrite-splitting" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/java-api/rules/readwrite-splitting/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Readwrite-splitting
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/java-api/rules/transaction/" title="Distributed Transaction" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/java-api/rules/transaction/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Distributed Transaction
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/java-api/rules/encrypt/" title="Encryption" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/java-api/rules/encrypt/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Encryption
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/java-api/rules/mask/" title="Data Masking" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/java-api/rules/mask/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Data Masking
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/java-api/rules/shadow/" title="Shadow DB" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/java-api/rules/shadow/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Shadow DB
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/java-api/rules/sql-parser/" title="SQL Parser" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/java-api/rules/sql-parser/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SQL Parser
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/java-api/rules/sql-translator/" title="SQL Translator" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/java-api/rules/sql-translator/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SQL Translator
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/java-api/rules/mix/" title="Mixed Rules" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/java-api/rules/mix/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Mixed Rules
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/java-api/algorithm/" title="Algorithm" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/java-api/algorithm/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Algorithm
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/special-api/" title="Special API" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/special-api/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
Special API
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/special-api/sharding/" title="Sharding" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/special-api/sharding/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
Sharding
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/special-api/sharding/hint/" title="Hint" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/special-api/sharding/hint/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Hint
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/special-api/readwrite-splitting/" title="Readwrite-splitting" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/special-api/readwrite-splitting/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
Readwrite-splitting
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/special-api/readwrite-splitting/hint/" title="Hint" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/special-api/readwrite-splitting/hint/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Hint
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/special-api/transaction/" title="Transaction" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/special-api/transaction/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
Transaction
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/special-api/transaction/java-api/" title="Use Java API" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/special-api/transaction/java-api/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Use Java API
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/special-api/transaction/atomikos/" title="Atomikos Transaction" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/special-api/transaction/atomikos/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Atomikos Transaction
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/special-api/transaction/bitronix/" title="Bitronix Transaction" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/special-api/transaction/bitronix/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Bitronix Transaction
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/special-api/transaction/narayana/" title="Narayana Transaction" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/special-api/transaction/narayana/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Narayana Transaction
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/special-api/transaction/seata/" title="Seata Transaction" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/special-api/transaction/seata/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Seata Transaction
</a>
</li>
</ul>
</li>
</ul>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/optional-plugins/" title="Optional Plugins" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/optional-plugins/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
</i>
Optional Plugins
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/unsupported/" title="Unsupported Items" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/unsupported/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Unsupported Items
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-jdbc/observability/" title="Observability" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/observability/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
</i>
Observability
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/" title="ShardingSphere-Proxy" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
<b>4.2. </b>ShardingSphere-Proxy
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/startup/" title="Startup" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/startup/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
Startup
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/startup/bin/" title="Use Binary Tar" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/startup/bin/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Use Binary Tar
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/startup/graalvm-native-image/" title="Build GraalVM Native Image(Alpha)" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/startup/graalvm-native-image/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Build GraalVM Native Image(Alpha)
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/startup/docker/" title="Use Docker" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/startup/docker/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Use Docker
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/startup/helm/" title="Use Helm" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/startup/helm/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Use Helm
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/startup/dependencies-download/" title="Add dependencies" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/startup/dependencies-download/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
Add dependencies
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/startup/dependencies-download/add_bitronix_dependency/" title="Add Bitronix dependencies" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/startup/dependencies-download/add_bitronix_dependency/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Add Bitronix dependencies
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/startup/dependencies-download/add_narayana_dependency/" title="Add Narayana dependencies" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/startup/dependencies-download/add_narayana_dependency/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Add Narayana dependencies
</a>
</li>
</ul>
</li>
</ul>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/yaml-config/" title="Yaml Configuration" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/yaml-config/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
Yaml Configuration
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/yaml-config/authority/" title="Authentication &amp; Authorization" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/yaml-config/authority/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Authentication &amp; Authorization
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/yaml-config/props/" title="Properties" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/yaml-config/props/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Properties
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/yaml-config/rules/" title="Rules" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/yaml-config/rules/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Rules
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/" title="DistSQL" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
DistSQL
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/" title="Syntax" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
Syntax
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/" title="RDL Syntax" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
RDL Syntax
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/storage-unit-definition/" title="Storage Unit Definition" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/storage-unit-definition/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
Storage Unit Definition
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/storage-unit-definition/register-storage-unit/" title="REGISTER STORAGE UNIT" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/storage-unit-definition/register-storage-unit/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
REGISTER STORAGE UNIT
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/storage-unit-definition/alter-storage-unit/" title="ALTER STORAGE UNIT" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/storage-unit-definition/alter-storage-unit/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
ALTER STORAGE UNIT
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/storage-unit-definition/unregister-storage-unit/" title="UNREGISTER STORAGE UNIT" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/storage-unit-definition/unregister-storage-unit/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
UNREGISTER STORAGE UNIT
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/" title="Rule Definition" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
Rule Definition
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/" title="Sharding" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
Sharding
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/create-sharding-table-rule/" title="CREATE SHARDING TABLE RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/create-sharding-table-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
CREATE SHARDING TABLE RULE
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/alter-sharding-table-rule/" title="ALTER SHARDING TABLE RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/alter-sharding-table-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
ALTER SHARDING TABLE RULE
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/drop-sharding-table-rule/" title="DROP SHARDING TABLE RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/drop-sharding-table-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
DROP SHARDING TABLE RULE
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/create-default-sharding-strategy/" title="CREATE DEFAULT SHARDING STRATEGY" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/create-default-sharding-strategy/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
CREATE DEFAULT SHARDING STRATEGY
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/alter-default-sharding-strategy/" title="ALTER DEFAULT SHARDING STRATEGY" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/alter-default-sharding-strategy/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
ALTER DEFAULT SHARDING STRATEGY
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/drop-default-sharding-strategy/" title="DROP DEFAULT SHARDING STRATEGY" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/drop-default-sharding-strategy/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
DROP DEFAULT SHARDING STRATEGY
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/drop-sharding-key-generator/" title="DROP SHARDING KEY GENERATOR" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/drop-sharding-key-generator/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
DROP SHARDING KEY GENERATOR
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/drop-sharding-algorithm/" title="DROP SHARDING ALGORITHM" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/drop-sharding-algorithm/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
DROP SHARDING ALGORITHM
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/create-sharding-table-reference-rule/" title="CREATE SHARDING TABLE REFERENCE RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/create-sharding-table-reference-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
CREATE SHARDING TABLE REFERENCE RULE
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/alter-sharding-table-reference-rule/" title="ALTER SHARDING TABLE REFERENCE RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/alter-sharding-table-reference-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
ALTER SHARDING TABLE REFERENCE RULE
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/drop-sharding-table-reference-rule/" title="DROP SHARDING TABLE REFERENCE RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/drop-sharding-table-reference-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
DROP SHARDING TABLE REFERENCE RULE
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/create-broadcast-table-rule/" title="CREATE BROADCAST TABLE RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/create-broadcast-table-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
CREATE BROADCAST TABLE RULE
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/drop-broadcast-table-rule/" title="DROP BROADCAST TABLE RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/drop-broadcast-table-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
DROP BROADCAST TABLE RULE
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/single-table/" title="Single Table" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/single-table/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
Single Table
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/single-table/set-default-single-table-storage-unit/" title="SET DEFAULT SINGLE TABLE STORAGE UNIT" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/single-table/set-default-single-table-storage-unit/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SET DEFAULT SINGLE TABLE STORAGE UNIT
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/readwrite-splitting/" title="Readwrite-Splitting" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/readwrite-splitting/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
Readwrite-Splitting
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/readwrite-splitting/create-readwrite-splitting-rule/" title="CREATE READWRITE_SPLITTING RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/readwrite-splitting/create-readwrite-splitting-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
CREATE READWRITE_SPLITTING RULE
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/readwrite-splitting/alter-readwrite-splitting-rule/" title="ALTER READWRITE_SPLITTING RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/readwrite-splitting/alter-readwrite-splitting-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
ALTER READWRITE_SPLITTING RULE
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/readwrite-splitting/drop-readwrite-splitting-rule/" title="DROP READWRITE_SPLITTING RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/readwrite-splitting/drop-readwrite-splitting-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
DROP READWRITE_SPLITTING RULE
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/encrypt/" title="Encrypt" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/encrypt/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
Encrypt
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/encrypt/create-encrypt-rule/" title="CREATE ENCRYPT RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/encrypt/create-encrypt-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
CREATE ENCRYPT RULE
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/encrypt/alter-encrypt-rule/" title="ALTER ENCRYPT RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/encrypt/alter-encrypt-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
ALTER ENCRYPT RULE
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/encrypt/drop-encrypt-rule/" title="DROP ENCRYPT RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/encrypt/drop-encrypt-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
DROP ENCRYPT RULE
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/mask/" title="Mask" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/mask/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
Mask
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/mask/create-mask-rule/" title="CREATE MASK RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/mask/create-mask-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
CREATE MASK RULE
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/mask/alter-mask-rule/" title="ALTER MASK RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/mask/alter-mask-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
ALTER MASK RULE
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/mask/drop-mask-rule/" title="DROP MASK RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/mask/drop-mask-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
DROP MASK RULE
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/shadow/" title="Shadow" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/shadow/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
Shadow
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/shadow/create-shadow-rule/" title="CREATE SHADOW RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/shadow/create-shadow-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
CREATE SHADOW RULE
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/shadow/alter-shadow-rule/" title="ALTER SHADOW RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/shadow/alter-shadow-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
ALTER SHADOW RULE
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/shadow/drop-shadow-rule/" title="DROP SHADOW RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/shadow/drop-shadow-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
DROP SHADOW RULE
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/shadow/create-default-shadow-algorithm/" title="CREATE DEFAULT SHADOW ALGORITHM" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/shadow/create-default-shadow-algorithm/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
CREATE DEFAULT SHADOW ALGORITHM
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/shadow/alter-default-shadow-algorithm/" title="ALTER DEFAULT SHADOW ALGORITHM" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/shadow/alter-default-shadow-algorithm/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
ALTER DEFAULT SHADOW ALGORITHM
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/shadow/drop-default-shadow-algorithm/" title="DROP DEFAULT SHADOW ALGORITHM" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/shadow/drop-default-shadow-algorithm/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
DROP DEFAULT SHADOW ALGORITHM
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/shadow/drop-shadow-algorithm/" title="DROP SHADOW ALGORITHM" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/shadow/drop-shadow-algorithm/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
DROP SHADOW ALGORITHM
</a>
</li>
</ul>
</li>
</ul>
</li>
</ul>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/" title="RQL Syntax" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
RQL Syntax
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/storage-unit-query/" title="Storage Unit Query" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/storage-unit-query/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
Storage Unit Query
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/storage-unit-query/show-storage-units/" title="SHOW STORAGE UNITS" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/storage-unit-query/show-storage-units/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW STORAGE UNITS
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/" title="Rule Query" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
Rule Query
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/" title="Sharding" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
Sharding
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/show-sharding-table-rule/" title="SHOW SHARDING TABLE RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/show-sharding-table-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW SHARDING TABLE RULE
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/show-sharding-algorithms/" title="SHOW SHARDING ALGORITHMS" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/show-sharding-algorithms/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW SHARDING ALGORITHMS
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/show-unused-sharding-algorithms/" title="SHOW UNUSED SHARDING ALGORITHMS" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/show-unused-sharding-algorithms/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW UNUSED SHARDING ALGORITHMS
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/show-default-sharding-strategy/" title="SHOW DEFAULT SHARDING STRATEGY" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/show-default-sharding-strategy/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW DEFAULT SHARDING STRATEGY
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/show-sharding-key-generator/" title="SHOW SHARDING KEY GENERATORS" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/show-sharding-key-generator/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW SHARDING KEY GENERATORS
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/show-unused-sharding-key-generators/" title="SHOW UNUSED SHARDING KEY GENERATORS" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/show-unused-sharding-key-generators/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW UNUSED SHARDING KEY GENERATORS
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/show-sharding-auditors/" title="SHOW SHARDING AUDITORS" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/show-sharding-auditors/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW SHARDING AUDITORS
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/show-unused-sharding-auditors/" title="SHOW UNUSED SHARDING AUDITORS" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/show-unused-sharding-auditors/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW UNUSED SHARDING AUDITORS
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/show-sharding-table-nodes/" title="SHOW SHARDING TABLE NODES" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/show-sharding-table-nodes/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW SHARDING TABLE NODES
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/show-sharding-table-rules-used-algorithm/" title="SHOW SHARDING TABLE NODES" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/show-sharding-table-rules-used-algorithm/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW SHARDING TABLE NODES
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/show-sharding-table-rules-used-key-generator/" title="SHOW SHARDING TABLE RULES USED KEY GENERATOR" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/show-sharding-table-rules-used-key-generator/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW SHARDING TABLE RULES USED KEY GENERATOR
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/show-sharding-table-rules-used-auditor/" title="SHOW SHARDING TABLE RULES USED AUDITOR" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/show-sharding-table-rules-used-auditor/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW SHARDING TABLE RULES USED AUDITOR
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/show-sharding-table-reference-rules/" title="SHOW SHARDING TABLE REFERENCE RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/show-sharding-table-reference-rules/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW SHARDING TABLE REFERENCE RULE
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/show-broadcast-table-rule/" title="SHOW BROADCAST TABLE RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/show-broadcast-table-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW BROADCAST TABLE RULE
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/count-sharding-rule/" title="COUNT SHARDING RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/count-sharding-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
COUNT SHARDING RULE
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/single-table/" title="Single Table" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/single-table/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
Single Table
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/single-table/show-single-table/" title="SHOW SINGLE TABLE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/single-table/show-single-table/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW SINGLE TABLE
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/single-table/show-deafult-single-table-storage-unit/" title="SHOW DEFAULT SINGLE TABLE STORAGE UNIT" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/single-table/show-deafult-single-table-storage-unit/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW DEFAULT SINGLE TABLE STORAGE UNIT
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/single-table/count-single-table/" title="COUNT SINGLE_TABLE RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/single-table/count-single-table/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
COUNT SINGLE_TABLE RULE
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/readwrite-splitting/" title="Readwrite-Splitting" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/readwrite-splitting/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
Readwrite-Splitting
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/readwrite-splitting/show-readwrite-splitting-rule/" title="SHOW READWRITE_SPLITTING RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/readwrite-splitting/show-readwrite-splitting-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW READWRITE_SPLITTING RULE
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/readwrite-splitting/count-readwrite-splitting-rule/" title="COUNT READWRITE_SPLITTING RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/readwrite-splitting/count-readwrite-splitting-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
COUNT READWRITE_SPLITTING RULE
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/encrypt/" title="Encrypt" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/encrypt/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
Encrypt
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/encrypt/show-encrypt-rule/" title="SHOW ENCRYPT RULES" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/encrypt/show-encrypt-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW ENCRYPT RULES
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/encrypt/count-encrypt-rule/" title="COUNT ENCRYPT RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/encrypt/count-encrypt-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
COUNT ENCRYPT RULE
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/mask/" title="Mask" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/mask/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
Mask
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/mask/show-mask-rule/" title="SHOW MASK RULES" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/mask/show-mask-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW MASK RULES
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/mask/count-mask-rule/" title="COUNT MASK RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/mask/count-mask-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
COUNT MASK RULE
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/shadow/" title="Shadow" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/shadow/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
Shadow
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/shadow/show-shadow-rule/" title="SHOW SHADOW RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/shadow/show-shadow-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW SHADOW RULE
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/shadow/show-shadow-table-rule/" title="SHOW SHADOW TABLE RULES" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/shadow/show-shadow-table-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW SHADOW TABLE RULES
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/shadow/show-shadow-algorithm/" title="SHOW SHADOW ALGORITHMS" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/shadow/show-shadow-algorithm/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW SHADOW ALGORITHMS
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/shadow/show-default-shadow-algorithm/" title="SHOW DEFAULT SHADOW ALGORITHM" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/shadow/show-default-shadow-algorithm/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW DEFAULT SHADOW ALGORITHM
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/shadow/count-shadow-rule/" title="COUNT SHADOW RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/shadow/count-shadow-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
COUNT SHADOW RULE
</a>
</li>
</ul>
</li>
</ul>
</li>
</ul>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/" title="RAL Syntax" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
RAL Syntax
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/global-rule/" title="GLOBAL RULE" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/global-rule/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
GLOBAL RULE
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/global-rule/show-authority-rule/" title="SHOW AUTHORITY RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/global-rule/show-authority-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW AUTHORITY RULE
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/global-rule/show-transaction-rule/" title="SHOW TRANSACTION RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/global-rule/show-transaction-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW TRANSACTION RULE
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/global-rule/alter-transaction-rule/" title="ALTER TRANSACTION RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/global-rule/alter-transaction-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
ALTER TRANSACTION RULE
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/global-rule/show-sql-parser-rule/" title="SHOW SQL_PARSER RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/global-rule/show-sql-parser-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW SQL_PARSER RULE
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/global-rule/alter-sql-parser-rule/" title="ALTER SQL_PARSER RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/global-rule/alter-sql-parser-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
ALTER SQL_PARSER RULE
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/global-rule/show-traffic-rule/" title="SHOW TRAFFIC RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/global-rule/show-traffic-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW TRAFFIC RULE
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/global-rule/alter-traffic-rule/" title="ALTER TRAFFIC RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/global-rule/alter-traffic-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
ALTER TRAFFIC RULE
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/circuit-breaker/" title="CIRCUIT BREAKER" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/circuit-breaker/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
CIRCUIT BREAKER
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/circuit-breaker/alter-readwrite-splitting-rule-enable-disable/" title="ALTER READWRITE_SPLITTING RULE ENABLE/DISABLE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/circuit-breaker/alter-readwrite-splitting-rule-enable-disable/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
ALTER READWRITE_SPLITTING RULE ENABLE/DISABLE
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/circuit-breaker/show-status-from-readwrite-splitting-rule/" title="SHOW STATUS FROM READWRITE_SPLITTING RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/circuit-breaker/show-status-from-readwrite-splitting-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW STATUS FROM READWRITE_SPLITTING RULE
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/circuit-breaker/show-compute-nodes/" title="SHOW COMPUTE NODES" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/circuit-breaker/show-compute-nodes/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW COMPUTE NODES
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/circuit-breaker/enable-disable-compute-node/" title="ENABLE/DISABLE COMPUTE NODE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/circuit-breaker/enable-disable-compute-node/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
ENABLE/DISABLE COMPUTE NODE
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/circuit-breaker/label-relabel-compute-node/" title="LABEL|RELABEL COMPUTE NODES" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/circuit-breaker/label-relabel-compute-node/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
LABEL|RELABEL COMPUTE NODES
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/circuit-breaker/unlabel-compute-node/" title="UNLABEL COMPUTE NODES" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/circuit-breaker/unlabel-compute-node/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
UNLABEL COMPUTE NODES
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/" title="MIGRATUION" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
MIGRATUION
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/show-migration-rule/" title="SHOW MIGRATION RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/show-migration-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW MIGRATION RULE
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/alter-migration-rule/" title="ALTER MIGRATION RULE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/alter-migration-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
ALTER MIGRATION RULE
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/register-migration-source-storage-unit/" title="REGISTER MIGRATION SOURCE STORAGE UNIT" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/register-migration-source-storage-unit/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
REGISTER MIGRATION SOURCE STORAGE UNIT
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/unregister-storage-unit/" title="UNREGISTER MIGRATION SOURCE STORAGE UNIT" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/unregister-storage-unit/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
UNREGISTER MIGRATION SOURCE STORAGE UNIT
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/show-migration-source-storage-units/" title="SHOW MIGRATION SOURCE STORAGE UNITS" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/show-migration-source-storage-units/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW MIGRATION SOURCE STORAGE UNITS
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/migrate-table-into/" title="MIGRATE TABLE INTO" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/migrate-table-into/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
MIGRATE TABLE INTO
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/show-migration-list/" title="SHOW MIGRATION LIST" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/show-migration-list/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW MIGRATION LIST
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/show-migration-status/" title="SHOW MIGRATION STATUS" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/show-migration-status/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW MIGRATION STATUS
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/show-migration-check-algorithm/" title="SHOW MIGRATION CHECK ALGORITHM" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/show-migration-check-algorithm/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW MIGRATION CHECK ALGORITHM
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/check-migration/" title="CHECK MIGRATION " class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/check-migration/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
CHECK MIGRATION
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/show-migration-check-status/" title="SHOW MIGRATION CHECK STATUS" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/show-migration-check-status/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW MIGRATION CHECK STATUS
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/start-migration-check/" title="START MIGRATION CHECK" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/start-migration-check/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
START MIGRATION CHECK
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/stop-migration-check/" title="STOP MIGRATION CHECK" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/stop-migration-check/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
STOP MIGRATION CHECK
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/start-migration/" title="START MIGRATION" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/start-migration/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
START MIGRATION
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/stop-migration/" title="STOP MIGRATION" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/stop-migration/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
STOP MIGRATION
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/commit-migration/" title="COMMIT MIGRATION" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/commit-migration/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
COMMIT MIGRATION
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/rollback-migration/" title="ROLLBACK MIGRATION" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/rollback-migration/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
ROLLBACK MIGRATION
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/show-compute-node-info/" title="SHOW COMPUTE NODE INFO" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/show-compute-node-info/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW COMPUTE NODE INFO
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/show-compute-node-mode/" title="SHOW COMPUTE NODE MODE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/show-compute-node-mode/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW COMPUTE NODE MODE
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/set-dist-vairable/" title="SET DIST VARIABLE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/set-dist-vairable/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SET DIST VARIABLE
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/show-dist-variable/" title="SHOW DIST VARIABLE" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/show-dist-variable/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW DIST VARIABLE
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/refresh-table-metadata/" title="REFRESH TABLE METADATA" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/refresh-table-metadata/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
REFRESH TABLE METADATA
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/refresh-database-metadata/" title="REFRESH DATABASE METADATA FROM GOVERNANCE CENTER" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/refresh-database-metadata/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
REFRESH DATABASE METADATA FROM GOVERNANCE CENTER
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/show-table-metadata/" title="SHOW TABLE METADATA" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/show-table-metadata/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW TABLE METADATA
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/export-database-configuration/" title="EXPORT DATABASE CONFIGURATION" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/export-database-configuration/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
EXPORT DATABASE CONFIGURATION
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/import-database-configuration/" title="IMPORT DATABASE CONFIGURATION" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/import-database-configuration/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
IMPORT DATABASE CONFIGURATION
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/show-rules-used-storage-unit/" title="SHOW RULES USED STORAGE UNIT" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/ral/show-rules-used-storage-unit/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SHOW RULES USED STORAGE UNIT
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rul/" title="RUL Syntax" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rul/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
RUL Syntax
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rul/parse-sql/" title="PARSE SQL" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rul/parse-sql/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
PARSE SQL
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rul/format-sql/" title="FORMAT SQL" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rul/format-sql/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
FORMAT SQL
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/rul/preview-sql/" title="PREVIEW SQL" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rul/preview-sql/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
PREVIEW SQL
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/syntax/reserved-word/" title="Reserved word" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/reserved-word/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Reserved word
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/usage/" title="Usage" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/usage/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
Usage
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/usage/sharding-rule/" title="Sharding" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/usage/sharding-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Sharding
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/usage/readwirte-splitting-rule/" title="Readwrite_splitting" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/usage/readwirte-splitting-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Readwrite_splitting
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/usage/encrypt-rule/" title="Encrypt" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/usage/encrypt-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Encrypt
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/usage/mask-rule/" title="MASK" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/usage/mask-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
MASK
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/distsql/usage/shadow-rule/" title="Shadow" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/usage/shadow-rule/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Shadow
</a>
</li>
</ul>
</li>
</ul>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/migration/" title="Data Migration" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/migration/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
Data Migration
</a>
<ul>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/migration/build/" title="Build" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/migration/build/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Build
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/migration/usage/" title="Manual" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/migration/usage/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Manual
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/observability/" title="Observability" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/observability/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
</i>
Observability
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/optional-plugins/" title="Optional Plugins" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/optional-plugins/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
</i>
Optional Plugins
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/session/" title="Session Management" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/session/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
</i>
Session Management
</a>
</li>
<li data-nav-id="/en/user-manual/shardingsphere-proxy/logging/" title="Logging Configuration" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/logging/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
</i>
Logging Configuration
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/user-manual/common-config/" title="Common Configuration" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/common-config/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
<b>4.3. </b>Common Configuration
</a>
<ul>
<li data-nav-id="/en/user-manual/common-config/props/" title="Properties Configuration" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/common-config/props/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Properties Configuration
</a>
</li>
<li data-nav-id="/en/user-manual/common-config/builtin-algorithm/" title="Builtin Algorithm" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/common-config/builtin-algorithm/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
Builtin Algorithm
</a>
<ul>
<li data-nav-id="/en/user-manual/common-config/builtin-algorithm/metadata-repository/" title="Metadata Repository" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/common-config/builtin-algorithm/metadata-repository/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Metadata Repository
</a>
</li>
<li data-nav-id="/en/user-manual/common-config/builtin-algorithm/sharding/" title="Sharding Algorithm" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/common-config/builtin-algorithm/sharding/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Sharding Algorithm
</a>
</li>
<li data-nav-id="/en/user-manual/common-config/builtin-algorithm/keygen/" title="Key Generate Algorithm" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/common-config/builtin-algorithm/keygen/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Key Generate Algorithm
</a>
</li>
<li data-nav-id="/en/user-manual/common-config/builtin-algorithm/load-balance/" title="Load Balance Algorithm" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/common-config/builtin-algorithm/load-balance/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Load Balance Algorithm
</a>
</li>
<li data-nav-id="/en/user-manual/common-config/builtin-algorithm/encrypt/" title="Encryption Algorithm" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/common-config/builtin-algorithm/encrypt/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Encryption Algorithm
</a>
</li>
<li data-nav-id="/en/user-manual/common-config/builtin-algorithm/shadow/" title="Shadow Algorithm" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/common-config/builtin-algorithm/shadow/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Shadow Algorithm
</a>
</li>
<li data-nav-id="/en/user-manual/common-config/builtin-algorithm/sql-translator/" title="SQL Translator" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/common-config/builtin-algorithm/sql-translator/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SQL Translator
</a>
</li>
<li data-nav-id="/en/user-manual/common-config/builtin-algorithm/audit/" title="Sharding Audit Algorithm" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/common-config/builtin-algorithm/audit/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Sharding Audit Algorithm
</a>
</li>
<li data-nav-id="/en/user-manual/common-config/builtin-algorithm/mask/" title="Data Masking Algorithm" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/common-config/builtin-algorithm/mask/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Data Masking Algorithm
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/user-manual/common-config/sql-hint/" title="SQL Hint" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/common-config/sql-hint/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SQL Hint
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/user-manual/error-code/" title="Error Code" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/error-code/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
<b>4.4. </b>Error Code
</a>
<ul>
<li data-nav-id="/en/user-manual/error-code/sql-error-code/" title="SQL Error Code" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/error-code/sql-error-code/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SQL Error Code
</a>
</li>
<li data-nav-id="/en/user-manual/error-code/server-error-code/" title="Server Error Code" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/user-manual/error-code/server-error-code/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Server Error Code
</a>
</li>
</ul>
</li>
</ul>
</li>
<li data-nav-id="/en/dev-manual/" title="Dev Manual" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/dev-manual/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
<b>5. </b>Dev Manual
</a>
<ul>
<li data-nav-id="/en/dev-manual/mode/" title="Mode" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/dev-manual/mode/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
<b>5.1. </b>Mode
</a>
</li>
<li data-nav-id="/en/dev-manual/configuration/" title="Configuration" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/dev-manual/configuration/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
<b>5.2. </b>Configuration
</a>
</li>
<li data-nav-id="/en/dev-manual/kernel/" title="Kernel" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/dev-manual/kernel/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
<b>5.3. </b>Kernel
</a>
</li>
<li data-nav-id="/en/dev-manual/data-source/" title="DataSource" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/dev-manual/data-source/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
<b>5.4. </b>DataSource
</a>
</li>
<li data-nav-id="/en/dev-manual/sql-parser/" title="SQL Parser" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/dev-manual/sql-parser/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
<b>5.5. </b>SQL Parser
</a>
</li>
<li data-nav-id="/en/dev-manual/proxy/" title="Proxy" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/dev-manual/proxy/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
<b>5.6. </b>Proxy
</a>
</li>
<li data-nav-id="/en/dev-manual/sharding/" title="Data Sharding" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/dev-manual/sharding/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
<b>5.7. </b>Data Sharding
</a>
</li>
<li data-nav-id="/en/dev-manual/readwrite-splitting/" title="Readwrite-splitting" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/dev-manual/readwrite-splitting/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
<b>5.8. </b>Readwrite-splitting
</a>
</li>
<li data-nav-id="/en/dev-manual/transaction/" title="Distributed Transaction" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/dev-manual/transaction/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
<b>5.9. </b>Distributed Transaction
</a>
</li>
<li data-nav-id="/en/dev-manual/sql-audit/" title="SQL Audit" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/dev-manual/sql-audit/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
<b>5.10. </b>SQL Audit
</a>
</li>
<li data-nav-id="/en/dev-manual/encrypt/" title="Encryption" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/dev-manual/encrypt/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
<b>5.11. </b>Encryption
</a>
</li>
<li data-nav-id="/en/dev-manual/mask/" title="Data Masking" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/dev-manual/mask/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
<b>5.12. </b>Data Masking
</a>
</li>
<li data-nav-id="/en/dev-manual/shadow/" title="Shadow DB" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/dev-manual/shadow/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
<b>5.13. </b>Shadow DB
</a>
</li>
<li data-nav-id="/en/dev-manual/agent/" title="Observability" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/dev-manual/agent/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
<b>5.14. </b>Observability
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/test-manual/" title="Test Manual" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/test-manual/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
<b>6. </b>Test Manual
</a>
<ul>
<li data-nav-id="/en/test-manual/integration-test/" title="Integration Test" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/test-manual/integration-test/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
</i>
<b>6.1. </b>Integration Test
</a>
</li>
<li data-nav-id="/en/test-manual/performance-test/" title="Performance Test" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/test-manual/performance-test/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
<b>6.2. </b>Performance Test
</a>
<ul>
<li data-nav-id="/en/test-manual/performance-test/sysbench-proxy-norules-test/" title="SysBench ShardingSphere-Proxy Empty Rule Performance Test" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/test-manual/performance-test/sysbench-proxy-norules-test/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SysBench ShardingSphere-Proxy Empty Rule Performance Test
</a>
</li>
<li data-nav-id="/en/test-manual/performance-test/benchmarksql-proxy-sharding-test/" title="BenchmarkSQL ShardingSphere-Proxy Sharding Performance Test" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/test-manual/performance-test/benchmarksql-proxy-sharding-test/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
BenchmarkSQL ShardingSphere-Proxy Sharding Performance Test
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/test-manual/module-test/" title="Module Test" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/test-manual/module-test/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
<b>6.3. </b>Module Test
</a>
<ul>
<li data-nav-id="/en/test-manual/module-test/parser-test/" title="SQL Parser Test" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/test-manual/module-test/parser-test/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SQL Parser Test
</a>
</li>
<li data-nav-id="/en/test-manual/module-test/rewrite-test/" title="SQL Rewrite Test" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/test-manual/module-test/rewrite-test/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SQL Rewrite Test
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/test-manual/pipeline-e2e-test/" title="Pipeline E2E Test" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/test-manual/pipeline-e2e-test/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
</i>
<b>6.4. </b>Pipeline E2E Test
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/reference/" title="Reference" class="dd-item
parent
">
<a href="https://shardingsphere.apache.org/document/current/en/reference/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
<b>7. </b>Reference
</a>
<ul>
<li data-nav-id="/en/reference/db-compatibility/" title="Database Compatibility" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/reference/db-compatibility/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
</i>
<b>7.1. </b>Database Compatibility
</a>
</li>
<li data-nav-id="/en/reference/gateway/" title="Database Gateway" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/reference/gateway/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
</i>
<b>7.2. </b>Database Gateway
</a>
</li>
<li data-nav-id="/en/reference/management/" title="Management" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/reference/management/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
</i>
<b>7.3. </b>Management
</a>
</li>
<li data-nav-id="/en/reference/sharding/" title="Sharding" class="dd-item
parent
">
<a href="https://shardingsphere.apache.org/document/current/en/reference/sharding/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
<b>7.4. </b>Sharding
</a>
<ul>
<li data-nav-id="/en/reference/sharding/parse/" title="Parse Engine" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/reference/sharding/parse/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Parse Engine
</a>
</li>
<li data-nav-id="/en/reference/sharding/route/" title="Route Engine" class="dd-item active">
<a href="https://shardingsphere.apache.org/document/current/en/reference/sharding/route/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Route Engine
</a>
</li>
<li data-nav-id="/en/reference/sharding/rewrite/" title="Rewrite Engine" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/reference/sharding/rewrite/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Rewrite Engine
</a>
</li>
<li data-nav-id="/en/reference/sharding/execute/" title="Execute Engine" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/reference/sharding/execute/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Execute Engine
</a>
</li>
<li data-nav-id="/en/reference/sharding/merge/" title="Merger Engine" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/reference/sharding/merge/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Merger Engine
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/reference/transaction/" title="Transaction" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/reference/transaction/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg class="icon icon-down"
style="display: none;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M500.8 604.778667L267.306667 371.392l-45.226667 45.269333 278.741333 278.613334 278.485334-278.613334-45.248-45.248z" p-id="5376" ></path>
</svg>
<svg class="icon icon-right"
style="display: inline-block;"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="#777">
<path d="M593.450667 512.128L360.064 278.613333l45.290667-45.226666 278.613333 278.762666L405.333333 790.613333l-45.226666-45.269333z" p-id="5605" ></path>
</svg>
</i>
<b>7.5. </b>Transaction
</a>
<ul>
<li data-nav-id="/en/reference/transaction/2pc-xa-transaction/" title="XA Transaction" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/reference/transaction/2pc-xa-transaction/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
XA Transaction
</a>
</li>
<li data-nav-id="/en/reference/transaction/base-transaction-seata/" title="Seata BASE transaction" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/en/reference/transaction/base-transaction-seata/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Seata BASE transaction
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/reference/migration/" title="Data Migration" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/reference/migration/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
</i>
<b>7.6. </b>Data Migration
</a>
</li>
<li data-nav-id="/en/reference/encrypt/" title="Encryption" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/reference/encrypt/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
</i>
<b>7.7. </b>Encryption
</a>
</li>
<li data-nav-id="/en/reference/mask/" title="Mask" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/reference/mask/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
</i>
<b>7.8. </b>Mask
</a>
</li>
<li data-nav-id="/en/reference/shadow/" title="Shadow" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/reference/shadow/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
</i>
<b>7.9. </b>Shadow
</a>
</li>
<li data-nav-id="/en/reference/observability/" title="Oberservability" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/reference/observability/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
</i>
<b>7.10. </b>Oberservability
</a>
</li>
<li data-nav-id="/en/reference/architecture/" title="Architecture" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/reference/architecture/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
</i>
<b>7.11. </b>Architecture
</a>
</li>
</ul>
</li>
<li data-nav-id="/en/faq/" title="FAQ" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/faq/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
</i>
<b>8. </b>FAQ
</a>
</li>
<li data-nav-id="/en/downloads/" title="Downloads" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/en/downloads/">
<i class="collapse" style="display:inline; font-family:'courier';">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
</i>
<b>9. </b>Downloads
</a>
</li>
</ul>
</div>
<a class="padding" href="https://shardingsphere.apache.org/pdf/shardingsphere_docs_en.pdf">
Download PDF
</a>
<section id="footer">
<p></p>
</section>
</div>
</nav>
<section id="body">
<div id="overlay"></div>
<div class="padding highlightable">
<div>
<div id="top-bar">
<div id="top-github-link">
<a class="github-link" title='Edit this page' href="https://github.com/apache/shardingsphere/tree/master/docs/document/content/reference/sharding/route.en.md" target="blank">
<i class="fas fa-code-branch"></i>
<span id="top-github-link-text">Edit this page</span>
</a>
</div>
<div id="breadcrumbs" itemscope="" itemtype="http://data-vocabulary.org/Breadcrumb">
<span id="sidebar-toggle-span">
<a href="#" id="sidebar-toggle" data-sidebar-toggle="">
<i class="fas fa-bars"></i>
</a>
</span>
<span id="toc-menu"><i class="fas fa-list-alt"></i></span>
<span class="links">
Route Engine
</span>
</div>
</div>
</div>
<div id="head-tags">
</div>
<div id="body-inner">
<h1>
Route Engine
</h1>
<nav id="TableOfContents">
<ul>
<li><a href="#sharding-route">Sharding Route</a>
<ul>
<li><a href="#direct-route">Direct Route</a></li>
<li><a href="#standard-route">Standard Route</a></li>
<li><a href="#cartesian-route">Cartesian Route</a></li>
</ul>
</li>
<li><a href="#broadcast-route">Broadcast Route</a>
<ul>
<li><a href="#full-database-and-table-route">Full database and table route</a></li>
<li><a href="#full-database-route">Full database route</a></li>
<li><a href="#full-instance-route">Full instance route</a></li>
<li><a href="#unicast-route">Unicast Route</a></li>
<li><a href="#block-route">Block Route</a></li>
</ul>
</li>
</ul>
</nav>
<p>Sharding strategies for databases and tables are matched based on the parsing context, and routing paths are generated. SQL with shard keys can be divided into the single-shard router (the shard key operator is equal), multi-shard router (the shard key operator is IN), and range router (the shard key operator is BETWEEN). SQL that does not carry shard keys adopts broadcast routing.</p>
<p>Sharding strategies can usually be configured either by the built-in database or by the user. The built-in database scheme is relatively simple, and the built-in sharding strategy can be roughly divided into mantissa modulo, hash, range, label, time, etc.</p>
<p>The sharding strategies configured by the user are more flexible. You can customize the compound sharding strategy based on the user&rsquo;s requirements. If it is used with automatic data migration, users do not need to work on the sharding strategies.</p>
<p>Sharding and data balancing can be automatically achieved by the middle layer of the database, and distributed databases can achieve elastic scalability. In the planning of ShardingSphere, the elastic scaling function will be available at V4.x.</p>
<h2 id="sharding-route">Sharding Route</h2>
<p>The scenario that is routed based on shard keys is divided into three types: direct route, standard route, and Cartesian route.</p>
<h3 id="direct-route">Direct Route</h3>
<p>The requirement for direct route is relatively harsh. It needs to be sharded by Hint (using HintAPI to specify routes to databases and tables), and it can avoid SQL parsing and subsequent result merge on the premise of having database shards but not table shards.</p>
<p>Therefore, it is the most compatible one and can execute any SQL in complex scenarios including sub-queries and custom functions. The direct route can also be used when shard keys are not in SQL. For example, set the key for database sharding to <code>3</code>,</p>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-java" data-lang="java">hintManager<span style="color:#f92672">.</span><span style="color:#a6e22e">setDatabaseShardingValue</span><span style="color:#f92672">(</span>3<span style="color:#f92672">);</span>
</code></pre></div><p>If the routing algorithm is <code>value % 2</code>, when a logical database <code>t_order</code> corresponds to two physical databases<code>t_order_0</code> and <code>t_order_1</code>, the SQL will be executed on <code>t_order_1</code> after routing.
The following is a sample code using the API.</p>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-java" data-lang="java">String sql <span style="color:#f92672">=</span> <span style="color:#e6db74">&#34;SELECT * FROM t_order&#34;</span><span style="color:#f92672">;</span>
<span style="color:#66d9ef">try</span> <span style="color:#f92672">(</span>
HintManager hintManager <span style="color:#f92672">=</span> HintManager<span style="color:#f92672">.</span><span style="color:#a6e22e">getInstance</span><span style="color:#f92672">();</span>
Connection conn <span style="color:#f92672">=</span> dataSource<span style="color:#f92672">.</span><span style="color:#a6e22e">getConnection</span><span style="color:#f92672">();</span>
PreparedStatement pstmt <span style="color:#f92672">=</span> conn<span style="color:#f92672">.</span><span style="color:#a6e22e">prepareStatement</span><span style="color:#f92672">(</span>sql<span style="color:#f92672">))</span> <span style="color:#f92672">{</span>
hintManager<span style="color:#f92672">.</span><span style="color:#a6e22e">setDatabaseShardingValue</span><span style="color:#f92672">(</span>3<span style="color:#f92672">);</span>
<span style="color:#66d9ef">try</span> <span style="color:#f92672">(</span>ResultSet rs <span style="color:#f92672">=</span> pstmt<span style="color:#f92672">.</span><span style="color:#a6e22e">executeQuery</span><span style="color:#f92672">())</span> <span style="color:#f92672">{</span>
<span style="color:#66d9ef">while</span> <span style="color:#f92672">(</span>rs<span style="color:#f92672">.</span><span style="color:#a6e22e">next</span><span style="color:#f92672">())</span> <span style="color:#f92672">{</span>
<span style="color:#75715e">//...
</span><span style="color:#75715e"></span> <span style="color:#f92672">}</span>
<span style="color:#f92672">}</span>
<span style="color:#f92672">}</span>
</code></pre></div><h3 id="standard-route">Standard Route</h3>
<p>The standard route is the most recommended sharding method, and it is applicable to SQL that does not contain an associated query or only contains the associated query between binding tables.</p>
<p>When the sharding operator is equal, the routing result will fall into a single database (table). When the sharding operator is BETWEEN or IN, the routing result will not necessarily fall into a unique database (table).</p>
<p>Therefore, logical SQL may eventually be split into multiple real SQL to be executed. For example, if the data sharding is carried out according to the odd and even numbers of order_id, the SQL for a single table query is as follows:</p>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-sql" data-lang="sql"><span style="color:#66d9ef">SELECT</span> <span style="color:#f92672">*</span> <span style="color:#66d9ef">FROM</span> t_order <span style="color:#66d9ef">WHERE</span> order_id <span style="color:#66d9ef">IN</span> (<span style="color:#ae81ff">1</span>, <span style="color:#ae81ff">2</span>);
</code></pre></div><p>Then the routing result should be:</p>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-sql" data-lang="sql"><span style="color:#66d9ef">SELECT</span> <span style="color:#f92672">*</span> <span style="color:#66d9ef">FROM</span> t_order_0 <span style="color:#66d9ef">WHERE</span> order_id <span style="color:#66d9ef">IN</span> (<span style="color:#ae81ff">1</span>, <span style="color:#ae81ff">2</span>);
<span style="color:#66d9ef">SELECT</span> <span style="color:#f92672">*</span> <span style="color:#66d9ef">FROM</span> t_order_1 <span style="color:#66d9ef">WHERE</span> order_id <span style="color:#66d9ef">IN</span> (<span style="color:#ae81ff">1</span>, <span style="color:#ae81ff">2</span>);
</code></pre></div><p>An associated query for a binding table is as complex as a single table query and they have the same performance. For example, if the SQL of an associated query that contains binding tables is as follows:</p>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-sql" data-lang="sql"><span style="color:#66d9ef">SELECT</span> <span style="color:#f92672">*</span> <span style="color:#66d9ef">FROM</span> t_order o <span style="color:#66d9ef">JOIN</span> t_order_item i <span style="color:#66d9ef">ON</span> o.order_id<span style="color:#f92672">=</span>i.order_id <span style="color:#66d9ef">WHERE</span> order_id <span style="color:#66d9ef">IN</span> (<span style="color:#ae81ff">1</span>, <span style="color:#ae81ff">2</span>);
</code></pre></div><p>Then the routing result should be:</p>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-sql" data-lang="sql"><span style="color:#66d9ef">SELECT</span> <span style="color:#f92672">*</span> <span style="color:#66d9ef">FROM</span> t_order_0 o <span style="color:#66d9ef">JOIN</span> t_order_item_0 i <span style="color:#66d9ef">ON</span> o.order_id<span style="color:#f92672">=</span>i.order_id <span style="color:#66d9ef">WHERE</span> order_id <span style="color:#66d9ef">IN</span> (<span style="color:#ae81ff">1</span>, <span style="color:#ae81ff">2</span>);
<span style="color:#66d9ef">SELECT</span> <span style="color:#f92672">*</span> <span style="color:#66d9ef">FROM</span> t_order_1 o <span style="color:#66d9ef">JOIN</span> t_order_item_1 i <span style="color:#66d9ef">ON</span> o.order_id<span style="color:#f92672">=</span>i.order_id <span style="color:#66d9ef">WHERE</span> order_id <span style="color:#66d9ef">IN</span> (<span style="color:#ae81ff">1</span>, <span style="color:#ae81ff">2</span>);
</code></pre></div><p>As you can see, the number of SQL splits is consistent with that of a single table.</p>
<h3 id="cartesian-route">Cartesian Route</h3>
<p>The Cartesian route is the most complex one because it cannot locate sharding rules according to the relationship between binding tables, so associated queries between unbound tables need to be disassembled and executed as cartesian product combinations. If the SQL in the previous example was not configured with binding table relationships, the routing result would be:</p>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-sql" data-lang="sql"><span style="color:#66d9ef">SELECT</span> <span style="color:#f92672">*</span> <span style="color:#66d9ef">FROM</span> t_order_0 o <span style="color:#66d9ef">JOIN</span> t_order_item_0 i <span style="color:#66d9ef">ON</span> o.order_id<span style="color:#f92672">=</span>i.order_id <span style="color:#66d9ef">WHERE</span> order_id <span style="color:#66d9ef">IN</span> (<span style="color:#ae81ff">1</span>, <span style="color:#ae81ff">2</span>);
<span style="color:#66d9ef">SELECT</span> <span style="color:#f92672">*</span> <span style="color:#66d9ef">FROM</span> t_order_0 o <span style="color:#66d9ef">JOIN</span> t_order_item_1 i <span style="color:#66d9ef">ON</span> o.order_id<span style="color:#f92672">=</span>i.order_id <span style="color:#66d9ef">WHERE</span> order_id <span style="color:#66d9ef">IN</span> (<span style="color:#ae81ff">1</span>, <span style="color:#ae81ff">2</span>);
<span style="color:#66d9ef">SELECT</span> <span style="color:#f92672">*</span> <span style="color:#66d9ef">FROM</span> t_order_1 o <span style="color:#66d9ef">JOIN</span> t_order_item_0 i <span style="color:#66d9ef">ON</span> o.order_id<span style="color:#f92672">=</span>i.order_id <span style="color:#66d9ef">WHERE</span> order_id <span style="color:#66d9ef">IN</span> (<span style="color:#ae81ff">1</span>, <span style="color:#ae81ff">2</span>);
<span style="color:#66d9ef">SELECT</span> <span style="color:#f92672">*</span> <span style="color:#66d9ef">FROM</span> t_order_1 o <span style="color:#66d9ef">JOIN</span> t_order_item_1 i <span style="color:#66d9ef">ON</span> o.order_id<span style="color:#f92672">=</span>i.order_id <span style="color:#66d9ef">WHERE</span> order_id <span style="color:#66d9ef">IN</span> (<span style="color:#ae81ff">1</span>, <span style="color:#ae81ff">2</span>);
</code></pre></div><p>The Cartesian route query has low performance, so think carefully when you use it.</p>
<h2 id="broadcast-route">Broadcast Route</h2>
<p>For SQL that does not carry shard keys, broadcast routes are used. According to the SQL type, it can be further divided into five types: full database and table route, full database route, full instance route, unicast route, and block route.</p>
<h3 id="full-database-and-table-route">Full database and table route</h3>
<p>The full database table route is used to handle operations on all real tables related to its logical tables in the database, including DQL and DML without shard keys, as well as DDL, etc. For example:</p>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-sql" data-lang="sql"><span style="color:#66d9ef">SELECT</span> <span style="color:#f92672">*</span> <span style="color:#66d9ef">FROM</span> t_order <span style="color:#66d9ef">WHERE</span> good_prority <span style="color:#66d9ef">IN</span> (<span style="color:#ae81ff">1</span>, <span style="color:#ae81ff">10</span>);
</code></pre></div><p>All tables in all databases will be traversed, matching logical tables and real table names one by one. The table that can be matched will be executed. The routing result would be:</p>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-sql" data-lang="sql"><span style="color:#66d9ef">SELECT</span> <span style="color:#f92672">*</span> <span style="color:#66d9ef">FROM</span> t_order_0 <span style="color:#66d9ef">WHERE</span> good_prority <span style="color:#66d9ef">IN</span> (<span style="color:#ae81ff">1</span>, <span style="color:#ae81ff">10</span>);
<span style="color:#66d9ef">SELECT</span> <span style="color:#f92672">*</span> <span style="color:#66d9ef">FROM</span> t_order_1 <span style="color:#66d9ef">WHERE</span> good_prority <span style="color:#66d9ef">IN</span> (<span style="color:#ae81ff">1</span>, <span style="color:#ae81ff">10</span>);
<span style="color:#66d9ef">SELECT</span> <span style="color:#f92672">*</span> <span style="color:#66d9ef">FROM</span> t_order_2 <span style="color:#66d9ef">WHERE</span> good_prority <span style="color:#66d9ef">IN</span> (<span style="color:#ae81ff">1</span>, <span style="color:#ae81ff">10</span>);
<span style="color:#66d9ef">SELECT</span> <span style="color:#f92672">*</span> <span style="color:#66d9ef">FROM</span> t_order_3 <span style="color:#66d9ef">WHERE</span> good_prority <span style="color:#66d9ef">IN</span> (<span style="color:#ae81ff">1</span>, <span style="color:#ae81ff">10</span>);
</code></pre></div><h3 id="full-database-route">Full database route</h3>
<p>The full database route is used to handle operations on the database, including database management commands of type SET for database settings and transaction control statements such as TCL.</p>
<p>In this case, all real database matching names are traversed based on the logical database name, and the command is executed in the real database. For example:</p>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-sql" data-lang="sql"><span style="color:#66d9ef">SET</span> autocommit<span style="color:#f92672">=</span><span style="color:#ae81ff">0</span>;
</code></pre></div><p>If the command is executed in <code>t_order</code>, <code>t_order</code> which has two real databases, it is actually executed on both <code>t_order_0</code> and <code>t_order_1</code>.</p>
<h3 id="full-instance-route">Full instance route</h3>
<p>Full instance route is used for DCL operations, and authorized statements are used for database instances.</p>
<p>No matter how many schemas are contained in an instance, each database instance is executed only once. For example:</p>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-sql" data-lang="sql"><span style="color:#66d9ef">CREATE</span> <span style="color:#66d9ef">USER</span> customer<span style="color:#f92672">@</span><span style="color:#ae81ff">127</span>.<span style="color:#ae81ff">0</span>.<span style="color:#ae81ff">0</span>.<span style="color:#ae81ff">1</span> identified <span style="color:#66d9ef">BY</span> <span style="color:#e6db74">&#39;123&#39;</span>;
</code></pre></div><p>This command will be executed on all real database instances to ensure that users can access each instance.</p>
<h3 id="unicast-route">Unicast Route</h3>
<p>The unicast route is used to obtain the information of a real table. It only needs to obtain data from any real table in any database. For example:</p>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-sql" data-lang="sql"><span style="color:#66d9ef">DESCRIBE</span> t_order;
</code></pre></div><p><code>t_order_0</code> and <code>t_order_1</code>, the two real tables of <code>t_order</code>, have the same description structure, so this command is executed only once on any real table.</p>
<h3 id="block-route">Block Route</h3>
<p>Block route is used to block SQL operations on the database, for example:</p>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-sql" data-lang="sql">USE order_db;
</code></pre></div><p>This command will not be executed in a real database because ShardingSphere uses the logical Schema and there is no need to send the Schema shift command to the database.</p>
<p>The overall structure of the routing engine is as follows.</p>
<p><img src="https://shardingsphere.apache.org/document/current/img/sharding/route_architecture_en.png" alt="Route Engine"></p>
<footer class="footline">
</footer>
</div>
</div>
<div id="navigation">
</div>
</section>
</div>
<div style="left: -1000px; overflow: scroll; position: absolute; top: -1000px; border: none; box-sizing: content-box; height: 200px; margin: 0px; padding: 0px; width: 200px;">
<div style="border: none; box-sizing: content-box; height: 200px; margin: 0px; padding: 0px; width: 200px;"></div>
</div>
<script src="https://shardingsphere.apache.org/document/current/js/clipboard.min.js?1686302707"></script>
<script src="https://shardingsphere.apache.org/document/current/js/perfect-scrollbar.min.js?1686302707"></script>
<script src="https://shardingsphere.apache.org/document/current/js/perfect-scrollbar.jquery.min.js?1686302707"></script>
<script src="https://shardingsphere.apache.org/document/current/js/jquery.sticky.js?1686302707"></script>
<script src="https://shardingsphere.apache.org/document/current/js/featherlight.min.js?1686302707"></script>
<script src="https://shardingsphere.apache.org/document/current/js/highlight.pack.js?1686302707"></script>
<script>hljs.initHighlightingOnLoad();</script>
<script src="https://shardingsphere.apache.org/document/current/js/modernizr.custom-3.6.0.js?1686302707"></script>
<script src="https://shardingsphere.apache.org/document/current/js/learn.js?1686302707"></script>
<script src="https://shardingsphere.apache.org/document/current/js/hugo-learn.js?1686302707"></script>
<script src="https://shardingsphere.apache.org/document/current/mermaid/mermaid.js?1686302707"></script>
<script>
mermaid.initialize({ startOnLoad: true });
</script>
<script>
try{
function log(fileName, category, locale){
window._hmt.push(['_trackEvent', 'document', 'download', locale ? 'PDF_'+locale : fileName]);
gtag('event', 'Downloads', {
'event_category' : locale ? 'PDF' : category,
'event_label' : locale ? locale+'.pdf' : fileName
});
}
$('.padding[href*=shardingsphere]').on('click', function(){
var locale = /cn/.test(location.pathname) ?'cn':'en';
log('','', locale)
})
function getFileName(str){
var strs = str.split('/');
return strs[strs.length - 1]
}
$('a[href$="src.zip"]').on('click', function(){
log(getFileName($(this).attr('href')), "SRC")
})
$('a[href$="zip.asc"]').on('click', function(){
log(getFileName($(this).attr('href')), "ASC")
})
$('a[href$="zip.sha512"]').on('click', function(){
log(getFileName($(this).attr('href')), "SHA512")
})
$('a[href$="tar.gz.asc"]').on('click', function(){
log(getFileName($(this).attr('href')), "ASC")
})
$('a[href$="tar.gz.sha512"]').on('click', function(){
log(getFileName($(this).attr('href')), "SHA512")
})
$('a[href$="tar.gz"]').on('click', function(){
log(getFileName($(this).attr('href')), "TAR")
})
}catch(ex){}
</script>
</body>
</html>