Philosophy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 1.2.1 Connect: Create database upper level standard . . . . . . . . . . . . . . . . . . 4 1.2.2 Enhance: Database computing 19 3.1.6 Core Concept . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 Data Nodes using a client such as Navicat to connect to ShardingSphere‐Proxy, if ShardingSphere‐Proxy does not create a database or does not add a resource, the client connection will fail? . . . . . . . . . . . .

Philosophy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 1.2.1 Connect: Create database upper level standard . . . . . . . . . . . . . . . . . . 5 1.2.2 Enhance: Database computing 20 3.1.6 Core Concept . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20 Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20 Data Nodes using a client such as Navicat to connect to ShardingSphere‐Proxy, if ShardingSphere‐Proxy does not create a database or does not add a resource, the client connection will fail? . . . . . . . . . . . .

. 27 Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 Data Node using a client such as Navicat to connect to ShardingSphere‐Proxy, if ShardingSphere‐Proxy does not create a Schema or does not add a Resource, the client connection will fail? . . . . . . . . . . . . . 360 7.8.10 [Sharding] If sharding database is partial, should tables without sharding database & table configured in sharding rules? . . . . . . . . . . . . . . . . . . 360 7.8.11 [Sharding] When generic

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 2 Design Philosophy 4 2.1 Connect: Create database upper level standard . . . . . . . . . . . . . . . . . . . . . . 5 2.2 Enhance: Database 23 8.1.6 Core Concept . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 Data Nodes 4 Proxy When using a client to connect to ShardingSphere‐Proxy, if ShardingSphere‐Proxy does not create a database or does not register a storage unit, the client connection will fail? . . . . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 2 Design Philosophy 4 2.1 Connect: Create database upper level standard . . . . . . . . . . . . . . . . . . . . . . 5 2.2 Enhance: Database 23 8.1.6 Core Concept . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 Data Nodes 4 Proxy When using a client to connect to ShardingSphere‐Proxy, if ShardingSphere‐Proxy does not create a database or does not register a storage unit, the client connection will fail? . . . . . . .

Rules Configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 2.1.3 3. Create Data Source . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 2.2 ShardingSphere‐Proxy 3 Start Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 2.3.4 Create Migration Job . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 2.3.5 Related documents . 27 Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 Data Node

2. Rules Configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 2.1.3 3. Create Data Source . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 2.2 ShardingSphere‐Proxy Start Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 2.3.4 4. Create Migration Job . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 2.3.5 5. Related documents . 24 Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24 Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24 Data Node

尔组合。 例如，以下行表达式： ${['online', 'offline']}_table${1..3} 最终会解析为： online_table1, online_table2, online_table3, offline_table1, offline_table2, offline_table3 分布式主键 传统数据库软件开发中，主键自动生成技术是基本需求。而各个数据库对于该需求也提供了相应的支持， 数据库 SCHEMA DDL 和 DML 语句。 常规查询 • SELECT 主语句 SELECT select_expr [, select_expr ...] FROM table_reference [, table_reference ...] [WHERE predicates] [GROUP BY {col_name | position} [ASC | DESC], ...] COUNT(* | COLUMN_NAME | alias) [AS] [alias] • table_reference tbl_name [AS] alias] [index_hint_list] | table_reference ([INNER] | {LEFT|RIGHT} [OUTER]) JOIN table_factor [JOIN ON conditional_expr | USING

‘file://component2’ REPAIR TABLE t_order OPTIMIZE TABLE t_order CHECKSUM TABLE t_order CHECK TABLE t_order SET RESOURCE GROUP group_name DROP RESOURCE GROUP group_name CREATE RESOURCE GROUP group_name 不支持的 SQL 清单如下： SQL CREATE type avg_state AS (total bigint, count bigint); CREATE AGGREGATE my_avg(int4) (stype = avg_state, sfunc = avg_transfn, finalfunc = avg_finalfn) CREATE TABLE agg_data_2k AS SELECT generate_series(0, 1999) g; CREATE SCHEMA alt_nsp1; ALTER AGGREGATE alt_agg3(int) OWNER TO regress_alter_generic_user2; CREATE CONVERSION alt_conv1 FOR ‘LATIN1’TO ‘UTF8’FROM iso8859_1_to_utf8; CREATE FOREIGN DATA

尔组合。 例如，以下行表达式： ${['online', 'offline']}_table${1..3} 最终会解析为： online_table1, online_table2, online_table3, offline_table1, offline_table2, offline_table3 8.1. 数据分片 25 Apache ShardingSphere document SEARCH_PATH 修改 schema 搜索路径。 常规查询 • SELECT 主语句 SELECT select_expr [, select_expr ...] FROM table_reference [, table_reference ...] [WHERE predicates] [GROUP BY {col_name | position} [ASC | DESC], ...] COUNT(* | COLUMN_NAME | alias) [AS] [alias] • table_reference tbl_name [AS] alias] [index_hint_list] | table_reference ([INNER] | {LEFT|RIGHT} [OUTER]) JOIN table_factor [JOIN ON conditional_expr | USING