Springboot+Zookeeper+Seata

CL_Blog

已于 2022-10-14 11:23:32 修改

阅读量415

点赞数

文章标签： java spring boot

于 2022-08-16 11:59:30 首次发布

本文链接：https://blog.csdn.net/CL_Blog/article/details/126362945

版权

maven依赖

        <dependency>
            <groupId>io.seata</groupId>
            <artifactId>seata-spring-boot-starter</artifactId>
            <version>1.5.1</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba.cloud</groupId>
            <artifactId>spring-cloud-starter-alibaba-seata</artifactId>
            <version>2.1.0.RELEASE</version>
            <exclusions>
                <exclusion>
                    <groupId>io.seata</groupId>
                    <artifactId>seata-spring-boot-starter</artifactId>
                </exclusion>
            </exclusions>
        </dependency>
        <dependency>
            <groupId>com.esotericsoftware.kryo</groupId>
            <artifactId>kryo</artifactId>
            <version>2.24.0</version>
        </dependency>
        <dependency>
            <groupId>com.esotericsoftware</groupId>
            <artifactId>kryo</artifactId>
            <version>4.0.2</version>
        </dependency>
        <dependency>
            <groupId>de.javakaffee</groupId>
            <artifactId>kryo-serializers</artifactId>
            <version>0.44</version>
        </dependency>
        <dependency>
            <groupId>com.github.sgroschupf</groupId>
            <artifactId>zkclient</artifactId>
            <version>0.1</version>
            <exclusions>
                <exclusion>
                    <groupId>org.apache.zookeeper</groupId>
                    <artifactId>zookeeper</artifactId>
                </exclusion>
                <exclusion>
                    <groupId>log4j</groupId>
                    <artifactId>log4j</artifactId>
                </exclusion>
            </exclusions>
        </dependency>
        <dependency>
            <groupId>org.apache.zookeeper</groupId>
            <artifactId>zookeeper</artifactId>
            <version>3.4.6</version>
            <!--排除这个slf4j-log4j12-->
            <exclusions>
                <exclusion>
                    <groupId>org.slf4j</groupId>
                    <artifactId>slf4j-log4j12</artifactId>
                </exclusion>
            </exclusions>
        </dependency>
        <dependency>
            <groupId>org.apache.curator</groupId>
            <artifactId>curator-framework</artifactId>
            <version>2.13.0</version>
        </dependency>

yml配置

seata:
  enabled: true
  application-id: system-user
  tx-service-group: my_test_tx_group
  data-source-proxy-mode: AT 
  client:
    undo:
      # undo序列化方式  这个值需要在 seata server 的配置中心中修改，否则不生效
      logSerialization: jackson
      # 自定义undo表名
      logTable: undo_log
    rm:
      lock:
        retryInterval: 10
        retryTimes: 30
        # 分支事务与其它全局回滚事务冲突时锁策略 默认true，优先释放本地锁让回滚成功
        retryPolicyBranchRollbackOnConflict: false
    tm:
      # 一阶段全局提交结果上报TC重试次数
      commit-retry-count: 5
      # 一阶段全局回滚结果上报TC重试次数
      rollback-retry-count: 5
      # 分布式事物超时时间
      default-global-transaction-timeout: 600000
      # 降级开关,false 不打开
      degrade-check: false
      degrade-check-period: 2000
      degrade-check-allow-times: 10
  service:
    # 全局事务开关
    disableGlobalTransaction: false
    vgroupMapping:
#      my_test_tx_group: default
      system-user-fescar-service-group: default
    default:
      grouplist: 127.0.0.1:7092
  # 是否自动开启数据源代理
  enable-auto-data-source-proxy: false
  # 数据源代理模式，使用AT模式
  #  data-source-proxy-mode: AT
  # 配置中心，需要和 seata server 保持一致
  config:
    type: zk
    zk:
      server-addr: 127.0.0.1:2181
      connect-timeout: 2000
      session-timeout: 6000
  # 注册中心，需要和 seata server 保持一致
  registry:
    type: zk
    zk:
      server-addr: 127.0.0.1:2181
      connect-timeout: 2000
      session-timeout: 6000
      cluster: default

往zk注册seata服务端结点

import org.apache.curator.RetryPolicy;
import org.apache.curator.framework.CuratorFramework;
import org.apache.curator.framework.CuratorFrameworkFactory;
import org.apache.curator.retry.RetryUntilElapsed;
import org.apache.zookeeper.CreateMode;
import org.apache.zookeeper.data.Stat;

import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.util.Objects;
import java.util.Properties;
import java.util.Set;
import java.util.concurrent.ExecutorService;
import java.util.concurrent.Executors;

/**
 * @author：CL
 * @time： 2022/7/16
 */
public class ZkConfig {

    private static final String NODE_PATH = "/seata";
    private static final String CONNECT_TOSTRING = "127.0.0.1:2181";
    public static ExecutorService executorService = Executors.newCachedThreadPool();

    public static void main(String[] args) throws Exception {
        try {
            RetryPolicy retryPolicy2 = new RetryUntilElapsed(5000, 1000);
            CuratorFramework curatorFramework = CuratorFrameworkFactory.builder()
                    .connectString(CONNECT_TOSTRING)
                    .sessionTimeoutMs(5000)
                    .connectionTimeoutMs(5000)
                    .retryPolicy(retryPolicy2)
                    .build();
            curatorFramework.start();
            Stat stat1 = curatorFramework.checkExists().forPath(NODE_PATH);
            if(Objects.isNull(stat1)){
                curatorFramework.create().creatingParentsIfNeeded().withMode(CreateMode.PERSISTENT).forPath(NODE_PATH, null);
            }
            Properties properties = new Properties();
            try {
                File file=new File("E:\\seata\\jy\\jy-framework\\src\\main\\java\\net\\hnwxkj\\jy\\framework\\config\\config.txt");
                InputStream in = new FileInputStream(file);
                properties.load(in);
                Set<Object> keys = properties.keySet();
                for (Object key : keys) {
                    putConfig(curatorFramework,key.toString(), properties.get(key).toString());
                }
            } catch (IOException e) {
                e.printStackTrace();
            }

        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            executorService.shutdown();
        }
    }

    /**
     *
     * @param curatorFramework
     * @param dataId
     * @param content
     * @return
     */
    public static boolean putConfig(CuratorFramework curatorFramework, final String dataId, final String content) {
        Boolean flag = false;
        String path = "/seata/" + dataId;
        try {
            Stat stat1 = curatorFramework.checkExists().forPath(path);
            if (Objects.isNull(stat1)) {
                curatorFramework.create().creatingParentsIfNeeded().withMode(CreateMode.PERSISTENT).forPath(path, content.getBytes());
                flag = true;
            }
            return flag;
        } catch (Exception e) {
            e.printStackTrace();
        }
        return false;

    }

}

config.txt

service.vgroupMapping.my_test_tx_group=default
service.vgroupMapping.system-user-fescar-service-group=default
service.default.grouplist=127.0.0.1:7092
service.enableDegrade=false
service.disableGlobalTransaction=false
store.mode=db
store.db.datasource=druid
store.db.dbType=mysql
store.db.driverClassName=com.mysql.jdbc.Driver
store.db.url=jdbc:mysql://localhost:3306/seata?useUnicode=true
store.db.user=root
store.db.password=root
store.db.minConn=5
store.db.maxConn=30
store.db.globalTable=global_table
store.db.branchTable=branch_table
store.db.queryLimit=100
store.db.lockTable=lock_table
store.db.maxWait=5000
client.undo.logSerialization=jackson

seata服务端配置（版本1.3.0）示例采用DB模式

file.conf


## transaction log store, only used in seata-server
store {
  ## store mode: file、db、redis
  mode = "db"

  ## database store property
  db {
    ## the implement of javax.sql.DataSource, such as DruidDataSource(druid)/BasicDataSource(dbcp)/HikariDataSource(hikari) etc.
    datasource = "druid"
    ## mysql/oracle/postgresql/h2/oceanbase etc.
    dbType = "mysql"
    driverClassName = "com.mysql.jdbc.Driver"
    url = "jdbc:mysql://127.0.0.1:3306/seata"
    user = "root"
    password = "root"
    minConn = 5
    maxConn = 30
    globalTable = "global_table"
    branchTable = "branch_table"
    lockTable = "lock_table"
    queryLimit = 100
    maxWait = 5000
  }

}

registry.conf

registry {
  # file 、nacos 、eureka、redis、zk、consul、etcd3、sofa
  type = "zk"

  zk {
    cluster = "default"
    serverAddr = "127.0.0.1:2181"
    sessionTimeout = 6000
    connectTimeout = 2000
    username = ""
    password = ""
  }
}

config {
  # file、nacos 、apollo、zk、consul、etcd3
  type = "zk"

  zk {
    serverAddr = "127.0.0.1:2181"
    sessionTimeout = 6000
    connectTimeout = 2000
    username = ""
    password = ""
  }
}

sql

/*
Navicat MySQL Data Transfer

Source Server         : 127.0.0.1
Source Server Version : 50722
Source Host           : 127.0.0.1:3306
Source Database       : seata

Target Server Type    : MYSQL
Target Server Version : 50722
File Encoding         : 65001

Date: 2022-08-16 11:57:14
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for branch_table
-- ----------------------------
DROP TABLE IF EXISTS `branch_table`;
CREATE TABLE `branch_table` (
  `branch_id` bigint(20) NOT NULL COMMENT '分支事务ID',
  `xid` varchar(128) NOT NULL COMMENT '全局事务ID',
  `transaction_id` bigint(20) DEFAULT NULL COMMENT '全局事务ID，不带TC地址',
  `resource_group_id` varchar(32) DEFAULT NULL COMMENT '资源分组ID',
  `resource_id` varchar(256) DEFAULT NULL COMMENT '资源ID',
  `branch_type` varchar(8) DEFAULT NULL COMMENT '事务模式，AT、XA等',
  `status` tinyint(4) DEFAULT NULL COMMENT '状态',
  `client_id` varchar(64) DEFAULT NULL COMMENT '客户端ID',
  `application_data` varchar(2000) DEFAULT NULL COMMENT '应用数据',
  `gmt_create` datetime(6) DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime(6) DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`branch_id`),
  KEY `idx_xid` (`xid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='分支事务的信息';

-- ----------------------------
-- Table structure for global_table
-- ----------------------------
DROP TABLE IF EXISTS `global_table`;
CREATE TABLE `global_table` (
  `xid` varchar(128) NOT NULL COMMENT '全局事务ID',
  `transaction_id` bigint(20) DEFAULT NULL COMMENT '事务ID',
  `status` tinyint(4) NOT NULL COMMENT '状态',
  `application_id` varchar(32) DEFAULT NULL COMMENT '应用ID',
  `transaction_service_group` varchar(32) DEFAULT NULL COMMENT '事务分组名',
  `transaction_name` varchar(128) DEFAULT NULL COMMENT '执行事务的方法',
  `timeout` int(11) DEFAULT NULL COMMENT '超时时间',
  `begin_time` bigint(20) DEFAULT NULL COMMENT '开始时间',
  `application_data` varchar(2000) DEFAULT NULL COMMENT '应用数据',
  `gmt_create` datetime DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`xid`),
  KEY `idx_status_gmt_modified` (`status`,`gmt_modified`),
  KEY `idx_transaction_id` (`transaction_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='全局事务的信息';

-- ----------------------------
-- Table structure for lock_table
-- ----------------------------
DROP TABLE IF EXISTS `lock_table`;
CREATE TABLE `lock_table` (
  `row_key` varchar(128) NOT NULL COMMENT '行键',
  `xid` varchar(128) DEFAULT NULL COMMENT '全局事务ID',
  `transaction_id` bigint(20) DEFAULT NULL COMMENT '全局事务ID，不带TC 地址',
  `branch_id` bigint(20) NOT NULL COMMENT '分支ID',
  `resource_id` varchar(256) DEFAULT NULL COMMENT '资源ID',
  `table_name` varchar(32) DEFAULT NULL COMMENT '表名',
  `pk` varchar(36) DEFAULT NULL COMMENT '主键对应的值',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0:locked ,1:rollbacking',
  `gmt_create` datetime DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`row_key`),
  KEY `idx_status` (`status`),
  KEY `idx_branch_id` (`branch_id`),
  KEY `idx_xid_and_branch_id` (`xid`,`branch_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='锁相关的信息';

-- ----------------------------
-- Table structure for undo_log
-- ----------------------------
DROP TABLE IF EXISTS `undo_log`;
CREATE TABLE `undo_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `branch_id` bigint(20) NOT NULL COMMENT '分支事务ID',
  `xid` varchar(100) NOT NULL COMMENT '全局事务ID',
  `context` varchar(128) NOT NULL COMMENT '上下文',
  `rollback_info` longblob NOT NULL COMMENT '回滚信息',
  `log_status` int(11) NOT NULL COMMENT '状态，0正常，1全局已完成',
  `log_created` datetime NOT NULL COMMENT '创建时间',
  `log_modified` datetime NOT NULL COMMENT '修改时间',
  `ext` varchar(100) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ux_undo_log` (`xid`,`branch_id`)
) ENGINE=InnoDB AUTO_INCREMENT=126 DEFAULT CHARSET=utf8;