251 Connection Mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 251 Automatic Execution Engine . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 253 7.1.11 Merger Engine Distributed Primary Key Motivation In the development of traditional database software, the automatic sequence generation technology is a basic requirement. All kinds of databases have provided corresponding second way is to use SkyWalking’s automatic monitor agent. Cooperating with Apache SkyWalk‐ ing team, Apache ShardingSphere team has realized ShardingSphere automatic monitor agent to automatically send

261 Connection Mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 261 Automatic Execution Engine . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 263 viii 7.2.11 Merger Distributed Primary Key Motivation In the development of traditional database software, the automatic sequence generation technology is a basic requirement. All kinds of databases have provided corresponding apm‐toolkit. • Use SkyWalking’s automatic monitor probe Cooperating with Apache SkyWalking team, Apache ShardingSphere team has realized Sharding- Sphere automatic monitor probe to automatically send

376 Connection Mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 377 Automatic Execution Engine . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 378 7.4.11 Merger Engine the Apache ShardingSphere built‐in sharding algorithm, syntax sugar, which is very flexible. Automatic Sharding Algorithm Sharding algorithm—syntactic sugar is for conveniently hosting all data nodes offline_table2, offline_table3 Distributed Primary Key In traditional database software development, automatic primary key generation is a basic require‐ ment. Various databases provide support for this requirement

272 Connection Mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 272 Automatic Execution Engine . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 274 7.2.11 Merger Engine Distributed Primary Key Motivation In the development of traditional database software, the automatic sequence generation technology is a basic requirement. All kinds of databases have provided corresponding apm‐toolkit. • Use SkyWalking’s automatic monitor probe Cooperating with Apache SkyWalking team, Apache ShardingSphere team has realized Sharding- Sphere automatic monitor probe to automatically send

403 Connection Mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 404 Automatic Execution Engine . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 405 7.4.11 Merger Engine the Apache ShardingSphere built‐in sharding algorithm, syntax sugar, which is very flexible. Automatic Sharding Algorithm Sharding algorithm—syntactic sugar is for conveniently hosting all data nodes offline_table2, offline_table3 Distributed Primary Key In traditional database software development, automatic primary key generation is a basic require‐ ment. Various databases provide support for this requirement

Distributed Primary Key Motivation In the development of traditional database software, the automatic sequence generation technology is a basic requirement. All kinds of databases have provided corresponding flexible, sharding strategies set by users can be customized according to their needs. Together with automatic data migration, database middle layer can automatically shard and balance the data without users 39 Apache ShardingSphere document, v5.0.0-beta Execute Engine ShardingSphere adopts a set of automatic execution engine, responsible for sending the true SQL, which has been routed and rewritten, to

544 Connection Mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 544 Automatic Execution Engine . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 546 12.4.11 Merger Engine the Apache ShardingSphere built‐in sharding algorithm, syntax sugar, which is very flexible. Automatic Sharding Algorithm Sharding algorithm—syntactic sugar is for conveniently hosting all data nodes offline_table2, offline_table3 Distributed Primary Key In traditional database software development, automatic primary key generation is a basic require‐ ment. Various databases provide support for this requirement

515 Connection Mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 515 Automatic Execution Engine . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 517 12.4.11 Merger Engine the Apache ShardingSphere built‐in sharding algorithm, syntax sugar, which is very flexible. Automatic Sharding Algorithm Sharding algorithm—syntactic sugar is for conveniently hosting all data nodes offline_table2, offline_table3 Distributed Primary Key In traditional database software development, automatic primary key generation is a basic require‐ ment. Various databases provide support for this requirement

operators too, so that they do not have to worry about jobs high availability and management, and can automatic operation by simply adding servers. ElasticJob is a lightweight, decentralized solution that provides