目录

Docker 安装 Seata

官网 http://seata.io/zh-cn/index.html

启动

docker run --name seata -p 8091:8091 -d seataio/seata-server

复制配置文件

docker cp seata:/seata-server/resources /home/seata

重启 seata

docker stop seata
docker rm -f seata

docker run --name seata --restart=always -p 8091:8091 -p 7091:7091  -e SEATA_IP=192.168.1.1  -e SEATA_PORT=8091  -v /vuser/docker/seata/resources/application.yml:/seata-server/resources/application.yml  -d seataio/seata-server 

修改配置文件

seata:
  config:
    type: nacos
    nacos:
      server-addr: 127.0.0.1:8848
      group : DEFAULT_GROUP
      namespace: public
      dataId: seataServer.properties
      username: "nacos"
      password: "nacos"
registry:
    # support: nacos, eureka, redis, zk, consul, etcd3, sofa
    type: nacos
    nacos: 
      application: seata-server
      server-addr: IP:8848
      group: DEFAULT_GROUP
      namespace: public
      username: nacos
      password: nacos


## dataId 是 nacos 中的配置文件ID

## nacos 配置内容如下
store.mode: db
##store.mode file、nacos 、apollo、zk、consul、etcd3、custom
store.db.driverClassName: com.mysql.jdbc.Driver
# mysql8及以上版本对应的driver：com.mysql.cj.jdbc.Driver
# mysql8以下版本的driver：com.mysql.jdbc.Driver
store.db.url: 
#store.db.url=jdbc:mysql://127.0.0.1:3306/testseata?characterEncoding=utf-8&serverTimezone=Asia/Shanghai&useSSL=false&zeroDateTimeBehavior=convertToNull&useSSL=false
store.db.user: 
store.db.password:

## 参考

seata:
  config:
    # support: nacos, consul, apollo, zk, etcd3
    type: nacos
    nacos:
      server-addr: 192.168.1.50:5000
      group: DEFAULT_GROUP
      namespace: public
      username:
      password:
  registry:
    # support: nacos, eureka, redis, zk, consul, etcd3, sofa
    type: nacos
    nacos:
      application: seata-server
      server-addr: 192.168.1.50:5000
      group: DEFAULT_GROUP
      namespace: public
      username:
      password:


## 参考 seataServer.properties
store.mode: db
store.db.driverClassName: com.mysql.jdbc.Driver
store.db.url: jdbc:mysql://192.168.1.1:3306/seata?characterEncoding=utf-8&serverTimezone=Asia/Shanghai&useSSL=false&zeroDateTimeBehavior=convertToNull&useSSL=false
store.db.user: root
store.db.password: 123456

项目配置

seata:
  enabled: true
  enable-auto-data-source-proxy: true
  tx-service-group: tx-group
  registry:
    type: nacos
    nacos:
      server-addr: ${cfg.nacos.ips}
      namespace:
      group: SEATA_GROUP
      cluster: default
  config:
    type: nacos
    nacos:
      server-addr: ${cfg.nacos.ips}
      namespace:
      group: SEATA_GROUP
      data-id: seataServer.properties

动态数据源配置

# seata 配置
seata:
  enable-auto-data-source-proxy: false ## 这个一定要为 false

spring:
  datasource:
    dynamic:
      seata: true ## 这个一定要为 true
      seata-mode: xa  ## 模式的这里配置默认为at

数据表创建

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` (`xid`)
) 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);

AT模式表

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=utf8mb4;