Architecture #

SphereEx-DBPlusEngine focuses on pluggable architecture, providing features that can flexibly be embedded into projects. Currently, features such as data sharding, read/write splitting, data encryption, shadow database, and SQL dialects / database protocols such as MySQL, PostgreSQL, SQLServer, Oracle are supported and are all weaved by plugins. Developers can customize their own ShardingSphere just like building with lego blocks.

The pluggable architecture of DBPlusEngine are composed by L1 Kernel Layer, L2 Feature Layer and L3 Ecosystem Layer.

L1 Kernel Layer #

An abstraction of the database’s basic capabilities. All components are required and the specific implementation can be replaced by pluggable way. It includes a query optimizer, distributed transaction engine, distributed execution engine, authority engine and scheduling engine.

L2 Feature Layer #

Used to provide enhanced capability. All components are optional and can contain zero or multiple components. Components isolate each other and multiple components can be used together simultaneously. It includes data sharding, read/write splitting, database high availability, data encryption, shadow database and so on. User-defined features can be fully customized and extended for the top-level interface defined by Apache ShardingSphere without changing the kernel’s code.

L3 Ecosystem Layer #

Used to integrate into the current database ecosystem. It includes database protocol, SQL parser and storage adapter.