storage nodes, they also need to set up an independent load balancer and have the ability of service discovery and request distribution. Apache ShardingSphere provides compute nodes and reuse database as storage readwrite-splitting dynamic-strategy: # Readwrite-splitting type auto-aware-data-source-name: # Database discovery logic data source name write-data-source-query-enabled: # All read data source are offline, write dynamicStrategy: autoAwareDataSourceName: # High availability rule logical data source name - !DB_DISCOVERY dataSources: (+): # Logic data source name dataSourceNames: # Data source

storage nodes, they also need to set up an independent load balancer and have the ability of service discovery and request distribution. Apache ShardingSphere provides compute nodes and reuse database as storage readwrite-splitting dynamic-strategy: # Readwrite-splitting type auto-aware-data-source-name: # Database discovery logic data source name write-data-source-query-enabled: # All read data source are offline, write dynamicStrategy: autoAwareDataSourceName: # High availability rule logical data source name - !DB_DISCOVERY dataSources: (+): # Logic data source name dataSourceNames: # Data source

replica_ds: dynamicStrategy: Dynamic # 动态读写分离 autoAwareDataSourceName: # 高可用规则逻辑数据源名称 - !DB_DISCOVERY dataSources: (+): # 逻辑数据源名称 dataSourceNames: # 数据源名称列表 - - # 心跳检测配置 discoveryHeartbeats: <discovery-heartbeat-name> (+): # 心跳名称 props: keep-alive-cron: # cron 表达式，如：'0/5 * * * * ?' # 数据库发现类型配置 discoveryTypes: <discovery-type-name> (+): # 数据库发现类型名称 4.1 92504d5b-6dec-11e8-91ea-246e9612aaf1 # 数据库发现类型必要参数，如 MGR 的 group-name 配置示例 databaseName: database_discovery_db dataSources: ds_0: url: jdbc:mysql://127.0.0.1:33306/primary_demo_ds?serverTimezone=UTC&

storage nodes, they also need to set up an independent load balancer and have the ability of service discovery and request distribution. 4.6. HA 54 Apache ShardingSphere document, v5.1.1 Apache ShardingSphere and replica databases. Specifically, the ability of Apache ShardingSphere provided is database discovery, detect the primary and replica databases automatically, and updates the connection of compute configura‐ tion dis coveryTypes (+) Map Database discovery type con‐ figuration 5.1. ShardingSphere-JDBC 77 Apache ShardingSphere document, v5.1.1 Data

storage nodes, they also need to set up an independent load balancer and have the ability of service discovery and request distribution. Apache ShardingSphere provides compute nodes and reuse database as storage https://github.com/apache/shardingsphere/tree/master/shardingsphere‐ features/shardingsphere‐db‐discovery 4.6. HA 57 Apache ShardingSphere document, v5.1.2 4.6.4 Core Concept high Availability Type and replica databases. Specifically, the ability of Apache ShardingSphere provided is database discovery, detect the primary and replica databases automatically, and updates the connection of compute

props: # 负载均衡算法属性配置 # ... 算法类型的详情，请参见内置负载均衡算法列表。查询一致性路由的详情，请参见使用规范。 高可用 配置项说明 rules: - !DB_DISCOVERY dataSources: (+): # 逻辑数据源名称 dataSourceNames: # 数据源名称列表 - - # 心跳检测配置 discoveryHeartbeats: <discovery-heartbeat-name> (+): # 心跳名称 props: keep-alive-cron: # cron 表达式，如：'0/5 * * * * ?' # 数据库发现类型配置 discoveryTypes: <discovery-type-name> (+): # 数据库发现类型名称 5.1 database-discovery.data-sources.discovery- data-source-name>.data-source-names= # 数据源名称，多个数据源用逗号分隔 如：ds_0, ds_1 spring.shardingsphere.rules.database-discovery.data-sources.discovery- data-source-name>

props: # 负载均衡算法属性配置 # ... 算法类型的详情，请参见内置负载均衡算法列表。查询一致性路由的详情，请参见使用规范。 高可用 配置项说明 rules: - !DB_DISCOVERY dataSources: (+): # 逻辑数据源名称 dataSourceNames: # 数据源名称列表 - - # 心跳检测配置 discoveryHeartbeats: <discovery-heartbeat-name> (+): # 心跳名称 props: keep-alive-cron: # cron 表达式，如：'0/5 * * * * ?' # 数据库发现类型配置 discoveryTypes: <discovery-type-name> (+): # 数据库发现类型名称 5.1 database-discovery.data-sources.discovery- data-source-name>.data-source-names= # 数据源名称，多个数据源用逗号分隔 如：ds_0, ds_1 spring.shardingsphere.rules.database-discovery.data-sources.discovery- data-source-name>

码：https://github.com/apache/shardingsphere/tree/master/shardingsphere‐ features/shardingsphere‐db‐discovery 4.6.4 核心概念 高可用类型 Apache ShardingSphere 不提供数据库高可用的能力，它通过第三方提供的高可用方案感知数据库主从 关系的切换。确切来说，Apache props: # 负载均衡算法属性配置 # ... 算法类型的详情，请参见内置负载均衡算法列表。查询一致性路由的详情，请参见使用规范。 高可用 配置项说明 rules: - !DB_DISCOVERY dataSources: (+): # 逻辑数据源名称 dataSourceNames: # 数据源名称列表 - - # 心跳检测配置 discoveryHeartbeats: <discovery-heartbeat-name> (+): # 心跳名称 props: keep-alive-cron: # cron 表达式，如：'0/5 * * * * ?' # 数据库发现类型配置 discoveryTypes: <discovery-type-name> (+): # 数据库发现类型名称 5.1

rules and dynamic readwrite‐splitting rules • Dynamic readwrite‐splitting rules rely on database discovery rules • loadBanlancerType specifies the load balancing algorithm type, please refer to Load Balance RULE t_encrypt,t_encrypt_2; DB Discovery Definition CREATE DB_DISCOVERY RULE databaseDiscoveryRuleDefinition [, databaseDiscoveryRuleDefinition] ... ALTER DB_DISCOVERY RULE databaseDiscoveryRuleDefinition inition [, databaseDiscoveryRuleDefinition] ... DROP DB_DISCOVERY RULE ruleName [, ruleName] ... databaseDiscoveryRuleDefinition: ruleName(resources, discoveryTypeDefinition) resources: RESOURCES(resourceName

RULE t_encrypt,t_encrypt_2; 数据库发现 定义 CREATE DB_DISCOVERY RULE databaseDiscoveryRuleDefinition [, databaseDiscoveryRuleDefinition] ... ALTER DB_DISCOVERY RULE databaseDiscoveryRuleDefinition [, datab databaseDiscoveryRuleDefinition] ... DROP DB_DISCOVERY RULE ruleName [, ruleName] ... databaseDiscoveryRuleDefinition: ruleName(resources, discoveryTypeDefinition) resources: RESOURCES(resourceName [, v5.0.0 示例 CREATE DB_DISCOVERY RULE ha_group_0 ( RESOURCES(resource_0,resource_1), TYPE(NAME=mgr,PROPERTIES(groupName='92504d5b-6dec',keepAliveCron='')) ); ALTER DB_DISCOVERY RULE ha_group_0 ( RESOURCES(resource_0