YAML configuration provides interaction with ShardingSphere JDBC through configuration files. When used with the governance module together, the configuration of persistence in the configuration center is YAML format.
YAML configuration is the most common configuration mode, which can omit the complexity of programming and simplify user configuration.
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>shardingsphere-jdbc-core</artifactId>
<version>${shardingsphere.version}</version>
</dependency>
ShardingSphere-JDBC YAML file consists of schema name, mode configuration, data source map, rule configurations and properties.
Note: The example connection pool is HikariCP, which can be replaced with other connection pools according to business scenarios.
# Alias of the datasource in JDBC.
# Through this parameter to connect, ShardingSphere-JDBC and ShardingSphere-Proxy.
# Default value: logic_db
schemaName (?):
mode:
dataSources:
rules:
- !FOO_XXX
...
- !BAR_XXX
...
props:
key_1: value_1
key_2: value_2
Please refer to Mode Confiugration for more mode details.
Please refer to Data Source Confiugration for more data source details.
Please refer to Rules Confiugration for more rule details.
The ShardingSphereDataSource created by YamlShardingSphereDataSourceFactory implements the standard JDBC DataSource interface.
File yamlFile = // Indicate YAML file
DataSource dataSource = YamlShardingSphereDataSourceFactory.createDataSource(yamlFile);
Same with Java API.
!! means instantiation of that class
! means self-defined alias
- means one or multiple can be included
[] means array, can substitutable with - each other