Transaction policy is dynamic parameter of compute node. Reference to this document to see how to modify: Create knobs object of database parameter

Operation Steps

1. Configure knobs.yaml as shown below:

apiVersion: polardbx.aliyun.com/v1
kind: PolarDBXClusterKnobs
metadata:
  name: kunan-oss
spec:
  clusterName: "tunan-oss"
  knobs:
    TRANSACTION_POLICY: XA

Add TRANSACTION_POLICY parameter, and fill it with the policy you need XA|TSO|TSO_READONLY are supported.

1. Connect to PolarDB-X and execute SQL below to check if the configuration is valid:

begin; show variables like "drds_transaction_policy"; rollback;