ob_proxy_readonly_transaction_routing_policy specifies whether transaction routing by OceanBase Database Proxy (ODP) is affected by read-only statements.
Note
The default value is changed from true to false since OceanBase Database V4.0.0.
| Parameter | Description |
|---|---|
| Type | Boolean |
| Default value | false |
| Value range | true: specifies that ODP routes a transaction based on the first read-only statement.false: specifies that ODP routes a transaction based on the first statement that starts the transaction. |
| Effective upon restart of OBServer node | No |
Example
obclient> ALTER SYSTEM SET ob_proxy_readonly_transaction_routing_policy = true;