高可用

背景信息

通过 YAML 格式，ShardingSphere 会根据 YAML 配置，自动完成 ShardingSphereDataSource 对象的创建，减少用户不必要的编码工作。

参数解释

  1. rules:
  2. - !READWRITE_SPLITTING
  3.   dataSources:
  4.     replica_ds:
  5.       dynamicStrategy: Dynamic # 动态读写分离
  6.         autoAwareDataSourceName: # 高可用规则逻辑数据源名称
  8. - !DB_DISCOVERY
  9.   dataSources:
  10.     <data_source_name> (+): # 逻辑数据源名称
  11.       dataSourceNames: # 数据源名称列表
  12.         - <data_source>
  13.         - <data_source>
  14.       discoveryHeartbeatName: # 检测心跳名称
  15.       discoveryTypeName: # 数据库发现类型名称
  17.   # 心跳检测配置
  18.   discoveryHeartbeats:
  19.     <discovery_heartbeat_name> (+): # 心跳名称
  20.       props:
  21.         keep-alive-cron: # cron 表达式，如：'0/5 * * * * ?'
  23.   # 数据库发现类型配置
  24.   discoveryTypes:
  25.     <discovery_type_name> (+): # 数据库发现类型名称
  26.       type: # 数据库发现类型，如：MySQL.MGR，MySQL.NORMAL_REPLICATION，openGauss.NORMAL_REPLICATION 
  27.       props (?):
  28.         group-name: 92504d5b-6dec-11e8-91ea-246e9612aaf1 # 数据库发现类型必要参数，如 MGR 的 group-name

配置示例

  1. databaseName: database_discovery_db
  3. dataSources:
  4.   ds_0:
  5.     url: jdbc:mysql://127.0.0.1:33306/primary_demo_ds?serverTimezone=UTC&useSSL=false
  6.     username: root
  7.     password:
  8.     connectionTimeoutMilliseconds: 3000
  9.     idleTimeoutMilliseconds: 60000
  10.     maxLifetimeMilliseconds: 1800000
  11.     maxPoolSize: 50
  12.     minPoolSize: 1
  13.   ds_1:
  14.     url: jdbc:mysql://127.0.0.1:33307/primary_demo_ds?serverTimezone=UTC&useSSL=false
  15.     username: root
  16.     password:
  17.     connectionTimeoutMilliseconds: 3000
  18.     idleTimeoutMilliseconds: 60000
  19.     maxLifetimeMilliseconds: 1800000
  20.     maxPoolSize: 50
  21.     minPoolSize: 1
  22.   ds_2:
  23.     url: jdbc:mysql://127.0.0.1:33308/primary_demo_ds?serverTimezone=UTC&useSSL=false
  24.     username: root
  25.     password:
  26.     connectionTimeoutMilliseconds: 3000
  27.     idleTimeoutMilliseconds: 60000
  28.     maxLifetimeMilliseconds: 1800000
  29.     maxPoolSize: 50
  30.     minPoolSize: 1
  32. rules:
  33. - !READWRITE_SPLITTING
  34.   dataSources:
  35.     replica_ds:
  36.       dynamicStrategy:
  37.         autoAwareDataSourceName: readwrite_ds
  39. - !DB_DISCOVERY
  40.   dataSources:
  41.     readwrite_ds:
  42.       dataSourceNames:
  43.         - ds_0
  44.         - ds_1
  45.         - ds_2
  46.       discoveryHeartbeatName: mgr_heartbeat
  47.       discoveryTypeName: mgr
  48.   discoveryHeartbeats:
  49.     mgr_heartbeat:
  50.       props:
  51.         keep-alive-cron: '0/5 * * * * ?'
  52.   discoveryTypes:
  53.     mgr:
  54.       type: MySQL.MGR
  55.       props:
  56.         group-name: 558edd3c-02ec-11ea-9bb3-080027e39bd2

相关参考