blob: dd16a8fd17936a8f996657d6981c28dc7c5dea7b [file] [log] [blame]
<!DOCTYPE html>
<html lang="cn" class="js csstransforms3d">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no">
<meta name="generator" content="Hugo 0.70.0" />
<meta name="description" content="">
<meta name="buildDate" content="2021-07-29 18:50:53">
<link rel="shortcut icon" href="https://shardingsphere.apache.org/document/current/img/favicon.png" type="image/x-icon" />
<title>YAML 配置 :: ShardingSphere</title>
<link href="https://shardingsphere.apache.org/document/current/css/nucleus.css?1627555853" rel="stylesheet">
<link href="https://shardingsphere.apache.org/document/current/css/font-awesome.min.css?1627555853" rel="stylesheet">
<link href="https://shardingsphere.apache.org/document/current/css/hybrid.css?1627555853" rel="stylesheet">
<link href="https://shardingsphere.apache.org/document/current/css/featherlight.min.css?1627555853" rel="stylesheet">
<link href="https://shardingsphere.apache.org/document/current/css/perfect-scrollbar.min.css?1627555853" rel="stylesheet">
<link href="https://shardingsphere.apache.org/document/current/css/auto-complete.css?1627555853" rel="stylesheet">
<link href="https://shardingsphere.apache.org/document/current/css/theme.css?1627555853" rel="stylesheet">
<link href="https://shardingsphere.apache.org/document/current/css/hugo-theme.css?1627555853" rel="stylesheet">
<link href="https://shardingsphere.apache.org/document/current/css/theme-black.css?1627555853" rel="stylesheet">
<script src="https://shardingsphere.apache.org/document/current/js/jquery-2.x.min.js?1627555853"></script>
<style type="text/css">
:root #header + #content > #left > #rlblock_left{
display:none !important;
}
</style>
</head>
<body class="" data-url="/cn/others/api-change-history/shardingsphere-jdbc/yaml-configuration/">
<nav id="sidebar" class="">
<div id="header-wrapper">
<div id="header">
<a href="https://shardingsphere.apache.org/"><img src="https://shardingsphere.apache.org/document/current/img/logo_v2.png" /></a>
</div>
</div>
<div class="highlightable">
<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>
<li data-nav-id="/cn/quick-start/shardingsphere-scaling-quick-start/" title="ShardingSphere-Scaling(Alpha)" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/quick-start/shardingsphere-scaling-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.3. </b>ShardingSphere-Scaling(Alpha)
</a>
</li>
</ul>
</li>
<li data-nav-id="/cn/features/" title="概念 &amp; 功能" 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>概念 &amp; 功能
</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/">
<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.1. </b>核心概念
</a>
<ul>
<li data-nav-id="/cn/features/sharding/concept/sql/" title="SQL" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/sharding/concept/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>
SQL
</a>
</li>
<li data-nav-id="/cn/features/sharding/concept/sharding/" title="分片" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/sharding/concept/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/features/sharding/concept/configuration/" title="配置" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/sharding/concept/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>
配置
</a>
</li>
<li data-nav-id="/cn/features/sharding/concept/inline-expression/" title="行表达式" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/sharding/concept/inline-expression/">
<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/concept/key-generator/" title="分布式主键" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/sharding/concept/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>
分布式主键
</a>
</li>
<li data-nav-id="/cn/features/sharding/concept/hint/" title="强制分片路由" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/sharding/concept/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/features/sharding/principle/" title="内核剖析" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/cn/features/sharding/principle/">
<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.2. </b>内核剖析
</a>
<ul>
<li data-nav-id="/cn/features/sharding/principle/parse/" title="解析引擎" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/sharding/principle/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/features/sharding/principle/route/" title="路由引擎" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/sharding/principle/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/features/sharding/principle/rewrite/" title="改写引擎" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/sharding/principle/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/features/sharding/principle/execute/" title="执行引擎" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/sharding/principle/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/features/sharding/principle/merge/" title="归并引擎" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/sharding/principle/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/features/sharding/use-norms/" title="使用规范" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/cn/features/sharding/use-norms/">
<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.3. </b>使用规范
</a>
<ul>
<li data-nav-id="/cn/features/sharding/use-norms/sql/" title="SQL" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/sharding/use-norms/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>
SQL
</a>
</li>
<li data-nav-id="/cn/features/sharding/use-norms/pagination/" title="分页" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/sharding/use-norms/pagination/">
<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/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/">
<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.1. </b>核心概念
</a>
<ul>
<li data-nav-id="/cn/features/transaction/concept/2pc-xa-transaction/" title="XA两阶段事务" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/transaction/concept/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/features/transaction/concept/base-transaction-seata/" title="Seata 柔性事务" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/transaction/concept/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/features/transaction/principle/" title="实现原理" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/cn/features/transaction/principle/">
<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.2. </b>实现原理
</a>
<ul>
<li data-nav-id="/cn/features/transaction/principle/2pc-xa-transaction/" title="XA两阶段事务" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/transaction/principle/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/features/transaction/principle/base-transaction-seata/" title="Seata 柔性事务" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/transaction/principle/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/features/transaction/use-norms/" title="使用规范" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/cn/features/transaction/use-norms/">
<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.3. </b>使用规范
</a>
<ul>
<li data-nav-id="/cn/features/transaction/use-norms/local-transaction/" title="本地事务" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/transaction/use-norms/local-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/features/transaction/use-norms/2pc-xa-transaction/" title="XA两阶段事务" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/transaction/use-norms/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/features/transaction/use-norms/base-transaction-seata/" title="Seata 柔性事务" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/transaction/use-norms/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>
</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>
<b>3.3.1. </b>核心概念
</a>
</li>
<li data-nav-id="/cn/features/readwrite-splitting/use-norms/" title="使用规范" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/readwrite-splitting/use-norms/">
<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>3.3.2. </b>使用规范
</a>
</li>
</ul>
</li>
<li data-nav-id="/cn/features/governance/" title="分布式治理" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/cn/features/governance/">
<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/governance/management/" title="治理" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/cn/features/governance/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.4.1 </b>治理
</a>
<ul>
<li data-nav-id="/cn/features/governance/management/registry-center/" title="注册中心" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/governance/management/registry-center/">
<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/governance/management/dependency/" title="第三方组件依赖" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/governance/management/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>
第三方组件依赖
</a>
</li>
<li data-nav-id="/cn/features/governance/management/change-history/" title="变更历史" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/governance/management/change-history/">
<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/governance/observability/" title="可观察性" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/cn/features/governance/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.4.2 </b>可观察性
</a>
<ul>
<li data-nav-id="/cn/features/governance/observability/apm-integration/" title="应用性能监控集成" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/governance/observability/apm-integration/">
<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/governance/observability/agent/" title="Agent集成" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/governance/observability/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>
Agent集成
</a>
</li>
</ul>
</li>
</ul>
</li>
<li data-nav-id="/cn/features/scaling/" title="弹性伸缩" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/cn/features/scaling/">
<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/scaling/concept/" title="核心概念" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/scaling/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>
<b>3.5.1. </b>核心概念
</a>
</li>
<li data-nav-id="/cn/features/scaling/principle/" title="实现原理" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/scaling/principle/">
<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>3.5.2. </b>实现原理
</a>
</li>
<li data-nav-id="/cn/features/scaling/use-norms/" title="使用规范" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/scaling/use-norms/">
<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>3.5.3. </b>使用规范
</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.6. </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>
<b>3.6.1. </b>核心概念
</a>
</li>
<li data-nav-id="/cn/features/encrypt/principle/" title="实现原理" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/encrypt/principle/">
<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>3.6.2. </b>实现原理
</a>
</li>
<li data-nav-id="/cn/features/encrypt/use-norms/" title="使用规范" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/encrypt/use-norms/">
<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>3.6.3. </b>使用规范
</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.7. </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>
<b>3.7.1. </b>核心概念
</a>
</li>
<li data-nav-id="/cn/features/shadow/principle/" title="实现原理" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/shadow/principle/">
<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>3.7.2. </b>实现原理
</a>
</li>
</ul>
</li>
<li data-nav-id="/cn/features/dist-sql/" title="Dist SQL" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/cn/features/dist-sql/">
<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>Dist SQL
</a>
<ul>
<li data-nav-id="/cn/features/dist-sql/syntax/" title="语法" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/cn/features/dist-sql/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>
<b>3.8.1. </b>语法
</a>
<ul>
<li data-nav-id="/cn/features/dist-sql/syntax/rdl/" title="RDL 语法" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/cn/features/dist-sql/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>
<b>3.8.1.1 </b>RDL 语法
</a>
<ul>
<li data-nav-id="/cn/features/dist-sql/syntax/rdl/rdl-resource/" title="数据源资源" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/dist-sql/syntax/rdl/rdl-resource/">
<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/dist-sql/syntax/rdl/rdl-sharding-rule/" title="数据分片" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/dist-sql/syntax/rdl/rdl-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/features/dist-sql/syntax/rdl/rdl-readwrite-splitting-rule/" title="读写分离" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/dist-sql/syntax/rdl/rdl-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>
读写分离
</a>
</li>
<li data-nav-id="/cn/features/dist-sql/syntax/rdl/rdl-encrypt-rule/" title="数据加密" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/dist-sql/syntax/rdl/rdl-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/features/dist-sql/syntax/rdl/rdl-db-discovery-rule/" title="数据库发现" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/dist-sql/syntax/rdl/rdl-db-discovery-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>
<li data-nav-id="/cn/features/dist-sql/syntax/rql/" title="RQL 语法" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/cn/features/dist-sql/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>
<b>3.8.1.2 </b>RQL 语法
</a>
<ul>
<li data-nav-id="/cn/features/dist-sql/syntax/rql/rql-resource/" title="数据源资源" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/dist-sql/syntax/rql/rql-resource/">
<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/dist-sql/syntax/rql/rql-sharding-rule/" title="数据分片" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/dist-sql/syntax/rql/rql-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/features/dist-sql/syntax/rql/rql-readwrite-splitting-rule/" title="读写分离" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/dist-sql/syntax/rql/rql-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>
读写分离
</a>
</li>
<li data-nav-id="/cn/features/dist-sql/syntax/rql/rql-encrypt-rule/" title="数据加密" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/dist-sql/syntax/rql/rql-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/features/dist-sql/syntax/rql/rql-db-discovery-rule/" title="数据库发现" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/dist-sql/syntax/rql/rql-db-discovery-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>
<li data-nav-id="/cn/features/dist-sql/syntax/sctl/" title="SCTL 语法" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/cn/features/dist-sql/syntax/sctl/">
<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.1.3 </b>SCTL 语法
</a>
<ul>
<li data-nav-id="/cn/features/dist-sql/syntax/sctl/sctl/" title="SCTL" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/dist-sql/syntax/sctl/sctl/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
SCTL
</a>
</li>
</ul>
</li>
</ul>
</li>
<li data-nav-id="/cn/features/dist-sql/usage/" title="使用" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/cn/features/dist-sql/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>
<b>3.8.2 </b>使用
</a>
<ul>
<li data-nav-id="/cn/features/dist-sql/usage/sharding-rule/" title="数据分片" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/dist-sql/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>
</ul>
</li>
</ul>
</li>
<li data-nav-id="/cn/features/pluggable-architecture/" title="可插拔架构" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/cn/features/pluggable-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>3.9. </b>可插拔架构
</a>
</li>
<li data-nav-id="/cn/features/test-engine/" title="测试引擎" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/cn/features/test-engine/">
<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/test-engine/integration-test/" title="集成测试" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/test-engine/integration-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>
<b>3.9.1. </b>集成测试
</a>
</li>
<li data-nav-id="/cn/features/test-engine/parser-test/" title="SQL 解析测试" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/test-engine/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>
<b>3.9.2. </b>SQL 解析测试
</a>
</li>
<li data-nav-id="/cn/features/test-engine/rewrite-test/" title="SQL 改写测试" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/test-engine/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>
<b>3.9.3. </b>SQL 改写测试
</a>
</li>
<li data-nav-id="/cn/features/test-engine/performance-test/" title="性能测试" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/test-engine/performance-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>
<b>3.9.4. </b>性能测试
</a>
</li>
<li data-nav-id="/cn/features/test-engine/performance-test-sysbench/" title="性能测试(sysbench)" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/features/test-engine/performance-test-sysbench/">
<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>3.9.5. </b>性能测试(sysbench)
</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/usage/" title="使用手册" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/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>
<b>4.1.1. </b>使用手册
</a>
<ul>
<li data-nav-id="/cn/user-manual/shardingsphere-jdbc/usage/sharding/" title="数据分片" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/usage/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/usage/sharding/java-api/" title="使用 Java API" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/usage/sharding/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/usage/sharding/yaml/" title="使用 YAML 配置" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/usage/sharding/yaml/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
使用 YAML 配置
</a>
</li>
<li data-nav-id="/cn/user-manual/shardingsphere-jdbc/usage/sharding/spring-boot-starter/" title="使用 Spring Boot Starter" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/usage/sharding/spring-boot-starter/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
使用 Spring Boot Starter
</a>
</li>
<li data-nav-id="/cn/user-manual/shardingsphere-jdbc/usage/sharding/spring-namespace/" title="使用 Spring 命名空间" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/usage/sharding/spring-namespace/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
使用 Spring 命名空间
</a>
</li>
<li data-nav-id="/cn/user-manual/shardingsphere-jdbc/usage/sharding/hint/" title="强制路由" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/usage/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/usage/transaction/" title="分布式事务" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/usage/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/usage/transaction/java-api/" title="使用 Java API" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/usage/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/usage/transaction/spring-boot-starter/" title="使用 Spring Boot Starter" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/usage/transaction/spring-boot-starter/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
使用 Spring Boot Starter
</a>
</li>
<li data-nav-id="/cn/user-manual/shardingsphere-jdbc/usage/transaction/spring-namespace/" title="使用 Spring 命名空间" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/usage/transaction/spring-namespace/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
使用 Spring 命名空间
</a>
</li>
<li data-nav-id="/cn/user-manual/shardingsphere-jdbc/usage/transaction/atomikos/" title="Atomikos 事务" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/usage/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/usage/transaction/narayana/" title="Narayana 事务" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/usage/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/usage/transaction/bitronix/" title="Bitronix 事务" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/usage/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/usage/transaction/seata/" title="Seata 事务" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/usage/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/user-manual/shardingsphere-jdbc/usage/governance/" title="分布式治理" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/usage/governance/">
<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/usage/governance/java-api/" title="使用 Java API" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/usage/governance/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/usage/governance/yaml/" title="使用 YAML 配置" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/usage/governance/yaml/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
使用 YAML 配置
</a>
</li>
<li data-nav-id="/cn/user-manual/shardingsphere-jdbc/usage/governance/spring-boot-starter/" title="使用 Spring Boot Starter" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/usage/governance/spring-boot-starter/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
使用 Spring Boot Starter
</a>
</li>
<li data-nav-id="/cn/user-manual/shardingsphere-jdbc/usage/governance/spring-namespace/" title="使用 Spring 命名空间" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/usage/governance/spring-namespace/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
使用 Spring 命名空间
</a>
</li>
</ul>
</li>
</ul>
</li>
<li data-nav-id="/cn/user-manual/shardingsphere-jdbc/configuration/" title="配置手册" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/">
<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.2. </b>配置手册
</a>
<ul>
<li data-nav-id="/cn/user-manual/shardingsphere-jdbc/configuration/java-api/" title="Java API" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/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/configuration/java-api/sharding/" title="数据分片" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/java-api/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/configuration/java-api/readwrite-splitting/" title="读写分离" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/java-api/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/configuration/java-api/encrypt/" title="数据加密" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/java-api/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/configuration/java-api/shadow/" title="影子库" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/java-api/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/configuration/java-api/governance/" title="分布式治理" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/java-api/governance/">
<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/configuration/java-api/mix/" title="混合规则" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/java-api/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/configuration/java-api/change-history/" title="变更历史" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/java-api/change-history/">
<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/configuration/yaml/" title="YAML 配置" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/yaml/">
<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/configuration/yaml/sharding/" title="数据分片" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/yaml/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/configuration/yaml/readwrite-splitting-/" title="读写分离" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/yaml/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/configuration/yaml/encrypt/" title="数据加密" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/yaml/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/configuration/yaml/shadow/" title="影子库" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/yaml/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/configuration/yaml/governance/" title="分布式治理" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/yaml/governance/">
<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/configuration/yaml/mix/" title="混合规则" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/yaml/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/configuration/spring-boot-starter/" title="Spring Boot Starter 配置" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/spring-boot-starter/">
<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>
Spring Boot Starter 配置
</a>
<ul>
<li data-nav-id="/cn/user-manual/shardingsphere-jdbc/configuration/spring-boot-starter/sharding/" title="数据分片" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/spring-boot-starter/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/configuration/spring-boot-starter/readwrite-splitting/" title="读写分离" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/spring-boot-starter/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/configuration/spring-boot-starter/encrypt/" title="数据加密" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/spring-boot-starter/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/configuration/spring-boot-starter/shadow/" title="影子库" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/spring-boot-starter/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/configuration/spring-boot-starter/governance/" title="分布式治理" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/spring-boot-starter/governance/">
<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/configuration/spring-boot-starter/mix/" title="混合规则" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/spring-boot-starter/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/configuration/spring-boot-starter/change-history/" title="变更历史" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/spring-boot-starter/change-history/">
<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/configuration/spring-namespace/" title="Spring 命名空间配置" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/spring-namespace/">
<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>
Spring 命名空间配置
</a>
<ul>
<li data-nav-id="/cn/user-manual/shardingsphere-jdbc/configuration/spring-namespace/sharding/" title="数据分片" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/spring-namespace/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/configuration/spring-namespace/readwrite-splitting/" title="读写分离" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/spring-namespace/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/configuration/spring-namespace/encrypt/" title="数据加密" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/spring-namespace/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/configuration/spring-namespace/shadow/" title="影子库" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/spring-namespace/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/configuration/spring-namespace/governance/" title="分布式治理" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/spring-namespace/governance/">
<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/configuration/spring-namespace/mix/" title="混合规则" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/spring-namespace/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/configuration/spring-namespace/change-history/" title="变更历史" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/spring-namespace/change-history/">
<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/configuration/built-in-algorithm/" title="内置算法" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/built-in-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/shardingsphere-jdbc/configuration/built-in-algorithm/sharding/" title="分片算法" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/built-in-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/shardingsphere-jdbc/configuration/built-in-algorithm/keygen/" title="分布式序列算法" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/built-in-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/shardingsphere-jdbc/configuration/built-in-algorithm/load-balance/" title="负载均衡算法" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/built-in-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/shardingsphere-jdbc/configuration/built-in-algorithm/encrypt/" title="加密算法" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/built-in-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>
</ul>
</li>
<li data-nav-id="/cn/user-manual/shardingsphere-jdbc/configuration/props/" title="属性配置" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/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>
</ul>
</li>
<li data-nav-id="/cn/user-manual/shardingsphere-jdbc/unsupported-items/" title="不支持项" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/unsupported-items/">
<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>4.1.3. </b>不支持项
</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/usage/" title="使用手册" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-proxy/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>
<b>4.2.1. </b>使用手册
</a>
<ul>
<li data-nav-id="/cn/user-manual/shardingsphere-proxy/usage/startup/" title="Proxy 启动" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-proxy/usage/startup/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
Proxy 启动
</a>
</li>
<li data-nav-id="/cn/user-manual/shardingsphere-proxy/usage/governance/" title="分布式治理" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-proxy/usage/governance/">
<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/usage/transaction/" title="分布式事务" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-proxy/usage/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>
</ul>
</li>
<li data-nav-id="/cn/user-manual/shardingsphere-proxy/configuration/" title="配置手册" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-proxy/configuration/">
<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.2. </b>配置手册
</a>
<ul>
<li data-nav-id="/cn/user-manual/shardingsphere-proxy/configuration/data-source/" title="数据源配置" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-proxy/configuration/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-proxy/configuration/authentication/" title="权限配置" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-proxy/configuration/authentication/">
<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/configuration/props/" title="属性配置" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-proxy/configuration/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/configuration/yaml-syntax/" title="YAML 语法说明" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-proxy/configuration/yaml-syntax/">
<svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="5375" width="20" height="20"></svg>
YAML 语法说明
</a>
</li>
</ul>
</li>
<li data-nav-id="/cn/user-manual/shardingsphere-proxy/docker/" title="Docker 镜像" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-proxy/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>
<b>4.2.3. </b>Docker 镜像
</a>
</li>
</ul>
</li>
<li data-nav-id="/cn/user-manual/shardingsphere-sidecar/" title="ShardingSphere-Sidecar" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-sidecar/">
<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>4.3. </b>ShardingSphere-Sidecar
</a>
</li>
<li data-nav-id="/cn/user-manual/shardingsphere-scaling/" title="ShardingSphere-Scaling" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-scaling/">
<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>ShardingSphere-Scaling
</a>
<ul>
<li data-nav-id="/cn/user-manual/shardingsphere-scaling/build/" title="运行部署" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-scaling/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>
<b>4.4.1. </b>运行部署
</a>
</li>
<li data-nav-id="/cn/user-manual/shardingsphere-scaling/usage/" title="使用手册" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-scaling/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>
<b>4.4.2. </b>使用手册
</a>
</li>
</ul>
</li>
<li data-nav-id="/cn/user-manual/shardingsphere-ui/" title="ShardingSphere-UI" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-ui/">
<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.5. </b>ShardingSphere-UI
</a>
<ul>
<li data-nav-id="/cn/user-manual/shardingsphere-ui/usage/" title="使用手册" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-ui/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>
<b>4.5.1. </b>使用手册
</a>
<ul>
<li data-nav-id="/cn/user-manual/shardingsphere-ui/usage/build/" title="部署运行" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-ui/usage/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-ui/usage/registry-center/" title="注册中心" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-ui/usage/registry-center/">
<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-ui/usage/rule-config/" title="规则配置" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-ui/usage/rule-config/">
<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-ui/usage/runtime-status/" title="运行状态" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-ui/usage/runtime-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>
运行状态
</a>
</li>
</ul>
</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/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.1. </b>SQL 解析
</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/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.4. </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.5. </b>读写分离
</a>
</li>
<li data-nav-id="/cn/dev-manual/data-encryption/" title="数据加密" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/dev-manual/data-encryption/">
<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/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.7. </b>SQL 审计
</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.8. </b>分布式事务
</a>
</li>
<li data-nav-id="/cn/dev-manual/governance/" title="分布式治理" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/dev-manual/governance/">
<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/scaling/" title="弹性伸缩" class="dd-item ">
<a href="https://shardingsphere.apache.org/document/current/cn/dev-manual/scaling/">
<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>弹性伸缩
</a>
</li>
<li data-nav-id="/cn/dev-manual/proxy/" title="Proxy" 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.11. </b>Proxy
</a>
</li>
</ul>
</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>6. </b>下载
</a>
</li>
<li data-nav-id="/cn/others/" title="其他" class="dd-item
parent
">
<a href="https://shardingsphere.apache.org/document/current/cn/others/">
<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/others/faq/" title="FAQ" class="dd-item
">
<a href="https://shardingsphere.apache.org/document/current/cn/others/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>7.1. </b>FAQ
</a>
</li>
<li data-nav-id="/cn/others/api-change-history/" title="API 变更历史" class="dd-item
parent
">
<a href="https://shardingsphere.apache.org/document/current/cn/others/api-change-history/">
<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.2. </b>API 变更历史
</a>
<ul>
<li data-nav-id="/cn/others/api-change-history/shardingsphere-jdbc/" title="ShardingSphere-JDBC" class="dd-item
parent
">
<a href="https://shardingsphere.apache.org/document/current/cn/others/api-change-history/shardingsphere-jdbc/">
<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.2.1. </b>ShardingSphere-JDBC
</a>
<ul>
<li data-nav-id="/cn/others/api-change-history/shardingsphere-jdbc/yaml-configuration/" title="YAML 配置" class="dd-item active">
<a href="https://shardingsphere.apache.org/document/current/cn/others/api-change-history/shardingsphere-jdbc/yaml-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>
YAML 配置
</a>
</li>
</ul>
</li>
</ul>
</li>
</ul>
</li>
</ul>
<section id="prefooter">
<hr/>
<ul>
<li>
<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="cn" value="/document/current/cn/others/api-change-history/shardingsphere-jdbc/yaml-configuration/" selected>简体中文</option>
</select>
<svg version="1.1" id="Capa_1" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" x="0px" y="0px"
width="255px" height="255px" viewBox="0 0 255 255" style="enable-background:new 0 0 255 255;" xml:space="preserve">
<g>
<g id="arrow-drop-down">
<polygon points="0,63.75 127.5,191.25 255,63.75 " />
</g>
</g>
</svg>
</div>
</a>
</li>
</ul>
</section>
<hr />
<a class="padding" href="https://shardingsphere.apache.org/pdf/shardingsphere_docs_cn.pdf">
<i class="fa fa-fw fa-file-pdf-o" ></i>&nbsp;下载PDF文档&nbsp;&nbsp;
</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/others/api-change-history/shardingsphere-jdbc/yaml-configuration.cn.md" target="blank">
<i class="fa fa-code-fork"></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="fa fa-bars"></i>
</a>
</span>
<span id="toc-menu"><i class="fa fa-list-alt"></i></span>
<span class="links">
<a href='https://shardingsphere.apache.org/document/current/cn/'>ShardingSphere</a> > <a href='https://shardingsphere.apache.org/document/current/cn/others/'>其他</a> > <a href='https://shardingsphere.apache.org/document/current/cn/others/api-change-history/'>API 变更历史</a> > <a href='https://shardingsphere.apache.org/document/current/cn/others/api-change-history/shardingsphere-jdbc/'>ShardingSphere-JDBC</a> > YAML 配置
</span>
</div>
</div>
</div>
<div id="body-inner">
<h1>YAML 配置</h1>
<nav id="TableOfContents">
<ul>
<li><a href="#500-alpha">5.0.0-alpha</a>
<ul>
<li><a href="#数据分片">数据分片</a></li>
<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="#shardingsphere-4x">ShardingSphere-4.x</a>
<ul>
<li><a href="#数据分片-1">数据分片</a></li>
<li><a href="#读写分离-1">读写分离</a></li>
<li><a href="#数据脱敏">数据脱敏</a></li>
<li><a href="#治理">治理</a></li>
</ul>
</li>
<li><a href="#shardingsphere-3x">ShardingSphere-3.x</a>
<ul>
<li><a href="#数据分片-2">数据分片</a></li>
<li><a href="#读写分离-2">读写分离</a></li>
<li><a href="#治理-1">治理</a></li>
</ul>
</li>
<li><a href="#shardingsphere-2x">ShardingSphere-2.x</a>
<ul>
<li><a href="#数据分片-3">数据分片</a></li>
<li><a href="#读写分离-3">读写分离</a></li>
<li><a href="#治理-2">治理</a></li>
</ul>
</li>
</ul>
</nav>
<h2 id="500-alpha">5.0.0-alpha</h2>
<h3 id="数据分片">数据分片</h3>
<h4 id="配置项说明">配置项说明</h4>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-yaml" data-lang="yaml"><span style="color:#66d9ef">dataSources</span>: <span style="color:#75715e"># 省略数据源配置,请参考使用手册</span>
<span style="color:#66d9ef">rules</span>:
- !SHARDING
<span style="color:#66d9ef">tables</span>: <span style="color:#75715e"># 数据分片规则配置</span>
<span style="color:#66d9ef">&lt;logic-table-name&gt; (+)</span>: <span style="color:#75715e"># 逻辑表名称</span>
<span style="color:#66d9ef">actualDataNodes (?)</span>: <span style="color:#75715e"># 由数据源名 + 表名组成(参考Inline语法规则)</span>
<span style="color:#66d9ef">databaseStrategy (?)</span>: <span style="color:#75715e"># 分库策略,缺省表示使用默认分库策略,以下的分片策略只能选其一</span>
<span style="color:#66d9ef">standard</span>: <span style="color:#75715e"># 用于单分片键的标准分片场景</span>
<span style="color:#66d9ef">shardingColumn</span>: <span style="color:#75715e"># 分片列名称</span>
<span style="color:#66d9ef">shardingAlgorithmName</span>: <span style="color:#75715e"># 分片算法名称</span>
<span style="color:#66d9ef">complex</span>: <span style="color:#75715e"># 用于多分片键的复合分片场景</span>
<span style="color:#66d9ef">shardingColumns</span>: <span style="color:#75715e">#分片列名称,多个列以逗号分隔</span>
<span style="color:#66d9ef">shardingAlgorithmName</span>: <span style="color:#75715e"># 分片算法名称</span>
<span style="color:#66d9ef">hint</span>: <span style="color:#75715e"># Hint 分片策略</span>
<span style="color:#66d9ef">shardingAlgorithmName</span>: <span style="color:#75715e"># 分片算法名称</span>
<span style="color:#66d9ef">none</span>: <span style="color:#75715e"># 不分片</span>
<span style="color:#66d9ef">tableStrategy</span>: <span style="color:#75715e"># 分表策略,同分库策略</span>
<span style="color:#66d9ef">keyGenerateStrategy</span>: <span style="color:#75715e"># 分布式序列策略</span>
<span style="color:#66d9ef">column</span>: <span style="color:#75715e"># 自增列名称,缺省表示不使用自增主键生成器</span>
<span style="color:#66d9ef">keyGeneratorName</span>: <span style="color:#75715e"># 分布式序列算法名称</span>
<span style="color:#66d9ef">autoTables</span>: <span style="color:#75715e"># 自动分片表规则配置</span>
<span style="color:#66d9ef">t_order_auto</span>: <span style="color:#75715e"># 逻辑表名称</span>
<span style="color:#66d9ef">actualDataSources (?)</span>: <span style="color:#75715e"># 数据源名称</span>
<span style="color:#66d9ef">shardingStrategy</span>: <span style="color:#75715e"># 切分策略</span>
<span style="color:#66d9ef">standard</span>: <span style="color:#75715e"># 用于单分片键的标准分片场景</span>
<span style="color:#66d9ef">shardingColumn</span>: <span style="color:#75715e"># 分片列名称</span>
<span style="color:#66d9ef">shardingAlgorithmName</span>: <span style="color:#75715e"># 自动分片算法名称</span>
<span style="color:#66d9ef">bindingTables (+)</span>: <span style="color:#75715e"># 绑定表规则列表</span>
- &lt;logic_table_name_1, logic_table_name_2, ...<span style="color:#e6db74">&gt;
</span><span style="color:#e6db74"> - &lt;logic_table_name_1, logic_table_name_2, ...&gt; </span>
<span style="color:#66d9ef">broadcastTables (+)</span>: <span style="color:#75715e"># 广播表规则列表</span>
- &lt;table-name<span style="color:#e6db74">&gt;
</span><span style="color:#e6db74"> - &lt;table-name&gt;</span>
<span style="color:#66d9ef">defaultDatabaseStrategy</span>: <span style="color:#75715e"># 默认数据库分片策略</span>
<span style="color:#66d9ef">defaultTableStrategy</span>: <span style="color:#75715e"># 默认表分片策略</span>
<span style="color:#66d9ef">defaultKeyGenerateStrategy</span>: <span style="color:#75715e"># 默认的分布式序列策略</span>
<span style="color:#75715e"># 分片算法配置</span>
<span style="color:#66d9ef">shardingAlgorithms</span>:
<span style="color:#66d9ef">&lt;sharding-algorithm-name&gt; (+)</span>: <span style="color:#75715e"># 分片算法名称</span>
<span style="color:#66d9ef">type</span>: <span style="color:#75715e"># 分片算法类型</span>
<span style="color:#66d9ef">props</span>: <span style="color:#75715e"># 分片算法属性配置</span>
<span style="color:#75715e"># ...</span>
<span style="color:#75715e"># 分布式序列算法配置</span>
<span style="color:#66d9ef">keyGenerators</span>:
<span style="color:#66d9ef">&lt;key-generate-algorithm-name&gt; (+)</span>: <span style="color:#75715e"># 分布式序列算法名称</span>
<span style="color:#66d9ef">type</span>: <span style="color:#75715e"># 分布式序列算法类型</span>
<span style="color:#66d9ef">props</span>: <span style="color:#75715e"># 分布式序列算法属性配置</span>
<span style="color:#75715e"># ...</span>
<span style="color:#66d9ef">props</span>:
<span style="color:#75715e"># ...</span>
</code></pre></div><h3 id="读写分离">读写分离</h3>
<h4 id="配置项说明-1">配置项说明</h4>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-yaml" data-lang="yaml"><span style="color:#66d9ef">dataSources</span>: <span style="color:#75715e"># 省略数据源配置,请参考使用手册</span>
<span style="color:#66d9ef">rules</span>:
- !REPLICA_QUERY
<span style="color:#66d9ef">dataSources</span>:
<span style="color:#66d9ef">&lt;data-source-name&gt; (+)</span>: <span style="color:#75715e"># 读写分离逻辑数据源名称</span>
<span style="color:#66d9ef">primaryDataSourceName</span>: <span style="color:#75715e"># 主库数据源名称</span>
<span style="color:#66d9ef">replicaDataSourceNames</span>:
- &lt;replica-data_source-name&gt; (+) <span style="color:#75715e"># 从库数据源名称</span>
<span style="color:#66d9ef">loadBalancerName</span>: <span style="color:#75715e"># 负载均衡算法名称</span>
<span style="color:#75715e"># 负载均衡算法配置</span>
<span style="color:#66d9ef">loadBalancers</span>:
<span style="color:#66d9ef">&lt;load-balancer-name&gt; (+)</span>: <span style="color:#75715e"># 负载均衡算法名称</span>
<span style="color:#66d9ef">type</span>: <span style="color:#75715e"># 负载均衡算法类型</span>
<span style="color:#66d9ef">props</span>: <span style="color:#75715e"># 负载均衡算法属性配置</span>
<span style="color:#75715e"># ...</span>
<span style="color:#66d9ef">props</span>:
<span style="color:#75715e"># ...</span>
</code></pre></div><p>算法类型的详情,请参见<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/built-in-algorithm/load-balance">内置负载均衡算法列表</a></p>
<h3 id="数据加密">数据加密</h3>
<h4 id="配置项说明-2">配置项说明</h4>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-yaml" data-lang="yaml"><span style="color:#66d9ef">dataSource</span>: <span style="color:#75715e"># 省略数据源配置,请参考使用手册</span>
<span style="color:#66d9ef">rules</span>:
- !ENCRYPT
<span style="color:#66d9ef">tables</span>:
<span style="color:#66d9ef">&lt;table-name&gt; (+)</span>: <span style="color:#75715e"># 加密表名称</span>
<span style="color:#66d9ef">columns</span>:
<span style="color:#66d9ef">&lt;column-name&gt; (+)</span>: <span style="color:#75715e"># 加密列名称</span>
<span style="color:#66d9ef">cipherColumn</span>: <span style="color:#75715e"># 密文列名称</span>
<span style="color:#66d9ef">assistedQueryColumn (?)</span>: <span style="color:#75715e"># 查询辅助列名称</span>
<span style="color:#66d9ef">plainColumn (?)</span>: <span style="color:#75715e"># 原文列名称</span>
<span style="color:#66d9ef">encryptorName</span>: <span style="color:#75715e"># 加密算法名称</span>
<span style="color:#75715e"># 加密算法配置</span>
<span style="color:#66d9ef">encryptors</span>:
<span style="color:#66d9ef">&lt;encrypt-algorithm-name&gt; (+)</span>: <span style="color:#75715e"># 加解密算法名称</span>
<span style="color:#66d9ef">type</span>: <span style="color:#75715e"># 加解密算法类型</span>
<span style="color:#66d9ef">props</span>: <span style="color:#75715e"># 加解密算法属性配置</span>
<span style="color:#75715e"># ...</span>
<span style="color:#66d9ef">queryWithCipherColumn</span>: <span style="color:#75715e"># 是否使用加密列进行查询。在有原文列的情况下,可以使用原文列进行查询</span>
</code></pre></div><p>算法类型的详情,请参见<a href="https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/configuration/built-in-algorithm/encrypt">内置加密算法列表</a></p>
<h3 id="影子库">影子库</h3>
<h4 id="配置项说明-3">配置项说明</h4>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-yaml" data-lang="yaml"><span style="color:#66d9ef">dataSources</span>: <span style="color:#75715e"># 省略数据源配置,请参考使用手册</span>
<span style="color:#66d9ef">rules</span>:
- !SHADOW
<span style="color:#66d9ef">column</span>: <span style="color:#75715e"># 影子字段名</span>
<span style="color:#66d9ef">sourceDataSourceNames</span>: <span style="color:#75715e"># 影子前数据库名</span>
<span style="color:#75715e"># ...</span>
<span style="color:#66d9ef">shadowDataSourceNames</span>: <span style="color:#75715e"># 对应的影子库名</span>
<span style="color:#75715e"># ... </span>
<span style="color:#66d9ef">props</span>:
<span style="color:#75715e"># ...</span>
</code></pre></div><h3 id="分布式治理">分布式治理</h3>
<h4 id="配置项说明-4">配置项说明</h4>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-yaml" data-lang="yaml"><span style="color:#66d9ef">governance</span>:
<span style="color:#66d9ef">name</span>: <span style="color:#75715e"># 治理名称</span>
<span style="color:#66d9ef">registryCenter</span>: <span style="color:#75715e"># 注册中心</span>
<span style="color:#66d9ef">type</span>: <span style="color:#75715e"># 治理持久化类型。如:Zookeeper, etcd</span>
<span style="color:#66d9ef">serverLists: # 治理服务列表。包括 IP 地址和端口号。多个地址用逗号分隔。如</span>: host1:<span style="color:#ae81ff">2181</span>,host2:<span style="color:#ae81ff">2181</span>
<span style="color:#66d9ef">overwrite</span>: <span style="color:#75715e"># 本地配置是否覆盖配置中心配置。如果可覆盖,每次启动都以本地配置为准</span>
</code></pre></div><h2 id="shardingsphere-4x">ShardingSphere-4.x</h2>
<h3 id="数据分片-1">数据分片</h3>
<h4 id="配置项说明-5">配置项说明</h4>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-yaml" data-lang="yaml"><span style="color:#66d9ef">dataSources</span>:
<span style="color:#66d9ef">ds0</span>: <span style="color:#75715e">!!org.apache.commons.dbcp.BasicDataSource</span>
<span style="color:#66d9ef">driverClassName</span>: com.mysql.jdbc.Driver
<span style="color:#66d9ef">url</span>: jdbc:mysql://localhost:<span style="color:#ae81ff">3306</span>/ds0
<span style="color:#66d9ef">username</span>: root
<span style="color:#66d9ef">password</span>:
<span style="color:#66d9ef">ds1</span>: <span style="color:#75715e">!!org.apache.commons.dbcp.BasicDataSource</span>
<span style="color:#66d9ef">driverClassName</span>: com.mysql.jdbc.Driver
<span style="color:#66d9ef">url</span>: jdbc:mysql://localhost:<span style="color:#ae81ff">3306</span>/ds1
<span style="color:#66d9ef">username</span>: root
<span style="color:#66d9ef">password</span>:
<span style="color:#66d9ef">shardingRule</span>:
<span style="color:#66d9ef">tables</span>:
<span style="color:#66d9ef">t_order</span>:
<span style="color:#66d9ef">actualDataNodes</span>: ds${<span style="color:#ae81ff">0</span>..<span style="color:#ae81ff">1</span>}.t_order${<span style="color:#ae81ff">0</span>..<span style="color:#ae81ff">1</span>}
<span style="color:#66d9ef">databaseStrategy</span>:
<span style="color:#66d9ef">inline</span>:
<span style="color:#66d9ef">shardingColumn</span>: user_id
<span style="color:#66d9ef">algorithmExpression</span>: ds${user_id % <span style="color:#ae81ff">2</span>}
<span style="color:#66d9ef">tableStrategy</span>:
<span style="color:#66d9ef">inline</span>:
<span style="color:#66d9ef">shardingColumn</span>: order_id
<span style="color:#66d9ef">algorithmExpression</span>: t_order${order_id % <span style="color:#ae81ff">2</span>}
<span style="color:#66d9ef">keyGenerator</span>:
<span style="color:#66d9ef">type</span>: SNOWFLAKE
<span style="color:#66d9ef">column</span>: order_id
<span style="color:#66d9ef">t_order_item</span>:
<span style="color:#66d9ef">actualDataNodes</span>: ds${<span style="color:#ae81ff">0</span>..<span style="color:#ae81ff">1</span>}.t_order_item${<span style="color:#ae81ff">0</span>..<span style="color:#ae81ff">1</span>}
<span style="color:#66d9ef">databaseStrategy</span>:
<span style="color:#66d9ef">inline</span>:
<span style="color:#66d9ef">shardingColumn</span>: user_id
<span style="color:#66d9ef">algorithmExpression</span>: ds${user_id % <span style="color:#ae81ff">2</span>}
<span style="color:#66d9ef">tableStrategy</span>:
<span style="color:#66d9ef">inline</span>:
<span style="color:#66d9ef">shardingColumn</span>: order_id
<span style="color:#66d9ef">algorithmExpression</span>: t_order_item${order_id % <span style="color:#ae81ff">2</span>}
<span style="color:#66d9ef">bindingTables</span>:
- t_order,t_order_item
<span style="color:#66d9ef">broadcastTables</span>:
- t_config
<span style="color:#66d9ef">defaultDataSourceName</span>: ds0
<span style="color:#66d9ef">defaultTableStrategy</span>:
<span style="color:#66d9ef">none</span>:
<span style="color:#66d9ef">defaultKeyGenerator</span>:
<span style="color:#66d9ef">type</span>: SNOWFLAKE
<span style="color:#66d9ef">column</span>: order_id
<span style="color:#66d9ef">props</span>:
<span style="color:#66d9ef">sql.show</span>: <span style="color:#66d9ef">true</span>
</code></pre></div><h3 id="读写分离-1">读写分离</h3>
<h4 id="配置项说明-6">配置项说明</h4>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-yaml" data-lang="yaml"><span style="color:#66d9ef">dataSources</span>:
<span style="color:#66d9ef">ds_master</span>: <span style="color:#75715e">!!org.apache.commons.dbcp.BasicDataSource</span>
<span style="color:#66d9ef">driverClassName</span>: com.mysql.jdbc.Driver
<span style="color:#66d9ef">url</span>: jdbc:mysql://localhost:<span style="color:#ae81ff">3306</span>/ds_master
<span style="color:#66d9ef">username</span>: root
<span style="color:#66d9ef">password</span>:
<span style="color:#66d9ef">ds_slave0</span>: <span style="color:#75715e">!!org.apache.commons.dbcp.BasicDataSource</span>
<span style="color:#66d9ef">driverClassName</span>: com.mysql.jdbc.Driver
<span style="color:#66d9ef">url</span>: jdbc:mysql://localhost:<span style="color:#ae81ff">3306</span>/ds_slave0
<span style="color:#66d9ef">username</span>: root
<span style="color:#66d9ef">password</span>:
<span style="color:#66d9ef">ds_slave1</span>: <span style="color:#75715e">!!org.apache.commons.dbcp.BasicDataSource</span>
<span style="color:#66d9ef">driverClassName</span>: com.mysql.jdbc.Driver
<span style="color:#66d9ef">url</span>: jdbc:mysql://localhost:<span style="color:#ae81ff">3306</span>/ds_slave1
<span style="color:#66d9ef">username</span>: root
<span style="color:#66d9ef">password</span>:
<span style="color:#66d9ef">masterSlaveRule</span>:
<span style="color:#66d9ef">name</span>: ds_ms
<span style="color:#66d9ef">masterDataSourceName</span>: ds_master
<span style="color:#66d9ef">slaveDataSourceNames</span>: [ds_slave0, ds_slave1]
<span style="color:#66d9ef">props</span>:
<span style="color:#66d9ef">sql.show</span>: <span style="color:#66d9ef">true</span>
</code></pre></div><p>通过 <code>YamlMasterSlaveDataSourceFactory</code> 工厂类创建 <code>DataSource</code></p>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-java" data-lang="java">DataSource dataSource <span style="color:#f92672">=</span> YamlMasterSlaveDataSourceFactory<span style="color:#f92672">.</span><span style="color:#a6e22e">createDataSource</span><span style="color:#f92672">(</span>yamlFile<span style="color:#f92672">);</span>
</code></pre></div><h3 id="数据脱敏">数据脱敏</h3>
<h4 id="配置项说明-7">配置项说明</h4>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-yaml" data-lang="yaml"><span style="color:#66d9ef">dataSource</span>: <span style="color:#75715e">!!org.apache.commons.dbcp2.BasicDataSource</span>
<span style="color:#66d9ef">driverClassName</span>: com.mysql.jdbc.Driver
<span style="color:#66d9ef">url</span>: jdbc:mysql://<span style="color:#ae81ff">127.0.0.1</span>:<span style="color:#ae81ff">3306</span>/encrypt?serverTimezone=UTC<span style="color:#75715e">&amp;useSSL=false</span>
<span style="color:#66d9ef">username</span>: root
<span style="color:#66d9ef">password</span>:
<span style="color:#66d9ef">encryptRule</span>:
<span style="color:#66d9ef">encryptors</span>:
<span style="color:#66d9ef">encryptor_aes</span>:
<span style="color:#66d9ef">type</span>: aes
<span style="color:#66d9ef">props</span>:
<span style="color:#66d9ef">aes.key.value</span>: 123456abc
<span style="color:#66d9ef">encryptor_md5</span>:
<span style="color:#66d9ef">type</span>: md5
<span style="color:#66d9ef">tables</span>:
<span style="color:#66d9ef">t_encrypt</span>:
<span style="color:#66d9ef">columns</span>:
<span style="color:#66d9ef">user_id</span>:
<span style="color:#66d9ef">plainColumn</span>: user_plain
<span style="color:#66d9ef">cipherColumn</span>: user_cipher
<span style="color:#66d9ef">encryptor</span>: encryptor_aes
<span style="color:#66d9ef">order_id</span>:
<span style="color:#66d9ef">cipherColumn</span>: order_cipher
<span style="color:#66d9ef">encryptor</span>: encryptor_md5
<span style="color:#66d9ef">props</span>:
<span style="color:#66d9ef">query.with.cipher.column</span>: <span style="color:#66d9ef">true</span> <span style="color:#75715e">#是否使用密文列查询</span>
</code></pre></div><h3 id="治理">治理</h3>
<h4 id="配置项说明-8">配置项说明</h4>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-yaml" data-lang="yaml"><span style="color:#75715e">#省略数据分片、读写分离和数据脱敏配置</span>
<span style="color:#66d9ef">orchestration</span>:
<span style="color:#66d9ef">name</span>: orchestration_ds
<span style="color:#66d9ef">overwrite</span>: <span style="color:#66d9ef">true</span>
<span style="color:#66d9ef">registry</span>:
<span style="color:#66d9ef">type</span>: zookeeper
<span style="color:#66d9ef">namespace</span>: orchestration
<span style="color:#66d9ef">serverLists</span>: localhost:<span style="color:#ae81ff">2181</span>
</code></pre></div><h2 id="shardingsphere-3x">ShardingSphere-3.x</h2>
<h3 id="数据分片-2">数据分片</h3>
<h4 id="配置项说明-9">配置项说明</h4>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-yaml" data-lang="yaml"><span style="color:#66d9ef">dataSources</span>:
<span style="color:#66d9ef">ds0</span>: <span style="color:#75715e">!!org.apache.commons.dbcp.BasicDataSource</span>
<span style="color:#66d9ef">driverClassName</span>: com.mysql.jdbc.Driver
<span style="color:#66d9ef">url</span>: jdbc:mysql://localhost:<span style="color:#ae81ff">3306</span>/ds0
<span style="color:#66d9ef">username</span>: root
<span style="color:#66d9ef">password</span>:
<span style="color:#66d9ef">ds1</span>: <span style="color:#75715e">!!org.apache.commons.dbcp.BasicDataSource</span>
<span style="color:#66d9ef">driverClassName</span>: com.mysql.jdbc.Driver
<span style="color:#66d9ef">url</span>: jdbc:mysql://localhost:<span style="color:#ae81ff">3306</span>/ds1
<span style="color:#66d9ef">username</span>: root
<span style="color:#66d9ef">password</span>:
<span style="color:#66d9ef">shardingRule</span>:
<span style="color:#66d9ef">tables</span>:
<span style="color:#66d9ef">t_order</span>:
<span style="color:#66d9ef">actualDataNodes</span>: ds${<span style="color:#ae81ff">0</span>..<span style="color:#ae81ff">1</span>}.t_order${<span style="color:#ae81ff">0</span>..<span style="color:#ae81ff">1</span>}
<span style="color:#66d9ef">databaseStrategy</span>:
<span style="color:#66d9ef">inline</span>:
<span style="color:#66d9ef">shardingColumn</span>: user_id
<span style="color:#66d9ef">algorithmExpression</span>: ds${user_id % <span style="color:#ae81ff">2</span>}
<span style="color:#66d9ef">tableStrategy</span>:
<span style="color:#66d9ef">inline</span>:
<span style="color:#66d9ef">shardingColumn</span>: order_id
<span style="color:#66d9ef">algorithmExpression</span>: t_order${order_id % <span style="color:#ae81ff">2</span>}
<span style="color:#66d9ef">keyGeneratorColumnName</span>: order_id
<span style="color:#66d9ef">t_order_item</span>:
<span style="color:#66d9ef">actualDataNodes</span>: ds${<span style="color:#ae81ff">0</span>..<span style="color:#ae81ff">1</span>}.t_order_item${<span style="color:#ae81ff">0</span>..<span style="color:#ae81ff">1</span>}
<span style="color:#66d9ef">databaseStrategy</span>:
<span style="color:#66d9ef">inline</span>:
<span style="color:#66d9ef">shardingColumn</span>: user_id
<span style="color:#66d9ef">algorithmExpression</span>: ds${user_id % <span style="color:#ae81ff">2</span>}
<span style="color:#66d9ef">tableStrategy</span>:
<span style="color:#66d9ef">inline</span>:
<span style="color:#66d9ef">shardingColumn</span>: order_id
<span style="color:#66d9ef">algorithmExpression</span>: t_order_item${order_id % <span style="color:#ae81ff">2</span>}
<span style="color:#66d9ef">bindingTables</span>:
- t_order,t_order_item
<span style="color:#66d9ef">broadcastTables</span>:
- t_config
<span style="color:#66d9ef">defaultDataSourceName</span>: ds0
<span style="color:#66d9ef">defaultTableStrategy</span>:
<span style="color:#66d9ef">none</span>:
<span style="color:#66d9ef">defaultKeyGeneratorClassName</span>: io.shardingsphere.core.keygen.DefaultKeyGenerator
<span style="color:#66d9ef">props</span>:
<span style="color:#66d9ef">sql.show</span>: <span style="color:#66d9ef">true</span>
</code></pre></div><h3 id="读写分离-2">读写分离</h3>
<h4 id="配置项说明-10">配置项说明</h4>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-yaml" data-lang="yaml"><span style="color:#66d9ef">dataSources</span>:
<span style="color:#66d9ef">ds_master</span>: <span style="color:#75715e">!!org.apache.commons.dbcp.BasicDataSource</span>
<span style="color:#66d9ef">driverClassName</span>: com.mysql.jdbc.Driver
<span style="color:#66d9ef">url</span>: jdbc:mysql://localhost:<span style="color:#ae81ff">3306</span>/ds_master
<span style="color:#66d9ef">username</span>: root
<span style="color:#66d9ef">password</span>:
<span style="color:#66d9ef">ds_slave0</span>: <span style="color:#75715e">!!org.apache.commons.dbcp.BasicDataSource</span>
<span style="color:#66d9ef">driverClassName</span>: com.mysql.jdbc.Driver
<span style="color:#66d9ef">url</span>: jdbc:mysql://localhost:<span style="color:#ae81ff">3306</span>/ds_slave0
<span style="color:#66d9ef">username</span>: root
<span style="color:#66d9ef">password</span>:
<span style="color:#66d9ef">ds_slave1</span>: <span style="color:#75715e">!!org.apache.commons.dbcp.BasicDataSource</span>
<span style="color:#66d9ef">driverClassName</span>: com.mysql.jdbc.Driver
<span style="color:#66d9ef">url</span>: jdbc:mysql://localhost:<span style="color:#ae81ff">3306</span>/ds_slave1
<span style="color:#66d9ef">username</span>: root
<span style="color:#66d9ef">password</span>:
<span style="color:#66d9ef">masterSlaveRule</span>:
<span style="color:#66d9ef">name</span>: ds_ms
<span style="color:#66d9ef">masterDataSourceName</span>: ds_master
<span style="color:#66d9ef">slaveDataSourceNames</span>: [ds_slave0, ds_slave1]
<span style="color:#66d9ef">props</span>:
<span style="color:#66d9ef">sql.show</span>: <span style="color:#66d9ef">true</span>
<span style="color:#66d9ef">configMap</span>:
<span style="color:#66d9ef">key1</span>: value1
</code></pre></div><p>通过 <code>MasterSlaveDataSourceFactory</code> 工厂类创建 <code>DataSource</code></p>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-java" data-lang="java">DataSource dataSource <span style="color:#f92672">=</span> MasterSlaveDataSourceFactory<span style="color:#f92672">.</span><span style="color:#a6e22e">createDataSource</span><span style="color:#f92672">(</span>yamlFile<span style="color:#f92672">);</span>
</code></pre></div><h3 id="治理-1">治理</h3>
<h4 id="配置项说明-11">配置项说明</h4>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-yaml" data-lang="yaml"><span style="color:#75715e">#省略数据分片和读写分离配置</span>
<span style="color:#66d9ef">orchestration</span>:
<span style="color:#66d9ef">name</span>: orchestration_ds
<span style="color:#66d9ef">overwrite</span>: <span style="color:#66d9ef">true</span>
<span style="color:#66d9ef">registry</span>:
<span style="color:#66d9ef">namespace</span>: orchestration
<span style="color:#66d9ef">serverLists</span>: localhost:<span style="color:#ae81ff">2181</span>
</code></pre></div><h2 id="shardingsphere-2x">ShardingSphere-2.x</h2>
<h3 id="数据分片-3">数据分片</h3>
<h4 id="配置项说明-12">配置项说明</h4>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-yaml" data-lang="yaml"><span style="color:#66d9ef">dataSources</span>:
<span style="color:#66d9ef">db0</span>: <span style="color:#75715e">!!org.apache.commons.dbcp.BasicDataSource</span>
<span style="color:#66d9ef">driverClassName</span>: org.h2.Driver
<span style="color:#66d9ef">url</span>: jdbc:h2:mem:db0;DB_CLOSE_DELAY=-<span style="color:#ae81ff">1</span>;DATABASE_TO_UPPER=<span style="color:#66d9ef">false</span>;MODE=MYSQL
<span style="color:#66d9ef">username</span>: sa
<span style="color:#66d9ef">password</span>:
<span style="color:#66d9ef">maxActive</span>: <span style="color:#ae81ff">100</span>
<span style="color:#66d9ef">db1</span>: <span style="color:#75715e">!!org.apache.commons.dbcp.BasicDataSource</span>
<span style="color:#66d9ef">driverClassName</span>: org.h2.Driver
<span style="color:#66d9ef">url</span>: jdbc:h2:mem:db1;DB_CLOSE_DELAY=-<span style="color:#ae81ff">1</span>;DATABASE_TO_UPPER=<span style="color:#66d9ef">false</span>;MODE=MYSQL
<span style="color:#66d9ef">username</span>: sa
<span style="color:#66d9ef">password</span>:
<span style="color:#66d9ef">maxActive</span>: <span style="color:#ae81ff">100</span>
<span style="color:#66d9ef">shardingRule</span>:
<span style="color:#66d9ef">tables</span>:
<span style="color:#66d9ef">config</span>:
<span style="color:#66d9ef">actualDataNodes</span>: db${<span style="color:#ae81ff">0</span>..<span style="color:#ae81ff">1</span>}.t_config
<span style="color:#66d9ef">t_order</span>:
<span style="color:#66d9ef">actualDataNodes</span>: db${<span style="color:#ae81ff">0</span>..<span style="color:#ae81ff">1</span>}.t_order_${<span style="color:#ae81ff">0</span>..<span style="color:#ae81ff">1</span>}
<span style="color:#66d9ef">databaseStrategy</span>:
<span style="color:#66d9ef">standard</span>:
<span style="color:#66d9ef">shardingColumn</span>: user_id
<span style="color:#66d9ef">preciseAlgorithmClassName</span>: io.shardingjdbc.core.yaml.fixture.SingleAlgorithm
<span style="color:#66d9ef">tableStrategy</span>:
<span style="color:#66d9ef">inline</span>:
<span style="color:#66d9ef">shardingColumn</span>: order_id
<span style="color:#66d9ef">algorithmInlineExpression</span>: t_order_${order_id % <span style="color:#ae81ff">2</span>}
<span style="color:#66d9ef">keyGeneratorColumnName</span>: order_id
<span style="color:#66d9ef">keyGeneratorClass</span>: io.shardingjdbc.core.yaml.fixture.IncrementKeyGenerator
<span style="color:#66d9ef">t_order_item</span>:
<span style="color:#66d9ef">actualDataNodes</span>: db${<span style="color:#ae81ff">0</span>..<span style="color:#ae81ff">1</span>}.t_order_item_${<span style="color:#ae81ff">0</span>..<span style="color:#ae81ff">1</span>}
<span style="color:#75715e">#绑定表中其余的表的策略与第一张表的策略相同</span>
<span style="color:#66d9ef">databaseStrategy</span>:
<span style="color:#66d9ef">standard</span>:
<span style="color:#66d9ef">shardingColumn</span>: user_id
<span style="color:#66d9ef">preciseAlgorithmClassName</span>: io.shardingjdbc.core.yaml.fixture.SingleAlgorithm
<span style="color:#66d9ef">tableStrategy</span>:
<span style="color:#66d9ef">inline</span>:
<span style="color:#66d9ef">shardingColumn</span>: order_id
<span style="color:#66d9ef">algorithmInlineExpression</span>: t_order_item_${order_id % <span style="color:#ae81ff">2</span>}
<span style="color:#66d9ef">bindingTables</span>:
- t_order,t_order_item
<span style="color:#75715e">#默认数据库分片策略</span>
<span style="color:#66d9ef">defaultDatabaseStrategy</span>:
<span style="color:#66d9ef">none</span>:
<span style="color:#66d9ef">defaultTableStrategy</span>:
<span style="color:#66d9ef">complex</span>:
<span style="color:#66d9ef">shardingColumns</span>: id, order_id
<span style="color:#66d9ef">algorithmClassName</span>: io.shardingjdbc.core.yaml.fixture.MultiAlgorithm
<span style="color:#66d9ef">props</span>:
<span style="color:#66d9ef">sql.show</span>: <span style="color:#66d9ef">true</span>
</code></pre></div><h3 id="读写分离-3">读写分离</h3>
<h4 id="概念">概念</h4>
<p>为了缓解数据库压力,将写入和读取操作分离为不同数据源,写库称为主库,读库称为从库,一主库可配置多从库。</p>
<h4 id="支持项">支持项</h4>
<ol>
<li>提供了一主多从的读写分离配置,可独立使用,也可配合分库分表使用。</li>
<li>独立使用读写分离支持SQL透传。</li>
<li>同一线程且同一数据库连接内,如有写入操作,以后的读操作均从主库读取,用于保证数据一致性。</li>
<li>Spring命名空间。</li>
<li>基于Hint的强制主库路由。</li>
</ol>
<h4 id="不支持范围">不支持范围</h4>
<ol>
<li>主库和从库的数据同步。</li>
<li>主库和从库的数据同步延迟导致的数据不一致。</li>
<li>主库双写或多写。</li>
</ol>
<h4 id="配置规则">配置规则</h4>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-yaml" data-lang="yaml"><span style="color:#66d9ef">dataSources</span>:
<span style="color:#66d9ef">db_master</span>: <span style="color:#75715e">!!org.apache.commons.dbcp.BasicDataSource</span>
<span style="color:#66d9ef">driverClassName</span>: org.h2.Driver
<span style="color:#66d9ef">url</span>: jdbc:h2:mem:db_master;DB_CLOSE_DELAY=-<span style="color:#ae81ff">1</span>;DATABASE_TO_UPPER=<span style="color:#66d9ef">false</span>;MODE=MYSQL
<span style="color:#66d9ef">username</span>: sa
<span style="color:#66d9ef">password</span>:
<span style="color:#66d9ef">maxActive</span>: <span style="color:#ae81ff">100</span>
<span style="color:#66d9ef">db_slave_0</span>: <span style="color:#75715e">!!org.apache.commons.dbcp.BasicDataSource</span>
<span style="color:#66d9ef">driverClassName</span>: org.h2.Driver
<span style="color:#66d9ef">url</span>: jdbc:h2:mem:db_slave_0;DB_CLOSE_DELAY=-<span style="color:#ae81ff">1</span>;DATABASE_TO_UPPER=<span style="color:#66d9ef">false</span>;MODE=MYSQL
<span style="color:#66d9ef">username</span>: sa
<span style="color:#66d9ef">password</span>:
<span style="color:#66d9ef">maxActive</span>: <span style="color:#ae81ff">100</span>
<span style="color:#66d9ef">db_slave_1</span>: <span style="color:#75715e">!!org.apache.commons.dbcp.BasicDataSource</span>
<span style="color:#66d9ef">driverClassName</span>: org.h2.Driver
<span style="color:#66d9ef">url</span>: jdbc:h2:mem:db_slave_1;DB_CLOSE_DELAY=-<span style="color:#ae81ff">1</span>;DATABASE_TO_UPPER=<span style="color:#66d9ef">false</span>;MODE=MYSQL
<span style="color:#66d9ef">username</span>: sa
<span style="color:#66d9ef">password</span>:
<span style="color:#66d9ef">maxActive</span>: <span style="color:#ae81ff">100</span>
<span style="color:#66d9ef">masterSlaveRule</span>:
<span style="color:#66d9ef">name</span>: db_ms
<span style="color:#66d9ef">masterDataSourceName</span>: db_master
<span style="color:#66d9ef">slaveDataSourceNames</span>: [db_slave_0, db_slave_1]
<span style="color:#66d9ef">configMap</span>:
<span style="color:#66d9ef">key1</span>: value1
</code></pre></div><p>通过 <code>MasterSlaveDataSourceFactory</code> 工厂类创建 <code>DataSource</code></p>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-java" data-lang="java">DataSource dataSource <span style="color:#f92672">=</span> MasterSlaveDataSourceFactory<span style="color:#f92672">.</span><span style="color:#a6e22e">createDataSource</span><span style="color:#f92672">(</span>yamlFile<span style="color:#f92672">);</span>
</code></pre></div><h3 id="治理-2">治理</h3>
<h4 id="配置项说明-13">配置项说明</h4>
<p>Zookeeper分库分表编排配置项说明</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-yaml" data-lang="yaml"><span style="color:#66d9ef">dataSources</span>: 数据源配置
<span style="color:#66d9ef">shardingRule</span>: 分片规则配置
<span style="color:#66d9ef">orchestration</span>: Zookeeper编排配置
<span style="color:#66d9ef">name</span>: 编排服务节点名称
<span style="color:#66d9ef">overwrite</span>: 本地配置是否可覆盖注册中心配置。如果可覆盖,每次启动都以本地配置为准
<span style="color:#66d9ef">zookeeper</span>: Zookeeper注册中心配置
<span style="color:#66d9ef">namespace</span>: Zookeeper的命名空间
<span style="color:#66d9ef">serverLists: 连接Zookeeper服务器的列表。包括IP地址和端口号。多个地址用逗号分隔。如</span>: host1:<span style="color:#ae81ff">2181</span>,host2:<span style="color:#ae81ff">2181</span>
<span style="color:#66d9ef">baseSleepTimeMilliseconds</span>: 等待重试的间隔时间的初始值。单位:毫秒
<span style="color:#66d9ef">maxSleepTimeMilliseconds</span>: 等待重试的间隔时间的最大值。单位:毫秒
<span style="color:#66d9ef">maxRetries</span>: 最大重试次数
<span style="color:#66d9ef">sessionTimeoutMilliseconds</span>: 会话超时时间。单位:毫秒
<span style="color:#66d9ef">connectionTimeoutMilliseconds</span>: 连接超时时间。单位:毫秒
<span style="color:#66d9ef">digest</span>: 连接Zookeeper的权限令牌。缺省为不需要权限验证
</code></pre></div><p>Etcd分库分表编排配置项说明</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-yaml" data-lang="yaml"><span style="color:#66d9ef">dataSources</span>: 数据源配置
<span style="color:#66d9ef">shardingRule</span>: 分片规则配置
<span style="color:#66d9ef">orchestration</span>: Etcd编排配置
<span style="color:#66d9ef">name</span>: 编排服务节点名称
<span style="color:#66d9ef">overwrite</span>: 本地配置是否可覆盖注册中心配置。如果可覆盖,每次启动都以本地配置为准
<span style="color:#66d9ef">etcd</span>: Etcd注册中心配置
<span style="color:#66d9ef">serverLists: 连接Etcd服务器的列表。包括IP地址和端口号。多个地址用逗号分隔。如</span>: http://host1:<span style="color:#ae81ff">2379</span>,http://host2:<span style="color:#ae81ff">2379</span>
<span style="color:#66d9ef">timeToLiveSeconds</span>: 临时节点存活时间。单位:秒
<span style="color:#66d9ef">timeoutMilliseconds</span>: 每次请求的超时时间。单位:毫秒
<span style="color:#66d9ef">maxRetries</span>: 每次请求的最大重试次数
<span style="color:#66d9ef">retryIntervalMilliseconds</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-java" data-lang="java">DataSource dataSource <span style="color:#f92672">=</span> OrchestrationShardingDataSourceFactory<span style="color:#f92672">.</span><span style="color:#a6e22e">createDataSource</span><span style="color:#f92672">(</span>yamlFile<span style="color:#f92672">);</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-java" data-lang="java">DataSource dataSource <span style="color:#f92672">=</span> OrchestrationMasterSlaveDataSourceFactory<span style="color:#f92672">.</span><span style="color:#a6e22e">createDataSource</span><span style="color:#f92672">(</span>yamlFile<span style="color:#f92672">);</span>
</code></pre></div>
<footer class=" footline" >
</footer>
</div>
</div>
<div id="navigation">
<a class="nav nav-prev" href="https://shardingsphere.apache.org/document/current/cn/others/api-change-history/shardingsphere-jdbc/" title="ShardingSphere-JDBC"> <i class="fa fa-chevron-left"></i></a>
<a class="nav nav-next" href="https://shardingsphere.apache.org/document/current/cn/others/faq/" title="FAQ" style="margin-right: 0px;"><i class="fa fa-chevron-right"></i></a>
</div>
</section>
<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?1627555853"></script>
<script src="https://shardingsphere.apache.org/document/current/js/perfect-scrollbar.min.js?1627555853"></script>
<script src="https://shardingsphere.apache.org/document/current/js/perfect-scrollbar.jquery.min.js?1627555853"></script>
<script src="https://shardingsphere.apache.org/document/current/js/jquery.sticky.js?1627555853"></script>
<script src="https://shardingsphere.apache.org/document/current/js/featherlight.min.js?1627555853"></script>
<script src="https://shardingsphere.apache.org/document/current/js/html5shiv-printshiv.min.js?1627555853"></script>
<script src="https://shardingsphere.apache.org/document/current/js/highlight.pack.js?1627555853"></script>
<script>hljs.initHighlightingOnLoad();</script>
<script src="https://shardingsphere.apache.org/document/current/js/modernizr.custom.71422.js?1627555853"></script>
<script src="https://shardingsphere.apache.org/document/current/js/learn.js?1627555853"></script>
<script src="https://shardingsphere.apache.org/document/current/js/hugo-learn.js?1627555853"></script>
</body>
</html>