This repository was archived by the owner on Apr 15, 2026. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 594
Tinyid server config
duimba edited this page Oct 14, 2018
·
1 revision
datasource.tinyid.names=primary datasource.tinyid.primary.driver-class-name=com.mysql.jdbc.Driver datasource.tinyid.primary.url=jdbc:mysql://ip:port/databaseName?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8 datasource.tinyid.primary.username=root datasource.tinyid.primary.password=123456
单db时,delta=1,remainder=0即可
以两个db配置为例,配置文件如下:
datasource.tinyid.names=primary,secondary datasource.tinyid.primary.driver-class-name=com.mysql.jdbc.Driver datasource.tinyid.primary.url=jdbc:mysql://localhost:3306/db1?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8 datasource.tinyid.primary.username=root datasource.tinyid.primary.password=123456 datasource.tinyid.primary.testOnBorrow=false datasource.tinyid.primary.maxActive=10 datasource.tinyid.secondary.driver-class-name=com.mysql.jdbc.Driver datasource.tinyid.secondary.url=jdbc:mysql://localhost:3306/db2?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8 datasource.tinyid.secondary.username=root datasource.tinyid.secondary.password=123456 datasource.tinyid.secondary.testOnBorrow=false datasource.tinyid.secondary.maxActive=10
如上两个db,如果要生成1,2,3,4....序列的数据,则db中的数据设置如下:
| biz_type | delta | remainder | 备注 |
|---|---|---|---|
| test | 2 | 0 | 生成2,4,6,8序列的数据... |
| biz_type | delta | remainder | 备注 |
|---|---|---|---|
| test | 2 | 1 | 生成1,3,5,7序列的数据... |
- 如果primary db挂掉(remainder=0),则仍能正常服务,但只能产生1,3,5,7..的序列
- 注:不用介意max_id的初始值是奇数还是偶数,都能生成正确的序列
如上两个db,如果要生成1,3,5,7....序列的数据,则db中的数据设置如下:
| biz_type | delta | remainder | 备注 |
|---|---|---|---|
| test | 4 | 1 | 生成1,5,9,13序列的数据... |
| biz_type | delta | remainder | 备注 |
|---|---|---|---|
| test | 4 | 3 | 生成3,7,11,15序列的数据... |