Get the App
SLTechnology News&Howtos  ›  Database  › 

Example of mysql cross-library transaction XA operation

Shulou Source: shulou.com Published: 2022-06-01 04:16:56 11月17日 Update

This paper gives an example of mysql cross-database transaction XA operation. Share with you for your reference, the details are as follows:

Some time ago, I encountered the problem of cross-database transactions in my work, and then I made an inquiry on the Internet, and now I do some arrangement and summary.

1. First, make sure that mysql enables XA transaction support.

SHOW VARIABLES LIKE'% XA%'

If the value of innodb_support_xa is ON, mysql has enabled support for XA transactions.

If not, execute:

SET innodb_support_xa = ON

Tags: Transaction skill data database phase preparation performance Daquan support query topic two interest content function multiple barley instance common use time Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno macOS Redmi Microsoft Xiaomi Shulou Technology