尝试下简单的分布式事务
步骤引导
- 准备依赖环境服务
JDK1.8+,Mysql5.6+,Redis3.2+,Consul(SpringCloud),ZooKeeper(Dubbo),Git,Maven - 初始化数据 见下方说明
- 启动TxManager(TM)
见下方说明 - 配置微服务模块
见下方说明 - 启动模块与测试
见下方说明
初始化数据
TM数据初始化
TxManager(TM)依赖tx-manager数据库(MariaDB 、MySQL)建表语句如下:
DROP TABLE IF EXISTS `t_tx_exception`;
CREATE TABLE `t_tx_exception` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`group_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`unit_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`mod_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`transaction_state` tinyint(4) NULL DEFAULT NULL,
`registrar` tinyint(4) NULL DEFAULT NULL COMMENT '-1 未知 0 Manager 通知事务失败, 1 client询问事务状态失败2 事务发起方关闭事务组失败',
`ex_state` tinyint(4) NULL DEFAULT NULL COMMENT '0 待处理 1已处理',
`create_time` datetime(0) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 967 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
TC数据初始化 微服务演示Demo依赖txlcn-demo数据库(MariaDB 、MySQL)建表语句如下:
DROP TABLE IF EXISTS `t_demo`;
CREATE TABLE `t_demo` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`kid` varchar(45) DEFAULT NULL,
`demo_field` varchar(255) DEFAULT NULL,
`group_id` varchar(64) DEFAULT NULL,
`unit_id` varchar(32) DEFAULT NULL,
`app_name` varchar(32) DEFAULT NULL,
`create_time` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
启动TxManager(TM)
TM下载与配置
git clone https://github.com/codingapi/tx-lcn.git
修改配置信息(txlcn-tm\src\main\resources\application.properties)
spring.application.name=tx-manager
server.port=7970
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/tx-manager?characterEncoding=UTF-8
spring.datasource.username=root
spring.datasource.password=root
mybatis.configuration.map-underscore-to-camel-case=true
mybatis.configuration.use-generated-keys=true
#tx-lcn.logger.enabled=true
# TxManager Host Ip
#tx-lcn.manager.host=127.0.0.1
# TxClient连接请求端口
#tx-lcn.manager.port=8070
# 心跳检测时间(ms)
#tx-lcn.manager.heart-time=15000
# 分布式事务执行总时间
#tx-lcn.manager.dtx-time=30000
#参数延迟删除时间单位ms
#tx-lcn.message.netty.attr-delay-time=10000
#tx-lcn.manager.concurrent-level=128
# 开启日志
#tx-lcn.logger.enabled=true
#logging.level.com.codingapi=debug
#redisIp
#spring.redis.host=127.0.0.1
#redis\u7AEF\u53E3
#spring.redis.port=6379
#redis\u5BC6\u7801
#spring.redis.password=
#
给出信息都是默认值
关于详细配置说明见 manager
TM编译与启动
编译
进入到txlcn-tm路径下。 执行 mvn clean package '-Dmaven.test.skip=true'
启动
进入target文件夹下。执行 java -jar txlcn-tm-5.0.0.jar
启动TxManager
配置微服务模块
Dubbo Demo见Dubbo-Demo
SpringCloud Demo见SpringCloud-Demo
启动模块与测试
(1)正常提交事务
访问 发起方提供的Rest接口 /txlcn?value=the-value
。发现事务全部提交
(2)回滚事务
修改微服务 发起方Client 业务,在返回结果前抛出异常,再请求Rest接口。发现发起方由于本地事务回滚,而参与方D、E,由于TX-LCN的协调,数据也回滚了。
Dubbo示例
Dubbo 示例说明
共三个模块如下:
dubbo-demo-client(发起方 | LCN模式)
dubbo-demo-d (参与方 | TXC模式)
dubbo-demo-e (参与方 | TCC模式)
代码地址:https://github.com/codingapi/txlcn-demo
调用关系说明:
dubbo-demo-client -> DemoConsumerController的txlcn
的Mapping是调用发起方法,代码如下。
@RestController
public class DemoConsumerController {
@Autowired
private DemoApiService demoApiService;
@RequestMapping("/txlcn")
public String sayHello(@RequestParam("value") String value) {
return demoApiService.execute(value);
}
}
DemoApiService.execute(value)方法代码:
@Service
public class DemoApiServiceImpl implements DemoApiService {
@Reference(version = "${demo.service.version}",
application = "${dubbo.application.d}",
registry = "${dubbo.registry.address}",
retries = -1,
check = false,
loadbalance = "txlcn_random")
private DDemoService dDemoService;
@Reference(version = "${demo.service.version}",
application = "${dubbo.application.e}",
retries = -1,
check = false,
registry = "${dubbo.registry.address}",
loadbalance = "txlcn_random")
private EDemoService eDemoService;
@Autowired
private DemoMapper demoMapper;
@Override
@LcnTransaction
public String execute(String name) {
/*
* 注意 5.0.0 请用 DTXLocal 类
* 注意 5.0.0 请自行获取应用名称
* 注意 5.0.0 其它类重新导入包名
*/
String dResp = dDemoService.rpc(name);
String eResp = eDemoService.rpc(name);
Demo demo = new Demo();
demo.setCreateTime(new Date());
demo.setAppName(Transactions.APPLICATION_ID_WHEN_RUNNING);
demo.setDemoField(name);
demo.setGroupId(DTXLocalContext.getOrNew().getGroupId());
demo.setUnitId(DTXLocalContext.getOrNew().getUnitId());
demoMapper.save(demo);
// int a = 1 / 0;
return dResp + " > " + eResp + " > " + "client-ok";
}
}
参与方dDemoService.rpc(name)的代码
@Service(
version = "${demo.service.version}",
application = "${dubbo.application.id}",
protocol = "${dubbo.protocol.id}",
registry = "${dubbo.registry.id}"
)
@Slf4j
public class DefaultDemoService implements DDemoService {
@Autowired
private DDemoMapper demoMapper;
@Override
@TxTransaction(type = "txc")
public String rpc(String name) {
/*
* 注意 5.0.0 请用 DTXLocal 类
* 注意 5.0.0 请自行获取应用名称
* 注意 5.0.0 其它类重新导入包名
*/
log.info("GroupId: {}", TracingContext.tracing().groupId());
Demo demo = new Demo();
demo.setDemoField(name);
demo.setCreateTime(new Date());
demo.setGroupId(DTXLocalContext.getOrNew().getGroupId());
demo.setAppName(Transactions.APPLICATION_ID_WHEN_RUNNING);
demo.setUnitId(DTXLocalContext.getOrNew().getUnitId());
demoMapper.save(demo);
return "d-ok";
}
}
参与方eDemoService.rpc(name)的代码
@Service(
version = "${demo.service.version}",
application = "${dubbo.application.id}",
protocol = "${dubbo.protocol.id}",
registry = "${dubbo.registry.id}"
)
@Slf4j
public class DefaultDemoService implements EDemoService {
@Autowired
private EDemoMapper demoMapper;
private ConcurrentHashMap<String, Long> ids = new ConcurrentHashMap<>();
@Override
@TccTransaction(confirmMethod = "cm", cancelMethod = "cl", executeClass = DefaultDemoService.class)
public String rpc(String name) {
/*
* 注意 5.0.0 请用 DTXLocal 类
* 注意 5.0.0 请自行获取应用名称
* 注意 5.0.0 其它类重新导入包名
*/
log.info("GroupId: {}", TracingContext.tracing().groupId());
Demo demo = new Demo();
demo.setDemoField(name);
demo.setCreateTime(new Date());
demo.setGroupId(DTXLocalContext.getOrNew().getGroupId());
demo.setUnitId(DTXLocalContext.getOrNew().getUnitId());
demo.setAppName(Transactions.APPLICATION_ID_WHEN_RUNNING);
demoMapper.save(demo);
ids.put(DTXLocalContext.cur().getGroupId(), demo.getId());
return "e-ok";
}
public void cm(String name) {
log.info("tcc-confirm-" + DTXLocalContext.getOrNew().getGroupId());
ids.remove(DTXLocalContext.getOrNew().getGroupId());
}
public void cl(String name) {
log.info("tcc-cancel-" + DTXLocalContext.getOrNew().getGroupId());
demoMapper.deleteByKId(ids.get(DTXLocalContext.getOrNew().getGroupId()));
}
}
事务参与方D配置
工程截图
项目配置文件 application.properties
# Spring boot application
spring.application.name=dubbo-demo-d
server.port=12005
management.port=12008
# Service version
demo.service.version=1.0.0
# Base packages to scan Dubbo Components (e.g @Service , @Reference)
dubbo.scan.basePackages=com.example
# Dubbo Config properties
## ApplicationConfig Bean
dubbo.application.id=dubbo-demo-d
dubbo.application.name=dubbo-demo-d
## ProtocolConfig Bean
dubbo.protocol.id=dubbo
dubbo.protocol.name=dubbo
dubbo.protocol.port=12345
## RegistryConfig Bean
dubbo.registry.id=my-registry
dubbo.registry.address=127.0.0.1:2181
dubbo.registry.protocol=zookeeper
dubbo.application.qos.enable=false
## DB
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/txlcn-demo?characterEncoding=UTF-8&serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.hikari.maximum-pool-size=20
mybatis.configuration.map-underscore-to-camel-case=true
mybatis.configuration.use-generated-keys=true
## tx-manager 配置
#tx-lcn.client.manager-address=127.0.0.1:8070
Application代码
@SpringBootApplication
@EnableDistributedTransaction
public class DemoDubboDApplication {
public static void main(String[] args) {
SpringApplication.run(DemoDubboDApplication.class, args);
}
}
事务参与方 E
工程截图
配置文件 application.properties
# Spring boot application
spring.application.name=dubbo-demo-e
server.port=12006
management.port=12009
# Service version
demo.service.version=1.0.0
# Base packages to scan Dubbo Components (e.g @Service , @Reference)
dubbo.scan.basePackages=com.example
# Dubbo Config properties
## ApplicationConfig Bean
dubbo.application.id=dubbo-demo-e
dubbo.application.name=dubbo-demo-e
dubbo.application.service4=dubbo-demo-client
## ProtocolConfig Bean
dubbo.protocol.id=dubbo
dubbo.protocol.name=dubbo
dubbo.protocol.port=12346
## RegistryConfig Bean
dubbo.registry.id=my-registry
dubbo.registry.address=127.0.0.1:2181
dubbo.registry.protocol=zookeeper
dubbo.application.qos.enable=false
#db
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/txlcn-demo\
?characterEncoding=UTF-8&serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.hikari.maximum-pool-size=20
mybatis.configuration.map-underscore-to-camel-case=true
mybatis.configuration.use-generated-keys=true
## tx-manager 配置
#tx-lcn.client.manager-address=127.0.0.1:8070
Application代码
@SpringBootApplication
@EnableDistributedTransaction
public class DemoDubboEApplication {
public static void main(String[] args) {
SpringApplication.run(DemoDubboEApplication.class, args);
}
}
事务发起方 Client
工程目录
项目配置文件 application.properties
# Spring boot application
spring.application.name=dubbo-demo-client
server.port=12004
management.port=12007
# Service Version
demo.service.version=1.0.0
# Dubbo Config properties
## ApplicationConfig Bean
dubbo.application.id=dubbo-demo-client
dubbo.application.name=dubbo-demo-client
dubbo.application.d=dubbo-demo-d
dubbo.application.e=dubbo-demo-e
## ProtocolConfig Bean
dubbo.protocol.id=dubbo
dubbo.protocol.name=dubbo
dubbo.protocol.port=12345
dubbo.registry.protocol=zookeeper
dubbo.registry.address=127.0.0.1:2181
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/txlcn-demo?characterEncoding=UTF-8&serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.hikari.maximum-pool-size=20
mybatis.configuration.map-underscore-to-camel-case=true
mybatis.configuration.use-generated-keys=true
## 切面日志信息(h2数据库地址,自创建)
#tx-lcn.aspect.log.file-path=D://txlcn/h2-${spring.application.name}
#
## manager服务地址(rpc端口),可填写多个负载
#tx-lcn.client.manager-address=127.0.0.1:8070
#
## 开启日志数据库记录存储
#tx-lcn.logger.enabled=true
## 日志数据库存储jdbc配置
#tx-lcn.logger.driver-class-name=com.mysql.jdbc.Driver
#tx-lcn.logger.jdbc-url=jdbc:mysql://127.0.0.1:3306/tx-logger?characterEncoding=UTF-8&serverTimezone=UTC
#tx-lcn.logger.username=root
#tx-lcn.logger.password=123456
启动Dubbo微服务
事务参与方 D
事务参与方 E
事务发起方 Client
SpringCloud示例
SpringCloud 示例说明
共三个模块如下:
spring-demo-client(发起方 | LCN模式)
spring-demo-d (参与方 | TXC模式)
spring-demo-e (参与方 | TCC模式)
代码地址:https://github.com/codingapi/txlcn-demo
调用关系说明:
spring-demo-client -> DemoController的txlcn
的Mapping是调用发起方法,代码如下。
@RestController
public class DemoController {
private final DemoService demoService;
@Autowired
public DemoController(DemoService demoService) {
this.demoService = demoService;
}
@RequestMapping("/txlcn")
public String execute(@RequestParam("value") String value) {
return demoService.execute(value);
}
}
demoService.execute(value)代码:
@Service
@Slf4j
public class DemoServiceImpl implements DemoService {
private final ClientDemoMapper demoMapper;
private final DDemoClient dDemoClient;
private final EDemoClient eDemoClient;
@Autowired
public DemoServiceImpl(ClientDemoMapper demoMapper, DDemoClient dDemoClient, EDemoClient eDemoClient) {
this.demoMapper = demoMapper;
this.dDemoClient = dDemoClient;
this.eDemoClient = eDemoClient;
}
@Override
@LcnTransaction
public String execute(String value) {
/*
* 注意 5.0.0 请用 DTXLocal 类
* 注意 5.0.0 请自行获取应用名称
* 注意 5.0.0 其它类重新导入包名
*/
// ServiceD
String dResp = dDemoClient.rpc(value);
// ServiceE
String eResp = eDemoClient.rpc(value);
// local transaction
Demo demo = new Demo();
demo.setDemoField(value);
demo.setAppName(Transactions.APPLICATION_ID_WHEN_RUNNING); // 应用名称
demo.setCreateTime(new Date());
demo.setGroupId(DTXLocalContext.getOrNew().getGroupId()); // DTXLocal
demo.setUnitId(DTXLocalContext.getOrNew().getUnitId());
demoMapper.save(demo);
// 手动异常,DTX B回滚
// int i = 1 / 0;
return dResp + " > " + eResp + " > " + "ok-client";
}
}
dDemoClient.rpc(value)代码:
@Service
@Slf4j
public class DemoServiceImpl implements DemoService {
private final DDemoMapper demoMapper;
@Autowired
public DemoServiceImpl(DDemoMapper demoMapper) {
this.demoMapper = demoMapper;
}
@Override
@TxcTransaction(propagation = DTXPropagation.SUPPORTS)
@Transactional
public String rpc(String value) {
/*
* 注意 5.0.0 请用 DTXLocal 类
* 注意 5.0.0 请自行获取应用名称
* 注意 5.0.0 其它类重新导入包名
*/
// log.info("GroupId: {}", TracingContext.tracing().groupId());
Demo demo = new Demo();
demo.setCreateTime(new Date());
demo.setDemoField(value);
demo.setAppName(Transactions.APPLICATION_ID_WHEN_RUNNING); // 应用名称
demo.setGroupId(DTXLocalContext.getOrNew().getGroupId()); // DTXLocal
demo.setUnitId(DTXLocalContext.getOrNew().getUnitId());
demoMapper.save(demo);
// moreOperateMapper.update(new Date());
// moreOperateMapper.delete();
return "ok-d";
}
}
eDemoClient.rpc(value)代码:
@Service
@Slf4j
public class DemoServiceImpl implements DemoService {
private final EDemoMapper demoMapper;
private ConcurrentHashMap<String, Long> ids = new ConcurrentHashMap<>();
@Autowired
public DemoServiceImpl(EDemoMapper demoMapper) {
this.demoMapper = demoMapper;
}
@Override
@TccTransaction(propagation = DTXPropagation.SUPPORTS)
@Transactional
public String rpc(String value) {
/*
* 注意 5.0.0 请用 DTXLocal 类
* 注意 5.0.0 请自行获取应用名称
* 注意 5.0.0 其它类重新导入包名
*/
// log.info("GroupId: {}", TracingContext.tracing().groupId());
Demo demo = new Demo();
demo.setDemoField(value);
demo.setCreateTime(new Date());
demo.setAppName(Transactions.APPLICATION_ID_WHEN_RUNNING);
demo.setGroupId(DTXLocalContext.getOrNew().getGroupId());
demo.setUnitId(DTXLocalContext.getOrNew().getUnitId());
demoMapper.save(demo);
// ids.put(DTXLocalContext.getOrNew().getGroupId(), demo.getId());
return "ok-e";
}
public void confirmRpc(String value) {
log.info("tcc-confirm-" + DTXLocalContext.getOrNew().getGroupId());
ids.remove(DTXLocalContext.getOrNew().getGroupId());
}
public void cancelRpc(String value) {
log.info("tcc-cancel-" + DTXLocalContext.getOrNew().getGroupId());
Long kid = ids.get(DTXLocalContext.getOrNew().getGroupId());
demoMapper.deleteByKId(kid);
}
}
事务参与方D
工程截图
项目配置文件 application.properties
spring.application.name=spring-demo-d
server.port=12002
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
## TODO 你的配置
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/txlcn-demo\
?characterEncoding=UTF-8&serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=root
#spring.datasource.hikari.maximum-pool-size=20
mybatis.configuration.map-underscore-to-camel-case=true
mybatis.configuration.use-generated-keys=true
## tx-manager 配置
#tx-lcn.client.manager-address=127.0.0.1:8070
Application
@SpringBootApplication
@EnableDiscoveryClient
@EnableDistributedTransaction
public class SpringDApplication {
public static void main(String[] args) {
SpringApplication.run(SpringDApplication.class, args);
}
}
事务参与方E
工程截图
项目配置文件 application.properties
spring.application.name=spring-demo-e
server.port=12003
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://ip:port/txlcn-demo?characterEncoding=UTF-8
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.hikari.maximum-pool-size=20
mybatis.configuration.map-underscore-to-camel-case=true
mybatis.configuration.use-generated-keys=true
Application
@SpringBootApplication
@EnableDiscoveryClient
@EnableDistributedTransaction
public class SpringEApplication {
public static void main(String[] args) {
SpringApplication.run(SpringEApplication.class, args);
}
}
事务发起方Client
工程截图
项目配置文件 application.properties
spring.application.name=spring-demo-client
server.port=12011
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
## TODO 你的配置
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/txlcn-demo?characterEncoding=UTF-8&serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.hikari.maximum-pool-size=20
mybatis.configuration.map-underscore-to-camel-case=true
mybatis.configuration.use-generated-keys=true
# 关闭Ribbon的重试机制(如果有必要)
ribbon.MaxAutoRetriesNextServer=0
ribbon.ReadTimeout=5000
ribbon.ConnectTimeout=5000
## tx-manager 配置
#tx-lcn.client.manager-address=127.0.0.1:8070
Application
@SpringBootApplication
@EnableDiscoveryClient
@EnableDistributedTransaction
public class SpringClientApplication {
public static void main(String[] args) {
SpringApplication.run(SpringClientApplication.class, args);
}
}
启动SpringCloud微服务
事务参与方 D
事务参与方 E
事务发起方 Client