seata-sample

KO | EN

gitlite — search

#python #react #ai #llm #golang #android #machine-learning #rust #docker #java #pytorch #security #openai #mcp

(★ 8)

基于spring cloud+spring jpa+spring cloud alibaba fescar+mysql+seata的分布式示例

seata-sample Latest Version Download

Download Latest Version (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# seata-sample
基于spring cloud+spring jpa+spring cloud alibaba fescar+mysql+seata的分布式示例

[分布式事务之Seata中间件原理及流程详细分析](https://blog.csdn.net/f4761/article/details/89077400)

### 准备工作
1. 执行数据库脚本
2. 启动fescar server
   使用默认配置
2. 启动启动business、storage、account、order
   数据库默认连接127.0.0.1:3306，不同的注意修改
3. 事务成功
   GET 127.0.0.1:8084/purchase?userId=1001&commodityCode=2001&orderCount=1
4. 事务回滚 GET 127.0.0.1:8084/purchase?userId=1001&commodityCode=2001&orderCount=5

###数据库脚本
```sql
create schema db_account;

use db_account;

CREATE TABLE `account_tbl` (
       `id` int(11) NOT NULL AUTO_INCREMENT,
       `user_id` varchar(255) DEFAULT NULL,
       `money` int(11) DEFAULT 0,
       PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO account_tbl (id, user_id, money) VALUES (1, '1001', 10000);

CREATE TABLE `undo_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `branch_id` bigint(20) NOT NULL,
  `xid` varchar(100) 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=9 DEFAULT CHARSET=utf8;

create schema db_order;

use db_order;

CREATE TABLE `order_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(255) DEFAULT NULL,
  `commodity_code` varchar(255) DEFAULT NULL,
  `count` int(11) DEFAULT '0',
  `money` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

create schema db_storage;

use db_storage;

CREATE TABLE `storage_tbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `commodity_code` varchar(255) DEFAULT NULL,
  `count` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `commodity_code` (`commodity_code`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

INSERT INTO storage_tbl (id, commodity_code, count) VALUES (1, '2001', 1000);

seata-sample

seata-sample Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

seata-sample

seata-sample Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

Download README