| spring.shardingsphere.datasource.names=ds_0,ds_1 |
| |
| spring.shardingsphere.datasource.ds_0.type=com.zaxxer.hikari.HikariDataSource |
| spring.shardingsphere.datasource.ds_0.driver-class-name=com.mysql.jdbc.Driver |
| spring.shardingsphere.datasource.ds_0.jdbc-url=jdbc:mysql://localhost:3306/demo_ds_0?serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=UTF-8 |
| spring.shardingsphere.datasource.ds_0.username=root |
| spring.shardingsphere.datasource.ds_0.password= |
| |
| spring.shardingsphere.datasource.ds_1.type=com.zaxxer.hikari.HikariDataSource |
| spring.shardingsphere.datasource.ds_1.driver-class-name=com.mysql.jdbc.Driver |
| spring.shardingsphere.datasource.ds_1.jdbc-url=jdbc:mysql://localhost:3306/demo_ds_1?serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=UTF-8 |
| spring.shardingsphere.datasource.ds_1.username=root |
| spring.shardingsphere.datasource.ds_1.password= |
| |
| spring.shardingsphere.sharding.tables.t_user.actual-data-nodes=ds_$->{0..1}.t_user_$->{0..1} |
| spring.shardingsphere.sharding.tables.t_user.table-strategy.inline.sharding-column=user_id |
| spring.shardingsphere.sharding.tables.t_user.table-strategy.inline.algorithm-expression=t_user_$->{user_id % 2} |
| spring.shardingsphere.sharding.tables.t_user.database-strategy.inline.sharding-column=user_id |
| spring.shardingsphere.sharding.tables.t_user.database-strategy.inline.algorithm-expression=ds_$->{user_id % 2} |
| spring.shardingsphere.sharding.tables.t_user.key-generator.column=user_id |
| spring.shardingsphere.sharding.tables.t_user.key-generator.type=SNOWFLAKE |
| spring.shardingsphere.sharding.tables.t_user.key-generator.props.worker.id=123 |
| |
| spring.shardingsphere.sharding.encrypt-rule.encryptors.encryptor_aes.type=aes |
| spring.shardingsphere.sharding.encrypt-rule.encryptors.encryptor_aes.props.aes.key.value=123456 |
| spring.shardingsphere.sharding.encrypt-rule.encryptors.encryptor_md5.type=md5 |
| spring.shardingsphere.sharding.encrypt-rule.tables.t_user.columns.user_name.plainColumn=user_name |
| spring.shardingsphere.sharding.encrypt-rule.tables.t_user.columns.user_name.cipherColumn=user_name_cipher |
| spring.shardingsphere.sharding.encrypt-rule.tables.t_user.columns.user_name.encryptor=encryptor_aes |
| spring.shardingsphere.sharding.encrypt-rule.tables.t_user.columns.pwd.plainColumn=pwd_plain |
| spring.shardingsphere.sharding.encrypt-rule.tables.t_user.columns.pwd.cipherColumn=pwd_cipher |
| spring.shardingsphere.sharding.encrypt-rule.tables.t_user.columns.pwd.encryptor=encryptor_md5 |
| |
| spring.shardingsphere.orchestration.name=local_sharding_encrypt |
| spring.shardingsphere.orchestration.overwrite=true |
| spring.shardingsphere.orchestration.registry.type=zookeeper |
| spring.shardingsphere.orchestration.registry.server-lists=localhost:2181 |
| spring.shardingsphere.orchestration.registry.namespace=lorchestration-spring-boot-mysql-local |