Rules
Background
This section explains how to configure the ShardingSphere-Proxy rules.
Parameters Explained
Rules configuration for ShardingSphere-Proxy is the same as ShardingSphere-JDBC. For details, please refer to ShardingSphere-JDBC Rules Configuration.
Notice
Unlike ShardingSphere-JDBC, the following rules need to be configured in ShardingSphere-Proxy’s global.yaml:
sqlParser:
sqlStatementCache:
initialCapacity: 2000
maximumSize: 65535
parseTreeCache:
initialCapacity: 128
maximumSize: 1024transaction:
defaultType: XA
providerType: AtomikossqlTranslator:
type:
useOriginalSQLWhenTranslatingFailed:sqlFederation:
providerType: CALCITE
allQueryUseSQLFederation: false
executionPlanCache:
initialCapacity: 2000
maximumSize: 65535