You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/08/06 02:07:01 UTC
[GitHub] [shardingsphere] bai1986 commented on issue #11671: ERROR 1815 (HY000): Internal error
bai1986 commented on issue #11671:
URL: https://github.com/apache/shardingsphere/issues/11671#issuecomment-893948757
config-sharding.yaml
schemaName: ProductDB
dataSources:
ds_0:
url: jdbc:mysql://127.0.0.1:3306/ProductDB00?serverTimezone=Asia/Shanghai&useSSL=false&characterEncoding=GBK&character_set_server= gbk&connectionCollation=gbk_bin
username: shardingsphere
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1
ds_1:
url: jdbc:mysql://127.0.0.1:3306/ProductDB01?serverTimezone=Asia/Shanghai&useSSL=false&characterEncoding=GBK&character_set_server= gbk&connectionCollation=gbk_bin
username: shardingsphere
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1
ds_2:
url: jdbc:mysql://127.0.0.1:3306/ProductDB02?serverTimezone=Asia/Shanghai&useSSL=false&characterEncoding=GBK&character_set_server= gbk&connectionCollation=gbk_bin
username: shardingsphere
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1
ds_3:
url: jdbc:mysql://127.0.0.1:3306/ProductDB03?serverTimezone=Asia/Shanghai&useSSL=false&characterEncoding=GBK&character_set_server= gbk&connectionCollation=gbk_bin
username: shardingsphere
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1
ds_4:
url: jdbc:mysql://127.0.0.1:3306/ProductDB04?serverTimezone=Asia/Shanghai&useSSL=false&characterEncoding=GBK&character_set_server= gbk&connectionCollation=gbk_bin
username: shardingsphere
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1
ds_5:
url: jdbc:mysql://127.0.0.1:3306/ProductDB05?serverTimezone=Asia/Shanghai&useSSL=false&characterEncoding=GBK&character_set_server= gbk&connectionCollation=gbk_bin
username: shardingsphere
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1
ds_6:
url: jdbc:mysql://127.0.0.1:3306/ProductDB06?serverTimezone=Asia/Shanghai&useSSL=false&characterEncoding=GBK&character_set_server= gbk&connectionCollation=gbk_bin
username: shardingsphere
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1
ds_7:
url: jdbc:mysql://127.0.0.1:3306/ProductDB07?serverTimezone=Asia/Shanghai&useSSL=false&characterEncoding=GBK&character_set_server= gbk&connectionCollation=gbk_bin
username: shardingsphere
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1
rules:
- !SHARDING
tables:
Products_Core:
actualDataNodes: ds_${0..7}.Products_Core
keyGenerateStrategy:
column: id
keyGeneratorName: snowflake
databaseStrategy:
standard:
shardingColumn: product_id
shardingAlgorithmName: product_core_database_inline
products_ddshop_category:
actualDataNodes: ds_${0..7}.products_ddshop_category
keyGenerateStrategy:
column: id
keyGeneratorName: snowflake
databaseStrategy:
standard:
shardingColumn: id
shardingAlgorithmName: ddshop_database_inline
mytest:
actualDataNodes: ds_0.mytest
coupon_products_map:
actualDataNodes: ds_4.coupon_products_map
defaultDatabaseStrategy:
none:
defaultTableStrategy:
none:
shardingAlgorithms:
product_core_database_inline:
type: INLINE
props:
algorithm-expression: ds_${product_id % 7}
ddshop_database_inline:
type: INLINE
props:
algorithm-expression: ds_${id % 7}
keyGenerators:
snowflake:
type: SNOWFLAKE
props:
worker-id: 123
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org