Operate sharding API . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 52 Job statistics API . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 52 Job server status During the zk authorization upgrade process, there was a false death of the instance during the rolling deployment process, and even if the historical version was rolled back, there was still false death which can handle important events in the scheduling process through event subscription for query, statistics and monitor. Now, the event subscription based on relation database is provided to record events

Transaction 37 Apache ShardingSphere document XA Transaction Unsupported • Recover committing and rolling back in other machines after the service is down. • MySQL, in the transaction block, the SQL execution sharding database. Sharding audit not only intercept illegal SQL statements, but also gather the SQL statistics. Parameters DML_SHARDING_CONDITIONS algorithm Type: DML_SHARDING_CONDITIONS Procedure 1. when 234638.36 (r/w/o: 164251.67/46924.69/23462. 00) lat (ms,95%): 24.38 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 19560590 # number of reads write: 5588740 # number of writes other:

Transaction 37 Apache ShardingSphere document XA Transaction Unsupported • Recover committing and rolling back in other machines after the service is down. • MySQL, in the transaction block, the SQL execution sharding database. Sharding audit not only intercept illegal SQL statements, but also gather the SQL statistics. Parameters DML_SHARDING_CONDITIONS algorithm Type: DML_SHARDING_CONDITIONS 9.3. Common Configuration 234638.36 (r/w/o: 164251.67/46924.69/23462. 00) lat (ms,95%): 24.38 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 19560590 # number of reads write: 5588740 # number of writes other:

Distributed Transaction 32 Apache ShardingSphere document, v5.2.1 Unsupported • Recover committing and rolling back in other machines after the service is down; • MySQL,in the transaction block, the SQL execution sharding database. Sharding audit not only intercept illegal SQL statements, but also gather the SQL statistics. Parameters DML_SHARDING_CONDITIONS algorithm Type: DML_SHARDING_CONDITIONS Procedure 1. when 234638.36 (r/w/o: 164251.67/46924.69/23462. 00) lat (ms,95%): 24.38 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 19560590 # number of reads write: 5588740 # number of writes other:

Distributed Transaction 33 Apache ShardingSphere document, v5.2.0 Unsupported • Recover committing and rolling back in other machines after the service is down; • MySQL,in the transaction block, the SQL execution 234638.36 (r/w/o: 164251.67/46924.69/23462. 00) lat (ms,95%): 24.38 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 19560590 # number of reads write: 5588740 # number of writes other: errors (per second) reconnects: 0 (0.00 per sec.) # number of reconnections (per second) General statistics: total time: 120.0463s # total time total number of events: 1397185 # toal number of transactions

alt_fserv1 FOREIGN DATA WRAPPER alt_fdw1 CREATE LANGUAGE alt_lang1 HANDLER plpgsql_call_handler CREATE STATISTICS alt_stat1 ON a, b FROM alt_regress_1 CREATE TEXT SEARCH DICTIONARY alt_ts_dict1 (template=simple) alt_fserv1 FOREIGN DATA WRAPPER alt_fdw1 CREATE LANGUAGE alt_lang1 HANDLER plpgsql_call_handler CREATE STATISTICS alt_stat1 ON a, b FROM alt_regress_1 CREATE TEXT SEARCH DICTIONARY alt_ts_dict1 (template=simple) Distributed Transaction 47 Apache ShardingSphere document, v5.1.1 Unsupported • Recover committing and rolling back in other machines after the service is down. • Savepoint. • In the transaction block, the

alt_fserv1 FOREIGN DATA WRAPPER alt_fdw1 CREATE LANGUAGE alt_lang1 HANDLER plpgsql_call_handler CREATE STATISTICS alt_stat1 ON a, b FROM alt_regress_1 CREATE TEXT SEARCH DICTIONARY alt_ts_dict1 (template=simple) alt_fserv1 FOREIGN DATA WRAPPER alt_fdw1 CREATE LANGUAGE alt_lang1 HANDLER plpgsql_call_handler CREATE STATISTICS alt_stat1 ON a, b FROM alt_regress_1 CREATE TEXT SEARCH DICTIONARY alt_ts_dict1 (template=simple) Distributed Transaction 49 Apache ShardingSphere document, v5.1.2 Unsupported • Recover committing and rolling back in other machines after the service is down; • MySQL,in the transaction block, the SQL execution

Transaction 66 Apache ShardingSphere document, v5.0.0-beta Unsupported Items • Recover committing and rolling back in other machines after the service is down. Seata BASE transaction Supported Items • Support

234638.36 (r/w/o: 164251.67/46924.69/23462. 00) lat (ms,95%): 24.38 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 19560590 # 读总数 write: 5588740 # 写总数 other: 27943700 # 其他操作总 数 (COMMIT (0.00 per sec.) # 忽略错误数 ( 每秒忽略错误数 ) reconnects: 0 (0.00 per sec.) # 重连次数 ( 每秒重连次数 ) General statistics: total time: 120.0463s # 总共耗时 total number of events: 1397185 # 总共发生多 少事务数 Latency (ms): min: 在定义的命名空间下，rules 、props 和 metadata 节点以 YAML 格式存储配置，可通过修改节点来实现 对于配置的动态管理。nodes 存储数据库访问对象运行节点，用于区分不同数据库访问实例。statistics 存储系统表中的数据记录。 namespace ├──rules # 全局规则配置 ├ ├──transaction ├ ├ ├──active_version ├ ├ ├──versions

234638.36 (r/w/o: 164251.67/46924.69/23462. 00) lat (ms,95%): 24.38 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: 11.5. 性能测试 413 Apache ShardingSphere document read: 19560590 # 读总数 write: (0.00 per sec.) # 忽略错误数 ( 每秒忽略错误数 ) reconnects: 0 (0.00 per sec.) # 重连次数 ( 每秒重连次数 ) General statistics: total time: 120.0463s # 总共耗时 total number of events: 1397185 # 总共发生多 少事务数 Latency (ms): min: 在定义的命名空间下，rules 、props 和 metadata 节点以 YAML 格式存储配置，可通过修改节点来实现 对于配置的动态管理。nodes 存储数据库访问对象运行节点，用于区分不同数据库访问实例。statistics 存储系统表中的数据记录。 namespace ├──rules # 全局规则配置 ├ ├──transaction ├ ├ ├──active_version ├ ├ ├──versions