Distributed SQL transaction & query engine for data sharding, scaling, encryption, and more - on any database.
DROP SHARDING ALGORITHM
ALTER RESOURCE
CREATE SHARDING ALGORITHM
CREATE DEFAULT SHARDING [TABLE | DATABASE] STRATEGY
SHOW ALL VARIABLE
SHOW VARIABLE variableName;
3
modes, including Memory, Standalone and Cluster modeNATIVE
to ALL_PRIVILEGES_PERMITTED
SHOW RESOURCES
DistSQL is adjusted to SHOW SCHEMA RESOURCES
shadow
logical field, support shadow algorithmABORT
statementCREATE INDEX
statement to generate index automatically when no index is specifiedADD RESOURCE
statement supports special charactersADD RESOURCE
supports custom JDBC parameters and connection pool propertiesDROP RESOURCE
supports optional parameter ignore single tables
, used to ignore single table rule restrictionsSHOW DATABASES
statement supports like syntaxCREATE SHARDING TABLE RULE
supports the use of inline expressions to specify resourcesCREATE SHARDING TABLE RULE
supports configuration using dataNodes
CREATE SHARDING TABLE RULE
supports reuse of existing algorithmsSET VARIABLE
, support to modify proxy configurationSHOW INDEX FROM TABLE FROM TABLE
statement rewrite exceptionSHOW RESOURCES
statement cannot display custom attributesQueryReplica
configuration item is replaced by read-write-splitting
Authentication
configuration item of ShardingProxy is replaced by AUTHORITY
dataSourceClassName
acceptor-size
from ShardingProxySELECT *
from encrypted SQL, add quote char for the rewritten column to avoid conflict with keywordCREATE/ALTER/DROP TABLESPACE
statementPREPARE, EXECUTE, DEALLOCATE
statementEXPLAIN
statementSTART/END TRANSACTION
statementALTER/DROP INDEX
statementTABLESPACE
of PostgreSQLCREATE LOADABLE FUNCTION
statementALTER TABLE RENAME
statementSELECT * wildcard
when readwrite-splitting onlyUPDATE ... SET ...
statementSELECT ... WHERE ... LIKE
statement class cast exceptionSELECT EXISTS ... FROM ...
statement parse errorSHOW INDEX
statement... GROUP BY ...
statement rewrite and merge result errorallow.range.query.with.inline.sharding
optionDataTypeName
syntax rules of all database dialectsBEGIN
using prepared statement of MySQL C APIALTER TABLE
fails to execute when the field type of the table contains Integer/Double/BigDecimalSELECT * FROM tbl WHERE encrypt_col = ? AND (sharding_key = ? OR sharding_key = ?)
when using sharding + encrypt would throw StringIndexOutOfBoundsException\n
\t
\r
could not supported by parser.io.shardingsphere
to org.apache.shardingsphere
.SELECT FOR UPDATE
route to master data source only.SELECT FOR UPDATE
on master dataSource.