t_user tables: #表逻辑 t_order: actual-data-nodes: ds$->{0..1}.t_order key-generator id: 10 t_order_item: actual-data-nodes: ds$->{0..1}.t_order_item key-generator
Decryption': 'rc4/decrypt/', }, 'ECDSA': { 'Key Generator': 'ecdsa/key-generator Signature': 'ecdsa/verify/', }, 'RSA': { 'Key Generator': 'rsa/key-generator
Groovy表达式,切分之后的真实表所在的节点 actual-data-nodes: ds$->{1}.product_base # 主键生成策略 key-generator # 数据节点配置,采用Groovy表达式 actual-data-nodes: ds$->{2}.shop # 主键生成策略 key-generator 表的分片策略 tables: ## product_base是逻辑表的名称 product_base: # 主键生成策略 key-generator product_id # 生成算法 type: SNOWFLAKE shop: # 主键生成策略 key-generator
algorithm-expression: users orderinfo: actual-data-nodes: db$->{1..2}.orderinfo key-generator
sharding: tables: bu_order: actual-data-nodes: ds1.bu_order_$->{0..1} key-generator
t_order_item tables: t_order: actual-data-nodes: ds0.t_order_$->{1..4} key-generator
sharding-column: today algorithm-expression: pt_call_info_$->{today} key-generator
inline: sharding-column: id algorithm-expression: user$->{id % 2} key-generator
-- 启用Cache注解 --> <cache:annotation-driven cache-manager="cacheManager" key-generator="keyGenerator
key-generator部分是主键生成策略的配置。 key-generator部分是配置主键生成策略。 master-slave 主从模式 修改配置 ?
sharding-column: cid algorithm-expression: user_$->{cid % 2} # 主键生成策略 key-generator
traffic_$->{ account_no % 2 } sharding-column: account_no #id⽣成策略 key-generator
com.zking.ssm.redis.CacheKeyGenerator"></bean> 1.3 启用缓存注解功能 <cache:annotation-driven cache-manager="redisCacheManager" key-generator
#刷新mapper 调试神器 refresh-mapper: true #数据库大写下划线转换 #capital-mode: true #序列接口实现类配置 #key-generator
<cache:annotation-driven key-generator="userKeyGenerator"/> <bean id="userKeyGenerator" class="com.xxx.cache.UserKeyGenerator <cache:advice id="cacheAdvice" cache-manager="cacheManager" key-generator="userKeyGenerator"> </cache
#刷新mapper 调试神器 refresh-mapper: true #数据库大写下划线转换 #capital-mode: true #序列接口实现类配置 #key-generator
<bean id="customKeyGenerator" class="com.example.CustomKeyGenerator"/> <cache:annotation-driven key-generator
sharding: tables: order: actual-data-nodes: db1.pay_order_$->{1..2} key-generator
sharding: tables: orderinfo: actual-data-nodes: db$->{1..2}.orderinfo key-generator
sharding: tables: order: actual-data-nodes: db1.pay_order_$->{1..2} key-generator