Apache ShardingSphere v5.2.1 Documentation
首页 白天 夜间 下载 阅读记录
  • 书签 我的书签
  • 添加书签 添加书签 移除书签 移除书签
编辑文档

Readwrite splitting

来源 1 浏览 205 扫码 打印 2023-05-10 08:23:31

    Readwrite splitting

    Dynamic Readwrite-splitting

    Please refer to Built-in Load Balance Algorithm List for more details about type of algorithm. Please refer to for more details about query consistent routing.

    1. Add read/write splitting data source.
    2. Set load-balancing algorithm.
    • Java API: read-write splitting
    • Spring namespace: read-write splitting
    上一篇:
    下一篇:
    • 书签
    • 添加书签 移除书签
    • 4. User Manual
      • 4.2. ShardingSphere-Proxy
        • Session Management
        • Yaml Configuration
          • Properties
          • Authorization
          • Rules
        • Observability
        • DistSQL
          • Usage
            • Shadow
            • Encrypt
            • Sharding
            • DB Discovery
            • Readwrite_splitting
          • Syntax
            • RAL Syntax
            • Resource Query
            • RQL Syntax
            • RUL Syntax
            • Rule Definition
              • Readwrite-Splitting
              • Encrypt
              • Sharding
              • DB Discovery
              • Shadow
              • Single Table
            • RDL Syntax
            • Rule Query
              • Single Table
              • Readwrite-Splitting
              • DB Discovery
              • Shadow
              • Sharding
              • Encrypt
            • Resource Definition
        • Startup
          • Use Binary Tar
          • Build GraalVM Native Image(Alpha)
          • Use Docker
          • Add dependencies
            • Add Narayana dependencies
            • Add Bitronix dependencies
          • Use Helm
        • Data Migration
          • Manual
          • Build
        • Optional Plugins
      • 4.1. ShardingSphere-JDBC
        • YAML Configuration
          • Rules
            • Distributed Transaction
            • Mixed Rules
            • Shadow DB
            • HA
            • Readwrite-splitting
            • SQL-parser
            • Sharding
            • SQL Translator
            • Encryption
          • Algorithm
          • Data Source
          • JDBC Driver
          • Mode
        • Unsupported Items
        • Special API
          • Readwrite Splitting
            • Hint
          • Sharding
            • Hint
          • Transaction
            • Narayana Transaction
            • Seata Transaction
            • Use Spring Boot Starter
            • Use Spring Namespace
            • Atomikos Transaction
            • Bitronix Transaction
            • Use Java API
        • Java API
          • Algorithm
          • Rules
            • SQL Translator
            • Encryption
            • Sharding
            • Shadow DB
            • SQL Parser
            • Readwrite-splitting
            • Mixed Rules
            • Distributed Transaction
            • HA
          • Data Source
          • Mode
        • Spring Boot Starter
          • Algorithm
          • Rules
            • Encryption
            • SQL Parser
            • Shadow DB
            • Mixed Rules
            • Sharding
            • Readwrite splitting
            • HA
          • Mode
          • Data Source
        • Spring Namespace
          • Mode
          • Rules
            • Sharding
            • SQL Parser
            • Encryption
            • HA
            • Shadow DB
            • Mixed Rules
            • Readwrite-splitting
          • Algorithm
          • Data Source
      • 4.3. Common Configuration
        • Builtin Algorithm
          • Encryption Algorithm
          • Load Balance Algorithm
          • Sharding Algorithm
          • Metadata Repository
          • Sharding Audit Algorithm
          • Shadow Algorithm
          • SQL Translator
          • Key Generate Algorithm
        • Properties Configuration
      • 4.4. Error Code
        • SQL Error Code
        • Server Error Code
    • 2. Quick Start
      • 2.2. ShardingSphere-Proxy
      • 2.1. ShardingSphere-JDBC
    • 1. Overview
    • 5. Dev Manual
      • 5.11. SQL Checker
      • 5.13. Shadow DB
      • 5.4. DataSource
      • 5.8. Readwrite-splitting
      • 5.12. Encryption
      • 5.10. Distributed Transaction
      • 5.14. Observability
      • 5.5. SQL Parser
      • 5.2. Configuration
      • 5.7. Data Sharding
      • 5.3. Kernel
      • 5.6. Proxy
      • 5.9. HA
      • 5.1. Mode
    • 9. Downloads
    • 6. Test Manual
      • 6.4. Scaling Integration Test
      • 6.2. Performance Test
        • SysBench ShardingSphere-Proxy Empty Rule Performance Test
        • BenchmarkSQL ShardingSphere-Proxy Sharding Performance Test
      • 6.3. Module Test
        • SQL Rewrite Test
        • SQL Parser Test
      • 6.1. Integration Test
    • 7. Reference
      • 7.4. Sharding
        • Parse Engine
        • Merger Engine
        • Rewrite Engine
        • Execute Engine
        • Route Engine
      • 7.6. Data Migration
      • 7.2. Database Gateway
      • 7.5. Transaction
        • XA Transaction
        • Seata BASE transaction
      • 7.3. Management
      • 7.8. Shadow
      • 7.9. Oberservability
      • 7.10. DistSQL
        • Syntax
          • RAL Syntax
          • RDL Syntax
            • Database Discovery
              • CREATE DB_DISCOVERY HEARTBEAT
              • CREATE DB_DISCOVERY TYPE
              • CREATE DB_DISCOVERY RULE
            • Rule Definition
            • Sharding
              • CREATE SHARDING TABLE RULE
              • CREATE DEFAULT SHARDING STRATEGY
              • CREATE SHARDING BROADCAST TABLE RULE
              • CREATE SHARDING ALGORITHM
              • ALTER SHARDING TABLE RULE
              • CREATE SHARDING BINDING TABLE RULE
              • CREATE SHARDING AUDITOR
              • CREATE SHARDING KEY GENERATOR
            • ADD RESOURCE
            • DROP RESOURCE
            • Shadow
              • CREATE SHADOW RULE
              • CREATE SHADOW ALGORITHM
              • CREATE DEFAULT SHADOW ALGORITHM
            • Encrypt
              • CREATE ENCRYPT RULE
            • ALTER RESOURCE
            • Readwrite-Splitting
              • CREATE READWRITE_SPLITTING RULE
            • Resource Definition
            • Single Table
              • CREATE DEFAULT SINGLE TABLE RULE
              • DROP DEFAULT SINGLE TABLE RULE
              • ALTER DEFAULT SINGLE TABLE RULE
          • Reserved word
          • RQL Syntax
            • SHOW RULES USED RESOURCE
            • Rule Query
            • SHOW DATABASE RESOURCES
            • SHOW UNUSED RESOURCE
            • Sharding
              • SHOW SHARDING ALGORITHMS
              • SHOW SHARDING TABLE RULE
              • SHOW UNUSED SHARDING ALGORITHMS
            • Resource Query
      • 7.11. Architecture
      • 7.7. Encryption
      • 7.1. Database Compatibility
    • 3. Features
      • 3.1. Sharding
        • Core Concept
        • Limitations
        • Appendix with SQL operator
      • 3.10. Observability
        • Core Concept
      • 3.5. DB Gateway
        • Limitations
        • Core Concept
      • 3.4. HA
        • Limitations
        • Core Concept
      • 3.3. Readwrite-splitting
        • Limitations
        • Core Concept
      • 3.9. Shadow
        • Limitations
        • Core Concept
      • 3.8. Encryption
        • Core Concept
        • Appendix with SQL operator
        • Limitations
      • 3.7. Data Migration
        • Limitations
        • Core Concept
      • 3.6. Traffic Governance
        • Core Concept
      • 3.2. Distributed Transaction
        • Appendix with SQL operator
        • Core Concept
        • Limitations
    • 8. FAQ
    暂无相关搜索结果！

      本文档使用 全库网 构建

      展开/收起文章目录

      思维导图备注

      文章二维码

      手机扫一扫，轻松掌上读

      文档下载

      请下载您需要的格式的文档，随时随地，享受汲取知识的乐趣！
      PDF文档 EPUB文档 MOBI文档

      书签列表

        阅读记录

        阅读进度: 0.00% ( 0/0 ) 重置阅读进度