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 2022/10/21 03:22:46 UTC
[GitHub] [shardingsphere] chengyonghu commented on issue #21558: shardingsphere5.1.2+seata1.5.1
chengyonghu commented on issue #21558:
URL: https://github.com/apache/shardingsphere/issues/21558#issuecomment-1286407862
**This is my yml configuration**
`spring:`
`shardingsphere:`
`datasource:`
`ds-0:`
`driver-class-name: com.mysql.cj.jdbc.Driver`
`type: com.alibaba.druid.pool.DruidDataSource`
`driverClassName: com.mysql.jdbc.Driver`
`url: jdbc:mysql://192.168.0.12:3307/xx?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&autoReconnect=true&useSSL=false&serverTimezone=GMT%2B8`
`username: `
`password: `
`names: ds-0`
`rules:`
`sharding:`
`binding-tables:`
- `icloud_user_picture,icloud_user_picture_ext,icloud_user_picture_meta`
`ud_user_folder,icloud_user_folder_ext`
- `icloud_team_picture,icloud_team_picture_ext,icloud_team_picture_meta`
`ud_team_folder,icloud_team_folder_ext`
`tables:`
`icloud_user_picture: # 逻辑表名称`
`actualDataNodes: ds-0.icloud_user_picture_$->{0..1} # 由数据源名 + 表名组成（参考 Inline 语法规则）`
`tableStrategy: # 分表策略，同分库策略`
`standard:`
`shardingColumn: user_id #分配键`
`shardingAlgorithmName: icloud_user_picture_inline #分片规则`
`keyGenerateStrategy: # 分布式序列策略`
`column: picture_id # 自增列名称，缺省表示不使用自增主键生成器`
`keyGeneratorName: leaf # 分布式序列算法名称`
# `个人图片扩展信息表`
`icloud_user_picture_ext:`
`actualDataNodes: ds-0.icloud_user_picture_ext_$->{0..1}`
`tableStrategy:`
`standard:`
`shardingColumn: user_id`
`shardingAlgorithmName: icloud_user_picture_ext_inline`
# `个人图片水印信息表`
`icloud_user_picture_meta:`
`actualDataNodes: ds-0.icloud_user_picture_meta_$->{0..1}`
`tableStrategy:`
`standard:`
`shardingColumn: user_id`
`shardingAlgorithmName: icloud_user_picture_meta_inline`
# `个人文件夹基本信息表`
`icloud_user_folder:`
`actualDataNodes: ds-0.icloud_user_folder`
`keyGenerateStrategy:`
`column: folder_id`
`keyGeneratorName: leaf`
# `个人文件夹扩展信息表`
`icloud_user_folder_ext:`
`actualDataNodes: ds-0.icloud_user_folder_ext`
# `团队图片基本信息表`
`icloud_team_picture:`
`actualDataNodes: ds-0.icloud_team_picture_${0..1}`
`tableStrategy: # 分表策略，同分库策略`
`standard:`
`shardingColumn: team_id`
`shardingAlgorithmName: icloud_team_picture_inline`
`keyGenerateStrategy: # 分布式序列策略`
`column: picture_id # 自增列名称，缺省表示不使用自增主键生成器`
`keyGeneratorName: leaf # 分布式序列算法名称`
# `团队图片扩展信息表`
`icloud_team_picture_ext:`
`actualDataNodes: ds-0.icloud_team_picture_ext_${0..1}`
`tableStrategy: # 分表策略，同分库策略`
`standard:`
`shardingColumn: team_id`
`shardingAlgorithmName: icloud_team_picture_ext_inline`
# `团队图片水印信息表`
`icloud_team_picture_meta:`
`actualDataNodes: ds-0.icloud_team_picture_meta_${0..1}`
`tableStrategy: # 分表策略，同分库策略`
`standard:`
`shardingColumn: team_id`
`shardingAlgorithmName: icloud_team_picture_meta_inline`
# `团队文件夹基本信息表`
`icloud_team_folder:`
`actualDataNodes: ds-0.icloud_team_folder`
`keyGenerateStrategy:`
`column: folder_id`
`keyGeneratorName: leaf`
# `团队文件夹拓展信息表`
`icloud_team_folder_ext:`
`actualDataNodes: ds-0.icloud_team_folder_ext`
# `文件下载记录`
`icloud_history_download:`
`actualDataNodes: ds-0.icloud_history_download`
`keyGenerateStrategy:`
`column: download_id`
`keyGeneratorName: leaf`
# `用户常用文件夹`
`icloud_user_common_folder:`
`actualDataNodes: ds-0.icloud_user_common_folder`
`keyGenerateStrategy:`
`column: id`
`keyGeneratorName: leaf`
# `团队常用文件夹`
`icloud_team_common_folder:`
`actualDataNodes: ds-0.icloud_team_common_folder`
`keyGenerateStrategy:`
`column: id`
`keyGeneratorName: leaf`
# `操作日志`
`icloud_sys_oper_log:`
`actualDataNodes: ds-0.icloud_sys_oper_log_${202201..202212}`
`table-strategy:`
`standard:`
`sharding-column: oper_time`
`shardingAlgorithmName: icloud_sys_log_inline`
`keyGenerateStrategy:`
`column: oper_id`
`keyGeneratorName: leaf`
# `登录日志`
`icloud_sys_logininfor:`
`actualDataNodes: ds-0.icloud_sys_logininfor_${202201..202212}`
`table-strategy:`
`standard:`
`sharding-column: login_time`
`shardingAlgorithmName: icloud_sys_log_inline`
`keyGenerateStrategy:`
`column: info_id`
`keyGeneratorName: leaf`
# `分片规则`
`sharding-algorithms:`
`icloud_sys_log_inline:`
`type: CLASS_BASED`
`props:`
`strategy: STANDARD`
`algorithmClassName: com.ydtx.camera.icloud.config.CustomPreciseShardingAlgorithm`
`icloud_user_picture_inline:`
`type: inline`
`props:`
`algorithm-expression: icloud_user_picture_$->{user_id % 2}
icloud_user_picture_ext_inline:
type: inline
props:
algorithm-expression: icloud_user_picture_ext_$->{user_id % 2}`
`icloud_user_picture_meta_inline:`
`type: inline`
`props:`
`algorithm-expression: icloud_user_picture_meta_$->{user_id % 2}
icloud_team_picture_inline:
type: inline
props:
algorithm-expression: icloud_team_picture_$->{team_id % 2}`
`icloud_team_picture_ext_inline:`
`type: inline`
`props:`
`algorithm-expression: icloud_team_picture_ext_$->{team_id % 2}
icloud_team_picture_meta_inline:
type: inline
props:
algorithm-expression: icloud_team_picture_meta_$->{team_id % 2}`
`keyGenerators:`
`leaf:`
`type: "LEAF"`
**This is my seata configuration**
seata:
registry:
type: nacos
config:
type: nacos
nacos:
server-addr: 127.0.0.1:8848
group: SEATA_GROUP
username: nacos
password: nacos
tx-service-group: camera-icloud-tx-group
application-id: camera-icloud
use-jdk-proxy: true
@FlyingZC
--
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