document/current/cn/reference/sharding/rewrite/index.html - shardingsphere-doc - Git at Google

 <!DOCTYPE html>
 <html lang="cn" 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>改写引擎 :: ShardingSphere</title>


     <link href="https://shardingsphere.apache.org/document/current/css/nucleus.css?1686302715" rel="stylesheet">
     <link href="https://shardingsphere.apache.org/document/current/css/fontawesome-all.min.css?1686302715" rel="stylesheet">
     <link href="https://shardingsphere.apache.org/document/current/css/hybrid.css?1686302715" rel="stylesheet">
     <link href="https://shardingsphere.apache.org/document/current/css/featherlight.min.css?1686302715" rel="stylesheet">
     <link href="https://shardingsphere.apache.org/document/current/css/perfect-scrollbar.min.css?1686302715" rel="stylesheet">
     <link href="https://shardingsphere.apache.org/document/current/css/auto-complete.css?1686302715" rel="stylesheet">
     <link href="https://shardingsphere.apache.org/document/current/css/atom-one-dark-reasonable.css?1686302715" rel="stylesheet">
     <link href="https://shardingsphere.apache.org/document/current/css/theme.css?1686302715" rel="stylesheet">
     <link href="https://shardingsphere.apache.org/document/current/css/tabs.css?1686302715" rel="stylesheet">
     <link href="https://shardingsphere.apache.org/document/current/css/hugo-theme.css?1686302715" rel="stylesheet">

     <link href="https://shardingsphere.apache.org/document/current/css/theme-white.css?1686302715" rel="stylesheet">


     <script src="https://shardingsphere.apache.org/document/current/js/jquery-3.3.1.min.js?1686302715"></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="/cn/reference/sharding/rewrite/">
     <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>
             复古
         </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>
             护眼
         </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>
             海天
         </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>
             深邃
         </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>
             暗黑
         </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>
             默认
         </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/cn/reference/sharding/rewrite/"  selected  >current</option>


                   <option id="5.3.0" value="https://shardingsphere.apache.org/document/5.3.0/cn/reference/sharding/rewrite/"  >5.3.0</option>


                   <option id="5.2.1" value="https://shardingsphere.apache.org/document/5.2.1/cn/reference/sharding/rewrite/"  >5.2.1</option>


                   <option id="5.2.0" value="https://shardingsphere.apache.org/document/5.2.0/cn/reference/sharding/rewrite/"  >5.2.0</option>


                   <option id="5.1.2" value="https://shardingsphere.apache.org/document/5.1.2/cn/reference/sharding/rewrite/"  >5.1.2</option>


                   <option id="5.1.1" value="https://shardingsphere.apache.org/document/5.1.1/cn/reference/sharding/rewrite/"  >5.1.1</option>


                   <option id="5.1.0" value="https://shardingsphere.apache.org/document/5.1.0/cn/reference/sharding/rewrite/"  >5.1.0</option>


                   <option id="5.0.0" value="https://shardingsphere.apache.org/document/5.0.0/cn/reference/sharding/rewrite/"  >5.0.0</option>


                   <option id="4.1.1" value="https://shardingsphere.apache.org/document/4.1.1/cn/reference/sharding/rewrite/"  >4.1.1</option>


                   <option id="4.1.0" value="https://shardingsphere.apache.org/document/4.1.0/cn/reference/sharding/rewrite/"  >4.1.0</option>


                   <option id="4.0.1" value="https://shardingsphere.apache.org/document/4.0.1/cn/reference/sharding/rewrite/"  >4.0.1</option>


                   <option id="4.0.0" value="https://shardingsphere.apache.org/document/4.0.0/cn/reference/sharding/rewrite/"  >4.0.0</option>


                   <option id="3.1.0" value="https://shardingsphere.apache.org/document/3.1.0/cn/reference/sharding/rewrite/"  >3.1.0</option>


                   <option id="3.0.0" value="https://shardingsphere.apache.org/document/3.0.0/cn/reference/sharding/rewrite/"  >3.0.0</option>


                   <option id="2.0.3" value="https://shardingsphere.apache.org/document/2.0.3/cn/reference/sharding/rewrite/"  >2.0.3</option>


                   <option id="2.0.2" value="https://shardingsphere.apache.org/document/2.0.2/cn/reference/sharding/rewrite/"  >2.0.2</option>


                   <option id="2.0.1" value="https://shardingsphere.apache.org/document/2.0.1/cn/reference/sharding/rewrite/"  >2.0.1</option>


                   <option id="2.0.0" value="https://shardingsphere.apache.org/document/2.0.0/cn/reference/sharding/rewrite/"  >2.0.0</option>


                   <option id="1.5.4" value="https://shardingsphere.apache.org/document/1.5.4/cn/reference/sharding/rewrite/"  >1.5.4</option>


                   <option id="1.5.3" value="https://shardingsphere.apache.org/document/1.5.3/cn/reference/sharding/rewrite/"  >1.5.3</option>


                   <option id="1.5.2" value="https://shardingsphere.apache.org/document/1.5.2/cn/reference/sharding/rewrite/"  >1.5.2</option>


                   <option id="1.5.1" value="https://shardingsphere.apache.org/document/1.5.1/cn/reference/sharding/rewrite/"  >1.5.1</option>


                   <option id="1.5.0" value="https://shardingsphere.apache.org/document/1.5.0/cn/reference/sharding/rewrite/"  >1.5.0</option>


                   <option id="1.4.2" value="https://shardingsphere.apache.org/document/1.4.2/cn/reference/sharding/rewrite/"  >1.4.2</option>


                   <option id="1.4.1" value="https://shardingsphere.apache.org/document/1.4.1/cn/reference/sharding/rewrite/"  >1.4.1</option>


                   <option id="1.4.0" value="https://shardingsphere.apache.org/document/1.4.0/cn/reference/sharding/rewrite/"  >1.4.0</option>


                   <option id="1.3.3" value="https://shardingsphere.apache.org/document/1.3.3/cn/reference/sharding/rewrite/"  >1.3.3</option>


                   <option id="1.3.2" value="https://shardingsphere.apache.org/document/1.3.2/cn/reference/sharding/rewrite/"  >1.3.2</option>


                   <option id="1.3.1" value="https://shardingsphere.apache.org/document/1.3.1/cn/reference/sharding/rewrite/"  >1.3.1</option>


                   <option id="1.3.0" value="https://shardingsphere.apache.org/document/1.3.0/cn/reference/sharding/rewrite/"  >1.3.0</option>


                   <option id="1.2.1" value="https://shardingsphere.apache.org/document/1.2.1/cn/reference/sharding/rewrite/"  >1.2.1</option>


                   <option id="1.2.0" value="https://shardingsphere.apache.org/document/1.2.0/cn/reference/sharding/rewrite/"  >1.2.0</option>


                   <option id="1.1.0" value="https://shardingsphere.apache.org/document/1.1.0/cn/reference/sharding/rewrite/"  >1.1.0</option>


                   <option id="1.0.1" value="https://shardingsphere.apache.org/document/1.0.1/cn/reference/sharding/rewrite/"  >1.0.1</option>


                   <option id="1.0.0" value="https://shardingsphere.apache.org/document/1.0.0/cn/reference/sharding/rewrite/"  >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/rewrite/">English</option>


 <option id="cn" value="/document/current/cn/reference/sharding/rewrite/" selected>简体中文</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?1686302715"></script>
 <script type="text/javascript" src="https://shardingsphere.apache.org/document/current/js/auto-complete.js?1686302715"></script>
 <script type="text/javascript">

         var baseurl = "https:\/\/shardingsphere.apache.org\/document\/current\/\/cn";

 </script>
 <script type="text/javascript" src="https://shardingsphere.apache.org/document/current/js/search.js?1686302715"></script>


     </div>

       <div class="highlightable">
       <div class="leftMenu">
       <ul class="topics">


       <li data-nav-id="/cn/overview/" title="概览" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>概览

         </a>


       </li>


       <li data-nav-id="/cn/quick-start/" title="快速入门" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>快速入门

         </a>


           <ul>


         <li data-nav-id="/cn/quick-start/shardingsphere-jdbc-quick-start/" title="ShardingSphere-JDBC" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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="/cn/quick-start/shardingsphere-proxy-quick-start/" title="ShardingSphere-Proxy" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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="/cn/features/" title="功能" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>功能

         </a>


           <ul>


       <li data-nav-id="/cn/features/sharding/" title="数据分片" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>数据分片

         </a>


           <ul>


         <li data-nav-id="/cn/features/sharding/concept/" title="核心概念" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           核心概念

           </a>
       </li>


         <li data-nav-id="/cn/features/sharding/limitation/" title="使用限制" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           使用限制

           </a>
       </li>


         <li data-nav-id="/cn/features/sharding/appendix/" title="附录" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           附录

           </a>
       </li>


           </ul>

       </li>


       <li data-nav-id="/cn/features/transaction/" title="分布式事务" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>分布式事务

         </a>


           <ul>


         <li data-nav-id="/cn/features/transaction/concept/" title="核心概念" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           核心概念

           </a>
       </li>


         <li data-nav-id="/cn/features/transaction/limitations/" title="使用限制" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           使用限制

           </a>
       </li>


         <li data-nav-id="/cn/features/transaction/appendix/" title="附录" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           附录

           </a>
       </li>


           </ul>

       </li>


       <li data-nav-id="/cn/features/readwrite-splitting/" title="读写分离" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>读写分离

         </a>


           <ul>


         <li data-nav-id="/cn/features/readwrite-splitting/concept/" title="核心概念" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           核心概念

           </a>
       </li>


         <li data-nav-id="/cn/features/readwrite-splitting/limitations/" title="使用限制" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           使用限制

           </a>
       </li>


           </ul>

       </li>


       <li data-nav-id="/cn/features/db-gateway/" title="数据库网关" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>数据库网关

         </a>


           <ul>


         <li data-nav-id="/cn/features/db-gateway/concept/" title="核心概念" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           核心概念

           </a>
       </li>


         <li data-nav-id="/cn/features/db-gateway/limitations/" title="使用限制" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           使用限制

           </a>
       </li>


           </ul>

       </li>


       <li data-nav-id="/cn/features/management/" title="流量治理" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>流量治理

         </a>


           <ul>


         <li data-nav-id="/cn/features/management/concept/" title="核心概念" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           核心概念

           </a>
       </li>


           </ul>

       </li>


       <li data-nav-id="/cn/features/migration/" title="数据迁移" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>数据迁移

         </a>


           <ul>


         <li data-nav-id="/cn/features/migration/concept/" title="核心概念" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           核心概念

           </a>
       </li>


         <li data-nav-id="/cn/features/migration/limitations/" title="使用限制" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           使用限制

           </a>
       </li>


           </ul>

       </li>


       <li data-nav-id="/cn/features/encrypt/" title="数据加密" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>数据加密

         </a>


           <ul>


         <li data-nav-id="/cn/features/encrypt/concept/" title="核心概念" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           核心概念

           </a>
       </li>


         <li data-nav-id="/cn/features/encrypt/limitations/" title="使用限制" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           使用限制

           </a>
       </li>


         <li data-nav-id="/cn/features/encrypt/appendix/" title="附录" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           附录

           </a>
       </li>


           </ul>

       </li>


       <li data-nav-id="/cn/features/mask/" title="数据脱敏" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>数据脱敏

         </a>


           <ul>


         <li data-nav-id="/cn/features/mask/concept/" title="核心概念" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           核心概念

           </a>
       </li>


         <li data-nav-id="/cn/features/mask/limitations/" title="使用限制" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           使用限制

           </a>
       </li>


           </ul>

       </li>


       <li data-nav-id="/cn/features/shadow/" title="影子库" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>影子库

         </a>


           <ul>


         <li data-nav-id="/cn/features/shadow/concept/" title="核心概念" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           核心概念

           </a>
       </li>


         <li data-nav-id="/cn/features/shadow/limitations/" title="使用限制" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           使用限制

           </a>
       </li>


           </ul>

       </li>


       <li data-nav-id="/cn/features/observability/" title="可观察性" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>可观察性

         </a>


           <ul>


         <li data-nav-id="/cn/features/observability/concept/" title="核心概念" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           核心概念

           </a>
       </li>


           </ul>

       </li>


           </ul>

       </li>


       <li data-nav-id="/cn/user-manual/" title="用户手册" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>用户手册

         </a>


           <ul>


       <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/" title="ShardingSphere-JDBC" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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="/cn/user-manual/shardingsphere-jdbc/yaml-config/" title="YAML 配置" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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 配置

         </a>


           <ul>


         <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/yaml-config/mode/" title="模式配置" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           模式配置

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/yaml-config/data-source/" title="数据源配置" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           数据源配置

           </a>
       </li>


       <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/yaml-config/rules/" title="规则配置" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>
             规则配置

         </a>


           <ul>


         <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/yaml-config/rules/sharding/" title="数据分片" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           数据分片

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/yaml-config/rules/readwrite-splitting/" title="读写分离" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           读写分离

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/yaml-config/rules/transaction/" title="分布式事务" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           分布式事务

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/yaml-config/rules/encrypt/" title="数据加密" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           数据加密

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/yaml-config/rules/mask/" title="数据脱敏" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           数据脱敏

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/yaml-config/rules/shadow/" title="影子库" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           影子库

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/yaml-config/rules/sql-parser/" title="SQL 解析" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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 解析

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/yaml-config/rules/sql-translator/" title="SQL 翻译" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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 翻译

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/yaml-config/rules/mix/" title="混合规则" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           混合规则

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/yaml-config/rules/sharding-cache/" title="数据分片路由缓存" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           数据分片路由缓存

           </a>
       </li>


           </ul>

       </li>


         <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/yaml-config/algorithm/" title="算法配置" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           算法配置

           </a>
       </li>


       <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/yaml-config/jdbc-driver/" title="JDBC 驱动" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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 驱动

         </a>


           <ul>


       <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/yaml-config/jdbc-driver/spring-boot/" title="Spring Boot" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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="/cn/user-manual/shardingsphere-jdbc/yaml-config/jdbc-driver/spring-namespace/" title="Spring 命名空间" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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 命名空间

         </a>


       </li>


           </ul>

       </li>


           </ul>

       </li>


       <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/java-api/" title="Java API" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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="/cn/user-manual/shardingsphere-jdbc/java-api/mode/" title="模式配置" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           模式配置

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/java-api/data-source/" title="数据源配置" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           数据源配置

           </a>
       </li>


       <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/java-api/rules/" title="规则配置" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>
             规则配置

         </a>


           <ul>


         <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/java-api/rules/sharding/" title="数据分片" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           数据分片

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/java-api/rules/readwrite-splitting/" title="读写分离" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           读写分离

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/java-api/rules/transaction/" title="分布式事务" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           分布式事务

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/java-api/rules/encrypt/" title="数据加密" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           数据加密

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/java-api/rules/mask/" title="数据脱敏" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           数据脱敏

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/java-api/rules/shadow/" title="影子库" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           影子库

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/java-api/rules/sql-parser/" title="SQL 解析" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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 解析

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/java-api/rules/sql-translator/" title="SQL 翻译" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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 翻译

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/java-api/rules/mix/" title="混合规则" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           混合规则

           </a>
       </li>


           </ul>

       </li>


         <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/java-api/algorithm/" title="算法配置" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           算法配置

           </a>
       </li>


           </ul>

       </li>


       <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/special-api/" title="特殊 API" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>
             特殊 API

         </a>


           <ul>


       <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/special-api/sharding/" title="数据分片" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>
             数据分片

         </a>


           <ul>


         <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/special-api/sharding/hint/" title="强制路由" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           强制路由

           </a>
       </li>


           </ul>

       </li>


       <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/special-api/readwrite-splitting/" title="读写分离" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>
             读写分离

         </a>


           <ul>


         <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/special-api/readwrite-splitting/hint/" title="强制路由" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           强制路由

           </a>
       </li>


           </ul>

       </li>


       <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/special-api/transaction/" title="分布式事务" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>
             分布式事务

         </a>


           <ul>


         <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/special-api/transaction/java-api/" title="使用 Java API" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           使用 Java API

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/special-api/transaction/atomikos/" title="Atomikos 事务" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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 事务

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/special-api/transaction/narayana/" title="Narayana 事务" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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 事务

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/special-api/transaction/bitronix/" title="Bitronix 事务" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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 事务

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/special-api/transaction/seata/" title="Seata 事务" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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 事务

           </a>
       </li>


           </ul>

       </li>


           </ul>

       </li>


         <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/unsupported/" title="不支持项" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           不支持项

           </a>
       </li>


       <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/optional-plugins/" title="可选插件" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>
             可选插件

         </a>


       </li>


       <li data-nav-id="/cn/user-manual/shardingsphere-jdbc/observability/" title="可观察性" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>
             可观察性

         </a>


       </li>


           </ul>

       </li>


       <li data-nav-id="/cn/user-manual/shardingsphere-proxy/" title="ShardingSphere-Proxy" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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="/cn/user-manual/shardingsphere-proxy/startup/" title="启动手册" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>
             启动手册

         </a>


           <ul>


         <li data-nav-id="/cn/user-manual/shardingsphere-proxy/startup/bin/" title="使用二进制发布包" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           使用二进制发布包

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/shardingsphere-proxy/startup/docker/" title="使用 Docker" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           使用 Docker

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/shardingsphere-proxy/startup/graalvm-native-image/" title="构建 GraalVM Native Image(Alpha)" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           构建 GraalVM Native Image(Alpha)

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/shardingsphere-proxy/startup/helm/" title="使用 Helm" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           使用 Helm

           </a>
       </li>


       <li data-nav-id="/cn/user-manual/shardingsphere-proxy/startup/dependencies-download/" title="添加依赖" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>
             添加依赖

         </a>


           <ul>


         <li data-nav-id="/cn/user-manual/shardingsphere-proxy/startup/dependencies-download/add_bitronix_dependency/" title="添加 Bitronix 依赖" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           添加 Bitronix 依赖

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/shardingsphere-proxy/startup/dependencies-download/add_narayana_dependency/" title="添加 Narayana 依赖" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           添加 Narayana 依赖

           </a>
       </li>


           </ul>

       </li>


           </ul>

       </li>


       <li data-nav-id="/cn/user-manual/shardingsphere-proxy/yaml-config/" title="YAML 配置" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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 配置

         </a>


           <ul>


         <li data-nav-id="/cn/user-manual/shardingsphere-proxy/yaml-config/authority/" title="认证和授权" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           认证和授权

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/shardingsphere-proxy/yaml-config/props/" title="属性配置" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           属性配置

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/shardingsphere-proxy/yaml-config/rules/" title="规则配置" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           规则配置

           </a>
       </li>


           </ul>

       </li>


       <li data-nav-id="/cn/user-manual/shardingsphere-proxy/distsql/" title="DistSQL" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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="/cn/user-manual/shardingsphere-proxy/distsql/syntax/" title="语法" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>
             语法

         </a>


           <ul>


       <li data-nav-id="/cn/user-manual/shardingsphere-proxy/distsql/syntax/rdl/" title="RDL 语法" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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 语法

         </a>


           <ul>


       <li data-nav-id="/cn/user-manual/shardingsphere-proxy/distsql/syntax/rdl/storage-unit-definition/" title="存储单元定义" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>
             存储单元定义

         </a>


           <ul>


         <li data-nav-id="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/" title="规则定义" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>
             规则定义

         </a>


           <ul>


       <li data-nav-id="/cn/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/" title="分片" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>
             分片

         </a>


           <ul>


         <li data-nav-id="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/single-table/" title="单表" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>
             单表

         </a>


           <ul>


         <li data-nav-id="/cn/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/cn/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="/cn/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/readwrite-splitting/" title="读写分离" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>
             读写分离

         </a>


           <ul>


         <li data-nav-id="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/encrypt/" title="数据加密" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>
             数据加密

         </a>


           <ul>


         <li data-nav-id="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/mask/" title="数据脱敏" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>
             数据脱敏

         </a>


           <ul>


         <li data-nav-id="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/shadow/" title="影子库压测" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>
             影子库压测

         </a>


           <ul>


         <li data-nav-id="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/user-manual/shardingsphere-proxy/distsql/syntax/rql/" title="RQL 语法" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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 语法

         </a>


           <ul>


       <li data-nav-id="/cn/user-manual/shardingsphere-proxy/distsql/syntax/rql/storage-unit-query/" title="存储单元查询" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>
             存储单元查询

         </a>


           <ul>


         <li data-nav-id="/cn/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/cn/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="/cn/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/" title="规则查询" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>
             规则查询

         </a>


           <ul>


       <li data-nav-id="/cn/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/" title="分片" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>
             分片

         </a>


           <ul>


         <li data-nav-id="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/sharding/show-sharding-table-rules-used-algorithm/" title="SHOW SHARDING TABLE RULES USED ALGORITHM" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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 RULES USED ALGORITHM

           </a>
       </li>


         <li data-nav-id="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/single-table/" title="单表" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>
             单表

         </a>


           <ul>


         <li data-nav-id="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/readwrite-splitting/" title="读写分离" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>
             读写分离

         </a>


           <ul>


         <li data-nav-id="/cn/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/cn/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="/cn/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/cn/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="/cn/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/encrypt/" title="数据加密" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>
             数据加密

         </a>


           <ul>


         <li data-nav-id="/cn/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/cn/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="/cn/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/cn/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="/cn/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/mask/" title="数据脱敏" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>
             数据脱敏

         </a>


           <ul>


         <li data-nav-id="/cn/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/cn/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="/cn/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/cn/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="/cn/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/shadow/" title="影子库压测" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>
             影子库压测

         </a>


           <ul>


         <li data-nav-id="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/user-manual/shardingsphere-proxy/distsql/syntax/ral/" title="RAL 语法" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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 语法

         </a>


           <ul>


       <li data-nav-id="/cn/user-manual/shardingsphere-proxy/distsql/syntax/ral/global-rule/" title="全局规则" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>
             全局规则

         </a>


           <ul>


         <li data-nav-id="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/user-manual/shardingsphere-proxy/distsql/syntax/ral/circuit-breaker/" title="熔断" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>
             熔断

         </a>


           <ul>


         <li data-nav-id="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/user-manual/shardingsphere-proxy/distsql/syntax/ral/circuit-breaker/label-relabel-compute-node/" title="LABEL|RELABEL COMPUTE NODE" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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 NODE

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/shardingsphere-proxy/distsql/syntax/ral/circuit-breaker/unlabel-compute-node/" title="UNLABEL COMPUTE NODE" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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 NODE

           </a>
       </li>


           </ul>

       </li>


       <li data-nav-id="/cn/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/" title="数据迁移" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>
             数据迁移

         </a>


           <ul>


         <li data-nav-id="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/check-migration/" title="CHECK MIGRATION BY" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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 BY

           </a>
       </li>


         <li data-nav-id="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/start-migration/" title="START MIGRATION" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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="/cn/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/stop-migration/" title="STOP MIGRATION" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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="/cn/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/commit-migration/" title="COMMIT MIGRATION" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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="/cn/user-manual/shardingsphere-proxy/distsql/syntax/ral/migration/rollback-migration/" title="ROLLBACK MIGRATION" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/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/cn/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="/cn/user-manual/shardingsphere-proxy/distsql/syntax/rul/" title="RUL 语法" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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 语法

         </a>


           <ul>


         <li data-nav-id="/cn/user-manual/shardingsphere-proxy/distsql/syntax/rul/parse-sql/" title="PARSE SQL" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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="/cn/user-manual/shardingsphere-proxy/distsql/syntax/rul/format-sql/" title="FORMAT SQL" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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="/cn/user-manual/shardingsphere-proxy/distsql/syntax/rul/preview-sql/" title="PREVIEW SQL" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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="/cn/user-manual/shardingsphere-proxy/distsql/syntax/reserved-word/" title="保留字" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           保留字

           </a>
       </li>


           </ul>

       </li>


       <li data-nav-id="/cn/user-manual/shardingsphere-proxy/distsql/usage/" title="使用" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>
             使用

         </a>


           <ul>


         <li data-nav-id="/cn/user-manual/shardingsphere-proxy/distsql/usage/sharding-rule/" title="数据分片" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           数据分片

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/shardingsphere-proxy/distsql/usage/readwirte-splitting-rule/" title="读写分离" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           读写分离

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/shardingsphere-proxy/distsql/usage/encrypt-rule/" title="数据加密" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           数据加密

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/shardingsphere-proxy/distsql/usage/mask-rule/" title="数据脱敏" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           数据脱敏

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/shardingsphere-proxy/distsql/usage/shadow-rule/" title="影子库压测" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           影子库压测

           </a>
       </li>


           </ul>

       </li>


           </ul>

       </li>


       <li data-nav-id="/cn/user-manual/shardingsphere-proxy/migration/" title="数据迁移" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>
             数据迁移

         </a>


           <ul>


         <li data-nav-id="/cn/user-manual/shardingsphere-proxy/migration/build/" title="运行部署" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           运行部署

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/shardingsphere-proxy/migration/usage/" title="使用手册" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           使用手册

           </a>
       </li>


           </ul>

       </li>


       <li data-nav-id="/cn/user-manual/shardingsphere-proxy/observability/" title="可观察性" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>
             可观察性

         </a>


       </li>


       <li data-nav-id="/cn/user-manual/shardingsphere-proxy/optional-plugins/" title="可选插件" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>
             可选插件

         </a>


       </li>


       <li data-nav-id="/cn/user-manual/shardingsphere-proxy/session/" title="会话管理" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>
             会话管理

         </a>


       </li>


       <li data-nav-id="/cn/user-manual/shardingsphere-proxy/logging/" title="日志配置" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>
             日志配置

         </a>


       </li>


           </ul>

       </li>


       <li data-nav-id="/cn/user-manual/common-config/" title="通用配置" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>通用配置

         </a>


           <ul>


         <li data-nav-id="/cn/user-manual/common-config/props/" title="属性配置" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           属性配置

           </a>
       </li>


       <li data-nav-id="/cn/user-manual/common-config/builtin-algorithm/" title="内置算法" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>
             内置算法

         </a>


           <ul>


         <li data-nav-id="/cn/user-manual/common-config/builtin-algorithm/metadata-repository/" title="元数据持久化仓库" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           元数据持久化仓库

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/common-config/builtin-algorithm/sharding/" title="分片算法" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           分片算法

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/common-config/builtin-algorithm/keygen/" title="分布式序列算法" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           分布式序列算法

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/common-config/builtin-algorithm/load-balance/" title="负载均衡算法" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           负载均衡算法

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/common-config/builtin-algorithm/encrypt/" title="加密算法" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           加密算法

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/common-config/builtin-algorithm/shadow/" title="影子算法" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           影子算法

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/common-config/builtin-algorithm/sql-translator/" title="SQL 翻译" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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 翻译

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/common-config/builtin-algorithm/audit/" title="分片审计算法" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           分片审计算法

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/common-config/builtin-algorithm/mask/" title="脱敏算法" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           脱敏算法

           </a>
       </li>


           </ul>

       </li>


         <li data-nav-id="/cn/user-manual/common-config/sql-hint/" title="SQL Hint" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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="/cn/user-manual/error-code/" title="错误码" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>错误码

         </a>


           <ul>


         <li data-nav-id="/cn/user-manual/error-code/sql-error-code/" title="SQL 错误码" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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 错误码

           </a>
       </li>


         <li data-nav-id="/cn/user-manual/error-code/server-error-code/" title="服务器错误码" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           服务器错误码

           </a>
       </li>


           </ul>

       </li>


           </ul>

       </li>


       <li data-nav-id="/cn/dev-manual/" title="开发者手册" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>开发者手册

         </a>


           <ul>


         <li data-nav-id="/cn/dev-manual/mode/" title="运行模式" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>运行模式

           </a>
       </li>


         <li data-nav-id="/cn/dev-manual/configuration/" title="配置" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>配置

           </a>
       </li>


         <li data-nav-id="/cn/dev-manual/kernel/" title="内核" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>内核

           </a>
       </li>


         <li data-nav-id="/cn/dev-manual/data-source/" title="数据源" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>数据源

           </a>
       </li>


         <li data-nav-id="/cn/dev-manual/sql-parser/" title="SQL 解析" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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 解析

           </a>
       </li>


         <li data-nav-id="/cn/dev-manual/proxy/" title="代理端" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>代理端

           </a>
       </li>


         <li data-nav-id="/cn/dev-manual/sharding/" title="数据分片" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>数据分片

           </a>
       </li>


         <li data-nav-id="/cn/dev-manual/readwrite-splitting/" title="读写分离" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>读写分离

           </a>
       </li>


         <li data-nav-id="/cn/dev-manual/transaction/" title="分布式事务" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>分布式事务

           </a>
       </li>


         <li data-nav-id="/cn/dev-manual/sql-audit/" title="SQL 审计" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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 审计

           </a>
       </li>


         <li data-nav-id="/cn/dev-manual/encrypt/" title="数据加密" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>数据加密

           </a>
       </li>


         <li data-nav-id="/cn/dev-manual/mask/" title="数据脱敏" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>数据脱敏

           </a>
       </li>


         <li data-nav-id="/cn/dev-manual/shadow/" title="影子库" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>影子库

           </a>
       </li>


         <li data-nav-id="/cn/dev-manual/agent/" title="可观察性" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>可观察性

           </a>
       </li>


           </ul>

       </li>


       <li data-nav-id="/cn/test-manual/" title="测试手册" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>测试手册

         </a>


           <ul>


       <li data-nav-id="/cn/test-manual/integration-test/" title="集成测试" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>集成测试

         </a>


       </li>


       <li data-nav-id="/cn/test-manual/performance-test/" title="性能测试" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>性能测试

         </a>


           <ul>


         <li data-nav-id="/cn/test-manual/performance-test/sysbench-proxy-norules-test/" title="Sysbench ShardingSphere Proxy 空 Rules 性能测试" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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 空 Rules 性能测试

           </a>
       </li>


         <li data-nav-id="/cn/test-manual/performance-test/benchmarksql-proxy-sharding-test/" title="BenchmarkSQL ShardingSphere Proxy 分片性能测试" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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 分片性能测试

           </a>
       </li>


           </ul>

       </li>


       <li data-nav-id="/cn/test-manual/module-test/" title="模块测试" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>模块测试

         </a>


           <ul>


         <li data-nav-id="/cn/test-manual/module-test/parser-test/" title="SQL 解析测试" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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 解析测试

           </a>
       </li>


         <li data-nav-id="/cn/test-manual/module-test/rewrite-test/" title="SQL 改写测试" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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 改写测试

           </a>
       </li>


           </ul>

       </li>


       <li data-nav-id="/cn/test-manual/pipeline-e2e-test/" title="Pipeline E2E 测试" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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 测试

         </a>


       </li>


           </ul>

       </li>


       <li data-nav-id="/cn/reference/" title="技术参考" class="dd-item
           parent


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>技术参考

         </a>


           <ul>


       <li data-nav-id="/cn/reference/db-compatibility/" title="数据兼容性" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>数据兼容性

         </a>


       </li>


       <li data-nav-id="/cn/reference/gateway/" title="数据库网关" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>数据库网关

         </a>


       </li>


       <li data-nav-id="/cn/reference/management/" title="管控" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>管控

         </a>


       </li>


       <li data-nav-id="/cn/reference/sharding/" title="数据分片" class="dd-item
           parent


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>数据分片

         </a>


           <ul>


         <li data-nav-id="/cn/reference/sharding/parse/" title="解析引擎" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           解析引擎

           </a>
       </li>


         <li data-nav-id="/cn/reference/sharding/route/" title="路由引擎" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           路由引擎

           </a>
       </li>


         <li data-nav-id="/cn/reference/sharding/rewrite/" title="改写引擎" class="dd-item active">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           改写引擎

           </a>
       </li>


         <li data-nav-id="/cn/reference/sharding/execute/" title="执行引擎" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           执行引擎

           </a>
       </li>


         <li data-nav-id="/cn/reference/sharding/merge/" title="归并引擎" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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>
           归并引擎

           </a>
       </li>


           </ul>

       </li>


       <li data-nav-id="/cn/reference/transaction/" title="分布式事务" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>分布式事务

         </a>


           <ul>


         <li data-nav-id="/cn/reference/transaction/2pc-xa-transaction/" title="XA 事务" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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 事务

           </a>
       </li>


         <li data-nav-id="/cn/reference/transaction/base-transaction-seata/" title="Seata 柔性事务" class="dd-item ">
           <a href="https://shardingsphere.apache.org/document/current/cn/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 柔性事务

           </a>
       </li>


           </ul>

       </li>


       <li data-nav-id="/cn/reference/migration/" title="数据迁移" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>数据迁移

         </a>


       </li>


       <li data-nav-id="/cn/reference/encrypt/" title="数据加密" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>数据加密

         </a>


       </li>


       <li data-nav-id="/cn/reference/mask/" title="数据脱敏" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>数据脱敏

         </a>


       </li>


       <li data-nav-id="/cn/reference/shadow/" title="影子库" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>影子库

         </a>


       </li>


       <li data-nav-id="/cn/reference/observability/" title="可观察性" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>可观察性

         </a>


       </li>


       <li data-nav-id="/cn/reference/architecture/" title="基础架构" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>基础架构

         </a>


       </li>


           </ul>

       </li>


       <li data-nav-id="/cn/faq/" title="FAQ" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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="/cn/downloads/" title="下载" class="dd-item


           ">

         <a href="https://shardingsphere.apache.org/document/current/cn/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>下载

         </a>


       </li>


       </ul>


       </div>


         <a class="padding" href="https://shardingsphere.apache.org/pdf/shardingsphere_docs_cn.pdf">
           下载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/rewrite.cn.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">


                    改写引擎

                   </span>
                 </div>


               </div>
             </div>

         <div id="head-tags">

         </div>

         <div id="body-inner">

             <h1>

               改写引擎
             </h1>


 <nav id="TableOfContents">
   <ul>
     <li><a href="#正确性改写">正确性改写</a>
       <ul>
         <li><a href="#标识符改写">标识符改写</a></li>
         <li><a href="#补列">补列</a></li>
         <li><a href="#分页修正">分页修正</a></li>
         <li><a href="#批量拆分">批量拆分</a></li>
       </ul>
     </li>
     <li><a href="#优化改写">优化改写</a>
       <ul>
         <li><a href="#单节点优化">单节点优化</a></li>
         <li><a href="#流式归并优化">流式归并优化</a></li>
       </ul>
     </li>
   </ul>
 </nav>

 <p>工程师面向逻辑库与逻辑表书写的 SQL，并不能够直接在真实的数据库中执行，SQL 改写用于将逻辑 SQL 改写为在真实数据库中可以正确执行的 SQL。
 它包括正确性改写和优化改写两部分。</p>
 <h2 id="正确性改写">正确性改写</h2>
 <p>在包含分表的场景中，需要将分表配置中的逻辑表名称改写为路由之后所获取的真实表名称。仅分库则不需要表名称的改写。除此之外，还包括补列和分页信息修正等内容。</p>
 <h3 id="标识符改写">标识符改写</h3>
 <p>需要改写的标识符包括表名称、索引名称以及 Schema 名称。</p>
 <p>表名称改写是指将找到逻辑表在原始 SQL 中的位置，并将其改写为真实表的过程。表名称改写是一个典型的需要对 SQL 进行解析的场景。
 从一个最简单的例子开始，若逻辑 SQL 为：</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> order_id <span style="color:#66d9ef">FROM</span> t_order <span style="color:#66d9ef">WHERE</span> order_id<span style="color:#f92672">=</span><span style="color:#ae81ff">1</span>;
 </code></pre></div><p>假设该 SQL 配置分片键 order_id，并且 order_id=1 的情况，将路由至分片表 1。那么改写之后的 SQL 应该为：</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> order_id <span style="color:#66d9ef">FROM</span> t_order_1 <span style="color:#66d9ef">WHERE</span> order_id<span style="color:#f92672">=</span><span style="color:#ae81ff">1</span>;
 </code></pre></div><p>在这种最简单的 SQL 场景中，是否将 SQL 解析为抽象语法树似乎无关紧要，只要通过字符串查找和替换就可以达到 SQL 改写的效果。
 但是下面的场景，就无法仅仅通过字符串的查找替换来正确的改写 SQL 了：</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> order_id <span style="color:#66d9ef">FROM</span> t_order <span style="color:#66d9ef">WHERE</span> order_id<span style="color:#f92672">=</span><span style="color:#ae81ff">1</span> <span style="color:#66d9ef">AND</span> remarks<span style="color:#f92672">=</span><span style="color:#e6db74">&#39; t_order xxx&#39;</span>;
 </code></pre></div><p>正确改写的 SQL 应该是：</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> order_id <span style="color:#66d9ef">FROM</span> t_order_1 <span style="color:#66d9ef">WHERE</span> order_id<span style="color:#f92672">=</span><span style="color:#ae81ff">1</span> <span style="color:#66d9ef">AND</span> remarks<span style="color:#f92672">=</span><span style="color:#e6db74">&#39; t_order xxx&#39;</span>;
 </code></pre></div><p>而非：</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> order_id <span style="color:#66d9ef">FROM</span> t_order_1 <span style="color:#66d9ef">WHERE</span> order_id<span style="color:#f92672">=</span><span style="color:#ae81ff">1</span> <span style="color:#66d9ef">AND</span> remarks<span style="color:#f92672">=</span><span style="color:#e6db74">&#39; t_order_1 xxx&#39;</span>;
 </code></pre></div><p>由于表名之外可能含有表名称的类似字符，因此不能通过简单的字符串替换的方式去改写 SQL。</p>
 <p>下面再来看一个更加复杂的 SQL 改写场景：</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> t_order.order_id <span style="color:#66d9ef">FROM</span> t_order <span style="color:#66d9ef">WHERE</span> t_order.order_id<span style="color:#f92672">=</span><span style="color:#ae81ff">1</span> <span style="color:#66d9ef">AND</span> remarks<span style="color:#f92672">=</span><span style="color:#e6db74">&#39; t_order xxx&#39;</span>;
 </code></pre></div><p>上面的 SQL 将表名作为字段的标识符，因此在 SQL 改写时需要一并修改：</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> t_order_1.order_id <span style="color:#66d9ef">FROM</span> t_order_1 <span style="color:#66d9ef">WHERE</span> t_order_1.order_id<span style="color:#f92672">=</span><span style="color:#ae81ff">1</span> <span style="color:#66d9ef">AND</span> remarks<span style="color:#f92672">=</span><span style="color:#e6db74">&#39; t_order xxx&#39;</span>;
 </code></pre></div><p>而如果 SQL 中定义了表的别名，则无需连同别名一起修改，即使别名与表名相同亦是如此。例如：</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> t_order.order_id <span style="color:#66d9ef">FROM</span> t_order <span style="color:#66d9ef">AS</span> t_order <span style="color:#66d9ef">WHERE</span> t_order.order_id<span style="color:#f92672">=</span><span style="color:#ae81ff">1</span> <span style="color:#66d9ef">AND</span> remarks<span style="color:#f92672">=</span><span style="color:#e6db74">&#39; t_order xxx&#39;</span>;
 </code></pre></div><p>SQL 改写则仅需要改写表名称就可以了：</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> t_order.order_id <span style="color:#66d9ef">FROM</span> t_order_1 <span style="color:#66d9ef">AS</span> t_order <span style="color:#66d9ef">WHERE</span> t_order.order_id<span style="color:#f92672">=</span><span style="color:#ae81ff">1</span> <span style="color:#66d9ef">AND</span> remarks<span style="color:#f92672">=</span><span style="color:#e6db74">&#39; t_order xxx&#39;</span>;
 </code></pre></div><p>索引名称是另一个有可能改写的标识符。
 在某些数据库中（如 MySQL、SQLServer），索引是以表为维度创建的，在不同的表中的索引是可以重名的；
 而在另外的一些数据库中（如 PostgreSQL、Oracle），索引是以数据库为维度创建的，即使是作用在不同表上的索引，它们也要求其名称的唯一性。</p>
 <p>在 ShardingSphere 中，管理 Schema 的方式与管理表如出一辙，它采用逻辑 Schema 去管理一组数据源。
 因此，ShardingSphere 需要将用户在 SQL 中书写的逻辑 Schema 替换为真实的数据库 Schema。</p>
 <p>ShardingSphere 目前还不支持在 DQL 和 DML 语句中使用 Schema。
 它目前仅支持在数据库管理语句中使用 Schema，例如：</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">SHOW</span> COLUMNS <span style="color:#66d9ef">FROM</span> t_order <span style="color:#66d9ef">FROM</span> order_ds;
 </code></pre></div><p>Schema 的改写指的是将逻辑 Schema 采用单播路由的方式，改写为随机查找到的一个正确的真实 Schema。</p>
 <h3 id="补列">补列</h3>
 <p>需要在查询语句中补列通常由两种情况导致。
 第一种情况是 ShardingSphere 需要在结果归并时获取相应数据，但该数据并未能通过查询的 SQL 返回。
 这种情况主要是针对 GROUP BY 和 ORDER BY。结果归并时，需要根据 <code>GROUP BY</code> 和 <code>ORDER BY</code> 的字段项进行分组和排序，但如果原始 SQL 的选择项中若并未包含分组项或排序项，则需要对原始 SQL 进行改写。
 先看一下原始 SQL 中带有结果归并所需信息的场景：</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> order_id, user_id <span style="color:#66d9ef">FROM</span> t_order <span style="color:#66d9ef">ORDER</span> <span style="color:#66d9ef">BY</span> user_id;
 </code></pre></div><p>由于使用 user_id 进行排序，在结果归并中需要能够获取到 user_id 的数据，而上面的 SQL 是能够获取到 user_id 数据的，因此无需补列。</p>
 <p>如果选择项中不包含结果归并时所需的列，则需要进行补列，如以下 SQL：</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> order_id <span style="color:#66d9ef">FROM</span> t_order <span style="color:#66d9ef">ORDER</span> <span style="color:#66d9ef">BY</span> user_id;
 </code></pre></div><p>由于原始 SQL 中并不包含需要在结果归并中需要获取的 user_id，因此需要对 SQL 进行补列改写。补列之后的 SQL 是：</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> order_id, user_id <span style="color:#66d9ef">AS</span> ORDER_BY_DERIVED_0 <span style="color:#66d9ef">FROM</span> t_order <span style="color:#66d9ef">ORDER</span> <span style="color:#66d9ef">BY</span> user_id;
 </code></pre></div><p>值得一提的是，补列只会补充缺失的列，不会全部补充，而且，在 SELECT 语句中包含 * 的 SQL，也会根据表的元数据信息选择性补列。下面是一个较为复杂的 SQL 补列场景：</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> o.<span style="color:#f92672">*</span> <span style="color:#66d9ef">FROM</span> t_order o, t_order_item i <span style="color:#66d9ef">WHERE</span> o.order_id<span style="color:#f92672">=</span>i.order_id <span style="color:#66d9ef">ORDER</span> <span style="color:#66d9ef">BY</span> user_id, order_item_id;
 </code></pre></div><p>我们假设只有 t_order_item 表中包含 order_item_id 列，那么根据表的元数据信息可知，在结果归并时，排序项中的 user_id 是存在于 t_order 表中的，无需补列；order_item_id 并不在 t_order 中，因此需要补列。
 补列之后的 SQL 是：</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> o.<span style="color:#f92672">*</span>, order_item_id <span style="color:#66d9ef">AS</span> ORDER_BY_DERIVED_0 <span style="color:#66d9ef">FROM</span> t_order o, t_order_item i <span style="color:#66d9ef">WHERE</span> o.order_id<span style="color:#f92672">=</span>i.order_id <span style="color:#66d9ef">ORDER</span> <span style="color:#66d9ef">BY</span> user_id, order_item_id;
 </code></pre></div><p>补列的另一种情况是使用 AVG 聚合函数。在分布式的场景中，使用 (avg1 + avg2 + avg3) / 3 计算平均值并不正确，需要改写为 (sum1 + sum2 + sum3) / (count1 + count2 + count3)。
 这就需要将包含 AVG 的 SQL 改写为 SUM 和 COUNT，并在结果归并时重新计算平均值。例如以下 SQL：</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:#66d9ef">AVG</span>(price) <span style="color:#66d9ef">FROM</span> t_order <span style="color:#66d9ef">WHERE</span> user_id<span style="color:#f92672">=</span><span style="color:#ae81ff">1</span>;
 </code></pre></div><p>需要改写为：</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:#66d9ef">COUNT</span>(price) <span style="color:#66d9ef">AS</span> AVG_DERIVED_COUNT_0, <span style="color:#66d9ef">SUM</span>(price) <span style="color:#66d9ef">AS</span> AVG_DERIVED_SUM_0 <span style="color:#66d9ef">FROM</span> t_order <span style="color:#66d9ef">WHERE</span> user_id<span style="color:#f92672">=</span><span style="color:#ae81ff">1</span>;
 </code></pre></div><p>然后才能够通过结果归并正确的计算平均值。</p>
 <p>最后一种补列是在执行 INSERT 的 SQL 语句时，如果使用数据库自增主键，是无需写入主键字段的。
 但数据库的自增主键是无法满足分布式场景下的主键唯一的，因此 ShardingSphere 提供了分布式自增主键的生成策略，并且可以通过补列，让使用方无需改动现有代码，即可将分布式自增主键透明的替换数据库现有的自增主键。
 分布式自增主键的生成策略将在下文中详述，这里只阐述与 SQL 改写相关的内容。
 举例说明，假设表 t_order 的主键是 order_id，原始的 SQL 为：</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">INSERT</span> <span style="color:#66d9ef">INTO</span> t_order (<span style="color:#f92672">`</span>field1<span style="color:#f92672">`</span>, <span style="color:#f92672">`</span>field2<span style="color:#f92672">`</span>) <span style="color:#66d9ef">VALUES</span> (<span style="color:#ae81ff">10</span>, <span style="color:#ae81ff">1</span>);
 </code></pre></div><p>可以看到，上述 SQL 中并未包含自增主键，是需要数据库自行填充的。ShardingSphere 配置自增主键后，SQL 将改写为：</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">INSERT</span> <span style="color:#66d9ef">INTO</span> t_order (<span style="color:#f92672">`</span>field1<span style="color:#f92672">`</span>, <span style="color:#f92672">`</span>field2<span style="color:#f92672">`</span>, order_id) <span style="color:#66d9ef">VALUES</span> (<span style="color:#ae81ff">10</span>, <span style="color:#ae81ff">1</span>, xxxxx);
 </code></pre></div><p>改写后的 SQL 将在 INSERT FIELD 和 INSERT VALUE 的最后部分增加主键列名称以及自动生成的自增主键值。上述 SQL 中的 <code>xxxxx</code> 表示自动生成的自增主键值。</p>
 <p>如果 INSERT 的 SQL 中并未包含表的列名称，ShardingSphere 也可以根据判断参数个数以及表元信息中的列数量对比，并自动生成自增主键。例如，原始的 SQL 为：</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">INSERT</span> <span style="color:#66d9ef">INTO</span> t_order <span style="color:#66d9ef">VALUES</span> (<span style="color:#ae81ff">10</span>, <span style="color:#ae81ff">1</span>);
 </code></pre></div><p>改写的 SQL 将只在主键所在的列顺序处增加自增主键即可：</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">INSERT</span> <span style="color:#66d9ef">INTO</span> t_order <span style="color:#66d9ef">VALUES</span> (xxxxx, <span style="color:#ae81ff">10</span>, <span style="color:#ae81ff">1</span>);
 </code></pre></div><p>自增主键补列时，如果使用占位符的方式书写 SQL，则只需要改写参数列表即可，无需改写 SQL 本身。</p>
 <h3 id="分页修正">分页修正</h3>
 <p>从多个数据库获取分页数据与单数据库的场景是不同的。
 假设每 10 条数据为一页，取第 2 页数据。在分片环境下获取 LIMIT 10, 10，归并之后再根据排序条件取出前 10 条数据是不正确的。
 举例说明，若 SQL 为：</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> score <span style="color:#66d9ef">FROM</span> t_score <span style="color:#66d9ef">ORDER</span> <span style="color:#66d9ef">BY</span> score <span style="color:#66d9ef">DESC</span> <span style="color:#66d9ef">LIMIT</span> <span style="color:#ae81ff">1</span>, <span style="color:#ae81ff">2</span>;
 </code></pre></div><p>下图展示了不进行 SQL 的改写的分页执行结果。</p>
 <p><img src="https://shardingsphere.apache.org/document/current/img/sharding/pagination_without_rewrite.png" alt="不改写SQL的分页执行结果"></p>
 <p>通过图中所示，想要取得两个表中共同的按照分数排序的第 2 条和第 3 条数据，应该是 <code>95</code> 和 <code>90</code>。
 由于执行的 SQL 只能从每个表中获取第 2 条和第 3 条数据，即从 t_score_0 表中获取的是 <code>90</code> 和 <code>80</code>；从 t_score_1 表中获取的是 <code>85</code> 和 <code>75</code>。
 因此进行结果归并时，只能从获取的 <code>90</code>，<code>80</code>，<code>85</code> 和 <code>75</code> 之中进行归并，那么结果归并无论怎么实现，都不可能获得正确的结果。</p>
 <p>正确的做法是将分页条件改写为 <code>LIMIT 0, 3</code>，取出所有前两页数据，再结合排序条件计算出正确的数据。
 下图展示了进行 SQL 改写之后的分页执行结果。</p>
 <p><img src="https://shardingsphere.apache.org/document/current/img/sharding/pagination_with_rewrite.png" alt="改写SQL的分页执行结果"></p>
 <p>越获取偏移量位置靠后数据，使用 LIMIT 分页方式的效率就越低。
 有很多方法可以避免使用 LIMIT 进行分页。比如构建行记录数量与行偏移量的二级索引，或使用上次分页数据结尾 ID 作为下次查询条件的分页方式等。</p>
 <p>分页信息修正时，如果使用占位符的方式书写 SQL，则只需要改写参数列表即可，无需改写 SQL 本身。</p>
 <h3 id="批量拆分">批量拆分</h3>
 <p>在使用批量插入的 SQL 时，如果插入的数据是跨分片的，那么需要对 SQL 进行改写来防止将多余的数据写入到数据库中。
 插入操作与查询操作的不同之处在于，查询语句中即使用了不存在于当前分片的分片键，也不会对数据产生影响；而插入操作则必须将多余的分片键删除。
 举例说明，如下 SQL：</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">INSERT</span> <span style="color:#66d9ef">INTO</span> t_order (order_id, xxx) <span style="color:#66d9ef">VALUES</span> (<span style="color:#ae81ff">1</span>, <span style="color:#e6db74">&#39;xxx&#39;</span>), (<span style="color:#ae81ff">2</span>, <span style="color:#e6db74">&#39;xxx&#39;</span>), (<span style="color:#ae81ff">3</span>, <span style="color:#e6db74">&#39;xxx&#39;</span>);
 </code></pre></div><p>假设数据库仍然是按照 order_id 的奇偶值分为两片的，仅将这条 SQL 中的表名进行修改，然后发送至数据库完成 SQL 的执行 ，则两个分片都会写入相同的记录。
 虽然只有符合分片查询条件的数据才能够被查询语句取出，但存在冗余数据的实现方案并不合理。因此需要将 SQL 改写为：</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">INSERT</span> <span style="color:#66d9ef">INTO</span> t_order_0 (order_id, xxx) <span style="color:#66d9ef">VALUES</span> (<span style="color:#ae81ff">2</span>, <span style="color:#e6db74">&#39;xxx&#39;</span>);
 <span style="color:#66d9ef">INSERT</span> <span style="color:#66d9ef">INTO</span> t_order_1 (order_id, xxx) <span style="color:#66d9ef">VALUES</span> (<span style="color:#ae81ff">1</span>, <span style="color:#e6db74">&#39;xxx&#39;</span>), (<span style="color:#ae81ff">3</span>, <span style="color:#e6db74">&#39;xxx&#39;</span>);
 </code></pre></div><p>使用 IN 的查询与批量插入的情况相似，不过 IN 操作并不会导致数据查询结果错误。通过对 IN 查询的改写，可以进一步的提升查询性能。如以下 SQL：</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>, <span style="color:#ae81ff">3</span>);
 </code></pre></div><p>改写为：</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">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">3</span>);
 </code></pre></div><p>可以进一步的提升查询性能。ShardingSphere 暂时还未实现此改写策略，目前的改写结果是：</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:#ae81ff">3</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>, <span style="color:#ae81ff">3</span>);
 </code></pre></div><p>虽然 SQL 的执行结果是正确的，但并未达到最优的查询效率。</p>
 <h2 id="优化改写">优化改写</h2>
 <p>优化改写的目的是在不影响查询正确性的情况下，对性能进行提升的有效手段。它分为单节点优化和流式归并优化。</p>
 <h3 id="单节点优化">单节点优化</h3>
 <p>路由至单节点的 SQL，则无需优化改写。
 当获得一次查询的路由结果后，如果是路由至唯一的数据节点，则无需涉及到结果归并。因此补列和分页信息等改写都没有必要进行。
 尤其是分页信息的改写，无需将数据从第 1 条开始取，大量的降低了对数据库的压力，并且节省了网络带宽的无谓消耗。</p>
 <h3 id="流式归并优化">流式归并优化</h3>
 <p>它仅为包含 <code>GROUP BY</code> 的 SQL 增加 <code>ORDER BY</code> 以及和分组项相同的排序项和排序顺序，用于将内存归并转化为流式归并。
 在结果归并的部分中，将对流式归并和内存归并进行详细说明。</p>
 <p>改写引擎的整体结构划分如下图所示。</p>
 <p><img src="https://shardingsphere.apache.org/document/current/img/sharding/rewrite_architecture_cn.png" alt="改写引擎结构"></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?1686302715"></script>
     <script src="https://shardingsphere.apache.org/document/current/js/perfect-scrollbar.min.js?1686302715"></script>
     <script src="https://shardingsphere.apache.org/document/current/js/perfect-scrollbar.jquery.min.js?1686302715"></script>
     <script src="https://shardingsphere.apache.org/document/current/js/jquery.sticky.js?1686302715"></script>
     <script src="https://shardingsphere.apache.org/document/current/js/featherlight.min.js?1686302715"></script>
     <script src="https://shardingsphere.apache.org/document/current/js/highlight.pack.js?1686302715"></script>
     <script>hljs.initHighlightingOnLoad();</script>
     <script src="https://shardingsphere.apache.org/document/current/js/modernizr.custom-3.6.0.js?1686302715"></script>
     <script src="https://shardingsphere.apache.org/document/current/js/learn.js?1686302715"></script>
     <script src="https://shardingsphere.apache.org/document/current/js/hugo-learn.js?1686302715"></script>


             <script src="https://shardingsphere.apache.org/document/current/mermaid/mermaid.js?1686302715"></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>