simzyoo commented on issue #7335:
URL:
https://github.com/apache/incubator-seata/issues/7335#issuecomment-2861454627
> 是的，但是如果采用三阶段协议，再使用XA
flags为join的方式应该是可以，但是join是不允许prepare后的xa事务进行join的，而且取决于数据库层面的实现，这块mysql能力跟oracle就没有对齐。并且三阶段协议复杂度又提升，并且性能会进一步下降。
Yes, but if we use the three-phase protocol and XA flags with the "join"
method, it should work. However, "join" is not allowed for XA transactions
after prepare, and it depends on the database-level implementation. MySQL's
capabilities in this area are not aligned with Oracle's. Additionally, the
complexity of the three-phase protocol increases, and performance will further
decline.
那我感觉xa协议有很明显的缺陷，比如如下的代码，经过测试，我发现会直接卡死，在xa协议的范围内有什么办法规避吗？
```
@GlobalTransactional
public void testXA(){
//更新主键id为123的数据值为b
updateData(123,"b")
//更新主键id为123的数据值为a
updateData(123,"a")
}
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscr...@seata.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscr...@seata.apache.org
For additional commands, e-mail: notifications-h...@seata.apache.org
