Retro Eye care Haitian Deep Dark Default

Readwrite-splitting

Background

Read/write splitting YAML configuration is highly readable. The YAML format enables you to quickly understand the dependencies between read/write sharding rules. ShardingSphere automatically creates the ShardingSphereDataSource object according to the YAML configuration, which reduces unnecessary coding for users.

Parameters

Static Readwrite-splitting

rules:
- !READWRITE_SPLITTING
  dataSources:
    <data_source_name> (+): # Logic data source name of readwrite-splitting
      static_strategy: # Readwrite-splitting type
        write_data_source_name: # Write data source name
        read_data_source_names: # Read data source names, multiple data source names separated with comma
      loadBalancerName: # Load balance algorithm name
  
  # Load balance algorithm configuration
  loadBalancers:
    <load_balancer_name> (+): # Load balance algorithm name
      type: # Load balance algorithm type
      props: # Load balance algorithm properties
        # ...

Dynamic Readwrite-splitting

rules:
- !READWRITE_SPLITTING
  dataSources:
    <data_source_name> (+): # Logic data source name of 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 data source whether the data source is responsible for read traffic
      loadBalancerName: # Load balance algorithm name
  
  # Load balance algorithm configuration
  loadBalancers:
    <load_balancer_name> (+): # Load balance algorithm name
      type: # Load balance algorithm type
      props: # Load balance algorithm properties
        # ...

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

Procedure

  1. Add read/write splitting data source.
  2. Set the load balancer algorithm.
  3. Use read/write data source.

Sample

rules:
- !READWRITE_SPLITTING
  dataSources:
    readwrite_ds:
      staticStrategy:
        writeDataSourceName: write_ds
        readDataSourceNames:
          - read_ds_0
          - read_ds_1
      loadBalancerName: random
  loadBalancers:
    random:
      type: RANDOM