{"id":533,"date":"2022-05-01T20:36:11","date_gmt":"2022-05-01T12:36:11","guid":{"rendered":"https:\/\/blog.lijiajia.top\/?p=533"},"modified":"2026-06-19T18:15:26","modified_gmt":"2026-06-19T10:15:26","slug":"springcloud%e7%ac%ac%e4%ba%8c%e5%ad%a3%e5%ad%a6%e4%b9%a0%e7%ac%94%e8%ae%b0%ef%bc%9aspringcloud-alibabaseata%e5%a4%84%e7%90%86%e5%88%86%e5%b8%83%e5%bc%8f%e4%ba%8b%e5%8a%a1%e4%ba%8c%e5%8d%81","status":"publish","type":"post","link":"https:\/\/blog.ttwow.top\/?p=533","title":{"rendered":"SpringCloud\u7b2c\u4e8c\u5b63\u5b66\u4e60\u7b14\u8bb0\uff1aSpringCloud AlibabaSeata\u5904\u7406\u5206\u5e03\u5f0f\u4e8b\u52a1(\u4e8c\u5341)"},"content":{"rendered":"<h2>\u5206\u5e03\u5f0f\u4e8b\u52a1\u95ee\u9898<\/h2>\n<h3>\u5206\u5e03\u5f0f\u524d<\/h3>\n<p>\u5355\u673a\u5355\u5e93\u6ca1\u8fd9\u4e2a\u95ee\u9898<\/p>\n<\/p>\n<p>\u4ece1\uff1a1  -&gt;  1\uff1aN  -&gt;  N\uff1aN<\/p>\n<h3>\u5206\u5e03\u5f0f\u4e4b\u540e<\/h3>\n<p>\u5355\u4f53\u5e94\u7528\u88ab\u62c6\u5206\u6210\u5fae\u670d\u52a1\u5e94\u7528\uff0c\u539f\u6765\u7684\u4e09\u4e2a\u6a21\u5757\u88ab\u62c6\u5206\u6210\u4e09\u4e2a\u72ec\u7acb\u7684\u5e94\u7528\uff0c\u5206\u522b\u4f7f\u7528\u4e09\u4e2a\u72ec\u7acb\u7684\u6570\u636e\u6e90\uff0c<br \/>\n\u4e1a\u52a1\u64cd\u4f5c\u9700\u8981\u8c03\u7528\u4e09\u4e2a\u670d\u52a1\u6765\u5b8c\u6210\u3002\u6b64\u65f6\u6bcf\u4e2a\u670d\u52a1\u5185\u90e8\u7684\u6570\u636e\u4e00\u81f4\u6027\u7531\u672c\u5730\u4e8b\u52a1\u6765\u4fdd\u8bc1\uff0c\u4f46\u662f\u5168\u5c40\u7684\u6570\u636e\u4e00\u81f4\u6027\u95ee\u9898\u6ca1\u6cd5\u4fdd\u8bc1\u3002<\/p>\n<p><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='https:\/\/bucket-blog-img.oss-cn-shanghai.aliyuncs.com\/wp-content\/uploads\/2022\/05\/image-1651408632543.png'><img class=\"lazyload lazyload-style-11\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  decoding=\"async\" data-original=\"https:\/\/bucket-blog-img.oss-cn-shanghai.aliyuncs.com\/wp-content\/uploads\/2022\/05\/image-1651408632543.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"file\" \/><\/div><\/p>\n<h3>\u4e00\u53e5\u8bdd<\/h3>\n<p><strong>\u4e00\u6b21\u4e1a\u52a1\u64cd\u4f5c\u9700\u8981\u8de8\u591a\u4e2a\u6570\u636e\u6e90\u6216\u9700\u8981\u8de8\u591a\u4e2a\u7cfb\u7edf\u8fdb\u884c\u8fdc\u7a0b\u8c03\u7528\uff0c\u5c31\u4f1a\u4ea7\u751f\u5206\u5e03\u5f0f\u4e8b\u52a1\u95ee\u9898<\/strong><\/p>\n<h2>Seata\u7b80\u4ecb<\/h2>\n<h3>\u662f\u4ec0\u4e48<\/h3>\n<p>Seata\u662f\u4e00\u6b3e\u5f00\u6e90\u7684\u5206\u5e03\u5f0f\u4e8b\u52a1\u89e3\u51b3\u65b9\u6848\uff0c\u81f4\u529b\u4e8e\u5728\u5fae\u670d\u52a1\u67b6\u6784\u4e0b\u63d0\u4f9b\u9ad8\u6027\u80fd\u548c\u7b80\u5355\u6613\u7528\u7684\u5206\u5e03\u5f0f\u4e8b\u52a1\u670d\u52a1\u3002<\/p>\n<p>\u5b98\u7f51\u5730\u5740<\/p>\n<p><a href=\"http:\/\/seata.io\/zh-cn\/\">http:\/\/seata.io\/zh-cn\/<\/a><\/p>\n<h3>\u80fd\u5e72\u561b<\/h3>\n<p>\u4e00\u4e2a\u5178\u578b\u7684\u5206\u5e03\u5f0f\u4e8b\u52a1\u8fc7\u7a0b<\/p>\n<p>\u5206\u5e03\u5f0f\u4e8b\u52a1\u5904\u7406\u8fc7\u7a0b\u7684\u4e00ID+\u4e09\u7ec4\u4ef6\u6a21\u578b<\/p>\n<p>Transaction ID XID\uff1a\u5168\u5c40\u552f\u4e00\u7684\u4e8b\u52a1ID<\/p>\n<p>3\u7ec4\u4ef6\u6982\u5ff5\uff1a<\/p>\n<p>Transaction Coordinator (TC) \u4e8b\u52a1\u534f\u8c03\u5668\uff0c\u7ef4\u62a4\u5168\u5c40\u4e8b\u52a1\u7684\u8fd0\u884c\u72b6\u6001\uff0c\u8d1f\u8d23\u534f\u8c03\u5e76\u9a71\u52a8\u5168\u5c40\u4e8b\u52a1\u7684\u63d0\u4ea4\u6216\u56de\u6eda\uff1b<\/p>\n<p>Transaction Manager (TM) \u63a7\u5236\u5168\u5c40\u4e8b\u52a1\u7684\u8fb9\u754c\uff0c\u8d1f\u8d23\u5f00\u542f\u4e00\u4e2a\u5168\u5c40\u4e8b\u52a1\uff0c\u5e76\u6700\u7ec8\u53d1\u8d77\u5168\u5c40\u63d0\u4ea4\u6216\u5168\u5c40\u56de\u6eda\u7684\u51b3\u8bae\uff1b<\/p>\n<p>Resource Manager (RM) \u63a7\u5236\u5206\u652f\u4e8b\u52a1\uff0c\u8d1f\u8d23\u5206\u652f\u6ce8\u518c\u3001\u72b6\u6001\u6c47\u62a5\uff0c\u5e76\u63a5\u6536\u4e8b\u52a1\u534f\u8c03\u5668\u7684\u6307\u4ee4\uff0c\u9a71\u52a8\u5206\u652f\uff08\u672c\u5730\uff09\u4e8b\u52a1\u7684\u63d0\u4ea4\u548c\u56de\u6eda<\/p>\n<h3>\u5904\u7406\u8fc7\u7a0b<\/h3>\n<p>TM \u5411 TC \u7533\u8bf7\u5f00\u542f\u4e00\u4e2a\u5168\u5c40\u4e8b\u52a1\uff0c\u5168\u5c40\u4e8b\u52a1\u521b\u5efa\u6210\u529f\u5e76\u751f\u6210\u4e00\u4e2a\u5168\u5c40\u552f\u4e00\u7684 XID\uff1b<br \/>\nXID \u5728\u5fae\u670d\u52a1\u8c03\u7528\u94fe\u8def\u7684\u4e0a\u4e0b\u6587\u4e2d\u4f20\u64ad\uff1b<br \/>\nRM \u5411 TC \u6ce8\u518c\u5206\u652f\u4e8b\u52a1\uff0c\u5c06\u5176\u7eb3\u5165 XID \u5bf9\u5e94\u5168\u5c40\u4e8b\u52a1\u7684\u7ba1\u8f96\uff1b<br \/>\nTM \u5411 TC \u53d1\u8d77\u9488\u5bf9 XID \u7684\u5168\u5c40\u63d0\u4ea4\u6216\u56de\u6eda\u51b3\u8bae\uff1b<br \/>\nTC \u8c03\u5ea6 XID \u4e0b\u7ba1\u8f96\u7684\u5168\u90e8\u5206\u652f\u4e8b\u52a1\u5b8c\u6210\u63d0\u4ea4\u6216\u56de\u6eda\u8bf7\u6c42\u3002<\/p>\n<p><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='https:\/\/bucket-blog-img.oss-cn-shanghai.aliyuncs.com\/wp-content\/uploads\/2022\/05\/image-1651408645033.png'><img class=\"lazyload lazyload-style-11\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  decoding=\"async\" data-original=\"https:\/\/bucket-blog-img.oss-cn-shanghai.aliyuncs.com\/wp-content\/uploads\/2022\/05\/image-1651408645033.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"file\" \/><\/div><\/p>\n<h3>\u53bb\u54ea\u4e0b<\/h3>\n<p>\u53d1\u5e03\u8bf4\u660e: <a href=\"https:\/\/github.com\/seata\/seata\/releases\">https:\/\/github.com\/seata\/seata\/releases<\/a><\/p>\n<h3>\u600e\u4e48\u73a9<\/h3>\n<p>\u672c\u5730@Transactional<\/p>\n<p>\u5168\u5c40@GlobalTransactional<\/p>\n<p>SEATA \u7684\u5206\u5e03\u5f0f\u4ea4\u6613\u89e3\u51b3\u65b9\u6848<\/p>\n<p><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='https:\/\/bucket-blog-img.oss-cn-shanghai.aliyuncs.com\/wp-content\/uploads\/2022\/05\/image-1651408654488.png'><img class=\"lazyload lazyload-style-11\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  decoding=\"async\" data-original=\"https:\/\/bucket-blog-img.oss-cn-shanghai.aliyuncs.com\/wp-content\/uploads\/2022\/05\/image-1651408654488.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"file\" \/><\/div><\/p>\n<h2>\u8ba2\u5355\/\u5e93\u5b58\/\u8d26\u6237\u4e1a\u52a1\u6570\u636e\u5e93\u51c6\u5907<\/h2>\n<p>\u4ee5\u4e0b\u6f14\u793a\u90fd\u9700\u8981\u5148\u542f\u52a8Nacos\u540e\u542f\u52a8Seata\uff0c\u4fdd\u8bc1\u4e24\u4e2a\u90fdOK<\/p>\n<h3>\u5206\u5e03\u5f0f\u4e8b\u52a1\u4e1a\u52a1\u8bf4\u660e<\/h3>\n<p>\u4e1a\u52a1\u8bf4\u660e\uff1a<\/p>\n<p>\u8fd9\u91cc\u6211\u4eec\u4f1a\u521b\u5efa\u4e09\u4e2a\u670d\u52a1\uff0c\u4e00\u4e2a\u8ba2\u5355\u670d\u52a1\uff0c\u4e00\u4e2a\u5e93\u5b58\u670d\u52a1\uff0c\u4e00\u4e2a\u8d26\u6237\u670d\u52a1\u3002<\/p>\n<p>\u5f53\u7528\u6237\u4e0b\u5355\u65f6\uff0c\u4f1a\u5728\u8ba2\u5355\u670d\u52a1\u4e2d\u521b\u5efa\u4e00\u4e2a\u8ba2\u5355\uff0c\u7136\u540e\u901a\u8fc7\u8fdc\u7a0b\u8c03\u7528\u5e93\u5b58\u670d\u52a1\u6765\u6263\u51cf\u4e0b\u5355\u5546\u54c1\u7684\u5e93\u5b58\uff0c<br \/>\n\u518d\u901a\u8fc7\u8fdc\u7a0b\u8c03\u7528\u8d26\u6237\u670d\u52a1\u6765\u6263\u51cf\u7528\u6237\u8d26\u6237\u91cc\u9762\u7684\u4f59\u989d\uff0c<br \/>\n\u6700\u540e\u5728\u8ba2\u5355\u670d\u52a1\u4e2d\u4fee\u6539\u8ba2\u5355\u72b6\u6001\u4e3a\u5df2\u5b8c\u6210\u3002<\/p>\n<p>\u8be5\u64cd\u4f5c\u8de8\u8d8a\u4e09\u4e2a\u6570\u636e\u5e93\uff0c\u6709\u4e24\u6b21\u8fdc\u7a0b\u8c03\u7528\uff0c\u5f88\u660e\u663e\u4f1a\u6709\u5206\u5e03\u5f0f\u4e8b\u52a1\u95ee\u9898\u3002<\/p>\n<p>\u4e0b\u8ba2\u5355---&gt;\u6263\u5e93\u5b58---&gt;\u51cf\u8d26\u6237(\u4f59\u989d)<\/p>\n<h3>\u521b\u5efa\u4e1a\u52a1\u6570\u636e\u5e93<\/h3>\n<p>seata_order\uff1a\u5b58\u50a8\u8ba2\u5355\u7684\u6570\u636e\u5e93\uff1b<\/p>\n<p>seata_storage\uff1a\u5b58\u50a8\u5e93\u5b58\u7684\u6570\u636e\u5e93\uff1b<\/p>\n<p>seata_account\uff1a\u5b58\u50a8\u8d26\u6237\u4fe1\u606f\u7684\u6570\u636e\u5e93\u3002<\/p>\n<p>\u5efa\u5e93SQL<\/p>\n<pre><code class=\"language-sql\">CREATE DATABASE seata_order;\n\nCREATE DATABASE seata_storage;\n\nCREATE DATABASE seata_account;<\/code><\/pre>\n<h3>\u6309\u7167\u4e0a\u8ff03\u5e93\u5206\u522b\u5efa\u5bf9\u5e94\u4e1a\u52a1\u8868<\/h3>\n<p>seata_order\u5e93\u4e0b\u5efat_order\u8868<\/p>\n<pre><code class=\"language-sql\">CREATE TABLE t_order (\n    <code>id<\/code> BIGINT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,\n    <code>user_id<\/code> BIGINT(11) DEFAULT NULL COMMENT &#039;\u7528\u6237id&#039;,\n    <code>product_id<\/code> BIGINT(11) DEFAULT NULL COMMENT &#039;\u4ea7\u54c1id&#039;,\n    <code>count<\/code> INT(11) DEFAULT NULL COMMENT &#039;\u6570\u91cf&#039;,\n    <code>money<\/code> DECIMAL(11,0) DEFAULT NULL COMMENT &#039;\u91d1\u989d&#039;,\n    <code>status<\/code> INT(1) DEFAULT NULL COMMENT &#039;\u8ba2\u5355\u72b6\u6001\uff1a0\uff1a\u521b\u5efa\u4e2d\uff1b1\uff1a\u5df2\u5b8c\u7ed3&#039;\n) ENGINE=INNODB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;\n\nSELECT * FROM t_order;\n<\/code><\/pre>\n<p>seata_storage\u5e93\u4e0b\u5efat_storage <\/p>\n<pre><code class=\"language-sql\">CREATE TABLE t_storage (\n    <code>id<\/code> BIGINT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,\n    <code>product_id<\/code> BIGINT(11) DEFAULT NULL COMMENT &#039;\u4ea7\u54c1id&#039;,\n    <code>total<\/code> INT(11) DEFAULT NULL COMMENT &#039;\u603b\u5e93\u5b58&#039;,\n    <code>used<\/code> INT(11) DEFAULT NULL COMMENT &#039;\u5df2\u7528\u5e93\u5b58&#039;,\n    <code>residue<\/code> INT(11) DEFAULT NULL COMMENT &#039;\u5269\u4f59\u5e93\u5b58&#039;\n) ENGINE=INNODB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;\n\nINSERT INTO seata_storage.t_storage(<code>id<\/code>, <code>product_id<\/code>, <code>total<\/code>, <code>used<\/code>, <code>residue<\/code>)\nVALUES (&#039;1&#039;, &#039;1&#039;, &#039;100&#039;, &#039;0&#039;, &#039;100&#039;);\n\nSELECT * FROM t_storage;<\/code><\/pre>\n<p>seata_account\u5e93\u4e0b\u5efat_account <\/p>\n<pre><code class=\"language-json\">CREATE TABLE t_account (\n    <code>id<\/code> BIGINT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY COMMENT &#039;id&#039;,\n<code>user_id<\/code> BIGINT(11) DEFAULT NULL COMMENT &#039;\u7528\u6237id&#039;,\n<code>total<\/code> DECIMAL(10,0) DEFAULT NULL COMMENT &#039;\u603b\u989d\u5ea6&#039;,\n<code>used<\/code> DECIMAL(10,0) DEFAULT NULL COMMENT &#039;\u5df2\u7528\u4f59\u989d&#039;,\n<code>residue<\/code> DECIMAL(10,0) DEFAULT &#039;0&#039; COMMENT &#039;\u5269\u4f59\u53ef\u7528\u989d\u5ea6&#039;\n) ENGINE=INNODB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;\n\nINSERT INTO seata_account.t_account(<code>id<\/code>, <code>user_id<\/code>, <code>total<\/code>, <code>used<\/code>, <code>residue<\/code>)  VALUES (&#039;1&#039;, &#039;1&#039;, &#039;1000&#039;, &#039;0&#039;, &#039;1000&#039;);\n\nSELECT * FROM t_account;<\/code><\/pre>\n<p>\u6309\u7167\u4e0a\u8ff03\u5e93\u5206\u522b\u5efa\u5bf9\u5e94\u7684\u56de\u6eda\u65e5\u5fd7\u8868<\/p>\n<p>\u8ba2\u5355-\u5e93\u5b58-\u8d26\u62373\u4e2a\u5e93\u4e0b\u90fd\u9700\u8981\u5efa\u5404\u81ea\u7684\u56de\u6eda\u65e5\u5fd7\u8868<\/p>\n<p>\\seata-server-0.9.0\\seata\\conf\u76ee\u5f55\u4e0b\u7684db_undo_log.sql<\/p>\n<pre><code class=\"language-sql\">-- the table to store seata xid data\n-- 0.7.0+ add context\n-- you must to init this sql for you business databese. the seata server not need it.\n-- \u6b64\u811a\u672c\u5fc5\u987b\u521d\u59cb\u5316\u5728\u4f60\u5f53\u524d\u7684\u4e1a\u52a1\u6570\u636e\u5e93\u4e2d\uff0c\u7528\u4e8eAT \u6a21\u5f0fXID\u8bb0\u5f55\u3002\u4e0eserver\u7aef\u65e0\u5173\uff08\u6ce8\uff1a\u4e1a\u52a1\u6570\u636e\u5e93\uff09\n-- \u6ce8\u610f\u6b64\u59040.3.0+ \u589e\u52a0\u552f\u4e00\u7d22\u5f15 ux_undo_log\nDROP TABLE <code>undo_log<\/code>;\n\nCREATE TABLE <code>undo_log<\/code> (\n  <code>id<\/code> BIGINT(20) NOT NULL AUTO_INCREMENT,\n  <code>branch_id<\/code> BIGINT(20) NOT NULL,\n  <code>xid<\/code> VARCHAR(100) NOT NULL,\n  <code>context<\/code> VARCHAR(128) NOT NULL,\n  <code>rollback_info<\/code> LONGBLOB NOT NULL,\n  <code>log_status<\/code> INT(11) NOT NULL,\n  <code>log_created<\/code> DATETIME NOT NULL,\n  <code>log_modified<\/code> DATETIME NOT NULL,\n  <code>ext<\/code> VARCHAR(100) DEFAULT NULL,\n  PRIMARY KEY (<code>id<\/code>),\n  UNIQUE KEY <code>ux_undo_log<\/code> (<code>xid<\/code>,<code>branch_id<\/code>)\n) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;<\/code><\/pre>\n<h3>\u6700\u7ec8\u6548\u679c<\/h3>\n<p><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='https:\/\/bucket-blog-img.oss-cn-shanghai.aliyuncs.com\/wp-content\/uploads\/2022\/05\/image-1651408670886.png'><img class=\"lazyload lazyload-style-11\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  decoding=\"async\" data-original=\"https:\/\/bucket-blog-img.oss-cn-shanghai.aliyuncs.com\/wp-content\/uploads\/2022\/05\/image-1651408670886.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"file\" \/><\/div><\/p>\n<h2>\u8ba2\u5355\/\u5e93\u5b58\/\u8d26\u6237\u4e1a\u52a1\u5fae\u670d\u52a1\u51c6\u5907<\/h2>\n<h3>\u4e1a\u52a1\u9700\u6c42<\/h3>\n<p>\u4e0b\u8ba2\u5355-&gt;\u51cf\u5e93\u5b58-&gt;\u6263\u4f59\u989d-&gt;\u6539(\u8ba2\u5355)\u72b6\u6001<\/p>\n<h4>\u65b0\u5efa\u8ba2\u5355Order-Module<\/h4>\n<p>POM<\/p>\n<pre><code class=\"language-xml\">&lt;dependencies&gt;\n    &lt;!--nacos--&gt;\n    &lt;dependency&gt;\n        &lt;groupId&gt;com.alibaba.cloud&lt;\/groupId&gt;\n        &lt;artifactId&gt;spring-cloud-starter-alibaba-nacos-discovery&lt;\/artifactId&gt;\n    &lt;\/dependency&gt;\n    &lt;!--seata--&gt;\n    &lt;dependency&gt;\n        &lt;groupId&gt;com.alibaba.cloud&lt;\/groupId&gt;\n        &lt;artifactId&gt;spring-cloud-starter-alibaba-seata&lt;\/artifactId&gt;\n        &lt;exclusions&gt;\n            &lt;exclusion&gt;\n                &lt;artifactId&gt;seata-all&lt;\/artifactId&gt;\n                &lt;groupId&gt;io.seata&lt;\/groupId&gt;\n            &lt;\/exclusion&gt;\n        &lt;\/exclusions&gt;\n    &lt;\/dependency&gt;\n    &lt;dependency&gt;\n        &lt;groupId&gt;io.seata&lt;\/groupId&gt;\n        &lt;artifactId&gt;seata-all&lt;\/artifactId&gt;\n        &lt;version&gt;0.9.0&lt;\/version&gt;\n    &lt;\/dependency&gt;\n    &lt;!--feign--&gt;\n    &lt;dependency&gt;\n        &lt;groupId&gt;org.springframework.cloud&lt;\/groupId&gt;\n        &lt;artifactId&gt;spring-cloud-starter-openfeign&lt;\/artifactId&gt;\n    &lt;\/dependency&gt;\n    &lt;!--web-actuator--&gt;\n    &lt;dependency&gt;\n        &lt;groupId&gt;org.springframework.boot&lt;\/groupId&gt;\n        &lt;artifactId&gt;spring-boot-starter-web&lt;\/artifactId&gt;\n    &lt;\/dependency&gt;\n    &lt;dependency&gt;\n        &lt;groupId&gt;org.springframework.boot&lt;\/groupId&gt;\n        &lt;artifactId&gt;spring-boot-starter-actuator&lt;\/artifactId&gt;\n    &lt;\/dependency&gt;\n    &lt;!--mysql-druid--&gt;\n    &lt;dependency&gt;\n        &lt;groupId&gt;mysql&lt;\/groupId&gt;\n        &lt;artifactId&gt;mysql-connector-java&lt;\/artifactId&gt;\n        &lt;version&gt;5.1.37&lt;\/version&gt;\n    &lt;\/dependency&gt;\n    &lt;dependency&gt;\n        &lt;groupId&gt;com.alibaba&lt;\/groupId&gt;\n        &lt;artifactId&gt;druid-spring-boot-starter&lt;\/artifactId&gt;\n        &lt;version&gt;1.1.10&lt;\/version&gt;\n    &lt;\/dependency&gt;\n    &lt;dependency&gt;\n        &lt;groupId&gt;org.mybatis.spring.boot&lt;\/groupId&gt;\n        &lt;artifactId&gt;mybatis-spring-boot-starter&lt;\/artifactId&gt;\n        &lt;version&gt;2.0.0&lt;\/version&gt;\n    &lt;\/dependency&gt;\n    &lt;dependency&gt;\n        &lt;groupId&gt;org.springframework.boot&lt;\/groupId&gt;\n        &lt;artifactId&gt;spring-boot-starter-test&lt;\/artifactId&gt;\n        &lt;scope&gt;test&lt;\/scope&gt;\n    &lt;\/dependency&gt;\n    &lt;dependency&gt;\n        &lt;groupId&gt;org.projectlombok&lt;\/groupId&gt;\n        &lt;artifactId&gt;lombok&lt;\/artifactId&gt;\n        &lt;optional&gt;true&lt;\/optional&gt;\n    &lt;\/dependency&gt;\n&lt;\/dependencies&gt;<\/code><\/pre>\n<p>YML<\/p>\n<pre><code class=\"language-yaml\">server:\n  port: 2001\n\nspring:\n  application:\n    name: seata-order-service\n  cloud:\n    alibaba:\n      seata:\n        #\u81ea\u5b9a\u4e49\u4e8b\u52a1\u7ec4\u540d\u79f0\u9700\u8981\u4e0eseata-server\u4e2d\u7684\u5bf9\u5e94\n        tx-service-group: fsp_tx_group\n    nacos:\n      discovery:\n        server-addr: localhost:8848\n  datasource:\n    driver-class-name: com.mysql.jdbc.Driver\n    url: jdbc:mysql:\/\/localhost:3306\/seata_order\n    username: root\n    password: \u5bc6\u7801\n\nfeign:\n  hystrix:\n    enabled: false\n\nlogging:\n  level:\n    io:\n      seata: info\n\nmybatis:\n  mapperLocations: classpath:mapper\/*.xml<\/code><\/pre>\n<p>file.conf<\/p>\n<p>\u4f7f\u7528\u672c\u5730\u7684XXX\\seata\\seata-server-0.9.0\\conf\u76ee\u5f55\u4e0b\u9762\u7684<\/p>\n<p>registry.conf<\/p>\n<p>\u4f7f\u7528\u672c\u5730\u7684XXX\\seata\\seata-server-0.9.0\\conf\u76ee\u5f55\u4e0b\u9762\u7684<\/p>\n<p>domain<\/p>\n<p>CommonResult<\/p>\n<pre><code class=\"language-java\">@Data\n@AllArgsConstructor\n@NoArgsConstructor\npublic class CommonResult&lt;T&gt;\n{\n    private Integer code;\n    private String  message;\n    private T       data;\n\n    public CommonResult(Integer code, String message)\n    {\n        this(code,message,null);\n    }\n}<\/code><\/pre>\n<p>Order<\/p>\n<pre><code class=\"language-java\">@Data\n@AllArgsConstructor\n@NoArgsConstructor\npublic class Order\n{\n    private Long id;\n\n    private Long userId;\n\n    private Long productId;\n\n    private Integer count;\n\n    private BigDecimal money;\n\n    \/**\n     * \u8ba2\u5355\u72b6\u6001\uff1a0\uff1a\u521b\u5efa\u4e2d\uff1b1\uff1a\u5df2\u5b8c\u7ed3\n     *\/\n    private Integer status;\n}<\/code><\/pre>\n<p>Dao\u63a5\u53e3\u53ca\u5b9e\u73b0<\/p>\n<p>OrderDao<\/p>\n<pre><code class=\"language-java\">@Mapper\npublic interface OrderDao {\n\n    \/**\n     * \u521b\u5efa\u8ba2\u5355\n     *\/\n    void create(Order order);\n\n    \/**\n     * \u4fee\u6539\u8ba2\u5355\u91d1\u989d\n     *\/\n    void update(@Param(&quot;userId&quot;) Long userId, @Param(&quot;status&quot;) Integer status);\n}<\/code><\/pre>\n<p>resources\u6587\u4ef6\u5939\u4e0b\u65b0\u5efamapper\u6587\u4ef6\u5939\u540e\u6dfb\u52a0<\/p>\n<p>OrderMapper.xml<\/p>\n<pre><code class=\"language-xml\">&lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot; ?&gt;\n&lt;!DOCTYPE mapper PUBLIC &quot;-\/\/mybatis.org\/\/DTD Mapper 3.0\/\/EN&quot; &quot;http:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd&quot; &gt;\n\n&lt;mapper namespace=&quot;com.springcloud.dao.OrderDao&quot;&gt;\n\n    &lt;resultMap id=&quot;BaseResultMap&quot; type=&quot;com.springcloud.domain.Order&quot;&gt;\n        &lt;id column=&quot;id&quot; property=&quot;id&quot; jdbcType=&quot;BIGINT&quot;\/&gt;\n        &lt;result column=&quot;user_id&quot; property=&quot;userId&quot; jdbcType=&quot;BIGINT&quot;\/&gt;\n        &lt;result column=&quot;product_id&quot; property=&quot;productId&quot; jdbcType=&quot;BIGINT&quot;\/&gt;\n        &lt;result column=&quot;count&quot; property=&quot;count&quot; jdbcType=&quot;INTEGER&quot;\/&gt;\n        &lt;result column=&quot;money&quot; property=&quot;money&quot; jdbcType=&quot;DECIMAL&quot;\/&gt;\n        &lt;result column=&quot;status&quot; property=&quot;status&quot; jdbcType=&quot;INTEGER&quot;\/&gt;\n    &lt;\/resultMap&gt;\n\n    &lt;insert id=&quot;create&quot;&gt;\n        INSERT INTO <code>t_order<\/code> (<code>id<\/code>, <code>user_id<\/code>, <code>product_id<\/code>, <code>count<\/code>, <code>money<\/code>, <code>status<\/code>)\n        VALUES (NULL, #{userId}, #{productId}, #{count}, #{money}, 0);\n    &lt;\/insert&gt;\n\n    &lt;update id=&quot;update&quot;&gt;\n        UPDATE <code>t_order<\/code>\n        SET status = 1\n        WHERE user_id = #{userId} AND status = #{status};\n    &lt;\/update&gt;\n&lt;\/mapper&gt;<\/code><\/pre>\n<p>XXXmapper.xml\u6587\u4ef6\u9996\u884c\u4e0d\u80fd\u6709\u7a7a\u683c<\/p>\n<p>Service\u63a5\u53e3\u53ca\u5b9e\u73b0<\/p>\n<p>OrderService<\/p>\n<pre><code class=\"language-java\">public interface OrderService {\n\n    \/**\n     * \u521b\u5efa\u8ba2\u5355\n     *\/\n    void create(Order order);\n}<\/code><\/pre>\n<p>OrderServiceImpl<\/p>\n<pre><code class=\"language-java\">@Service\n@Slf4j\npublic class OrderServiceImpl implements OrderService\n{\n    @Resource\n    private OrderDao orderDao;\n\n    @Resource\n    private StorageService storageService;\n\n    @Resource\n    private AccountService accountService;\n\n    \/**\n     * \u521b\u5efa\u8ba2\u5355-&gt;\u8c03\u7528\u5e93\u5b58\u670d\u52a1\u6263\u51cf\u5e93\u5b58-&gt;\u8c03\u7528\u8d26\u6237\u670d\u52a1\u6263\u51cf\u8d26\u6237\u4f59\u989d-&gt;\u4fee\u6539\u8ba2\u5355\u72b6\u6001\n     * \u7b80\u5355\u8bf4\uff1a\n     * \u4e0b\u8ba2\u5355-&gt;\u51cf\u5e93\u5b58-&gt;\u51cf\u4f59\u989d-&gt;\u6539\u72b6\u6001\n     *\/\n    @Override\n\/\/    @GlobalTransactional(name = &quot;fsp-create-order&quot;,rollbackFor = Exception.class)\n    public void create(Order order) {\n        log.info(&quot;-------&gt;\u4e0b\u5355\u5f00\u59cb&quot;);\n        \/\/\u672c\u5e94\u7528\u521b\u5efa\u8ba2\u5355\n        orderDao.create(order);\n\n        \/\/\u8fdc\u7a0b\u8c03\u7528\u5e93\u5b58\u670d\u52a1\u6263\u51cf\u5e93\u5b58\n        log.info(&quot;-------&gt;order-service\u4e2d\u6263\u51cf\u5e93\u5b58\u5f00\u59cb&quot;);\n        storageService.decrease(order.getProductId(),order.getCount());\n        log.info(&quot;-------&gt;order-service\u4e2d\u6263\u51cf\u5e93\u5b58\u7ed3\u675f&quot;);\n\n        \/\/\u8fdc\u7a0b\u8c03\u7528\u8d26\u6237\u670d\u52a1\u6263\u51cf\u4f59\u989d\n        log.info(&quot;-------&gt;order-service\u4e2d\u6263\u51cf\u4f59\u989d\u5f00\u59cb&quot;);\n        accountService.decrease(order.getUserId(),order.getMoney());\n        log.info(&quot;-------&gt;order-service\u4e2d\u6263\u51cf\u4f59\u989d\u7ed3\u675f&quot;);\n\n        \/\/\u4fee\u6539\u8ba2\u5355\u72b6\u6001\u4e3a\u5df2\u5b8c\u6210\n        log.info(&quot;-------&gt;order-service\u4e2d\u4fee\u6539\u8ba2\u5355\u72b6\u6001\u5f00\u59cb&quot;);\n        orderDao.update(order.getUserId(),0);\n        log.info(&quot;-------&gt;order-service\u4e2d\u4fee\u6539\u8ba2\u5355\u72b6\u6001\u7ed3\u675f&quot;);\n\n        log.info(&quot;-------&gt;\u4e0b\u5355\u7ed3\u675f&quot;);\n    }\n}<\/code><\/pre>\n<p>StorageService<\/p>\n<pre><code class=\"language-java\">@FeignClient(value = &quot;seata-storage-service&quot;)\npublic interface StorageService {\n\n    \/**\n     * \u6263\u51cf\u5e93\u5b58\n     *\/\n    @PostMapping(value = &quot;\/storage\/decrease&quot;)\n    CommonResult decrease(@RequestParam(&quot;productId&quot;) Long productId, @RequestParam(&quot;count&quot;) Integer count);\n}<\/code><\/pre>\n<p>AccountService<\/p>\n<pre><code class=\"language-java\">@FeignClient(value = &quot;seata-account-service&quot;)\npublic interface AccountService {\n\n    \/**\n     * \u6263\u51cf\u8d26\u6237\u4f59\u989d\n     *\/\n    \/\/@RequestMapping(value = &quot;\/account\/decrease&quot;, method = RequestMethod.POST, produces = &quot;application\/json; charset=UTF-8&quot;)\n    @PostMapping(&quot;\/account\/decrease&quot;)\n    CommonResult decrease(@RequestParam(&quot;userId&quot;) Long userId, @RequestParam(&quot;money&quot;) BigDecimal money);\n}<\/code><\/pre>\n<p>Controller<\/p>\n<pre><code class=\"language-java\">@RestController\npublic class OrderController {\n\n    @Autowired\n    private OrderService orderService;\n\n    \/**\n     * \u521b\u5efa\u8ba2\u5355\n     *\/\n    @GetMapping(&quot;\/order\/create&quot;)\n    public CommonResult create(Order order) {\n        orderService.create(order);\n        return new CommonResult(200, &quot;\u8ba2\u5355\u521b\u5efa\u6210\u529f!&quot;);\n    }\n}<\/code><\/pre>\n<p>Config\u914d\u7f6e<\/p>\n<p>MyBatisConfig<\/p>\n<pre><code class=\"language-java\">@Configuration\n@MapperScan({&quot;com.springcloud.dao&quot;})\npublic class MyBatisConfig {\n}<\/code><\/pre>\n<p>DataSourceProxyConfig<\/p>\n<pre><code class=\"language-java\">import com.alibaba.druid.pool.DruidDataSource;\nimport io.seata.rm.datasource.DataSourceProxy;\nimport org.apache.ibatis.session.SqlSessionFactory;\nimport org.mybatis.spring.SqlSessionFactoryBean;\nimport org.mybatis.spring.transaction.SpringManagedTransactionFactory;\nimport org.springframework.beans.factory.annotation.Value;\nimport org.springframework.boot.context.properties.ConfigurationProperties;\nimport org.springframework.context.annotation.Bean;\nimport org.springframework.context.annotation.Configuration;\nimport org.springframework.core.io.support.PathMatchingResourcePatternResolver;\nimport javax.sql.DataSource;\n\n@Configuration\npublic class DataSourceProxyConfig {\n\n    @Value(&quot;${mybatis.mapperLocations}&quot;)\n    private String mapperLocations;\n\n    @Bean\n    @ConfigurationProperties(prefix = &quot;spring.datasource&quot;)\n    public DataSource druidDataSource(){\n        return new DruidDataSource();\n    }\n\n    @Bean\n    public DataSourceProxy dataSourceProxy(DataSource dataSource) {\n        return new DataSourceProxy(dataSource);\n    }\n\n    @Bean\n    public SqlSessionFactory sqlSessionFactoryBean(DataSourceProxy dataSourceProxy) throws Exception {\n        SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();\n        sqlSessionFactoryBean.setDataSource(dataSourceProxy);\n        sqlSessionFactoryBean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources(mapperLocations));\n        sqlSessionFactoryBean.setTransactionFactory(new SpringManagedTransactionFactory());\n        return sqlSessionFactoryBean.getObject();\n    }\n\n}<\/code><\/pre>\n<p>\u4e3b\u542f\u52a8<\/p>\n<pre><code class=\"language-java\">@EnableDiscoveryClient\n@EnableFeignClients\n@SpringBootApplication(exclude = DataSourceAutoConfiguration.class)\/\/\u53d6\u6d88\u6570\u636e\u6e90\u7684\u81ea\u52a8\u521b\u5efa\npublic class SeataOrderMainApp2001\n{\n\n    public static void main(String[] args)\n    {\n        SpringApplication.run(SeataOrderMainApp2001.class, args);\n    }\n}<\/code><\/pre>\n<p>\u65b0\u5efa\u5e93\u5b58Storage-Module<\/p>\n<p>\u65b0\u5efa\u8d26\u6237Account-Module<\/p>\n<p>Storage-Module\u548cAccount-Module\u53c2\u7167\u6b64\u6a21\u5757\uff0c\u7aef\u53e3\u548c\u5b9e\u4f53\u7c7b\u4e0d\u540c\u3002<\/p>\n<p>order\u8ba2\u5355\u6a21\u5757\u901a\u8fc7openfeigin\u63a5\u53e3\u65b9\u5f0f\u8bbf\u95ee\u5e93\u5b58\u548c\u8d26\u6237\u6a21\u5757\u3002<\/p>\n<p>\u6d4b\u8bd5\u5168\u5c40\u4e8b\u52a1@GlobalTransactional<\/p>\n<h2>Test<\/h2>\n<p>\u4e0b\u8ba2\u5355-&gt;\u51cf\u5e93\u5b58-&gt;\u6263\u4f59\u989d-&gt;\u6539(\u8ba2\u5355)\u72b6\u6001<\/p>\n<p><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='https:\/\/bucket-blog-img.oss-cn-shanghai.aliyuncs.com\/wp-content\/uploads\/2022\/05\/image-1651408707628.png'><img class=\"lazyload lazyload-style-11\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  decoding=\"async\" data-original=\"https:\/\/bucket-blog-img.oss-cn-shanghai.aliyuncs.com\/wp-content\/uploads\/2022\/05\/image-1651408707628.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"file\" \/><\/div><\/p>\n<p>\u6570\u636e\u5e93\u521d\u59cb\u60c5\u51b5<\/p>\n<h3>\u6b63\u5e38\u4e0b\u5355<\/h3>\n<p><a href=\"http:\/\/localhost:2001\/order\/create?userId=1&amp;productId=1&amp;count=10&amp;money=100\">http:\/\/localhost:2001\/order\/create?userId=1&productId=1&count=10&money=100<\/a><\/p>\n<p>\u6b63\u5e38\u6263\u6b3e\uff0c\u6b63\u5e38\u65b0\u5efa\u8ba2\u5355\uff0c\u6b63\u5e38\u6263\u5e93\u5b58<\/p>\n<h3>\u8d26\u53f7\u6a21\u5757\u6dfb\u52a0\u8d85\u65f6\u5f02\u5e38\uff0c\u6ca1\u52a0@GlobalTransactional<\/h3>\n<p>AccountServiceImpl\u6dfb\u52a0\u8d85\u65f6<\/p>\n<p>\u5f53\u5e93\u5b58\u548c\u8d26\u6237\u91d1\u989d\u6263\u51cf\u540e\uff0c\u8ba2\u5355\u72b6\u6001\u5e76\u6ca1\u6709\u8bbe\u7f6e\u4e3a\u5df2\u7ecf\u5b8c\u6210\uff0c\u6ca1\u6709\u4ece\u96f6\u6539\u4e3a1<\/p>\n<p>\u800c\u4e14\u7531\u4e8efeign\u7684\u91cd\u8bd5\u673a\u5236\uff0c\u8d26\u6237\u4f59\u989d\u8fd8\u6709\u53ef\u80fd\u88ab\u591a\u6b21\u6263\u51cf<\/p>\n<h3>\u8d85\u65f6\u5f02\u5e38\uff0c\u6dfb\u52a0@GlobalTransactional<\/h3>\n<p>AccountServiceImpl\u6dfb\u52a0\u8d85\u65f6<\/p>\n<p>\u4e0b\u5355\u540e\u6570\u636e\u5e93\u6570\u636e\u5e76\u6ca1\u6709\u4efb\u4f55\u6539\u53d8\uff1a\u8bb0\u5f55\u90fd\u6dfb\u52a0\u4e0d\u8fdb\u6765<\/p>\n<h2>\u4e00\u90e8\u5206\u8865\u5145<\/h2>\n<p>Seata<\/p>\n<p>2019\u5e741\u6708\u4efd\u8682\u8681\u91d1\u670d\u548c\u963f\u91cc\u5df4\u5df4\u5171\u540c\u5f00\u6e90\u7684\u5206\u5e03\u5f0f\u4e8b\u52a1\u89e3\u51b3\u65b9\u6848<\/p>\n<p>Simple Extensible Autonomous Transaction Architecture\uff0c\u7b80\u5355\u53ef\u6269\u5c55\u81ea\u6cbb\u4e8b\u52a1\u6846\u67b6<\/p>\n<p>2020\u8d77\u59cb\uff0c\u53c2\u52a0\u5de5\u4f5c\u540e\u75281.0\u4ee5\u540e\u7684\u7248\u672c<\/p>\n<h3>\u518d\u770bTC\/TM\/RM\u4e09\u5927\u7ec4\u4ef6<\/h3>\n<p><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='https:\/\/bucket-blog-img.oss-cn-shanghai.aliyuncs.com\/wp-content\/uploads\/2022\/05\/image-1651408720906.png'><img class=\"lazyload lazyload-style-11\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  decoding=\"async\" data-original=\"https:\/\/bucket-blog-img.oss-cn-shanghai.aliyuncs.com\/wp-content\/uploads\/2022\/05\/image-1651408720906.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"file\" \/><\/div><\/p>\n<p>\u5206\u5e03\u5f0f\u4e8b\u52a1\u7684\u6267\u884c\u6d41\u7a0b\uff1a<\/p>\n<p>TM \u5f00\u542f\u5206\u5e03\u5f0f\u4e8b\u52a1\uff08TM \u5411 TC \u6ce8\u518c\u5168\u5c40\u4e8b\u52a1\u8bb0\u5f55\uff09\uff1b<\/p>\n<p>\u6309\u4e1a\u52a1\u573a\u666f\uff0c\u7f16\u6392\u6570\u636e\u5e93\u3001\u670d\u52a1\u7b49\u4e8b\u52a1\u5185\u8d44\u6e90\uff08RM \u5411 TC \u6c47\u62a5\u8d44\u6e90\u51c6\u5907\u72b6\u6001 \uff09\uff1b<\/p>\n<p>TM \u7ed3\u675f\u5206\u5e03\u5f0f\u4e8b\u52a1\uff0c\u4e8b\u52a1\u4e00\u9636\u6bb5\u7ed3\u675f\uff08TM \u901a\u77e5 TC \u63d0\u4ea4\/\u56de\u6eda\u5206\u5e03\u5f0f\u4e8b\u52a1\uff09\uff1b<\/p>\n<p>TC \u6c47\u603b\u4e8b\u52a1\u4fe1\u606f\uff0c\u51b3\u5b9a\u5206\u5e03\u5f0f\u4e8b\u52a1\u662f\u63d0\u4ea4\u8fd8\u662f\u56de\u6eda\uff1b<\/p>\n<p>TC \u901a\u77e5\u6240\u6709 RM \u63d0\u4ea4\/\u56de\u6eda \u8d44\u6e90\uff0c\u4e8b\u52a1\u4e8c\u9636\u6bb5\u7ed3\u675f\u3002<\/p>\n<h3>AT\u6a21\u5f0f\u5982\u4f55\u505a\u5230\u5bf9\u4e1a\u52a1\u7684\u65e0\u4fb5\u5165<\/h3>\n<p>\u662f\u4ec0\u4e48<\/p>\n<p><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='https:\/\/bucket-blog-img.oss-cn-shanghai.aliyuncs.com\/wp-content\/uploads\/2022\/05\/image-1651408730058.png'><img class=\"lazyload lazyload-style-11\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  decoding=\"async\" data-original=\"https:\/\/bucket-blog-img.oss-cn-shanghai.aliyuncs.com\/wp-content\/uploads\/2022\/05\/image-1651408730058.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"file\" \/><\/div><\/p>\n<p>\u4e00\u9636\u6bb5\u52a0\u8f7d<\/p>\n<p>\u5728\u4e00\u9636\u6bb5\uff0cSeata \u4f1a\u62e6\u622a\u201c\u4e1a\u52a1 SQL\u201d\uff0c<br \/>\n1  \u89e3\u6790 SQL \u8bed\u4e49\uff0c\u627e\u5230\u201c\u4e1a\u52a1 SQL\u201d\u8981\u66f4\u65b0\u7684\u4e1a\u52a1\u6570\u636e\uff0c\u5728\u4e1a\u52a1\u6570\u636e\u88ab\u66f4\u65b0\u524d\uff0c\u5c06\u5176\u4fdd\u5b58\u6210\u201cbefore image\u201d\uff0c<br \/>\n2  \u6267\u884c\u201c\u4e1a\u52a1 SQL\u201d\u66f4\u65b0\u4e1a\u52a1\u6570\u636e\uff0c\u5728\u4e1a\u52a1\u6570\u636e\u66f4\u65b0\u4e4b\u540e\uff0c<br \/>\n3  \u5176\u4fdd\u5b58\u6210\u201cafter image\u201d\uff0c\u6700\u540e\u751f\u6210\u884c\u9501\u3002<br \/>\n\u4ee5\u4e0a\u64cd\u4f5c\u5168\u90e8\u5728\u4e00\u4e2a\u6570\u636e\u5e93\u4e8b\u52a1\u5185\u5b8c\u6210\uff0c\u8fd9\u6837\u4fdd\u8bc1\u4e86\u4e00\u9636\u6bb5\u64cd\u4f5c\u7684\u539f\u5b50\u6027\u3002<\/p>\n<p><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='https:\/\/bucket-blog-img.oss-cn-shanghai.aliyuncs.com\/wp-content\/uploads\/2022\/05\/image-1651408738902.png'><img class=\"lazyload lazyload-style-11\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  decoding=\"async\" data-original=\"https:\/\/bucket-blog-img.oss-cn-shanghai.aliyuncs.com\/wp-content\/uploads\/2022\/05\/image-1651408738902.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"file\" \/><\/div><\/p>\n<p>\u4e8c\u9636\u6bb5\u63d0\u4ea4<\/p>\n<p>\u4e8c\u9636\u6bb5\u5982\u662f\u987a\u5229\u63d0\u4ea4\u7684\u8bdd\uff0c<br \/>\n\u56e0\u4e3a\u201c\u4e1a\u52a1 SQL\u201d\u5728\u4e00\u9636\u6bb5\u5df2\u7ecf\u63d0\u4ea4\u81f3\u6570\u636e\u5e93\uff0c\u6240\u4ee5Seata\u6846\u67b6\u53ea\u9700\u5c06\u4e00\u9636\u6bb5\u4fdd\u5b58\u7684\u5feb\u7167\u6570\u636e\u548c\u884c\u9501\u5220\u6389\uff0c\u5b8c\u6210\u6570\u636e\u6e05\u7406\u5373\u53ef\u3002<\/p>\n<p><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='https:\/\/bucket-blog-img.oss-cn-shanghai.aliyuncs.com\/wp-content\/uploads\/2022\/05\/image-1651408747980.png'><img class=\"lazyload lazyload-style-11\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  decoding=\"async\" data-original=\"https:\/\/bucket-blog-img.oss-cn-shanghai.aliyuncs.com\/wp-content\/uploads\/2022\/05\/image-1651408747980.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"file\" \/><\/div><\/p>\n<p>\u4e8c\u9636\u6bb5\u56de\u6eda<\/p>\n<p>\u4e8c\u9636\u6bb5\u56de\u6eda\uff1a<br \/>\n\u4e8c\u9636\u6bb5\u5982\u679c\u662f\u56de\u6eda\u7684\u8bdd\uff0cSeata \u5c31\u9700\u8981\u56de\u6eda\u4e00\u9636\u6bb5\u5df2\u7ecf\u6267\u884c\u7684\u201c\u4e1a\u52a1 SQL\u201d\uff0c\u8fd8\u539f\u4e1a\u52a1\u6570\u636e\u3002<br \/>\n\u56de\u6eda\u65b9\u5f0f\u4fbf\u662f\u7528\u201cbefore image\u201d\u8fd8\u539f\u4e1a\u52a1\u6570\u636e\uff1b\u4f46\u5728\u8fd8\u539f\u524d\u8981\u9996\u5148\u8981\u6821\u9a8c\u810f\u5199\uff0c\u5bf9\u6bd4\u201c\u6570\u636e\u5e93\u5f53\u524d\u4e1a\u52a1\u6570\u636e\u201d\u548c \u201cafter image\u201d\uff0c<br \/>\n\u5982\u679c\u4e24\u4efd\u6570\u636e\u5b8c\u5168\u4e00\u81f4\u5c31\u8bf4\u660e\u6ca1\u6709\u810f\u5199\uff0c\u53ef\u4ee5\u8fd8\u539f\u4e1a\u52a1\u6570\u636e\uff0c\u5982\u679c\u4e0d\u4e00\u81f4\u5c31\u8bf4\u660e\u6709\u810f\u5199\uff0c\u51fa\u73b0\u810f\u5199\u5c31\u9700\u8981\u8f6c\u4eba\u5de5\u5904\u7406\u3002<\/p>\n<p><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='https:\/\/bucket-blog-img.oss-cn-shanghai.aliyuncs.com\/wp-content\/uploads\/2022\/05\/image-1651408770697.png'><img class=\"lazyload lazyload-style-11\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  decoding=\"async\" data-original=\"https:\/\/bucket-blog-img.oss-cn-shanghai.aliyuncs.com\/wp-content\/uploads\/2022\/05\/image-1651408770697.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"file\" \/><\/div><\/p>\n<p>debug<\/p>\n<p>\u8865\u5145<\/p>\n<p><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='https:\/\/bucket-blog-img.oss-cn-shanghai.aliyuncs.com\/wp-content\/uploads\/2022\/05\/image-1651408781120.png'><img class=\"lazyload lazyload-style-11\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  decoding=\"async\" data-original=\"https:\/\/bucket-blog-img.oss-cn-shanghai.aliyuncs.com\/wp-content\/uploads\/2022\/05\/image-1651408781120.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"file\" \/><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5206\u5e03\u5f0f\u4e8b\u52a1\u95ee\u9898 \u5206\u5e03\u5f0f\u524d \u5355\u673a\u5355\u5e93\u6ca1\u8fd9\u4e2a\u95ee\u9898 \u4ece1\uff1a1 -&gt; 1\uff1aN -&gt; N\uff1aN \u5206\u5e03\u5f0f\u4e4b\u540e \u5355 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[126],"tags":[71],"class_list":["post-533","post","type-post","status-publish","format-standard","hentry","category-java-microservices","tag-springcloudalibaba"],"_links":{"self":[{"href":"https:\/\/blog.ttwow.top\/index.php?rest_route=\/wp\/v2\/posts\/533","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ttwow.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ttwow.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ttwow.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ttwow.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=533"}],"version-history":[{"count":1,"href":"https:\/\/blog.ttwow.top\/index.php?rest_route=\/wp\/v2\/posts\/533\/revisions"}],"predecessor-version":[{"id":2033,"href":"https:\/\/blog.ttwow.top\/index.php?rest_route=\/wp\/v2\/posts\/533\/revisions\/2033"}],"wp:attachment":[{"href":"https:\/\/blog.ttwow.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=533"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ttwow.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=533"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ttwow.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=533"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}