基于CentOS Stream 9平台部署Seata1.6.1，以及使用NaocsConfig获取数据源记录

淩亂°似流年 2024-03-24 03:06 10阅读 0赞

> 相关推荐：  
> [CentOS Stream 9 静态IP配置][CentOS Stream 9 _IP]  
> [CentOS Stream 9 搭建Nacos2.2.0集群以及OpenResty反向代理以及GRPC协议配置][CentOS Stream 9 _Nacos2.2.0_OpenResty_GRPC]

--------------------

### 1.下载 ###

[官方GitHub：https://github.com/seata/seata/releases/tag/v1.6.1][GitHub_https_github.com_seata_seata_releases_tag_v1.6.1]  
在线下载：

cd /usr/local

wget https://github.com/seata/seata/releases/download/v1.6.1/seata-server-1.6.1.tar.gz

或者手动下载本地再上传

--------------------

### 2.解压 ###

tar -zxvf seata-server-1.6.1.tar.gz

--------------------

### 3.配置存储模式 ###

>  *  file：(默认)单机模式，全局事务会话信息内存中读写并持久化本地文件root.data，性能较高(默认）
>  *  db：（5.7+）高可用模式，全局事务会话信息通过db共享，相应性能差些

#### 3.1 创建数据库seata，先下载SQL，再用工具导入 ####

[https://github.com/seata/seata/tree/1.6.1/script/server/db][https_github.com_seata_seata_tree_1.6.1_script_server_db]  
![sql][]  
语句如下：

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

![新建表][a9eeb03967d24349a00747128f542cea.png]

#### 3.2 两种方法配置数据源（①直接配置和②从nacosConfig获取配置） ####

> 打开config/application.yml  
> 修改第`47行`为`db`

##### ①直接配置 #####

vi seata/conf/application.yml

添加

mode: db
        db:
          datasource: druid
          db-type: mysql
          driver-class-name: com.mysql.cj.jdbc.Driver
          url: jdbc:mysql://127.0.0.1:3306/seata?rewriteBatchedStatements=true&useSSL=true&useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai
          user: root
          password: 123456
          min-conn: 10
          max-conn: 100
          global-table: global_table
          branch-table: branch_table
          lock-table: lock_table
          distributed-lock-table: distributed_lock
          query-limit: 1000
          max-wait: 500

![修改数据库存储日志][553f9a3461454f9aadca6adf7d2e1ca2.png]

#### 3.3 配置Nacos注册中心 ####

> 将服务注册到Nacos中

修改第`44行`为 `type: nacos`  
添加;

type: nacos
        nacos:
          application: seata-server
          server-addr: 127.0.0.1:8848
          group: SEATA_GROUP
          namespace:
          cluster: default
          username: nacos
          password: nacos
          context-path:
          ##if use MSE Nacos with auth, mutex with username/password attribute
          #access-key:
          #secret-key:

![nacos][]

##### ② 从NacosConfig获取配置，方便维护数据源 #####

> 选择从NacosConfig获取配置，`上面db配置了，这一步可以不用配置`，以数据库配置为例  
> 修改第41行 type: nacos
> 
>     vi seata/conf/application.yml
> 
> 添加：
> 
>     type: nacos
>       nacos:
>          server-addr: 127.0.0.1:8848
>          namespace:
>          group: SEATA_GROUP
>          username: nacos
>          password: nacos
>          context-path:
>          ##if use MSE Nacos with auth, mutex with username/password attribute
>          #access-key:
>          #secret-key:
>          data-id: seata.properties
> 
> ![type][]

> ESC :wq保存并退出
> 
> 新建配置![新建配置][896bda523cab413988de4f5a44e27df0.png]  
> Data ID
> 
>     seata.properties
> 
> Group
> 
>     SEATA_GROUP
> 
> 配置格式
> 
>  *  `Properties`
> 
> 配置内容:
> 
>     store.mode=db
>     store.db.datasource=druid
>     store.db.dbType=mysql
>     store.db.driverClassName=com.mysql.cj.jdbc.Driver
>     store.db.url=jdbc:mysql://192.168.20.128:3306/seata?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=Asia/Shanghai
>     store.db.user=root
>     store.db.password=123456
> 
> ![新建配置][c9a2bf53ca004c11bab27476bfc3d89f.png]

--------------------

### 4. 启动Seata Server： ###

`sh /usr/local/seata/bin/seata-server.sh -h 192.168.20.128 -p 8091 -m db -n 1`

<table> 
 <thead> 
  <tr> 
   <th>参数</th> 
   <th>全写</th> 
   <th>作用</th> 
   <th>备注</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>-h</td> 
   <td><code>--</code>host</td> 
   <td>指定在注册中心注册的IP</td> 
   <td>不指定时获取当前IP，外部访问部署在云环境和容器中的server建议指定</td> 
  </tr> 
  <tr> 
   <td>-p</td> 
   <td><code>--</code>post</td> 
   <td>指定server启动的端口</td> 
   <td>默认为8091</td> 
  </tr> 
  <tr> 
   <td>-m</td> 
   <td><code>--</code>storeMode</td> 
   <td>事务日志存储模式</td> 
   <td>支持file，db，redis 默认为file 注：redis需seata-server1.3版本及以上</td> 
  </tr> 
  <tr> 
   <td>-n</td> 
   <td><code>--</code>serverNode</td> 
   <td>用于指定seata-server节点ID</td> 
   <td>（适合集群）如1,2，3…默认为1</td> 
  </tr> 
  <tr> 
   <td>-e</td> 
   <td><code>--</code>seataEnv</td> 
   <td>指定seata-server运行环境</td> 
   <td>如dev，test等，服务启动时会使用registry-dev.conf这样的配置</td> 
  </tr> 
 </tbody> 
</table>

![启动][5c7fa05fa06f4065ae44567e63447c5e.png]

查看启动日志（Ctrl C 可退出）

tail -f /usr/local/seata/logs/start.out

![启动日志][72a6f5fb41534f90a25f1d8e45526973.png]  
访问页面：[http://192.168.20.128:7091/\#/login][http_192.168.20.128_7091_login]

> 默认账号：seata  
> 默认密码：seata  
> ![登录][a825943251ba4e4cb78d7eb371ec106a.png]  
> ![事务信息][2f4d3c5578b24c918aede261eba39482.png]

#### 5. 开机自启配置 ####

给Seata指定JAVA\_HOME路径，避免报错  
![Java路径][Java]

##### 5.1 查看JDK路径：`echo $JAVA_HOME` #####

![jdk][]

##### 5.2 编辑seata的启动脚本， #####

vi /usr/local/seata/bin/seata-server.sh

添加JDK路径，并延迟15秒启动，主要等nacos启动完成…：

> 因为我本地搭建的Nacos集群，需要等OpenResty完成代理（对着浏览器刷新集群地址，差不多就是15秒），才能获取到集群地址，不然等seata去获取nacos注册中心时，获取不到，就报错退出程序了…  
> tail -f /usr/local/seata/logs/start.out 查看启动日志，面对不同问题，针对性的去解决~

echo "seata delayed 15s start"
    sleep 15
    JAVA_HOME=/usr/local/java/jdk1.8.0_361
    JAVA=$JAVA_HOME/bin

![延迟启动][51c03b3b59624d458b2b60412824898d.png]

##### 5.3 新增服务脚本： #####

vi /etc/systemd/system/seata.service

添加内容（如果nacos在本机的话，配置了NacosConfig，一定要配置在nacos服务启动之后再执行）：

[Unit]
    Description=seata
    After=nacos-cluster.service
    
    [Service]
    Type=forking
    ExecStartPre=/bin/sleep 10
    ExecStart=sh /usr/local/seata/bin/seata-server.sh -h 192.168.20.128 -p 8091 -m db -n 1
    PrivateTmp=true
    
    [Install]
    WantedBy=multi-user.target

按ESC :wq保存并退出  
![服务配置][70e3dbc190464147b228ee6d085b8d82.png]

##### 5.4 服务脚本赋权： #####

chmod 754 /etc/systemd/system/seata.service

##### 5.5 设置开机自启 #####

systemctl enable seata.service

可以reboot 重启测试是否生效  
![开机自启][03eac751933c4fea89c8ed4b833df336.png]

##### 5.6 查看服务状态： #####

systemctl status seata.service

--------------------

关于项目中事务的使用，有时间再写~

搞定，感谢阅览~  
END

--------------------

[CentOS Stream 9 _IP]: https://blog.csdn.net/qq_44870331/article/details/129750591
[CentOS Stream 9 _Nacos2.2.0_OpenResty_GRPC]: https://blog.csdn.net/qq_44870331/article/details/129828647
[GitHub_https_github.com_seata_seata_releases_tag_v1.6.1]: https://github.com/seata/seata/releases/tag/v1.6.1
[https_github.com_seata_seata_tree_1.6.1_script_server_db]: https://github.com/seata/seata/tree/1.6.1/script/server/db
[sql]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/852db6581ab9408d9bd564db7f249e2e.png
[a9eeb03967d24349a00747128f542cea.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/3959db8bb365465bba46181d85766a36.png
[553f9a3461454f9aadca6adf7d2e1ca2.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/64be4c775abe46498e9bc9423a3edc76.png
[nacos]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/6711b799f94c4cbbaea73ad5a5ed6fb1.png
[type]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/79526993b9e04e7e95799acd6ef7d7c9.png
[896bda523cab413988de4f5a44e27df0.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/f77aa86bd5f0496cb575a8b8a81da000.png
[c9a2bf53ca004c11bab27476bfc3d89f.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/846b6e064b094d11ae0cb3d32443ebf6.png
[5c7fa05fa06f4065ae44567e63447c5e.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/aa7760bdc0c944efbe47f5117be02d3e.png
[72a6f5fb41534f90a25f1d8e45526973.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/6fc3b3b4352544c883f5dde06b1a830b.png
[http_192.168.20.128_7091_login]: http://192.168.20.128:7091/#/login
[a825943251ba4e4cb78d7eb371ec106a.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/443d37a6c7ac41e0887e0cc0f7aaf865.png
[2f4d3c5578b24c918aede261eba39482.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/f4343830a03c45b09396841c0178b0d6.png
[Java]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/4d42f682170d4095ae4e75611997d4f6.png
[jdk]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/d82764ded07845d28d2da05484bd60cc.png
[51c03b3b59624d458b2b60412824898d.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/efca88c4cacf452884295fa3e6f56487.png
[70e3dbc190464147b228ee6d085b8d82.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/3fdca31edc8a4f3f810d73d9027627ba.png
[03eac751933c4fea89c8ed4b833df336.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/24/d0816bd13ab74d4ebd137a45f0cb6869.png