DistSQL #
Background #
DistSQL（Distributed SQL) is SphereEx-DBPlusEngine’s specific SQL, providing added-on operation capability if compared to standard SQL.
Challenges #
When using DBPlusEngine-Proxy, developers can operate data just like using a database, but they need to configure resources and rules through YAML files (or registry center). However, the format of YAML and habits changed by using registry center are not friendly to DBA.
DistSQL allows users to operate SphereEx-DBPlusEngine just like a database, transforming it from a framework and middleware for developers to a database product for DBAs.
DistSQL is divided into RDL, RQL, RAL and RUL.
- RDL (Resource & Rule Definition Language) responsible for the definition of resources and rules;
- RQL (Resource & Rule Query Language) responsible for the query of resources and rules;
- RAL (Resource & Rule Administration Language) responsible for the added-on administrator feature of hint, transaction type switch, sharding execute planning and so on.
- RUL (Resource Utility Language) responsible for SQL parsing, SQL formatting, preview execution plan and more utility functions.
Goal #
DistSQL aims at breaking the boundary between middleware and database, and let developers use SphereEx-DBPlusEngine just like a database.
Notice #
Currently DistSQL can be used with DBPlusEngine-Proxy only, not with DBPlusEngine-Driver.