Apache ShardingSphere v5.3.2 Documentation
首页
白天
夜间
下载
阅读记录
书签管理
我的书签
添加书签
移除书签
编辑文档
PREVIEW SQL
来源 1
浏览
170
扫码
打印
2023-05-06 09:39:28
PREVIEW SQL
Syntax
Example
Preview execution plan
Related links
Reserved word
上一篇:
下一篇:
发布点评
7. Reference
7.7. Encryption
7.4. Sharding
Route Engine
Rewrite Engine
Merger Engine
Parse Engine
Execute Engine
7.9. Shadow
7.1. Database Compatibility
7.11. Architecture
7.6. Data Migration
7.3. Management
7.8. Mask
7.5. Transaction
XA Transaction
Seata BASE transaction
7.2. Database Gateway
7.10. Oberservability
4. User Manual
4.3. Common Configuration
Properties Configuration
Builtin Algorithm
Encryption Algorithm
Key Generate Algorithm
Data Masking Algorithm
Load Balance Algorithm
SQL Translator
Sharding Algorithm
Shadow Algorithm
Metadata Repository
Sharding Audit Algorithm
4.4. Error Code
Server Error Code
SQL Error Code
4.2. ShardingSphere-Proxy
Yaml Configuration
Properties
Rules
Authentication & Authorization
Observability
Session Management
Data Migration
Manual
Build
Optional Plugins
Startup
Use Helm
Use Docker
Build GraalVM Native Image(Alpha)
Use Binary Tar
Add dependencies
Add Bitronix dependencies
Add Narayana dependencies
Logging Configuration
DistSQL
Syntax
SHOW COMPUTE NODE MODE
PREVIEW SQL
PARSE SQL
REFRESH DATABASE METADATA FROM GOVERNANCE CENTER
Rule Definition
Encrypt
CREATE ENCRYPT RULE
DROP ENCRYPT RULE
ALTER ENCRYPT RULE
Database Discovery
DROP DB_DISCOVERY RULE
DROP DB_DISCOVERY TYPE
DROP DB_DISCOVERY HEARTBEAT
CREATE DB_DISCOVERY RULE
ALTER DB_DISCOVERY RULE
Mask
ALTER MASK RULE
DROP MASK RULE
CREATE MASK RULE
Shadow
CREATE DEFAULT SHADOW ALGORITHM
ALTER DEFAULT SHADOW ALGORITHM
DROP SHADOW ALGORITHM
CREATE SHADOW RULE
DROP SHADOW RULE
DROP DEFAULT SHADOW ALGORITHM
ALTER SHADOW RULE
Sharding
ALTER SHARDING TABLE RULE
CREATE BROADCAST TABLE RULE
CREATE SHARDING TABLE RULE
DROP SHARDING ALGORITHM
DROP SHARDING TABLE RULE
DROP SHARDING TABLE REFERENCE RULE
CREATE DEFAULT SHARDING STRATEGY
DROP BROADCAST TABLE RULE
ALTER DEFAULT SHARDING STRATEGY
DROP SHARDING KEY GENERATOR
ALTER SHARDING TABLE REFERENCE RULE
CREATE SHARDING TABLE REFERENCE RULE
DROP DEFAULT SHARDING STRATEGY
Single Table
SET DEFAULT SINGLE TABLE STORAGE UNIT
Readwrite-Splitting
CREATE READWRITE_SPLITTING RULE
DROP READWRITE_SPLITTING RULE
ALTER READWRITE_SPLITTING RULE
Storage Unit Definition
UNREGISTER STORAGE UNIT
ALTER STORAGE UNIT
REGISTER STORAGE UNIT
SHOW DIST VARIABLE
Rule Query
Sharding
SHOW SHARDING TABLE REFERENCE RULE
SHOW SHARDING TABLE RULES USED KEY GENERATOR
SHOW SHARDING ALGORITHMS
SHOW UNUSED SHARDING KEY GENERATORS
SHOW DEFAULT SHARDING STRATEGY
SHOW SHARDING TABLE NODES
SHOW BROADCAST TABLE RULE
SHOW SHARDING TABLE RULE
SHOW SHARDING TABLE NODES
SHOW UNUSED SHARDING ALGORITHMS
SHOW SHARDING AUDITORS
SHOW UNUSED SHARDING AUDITORS
COUNT SHARDING RULE
SHOW SHARDING TABLE RULES USED AUDITOR
SHOW SHARDING KEY GENERATORS
Single Table
SHOW SINGLE TABLE
SHOW DEFAULT SINGLE TABLE STORAGE UNIT
COUNT SINGLE_TABLE RULE
Encrypt
SHOW ENCRYPT RULES
COUNT ENCRYPT RULE
Shadow
SHOW SHADOW RULE
SHOW DEFAULT SHADOW ALGORITHM
SHOW SHADOW TABLE RULE
COUNT SHADOW RULE
SHOW SHADOW ALGORITHM
Database Discovery
SHOW DB_DISCOVERY HEARTBEATS
COUNT DB_DISCOVERY RULE
SHOW DB_DISCOVERY TYPES
SHOW DB_DISCOVERY RULE
Mask
COUNT MASK RULE
SHOW MASK RULES
Readwrite-Splitting
SHOW READWRITE_SPLITTING RULE
COUNT READWRITE_SPLITTING RULE
CIRCUIT BREAKER
LABEL|RELABEL COMPUTE NODES
ENABLE/DISABLE COMPUTE NODE
SHOW STATUS FROM READWRITE_SPLITTING RULE
SHOW COMPUTE NODES
UNLABEL COMPUTE NODES
ALTER READWRITE_SPLITTING RULE ENABLE/DISABLE
SET DIST VARIABLE
RUL Syntax
MIGRATUION
START MIGRATION
SHOW MIGRATION CHECK ALGORITHM
SHOW MIGRATION LIST
MIGRATE TABLE INTO
ALTER MIGRATION RULE
REGISTER MIGRATION SOURCE STORAGE UNIT
START MIGRATION CHECK
SHOW MIGRATION CHECK STATUS
COMMIT MIGRATION
STOP MIGRATION
SHOW MIGRATION STATUS
CHECK MIGRATION
SHOW MIGRATION SOURCE STORAGE UNITS
ROLLBACK MIGRATION
SHOW MIGRATION RULE
STOP MIGRATION CHECK
UNREGISTER MIGRATION SOURCE STORAGE UNIT
Storage Unit Query
SHOW STORAGE UNITS
SHOW RULES USED STORAGE UNIT
Reserved word
RDL Syntax
IMPORT DATABASE CONFIGURATION
GLOBAL RULE
SHOW AUTHORITY RULE
SHOW TRAFFIC RULE
ALTER TRANSACTION RULE
SHOW TRANSACTION RULE
ALTER SQL_PARSER RULE
SHOW SQL_PARSER RULE
ALTER TRAFFIC RULE
SHOW COMPUTE NODE INFO
EXPORT DATABASE CONFIGURATION
RAL Syntax
SHOW TABLE METADATA
REFRESH TABLE METADATA
RQL Syntax
FORMAT SQL
Usage
Readwrite_splitting
DB Discovery
MASK
Shadow
Sharding
Encrypt
4.1. ShardingSphere-JDBC
Special API
Readwrite Splitting
Hint
Transaction
Seata Transaction
Narayana Transaction
Use Java API
Bitronix Transaction
Atomikos Transaction
Sharding
Hint
Observability
Java API
Algorithm
Rules
Shadow DB
SQL Translator
Encryption
Mixed Rules
HA
Data Masking
Distributed Transaction
SQL Parser
Readwrite-splitting
Sharding
Data Source
Mode
Unsupported Items
Optional Plugins
YAML Configuration
Rules
HA
Distributed Transaction
Encryption
Mixed Rules
SQL-parser
Cache for Sharding Route
Sharding
Readwrite-splitting
SQL Translator
Data Masking
Shadow DB
Mode
Algorithm
JDBC Driver
Spring Namespace
Spring Boot
Data Source
8. FAQ
2. Quick Start
2.1. ShardingSphere-JDBC
2.2. ShardingSphere-Proxy
1. Overview
3. Features
3.10. Observability
Core Concept
3.4. HA
Core Concept
Limitations
3.8. Encryption
Limitations
Core Concept
Appendix with SQL operator
3.3. Readwrite-splitting
Core Concept
Limitations
3.6. Traffic Governance
Core Concept
3.9. Shadow
Core Concept
Limitations
3.5. DB Gateway
Core Concept
Limitations
3.11. Data Masking
Core Concept
Limitations
3.1. Sharding
Appendix with SQL operator
Core Concept
Limitations
3.2. Distributed Transaction
Appendix with SQL operator
Core Concept
Limitations
3.7. Data Migration
Core Concept
Limitations
6. Test Manual
6.3. Module Test
SQL Rewrite Test
SQL Parser Test
6.2. Performance Test
SysBench ShardingSphere-Proxy Empty Rule Performance Test
BenchmarkSQL ShardingSphere-Proxy Sharding Performance Test
6.1. Integration Test
6.4. Pipeline Integration Test
9. Downloads
5. Dev Manual
5.4. DataSource
5.14. Observability
5.6. Proxy
5.2. Configuration
5.8. Readwrite-splitting
5.5. SQL Parser
5.12. Encryption
5.10. Distributed Transaction
5.11. SQL Audit
5.1. Mode
5.13. Shadow DB
5.7. Data Sharding
5.9. HA
5.3. Kernel
5.15. Data Masking
暂无相关搜索结果！
本文档使用
全库网
构建
×
思维导图备注
×
文章二维码
手机扫一扫，轻松掌上读
×
文档下载
请下载您需要的格式的文档，随时随地，享受汲取知识的乐趣！
PDF
文档
EPUB
文档
MOBI
文档
×
书签列表
×
阅读记录
阅读进度:
0.00%
(
0/0
)
重置阅读进度
我的书签
添加书签
移除书签