springboot+zookeeper+postgre引入seata1.4.0

腌萝卜ylb

已于 2023-03-24 15:41:16 修改

阅读量473

点赞数 1

文章标签： spring boot java 分布式 zookeeper

于 2022-12-21 10:54:24 首次发布

本文链接：https://blog.csdn.net/weixin_44100938/article/details/128393623

版权

组件版本：

springboot版本2.7.0

zookeeper版本3.6.3

seata版本1.4.0

postgre版本14.3

JDK版本1.8

seata安装

seata安装包下载地址：下载中心

下载seata-server-1.4.0.zip压缩文件，解压文件编辑 conf/registry.conf，将注册和配置中心都改为 zk，并配置上本地zk的地址,多个节点用逗号隔开

registry {
  # file 、nacos 、eureka、redis、zk、consul、etcd3、sofa
  type = "zk"
  loadBalance = "RandomLoadBalance"
  loadBalanceVirtualNodes = 10
  zk {
    cluster = "default"
    serverAddr = "127.0.0.1:2181,127.0.0.2:2181"
    sessionTimeout = 6000
    connectTimeout = 2000
    username = ""
    password = ""
  }
}

config {
  # file、nacos 、apollo、zk、consul、etcd3
  type = "zk"
  zk {
    serverAddr = "127.0.0.1:2181,127.0.0.2:2181"
    sessionTimeout = 6000
    connectTimeout = 2000
    username = ""
    password = ""
  }
}

因为我们使用的是zk做配置和注册中心，所以不需要配置 file.conf。下载config.txt配置文件，如果是下载的源码，可以在script\config-center\config.txt 找到，编辑此配置文件，主要是修改数据库参数。将配置执行到zk中，到zk服务器下，linux下执行zkCli.sh文件进入命令行模式，将下面的代码复制进去执行：

deleteall /seata
create /seata
create /seata/transport.type TCP
create /seata/transport.server NIO
create /seata/transport.heartbeat true
create /seata/transport.enableClientBatchSendRequest false
create /seata/transport.threadFactory.bossThreadPrefix NettyBoss
create /seata/transport.threadFactory.workerThreadPrefix NettyServerNIOWorker
create /seata/transport.threadFactory.serverExecutorThreadPrefix NettyServerBizHandler
create /seata/transport.threadFactory.shareBossWorker false
create /seata/transport.threadFactory.clientSelectorThreadPrefix NettyClientSelector
create /seata/transport.threadFactory.clientSelectorThreadSize 1
create /seata/transport.threadFactory.clientWorkerThreadPrefix NettyClientWorkerThread
create /seata/transport.threadFactory.bossThreadSize 1
create /seata/transport.threadFactory.workerThreadSize default
create /seata/transport.shutdown.wait 3
create /seata/service.vgroupMapping.my_test_tx_group default
create /seata/service.default.grouplist 127.0.0.1:8091
create /seata/service.enableDegrade false
create /seata/service.disableGlobalTransaction false
create /seata/client.rm.asyncCommitBufferLimit 10000
create /seata/client.rm.lock.retryInterval 10
create /seata/client.rm.lock.retryTimes 30
create /seata/client.rm.lock.retryPolicyBranchRollbackOnConflict true
create /seata/client.rm.reportRetryCount 5
create /seata/client.rm.tableMetaCheckEnable false
create /seata/client.rm.sqlParserType druid
create /seata/client.rm.reportSuccessEnable false
create /seata/client.rm.sagaBranchRegisterEnable false
create /seata/client.tm.commitRetryCount 5
create /seata/client.tm.rollbackRetryCount 5
create /seata/client.tm.defaultGlobalTransactionTimeout 60000
create /seata/client.tm.degradeCheck false
create /seata/client.tm.degradeCheckAllowTimes 10
create /seata/client.tm.degradeCheckPeriod 2000
create /seata/store.mode db
create /seata/store.file.dir file_store/data
create /seata/store.file.maxBranchSessionSize 16384
create /seata/store.file.maxGlobalSessionSize 512
create /seata/store.file.fileWriteBufferCacheSize 16384
create /seata/store.file.flushDiskMode async
create /seata/store.file.sessionReloadReadSize 100
create /seata/store.db.datasource druid
create /seata/store.db.dbType postgresql
create /seata/store.db.driverClassName org.postgresql.Driver
create /seata/store.db.url jdbc:postgresql://127.0.0.1:5432/test
create /seata/store.db.user test
create /seata/store.db.password test
create /seata/store.db.minConn 5
create /seata/store.db.maxConn 30
create /seata/store.db.globalTable global_table
create /seata/store.db.branchTable branch_table
create /seata/store.db.queryLimit 100
create /seata/store.db.lockTable lock_table
create /seata/store.db.maxWait 5000
create /seata/store.redis.host 127.0.0.1
create /seata/store.redis.port 6379
create /seata/store.redis.maxConn 10
create /seata/store.redis.minConn 1
create /seata/store.redis.database 0
create /seata/store.redis.password null
create /seata/store.redis.queryLimit 100
create /seata/server.recovery.committingRetryPeriod 1000
create /seata/server.recovery.asynCommittingRetryPeriod 1000
create /seata/server.recovery.rollbackingRetryPeriod 1000
create /seata/server.recovery.timeoutRetryPeriod 1000
create /seata/server.maxCommitRetryTimeout -1
create /seata/server.maxRollbackRetryTimeout -1
create /seata/server.rollbackRetryTimeoutUnlockEnable false
create /seata/client.undo.dataValidation true
create /seata/client.undo.logSerialization jackson
create /seata/client.undo.onlyCareUpdateColumns true
create /seata/server.undo.logSaveDays 7
create /seata/server.undo.logDeletePeriod 86400000
create /seata/client.undo.logTable undo_log
create /seata/client.log.exceptionRate 100
create /seata/transport.serialization seata
create /seata/transport.compressor none
create /seata/metrics.enabled false
create /seata/metrics.registryType compact
create /seata/metrics.exporterList prometheus
create /seata/metrics.exporterPrometheusPort 9898

需要提示每个节点创建成功，执行结果如下：

将postgrejdbc包复制到lib文件夹下，我这里postgre14.3需要引入postgresql-42.3.5.jar，然后删除旧的包。配置完成后启动seata，windows执行bin/seata-server.bat，linux执行bin/seata-server.sh。

项目配置

引入seata依赖

        <dependency>
            <groupId>io.seata</groupId>
            <artifactId>seata-spring-boot-starter</artifactId>
            <version>1.4.0</version>
        </dependency>
        <dependency>
            <groupId>com.101tec</groupId>
            <artifactId>zkclient</artifactId>
            <version>0.10</version>
        </dependency>

配置application.yml

seata:
  enabled: true
  config:
    type: zk
    zk:
      server-addr: 127.0.0.1:2181
      session-timeout: 6000
      connect-timeout: 2000
      username:
      password:
      node-path: /seata/seata.properties
  registry:
    type: zk
    zk:
      cluster: default
      server-addr: 127.0.0.1:2181
      session-timeout: 6000
      connect-timeout: 2000
      username: ""
      password: ""
  tx-service-group: my_test_tx_group
  service:
    vgroupMapping:
      my_test_tx_group: default

在需要的方法上加@GlobalTransactional(rollbackFor = Exception.class)注解，即可实现分布式事务。

seata相关的postgre数据库sql

CREATE TABLE IF NOT EXISTS public.global_table
(
    xid                       VARCHAR(128) NOT NULL,
    transaction_id            BIGINT,
    status                    SMALLINT     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                TIMESTAMP(0),
    gmt_modified              TIMESTAMP(0),
    CONSTRAINT pk_global_table PRIMARY KEY (xid)
);

CREATE INDEX idx_gmt_modified_status ON public.global_table (gmt_modified, status);
CREATE INDEX idx_transaction_id ON public.global_table (transaction_id);

-- the table to store BranchSession data
CREATE TABLE IF NOT EXISTS public.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            SMALLINT,
    client_id         VARCHAR(64),
    application_data  VARCHAR(2000),
    gmt_create        TIMESTAMP(6),
    gmt_modified      TIMESTAMP(6),
    CONSTRAINT pk_branch_table PRIMARY KEY (branch_id)
);

CREATE INDEX idx_xid ON public.branch_table (xid);

-- the table to store lock data
CREATE TABLE IF NOT EXISTS public.lock_table
(
    row_key        VARCHAR(128) NOT NULL,
    xid            VARCHAR(96),
    transaction_id BIGINT,
    branch_id      BIGINT       NOT NULL,
    resource_id    VARCHAR(256),
    table_name     VARCHAR(32),
    pk             VARCHAR(36),
    gmt_create     TIMESTAMP(0),
    gmt_modified   TIMESTAMP(0),
    CONSTRAINT pk_lock_table PRIMARY KEY (row_key)
);

CREATE INDEX idx_branch_id ON public.lock_table (branch_id);


-- for AT mode you must to init this sql for you business database. the seata server not need it.
CREATE TABLE IF NOT EXISTS public.undo_log
(
    id            SERIAL       NOT NULL,
    branch_id     BIGINT       NOT NULL,
    xid           VARCHAR(100) NOT NULL,
    context       VARCHAR(128) NOT NULL,
    rollback_info BYTEA        NOT NULL,
    log_status    INT          NOT NULL,
    log_created   TIMESTAMP(0) NOT NULL,
    log_modified  TIMESTAMP(0) NOT NULL,
    CONSTRAINT pk_undo_log PRIMARY KEY (id),
    CONSTRAINT ux_undo_log UNIQUE (xid, branch_id)
);

CREATE SEQUENCE IF NOT EXISTS undo_log_id_seq INCREMENT BY 1 MINVALUE 1 ;