分布式事务--seata初步使用

最新推荐文章于 2024-05-08 14:25:38 发布

NGC73

最新推荐文章于 2024-05-08 14:25:38 发布

阅读量628

点赞数

分类专栏：微服务文章标签：分布式 java spring cloud

本文链接：https://blog.csdn.net/Wulawuba/article/details/124820067

版权

微服务专栏收录该内容

3 篇文章 0 订阅

订阅专栏

分布式事务seata基本使用

官网连接：https://seata.io/zh-cn/，推荐看一下官方文档，比绝大多数的seata使用案例更清晰明了。

1、下载安装

下载链接：https://github.com/seata/seata/releases/tag/v1.4.2

$[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-cwU8K5ZD-1652766834804)(C:\Users\25060\AppData\Roaming\Typora\typora-user-images\image-20220517102518786.png)]$

2、注册中心与配置中心配置

下载后，在conf文件夹下的registry.conf配置注册中心。以nacos注册中心为例，配置ip端口，以及nacos的用户名与密码。（使用其他的注册中心类似配置ip、port、用户名、密码）

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

  nacos {
    application = "seata-server"
    serverAddr = "127.0.0.1:8848"
    group = "SEATA_GROUP"
    namespace = ""
    cluster = "default"
    username = "nacos"
    password = "nacos"
  }
  eureka {
    serviceUrl = "http://localhost:8761/eureka"
    application = "default"
    weight = "1"
  }
  redis {
    serverAddr = "localhost:6379"
    db = 0
    password = ""
    cluster = "default"
    timeout = 0
  }
  zk {
    cluster = "default"
    serverAddr = "127.0.0.1:2181"
    sessionTimeout = 6000
    connectTimeout = 2000
    username = ""
    password = ""
  }
  consul {
    cluster = "default"
    serverAddr = "127.0.0.1:8500"
    aclToken = ""
  }
  etcd3 {
    cluster = "default"
    serverAddr = "http://localhost:2379"
  }
  sofa {
    serverAddr = "127.0.0.1:9603"
    application = "default"
    region = "DEFAULT_ZONE"
    datacenter = "DefaultDataCenter"
    cluster = "default"
    group = "SEATA_GROUP"
    addressWaitTime = "3000"
  }
  file {
    name = "file.conf"
  }
}

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

  nacos {
    serverAddr = "127.0.0.1:8848"
    namespace = ""
    group = "SEATA_GROUP"
    username = "nacos"
    password = "nacos"
    dataId = "seataServer.properties"
  }
  consul {
    serverAddr = "127.0.0.1:8500"
    aclToken = ""
  }
  apollo {
    appId = "seata-server"
    ## apolloConfigService will cover apolloMeta
    apolloMeta = "http://192.168.1.204:8801"
    apolloConfigService = "http://192.168.1.204:8080"
    namespace = "application"
    apolloAccesskeySecret = ""
    cluster = "seata"
  }
  zk {
    serverAddr = "127.0.0.1:2181"
    sessionTimeout = 6000
    connectTimeout = 2000
    username = ""
    password = ""
    nodePath = "/seata/seata.properties"
  }
  etcd3 {
    serverAddr = "http://localhost:2379"
  }
  file {
    name = "file.conf"
  }
}

3、seata日志存储配置

conf文件夹下>>file.conf中，配置为数据库模式

$[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-mOsgSy1e-1652766834805)(C:\Users\25060\AppData\Roaming\Typora\typora-user-images\image-20220517105139840.png)]$

seata建表语句

-- -------------------------------- The script used when storeMode is 'db' --------------------------------
-- the table to store GlobalSession data
CREATE TABLE IF NOT EXISTS `global_table`
(
    `xid`                       VARCHAR(128) NOT NULL,
    `transaction_id`            BIGINT,
    `status`                    TINYINT      NOT NULL,
    `application_id`            VARCHAR(32),
    `transaction_service_group` VARCHAR(32),
    `transaction_name`          VARCHAR(128),
    `timeout`                   INT,
    `begin_time`                BIGINT,
    `application_data`          VARCHAR(2000),
    `gmt_create`                DATETIME,
    `gmt_modified`              DATETIME,
    PRIMARY KEY (`xid`),
    KEY `idx_status_gmt_modified` (`status` , `gmt_modified`),
    KEY `idx_transaction_id` (`transaction_id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

-- the table to store BranchSession data
CREATE TABLE IF NOT EXISTS `branch_table`
(
    `branch_id`         BIGINT       NOT NULL,
    `xid`               VARCHAR(128) NOT NULL,
    `transaction_id`    BIGINT,
    `resource_group_id` VARCHAR(32),
    `resource_id`       VARCHAR(256),
    `branch_type`       VARCHAR(8),
    `status`            TINYINT,
    `client_id`         VARCHAR(64),
    `application_data`  VARCHAR(2000),
    `gmt_create`        DATETIME(6),
    `gmt_modified`      DATETIME(6),
    PRIMARY KEY (`branch_id`),
    KEY `idx_xid` (`xid`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

-- the table to store lock data
CREATE TABLE IF NOT EXISTS `lock_table`
(
    `row_key`        VARCHAR(128) NOT NULL,
    `xid`            VARCHAR(128),
    `transaction_id` BIGINT,
    `branch_id`      BIGINT       NOT NULL,
    `resource_id`    VARCHAR(256),
    `table_name`     VARCHAR(32),
    `pk`             VARCHAR(36),
    `status`         TINYINT      NOT NULL DEFAULT '0' COMMENT '0:locked ,1:rollbacking',
    `gmt_create`     DATETIME,
    `gmt_modified`   DATETIME,
    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;

CREATE TABLE IF NOT EXISTS `distributed_lock`
(
    `lock_key`       CHAR(20) NOT NULL,
    `lock_value`     VARCHAR(20) NOT NULL,
    `expire`         BIGINT,
    primary key (`lock_key`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;

INSERT INTO `distributed_lock` (lock_key, lock_value, expire) VALUES ('AsyncCommitting', ' ', 0);
INSERT INTO `distributed_lock` (lock_key, lock_value, expire) VALUES ('RetryCommitting', ' ', 0);
INSERT INTO `distributed_lock` (lock_key, lock_value, expire) VALUES ('RetryRollbacking', ' ', 0);
INSERT INTO `distributed_lock` (lock_key, lock_value, expire) VALUES ('TxTimeoutCheck', ' ', 0);

并在每个服务的数据库中添加undo_log 表，建表语句如下

CREATE TABLE undo_log (
id bigint(20) NOT NULL AUTO_INCREMENT,
branch_id bigint(20) NOT NULL,
xid varchar(100) NOT NULL,
context varchar(128) NOT NULL,
rollback_info longblob NOT NULL,
log_status int(11) NOT NULL,
log_created datetime NOT NULL,
log_modified datetime NOT NULL,
ext varchar(100) DEFAULT NULL,
PRIMARY KEY (id),
UNIQUE KEY ux_undo_log (xid,branch_id)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

4、下载conf.txt

下载链接https://github.com/seata/seata/blob/develop/script/config-center/config.txt

下载config.txt文件到conf文件夹下，上述链接为官方参考配置。

5、创建nacos目录

在conf同级目录下创建nacos文件夹，下载nacos-config.sh放置nacos文件夹下，双击执行，等待完成，配置将同步到nacos注册中心

6、 pom引入

<!--seata-->
<dependency>
    <groupId>com.alibaba.cloud</groupId>
    <artifactId>spring-cloud-starter-alibaba-seata</artifactId>
    <exclusions>
        <exclusion>
            <artifactId>seata-all</artifactId>
            <groupId>io.seata</groupId>
        </exclusion>
    </exclusions>
</dependency>
<dependency>
    <groupId>io.seata</groupId>
    <artifactId>seata-all</artifactId>
    <version>1.3.0</version>
</dependency>

7、nacos配置各服务的配置信息

enable必须为true，才能开启seata

enable-auto-data-source-proxy为自动代理数据源，如果不开启建议改为enableAutoDataSourceProxy: false，而不是以下代码

（nacos配置坑点一：https://blog.csdn.net/dai909237869/article/details/124093302）

（nacos配置多数据源：https://www.cnblogs.com/huan1993/p/15416066.html）

seata:

  enabled: true

  application-id: ${spring.application.name}

  tx-service-group: ${spring.application.name}-group

  enable-auto-data-source-proxy: false

  service:

    vgroup-mapping:
      ruoyi-system-group: default
  config:
    type: nacos
    nacos:
      serverAddr: 127.0.0.1:8848
      group: SEATA_GROUP
      namespace:
  registry:
    type: nacos
    nacos:
      application: seata-server
      server-addr: 127.0.0.1:8848
      namespace:

8 、使用

$[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-yCO6kGdD-1652766834806)(C:\Users\25060\AppData\Roaming\Typora\typora-user-images\image-20220517134243362.png)]$

NGC73

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
分布式事务--seata初步使用

分布式事务seata基本使用官网连接：https://seata.io/zh-cn/，推荐看一下官方文档，比绝大多数的seata使用案例更清晰明了。1、下载安装下载链接：https://github.com/seata/seata/releases/tag/v1.4.22、注册中心与配置中心配置下载后，在conf文件夹下的registry.conf配置注册中心。以nacos注册中心为例，配置ip端口，以及nacos的用户名与密码。（使用其他的注册中心类似配置ip、port、用户名、密码）reg
复制链接

扫一扫