business at the database level. 8.11.2 Challenges User business queries in SQL are often complex and variable, and it is costly to integrate them into ShardingSphere through business SQL transformation. Convert configuration. Assume that the following set of environment variables exists, 1. The existing environment variable FIXTURE_JDBC_URL is jdbc:h2:mem:foo_ds_1; DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MySQL . 9.1. ShardingSphere-JDBC 91 Apache ShardingSphere document 2. The existing environment variable FIXTURE_USERNAME is sa. Then for the intercepted fragment of the following YAML file, ds_1: dataSourceClassName:

according to environment variable -e PORT Customized JVM related parameters can be set according to environment variable JVM_OPTS Note: Support setting environment variable CGROUP_ MEM_ OPTS: used to ShardingSphere document SET DIST VARIABLE Description The SET DIST VARIABLE syntax is used to set system variables. ### Syntax SetDistVariable ::= 'SET' 'DIST' 'VARIABLE' (proxyPropertyName '=' proxyPropertyValue configuration of Proxy SET DIST VARIABLE sql_show = true; • Set agent plugin enable status 9.2. ShardingSphere-Proxy 344 Apache ShardingSphere document SET DIST VARIABLE agent_plugins_enabled = TRUE;

Properties otherProperties = new Properties(); otherProperties.setProperty("sql-show", "true"); /* The variable `shardingDataSource` is the logic data source referenced by other frameworks(such as ORM, JPA, Example set variable pr oxy_property_name = xx proxy_property_name is one of properties con‐ fig uration of proxy，name is split by underscore set variable sql_show = true set variable transac‐ tion_type XA, BASE set variable t ransac‐ tion_type = XA set variable agen t_plugins_enabled = [true / false] Set whether the agent plugins are enabled, the default value is false set variable agent_ plugins_enabled

ShardingSphere-Proxy 325 Apache ShardingSphere document SET DIST VARIABLE 描述 SET DIST VARIABLE 语法用于设置系统变量。 语法 SetDistVariable ::= 'SET' 'DIST' 'VARIABLE' (proxyPropertyName '=' proxyPropertyValue | 'agent_ SET DIST VARIABLE sql_show = true; • 设置 agent 插件启用状态 SET DIST VARIABLE agent_plugins_enabled = TRUE; 9.2. ShardingSphere-Proxy 326 Apache ShardingSphere document 保留字 SET、DIST、VARIABLE 相关链接 • 保留字 保留字 SHOW DIST VARIABLE 描述 SHOW DIST VARIABLE 语法用于查询 PROXY 系统变量配置。 语法 ShowDistVariable ::= 'SHOW' 'DIST' ('VARIABLES' ('LIKE' likePattern)?| 'VARIABLE' 'WHERE' 'NAME' '=' variableName) likePattern

ShardingSphere-Proxy 308 Apache ShardingSphere document SET DIST VARIABLE 描述 SET DIST VARIABLE 语法用于设置系统变量。 语法 SetDistVariable ::= 'SET' 'DIST' 'VARIABLE' (proxyPropertyName '=' proxyPropertyValue | 'agent_ SET DIST VARIABLE sql_show = true; • 设置 agent 插件启用状态 SET DIST VARIABLE agent_plugins_enabled = TRUE; 9.2. ShardingSphere-Proxy 309 Apache ShardingSphere document 保留字 SET、DIST、VARIABLE 相关链接 • 保留字 保留字 SHOW DIST VARIABLE 描述 SHOW DIST VARIABLE 语法用于查询 PROXY 系统变量配置。 语法 ShowDistVariable ::= 'SHOW' 'DIST' ('VARIABLES' ('LIKE' likePattern)?| 'VARIABLE' 'WHERE' 'NAME' '=' variableName) likePattern

sec) 保留字 SHOW、COMPUTE、NODE、MODE 相关链接 • 保留字 SET DIST VARIABLE 描述 SET DIST VARIABLE 语法用于设置系统变量。 语法 SetDistVariable ::= 'SET' 'DIST' 'VARIABLE' (proxyPropertyName '=' proxyPropertyValue | 'agent_ 属性配置 SET DIST VARIABLE sql_show = true; • 设置 agent 插件启用状态 SET DIST VARIABLE agent_plugins_enabled = TRUE; 保留字 SET、DIST、VARIABLE 相关链接 • 保留字 SHOW DIST VARIABLE 描述 SHOW DIST VARIABLE 语法用于查询 PROXY likePattern)?| 'VARIABLE' 'WHERE' 'NAME' '=' variableName) likePattern ::= string variableName ::= identifier 9.2. ShardingSphere-Proxy 344 Apache ShardingSphere document 返回值说明 列 说明 variable_name 系统变量名称

Properties otherProperties = new Properties(); otherProperties.setProperty("sql-show", "true"); /* The variable `shardingDataSource` is the logic data source referenced by other 5.1. ShardingSphere-JDBC 85 apache/shardingsphere- proxy:latest Notice • You can define JVM related parameters to environment variable JVM_OPTS. docker run -d -v /${your_work_dir}/conf:/opt/shardingsphere-proxy/conf -v /${your_ rules SET VARIABLE proxy_property_name = xx proxy_property_name is one of prop‐ erties configuration of proxy, name is split by underscore SET VARIABLE sql_show = true SET VARIABLE transaction_type

readwrite_splitting read resources 其他 语句 说明 示例 set variable proxy_property_name = xx proxy_property_name 为 proxy 的属性 配置 ，需使用下划线命名 set variable sql_show = true set variable transaction_type = xx 修改当前连接的事务类型, 支持 LOCAL， XA，BASE set variable transac‐ tion_type = XA set variable agent_plugins_enabled = [true / false] 设置 agent 插件的启用状态，默认值 false set variable ag ent_plugins_enabled = true show all variables all variable show variable proxy_property_name 查询 proxy 属性配置，需使用下划线命 名 show variable sql_show show variable transac‐ tion_type 查询当前连接的事务类型 show variable transac‐ tion_type show variable cached_connections

Properties otherProperties = new Properties(); otherProperties.setProperty("sql-show", "true"); /* The variable `shardingDataSource` is the logic data source referenced by other 5.1. ShardingSphere-JDBC 88 apache/shardingsphere- proxy:latest Notice • You can define JVM related parameters to environment variable JVM_OPTS. docker run -d -v /${your_work_dir}/conf:/opt/shardingsphere-proxy/conf -v /${your_ RULES SET VARIABLE proxy_property_name = xx proxy_property_name is one of properties configuration of proxy, name is split by underscore SET VARIABLE sql_show = true SET VARIABLE transaction_type

portal 3307 can be designated according to environment variable -e PORT Customized JVM related parameters can be set according to environment variable JVM_OPTS 5. Use Client to connect to ShardingSphere‐Proxy MODE INFO SET VARIABLE proxy _property_name = xx proxy_property_name is one of properties configuration of proxy, name is split by un‐ derscore SET VARIABLE sql_show = true SET VARIABLE tr ansac‐ BASE SET VARIABLE tran sac‐ tion_type = “XA” SET VARIABLE agent_p lugins_enabled = [TRUE / FALSE] Set whether the agent plugins are enabled, the default value is false SET VARIABLE agent_plu