【分布式】【事务】seata的使用说明

一时失言乱红尘 2022-11-26 01:50 261阅读 0赞

**分布式事务基本概念：**   [https://blog.csdn.net/Timeguys/article/details/107646845][https_blog.csdn.net_Timeguys_article_details_107646845]

**seata组成：**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1RpbWVndXlz_size_16_color_FFFFFF_t_70][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1RpbWVndXlz_size_16_color_FFFFFF_t_70 1][]

**处理过程：**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1RpbWVndXlz_size_16_color_FFFFFF_t_70 2][]

**使用教程：**

> **一、下载：**
> 
> [http://seata.io/zh-cn/blog/download.html][http_seata.io_zh-cn_blog_download.html]
> 
> **二、file.conf和registry.conf：**
> 
> **file.conf**
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1RpbWVndXlz_size_16_color_FFFFFF_t_70 3][]
> 
>  如果变更mode为db时，建库建表。然后需要在数据库中创建一个seata库，之后创建一些seata-server运行时需要的一些表：
> 
>     CREATE TABLE `branch_table` (
>       `branch_id` bigint(20) NOT NULL,
>       `xid` varchar(128) NOT NULL,
>       `transaction_id` bigint(20) DEFAULT NULL,
>       `resource_group_id` varchar(128) DEFAULT NULL,
>       `resource_id` varchar(256) DEFAULT NULL,
>       `lock_key` varchar(256) DEFAULT NULL,
>       `branch_type` varchar(8) DEFAULT NULL,
>       `status` tinyint(4) DEFAULT NULL,
>       `client_id` varchar(64) DEFAULT NULL,
>       `application_data` varchar(2000) DEFAULT NULL,
>       `gmt_create` datetime DEFAULT NULL,
>       `gmt_modified` datetime DEFAULT NULL,
>       PRIMARY KEY (`branch_id`),
>       KEY `idx_xid` (`xid`)
>     ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
>     
>     CREATE TABLE `global_table` (
>       `xid` varchar(128) NOT NULL,
>       `transaction_id` bigint(20) DEFAULT NULL,
>       `status` tinyint(4) NOT NULL,
>       `application_id` varchar(64) DEFAULT NULL,
>       `transaction_service_group` varchar(64) DEFAULT NULL,
>       `transaction_name` varchar(128) DEFAULT NULL,
>       `timeout` int(11) DEFAULT NULL,
>       `begin_time` bigint(20) DEFAULT NULL,
>       `application_data` varchar(2000) DEFAULT NULL,
>       `gmt_create` datetime DEFAULT NULL,
>       `gmt_modified` datetime DEFAULT NULL,
>       PRIMARY KEY (`xid`),
>       KEY `idx_gmt_modified_status` (`gmt_modified`,`status`),
>       KEY `idx_transaction_id` (`transaction_id`)
>     ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
>     
>     
>     CREATE TABLE `lock_table` (
>       `row_key` varchar(128) NOT NULL,
>       `xid` varchar(128) DEFAULT NULL,
>       `transaction_id` mediumtext,
>       `branch_id` mediumtext,
>       `resource_id` varchar(256) DEFAULT NULL,
>       `table_name` varchar(32) DEFAULT NULL,
>       `pk` varchar(128) DEFAULT NULL,
>       `gmt_create` datetime DEFAULT NULL,
>       `gmt_modified` datetime DEFAULT NULL,
>       PRIMARY KEY (`row_key`)
>     ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
> 
>  
> 
>  **registry.conf：**
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1RpbWVndXlz_size_16_color_FFFFFF_t_70 4][]
> 
>  
> 
> **三、将file.conf和registry.conf复制到项目中，并配置application.yml，加入依赖：**
> 
> ![2020081115224194.png][]
> 
>  
> 
>     <dependency>
>         <groupId>com.alibaba.cloud</groupId>
>         <artifactId>spring-cloud-alibaba-seata</artifactId>
>         <version>2.1.0.RELEASE</version>
>     </dependency>
> 
>  四**、设置seata对数据源代理，并且在每个服务对应的库下创建一个undo\_log表。用于记录分支事务数据：：**
> 
>     /**
>      * 使用Seata对数据源进行代理
>      * Created by macro on 2019/11/11.
>      */
>     @Configuration
>     public class DataSourceConfiguration {
>     
>         @Bean
>         @ConfigurationProperties(prefix = "spring.datasource")
>         public DataSource dataSource() {
>             DruidDataSource druidDataSource = new DruidDataSource();
>             return druidDataSource;
>         }
>         @Primary
>         @Bean("dataSourceProxy")
>         public DataSourceProxy dataSourceProxy(DataSource dataSource) {
>             return new DataSourceProxy(dataSource);
>         }
>     }
> 
> undo\_log 创建语句：
> 
>     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 DEFAULT CHARSET=utf8;
> 
> 如图：
> 
> ![20200811153125322.png][]
> 
>  
> 
> **五、启动seata服务，并且全局事务使用，使用** **@GlobalTransactional：**
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1RpbWVndXlz_size_16_color_FFFFFF_t_70 5][]
> 
>  
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1RpbWVndXlz_size_16_color_FFFFFF_t_70 6][]

**报错信息：**

> **一、Caused by: io.seata.common.exception.NotSupportYetException: not support register type: null：**
> 
> **说明没有将file.conf和registry.conf 复制到项目中，**
> 
> ![2020081115360819.png][]**  ————————>    **![20200811153620685.png][]

**.**

相关博客：  [https://www.jianshu.com/p/394af797e0cf][https_www.jianshu.com_p_394af797e0cf]       [https://blog.csdn.net/hosaos/article/details/89136666][https_blog.csdn.net_hosaos_article_details_89136666]

[https_blog.csdn.net_Timeguys_article_details_107646845]: https://blog.csdn.net/Timeguys/article/details/107646845
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1RpbWVndXlz_size_16_color_FFFFFF_t_70]: /images/20221124/da515ff902f24512b90e1e97cef22ed7.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1RpbWVndXlz_size_16_color_FFFFFF_t_70 1]: /images/20221124/f523586c9611400db8f55751804d5d01.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1RpbWVndXlz_size_16_color_FFFFFF_t_70 2]: /images/20221124/11abd5b0e5fd450c92ed1cee7dec6e31.png
[http_seata.io_zh-cn_blog_download.html]: http://seata.io/zh-cn/blog/download.html
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1RpbWVndXlz_size_16_color_FFFFFF_t_70 3]: /images/20221124/7a2ed9ab5e774368af05be5ea2067fbb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1RpbWVndXlz_size_16_color_FFFFFF_t_70 4]: /images/20221124/25c4b6a6591944a682d561fa9cb3de8d.png
[2020081115224194.png]: /images/20221124/4fb865000477429693dd6caacb2e4e01.png
[20200811153125322.png]: /images/20221124/10dd33d4959947f58036f0fa01180cbd.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1RpbWVndXlz_size_16_color_FFFFFF_t_70 5]: /images/20221124/8a1a249e25854fe6af4f31e342f2aca7.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1RpbWVndXlz_size_16_color_FFFFFF_t_70 6]: /images/20221124/7ade4542eccd4c7fa391f61836a5f110.png
[2020081115360819.png]: https://img-blog.csdnimg.cn/2020081115360819.png
[20200811153620685.png]: /images/20221124/2846ed976f2244ca8879378117d56750.png
[https_www.jianshu.com_p_394af797e0cf]: https://www.jianshu.com/p/394af797e0cf
[https_blog.csdn.net_hosaos_article_details_89136666]: https://blog.csdn.net/hosaos/article/details/89136666