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 has been changed from `true` to `false` since OceanBase Database V4.0.0.
| Attribute | 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 OBServer node restart | No |
Example
obclient> ALTER SYSTEM SET ob_proxy_readonly_transaction_routing_policy = true;