HA

Background

Through YAML format, ShardingSphere will automatically create the ShardingSphereDataSource object according to the YAML configuration, reducing unnecessary coding work for users.

Parameters

  1. rules:
  2. - !READWRITE_SPLITTING
  3.   dataSources:
  4.     replica_ds:
  5.       dynamicStrategy:
  6.         autoAwareDataSourceName: # High availability rule logical data source name
  8. - !DB_DISCOVERY
  9.   dataSources:
  10.     <data-source-name> (+): # Logic data source name
  11.       dataSourceNames: # Data source names
  12.         - <data-source>
  13.         - <data-source>
  14.       discoveryHeartbeatName: # Detect heartbeat name
  15.       discoveryTypeName: # Database discovery type name
  17.   # Heartbeat Configuration
  18.   discoveryHeartbeats:
  19.     <discovery-heartbeat-name> (+): # heartbeat name
  20.       props:
  21.         keep-alive-cron: # This is cron expression, such as：'0/5 * * * * ?'
  23.   # Database Discovery Configuration
  24.   discoveryTypes:
  25.     <discovery-type-name> (+): # Database discovery type name
  26.       type: # Database discovery type, such as: MySQL.MGR
  27.       props (?):
  28.         group-name: 92504d5b-6dec-11e8-91ea-246e9612aaf1 # Required parameters for database discovery types, such as MGR's group-name

Sample

  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
  38.   - !DB_DISCOVERY
  39.     dataSources:
  40.       readwrite_ds:
  41.         dataSourceNames:
  42.           - ds_0
  43.           - ds_1
  44.           - ds_2
  45.         discoveryHeartbeatName: mgr-heartbeat
  46.         discoveryTypeName: mgr
  47.     discoveryHeartbeats:
  48.       mgr-heartbeat:
  49.         props:
  50.           keep-alive-cron: '0/5 * * * * ?'
  51.     discoveryTypes:
  52.       mgr:
  53.         type: MySQL.MGR
  54.         props:
  55.           group-name: 558edd3c-02ec-11ea-9bb3-080027e39bd2