Transaction #
| Syntax | Description | Type |
|---|---|---|
| ALTER TRANSACTION RULE(DEFAULT=xx,TYPE(NAME=xxx, PROPERTIES(“key1"=“value1”,“key2”=“value2”…))) | Update transaction rule configuration | RAL |
| SHOW TRAFFIC[ RULES / RULE ruleName] | Query transaction rule configuration | RQL |
1. Update Transaction Rule Configuration #
ALTER TRANSACTION RULE(DEFAULT=xx,TYPE(NAME=xxx, PROPERTIES(“key1"="value1”,“key2"="value2”…)))
Parameter Explanation
DEFAULT: Default transaction type, support LOCAL、XA、BASE；
NAME: Transaction manager name, support Atomikos、Narayana and Bitronix
Example
ALTER TRANSACTION RULE(DEFAULT=XA,TYPE(NAME=Narayana, PROPERTIES(“databaseName"="jbossts”,“host"="127.0.0.1”)))
2. Query Transaction Rule Configuration #
SHOW TRAFFIC[ RULES / RULE ruleName]
Parameter Explanation
None
Example
SHOW SQL_PARSER RULES;