Roadmap

Sharding-JDBC

JDBC

• Data Source
• Connection
• Connection Metadata
• Statement
• Prepared Statement
• Result Set
• Result Set Metadata

Database

• MySQL
• Oracle
• SQLServer
• PostgreSQL

Configuration

• Java API
• YAML
• Spring Namespace
• Spring Boot Starter

Sharding-Proxy

Database

• MySQL
  • Handshake Packet
  • OK Packet
  • ERR Packet
  • EOF Packet
  • COM_QUIT Packet
  • COM_INIT_DB Packet
  • COM_QUERY Packet
  • COM_FIELD_LIST Packet
  • COM_STMT_PREPARE
  • COM_STMT_EXECUTE
  • COM_STMT_CLOSE
  • COM_STMT_RESET
• Oracle
• SQLServer
• PostgreSQL

Configuration

• YAML

Sharding-Sidecar

• TODO

Kernel

SQL

• DQL
  • Simple DQL
  • JOIN
  • BETWEEN
  • IN
  • ORDER BY
  • GROUP BY
  • Aggregation Functions
  • LIMIT, rownum, TOP
  • Simple Sub Query
  • OR
  • DISTINCT
  • HAVING
  • UNION, UNION ALL
  • Calculate Expression, eg: SUM(pv) / COUNT(uv)
  • Complicated Sub Query
  • SQL Hint
• DML
  • INSERT INTO
  • INSERT SET
  • UPDATE
  • DELETE
  • INSERT INTO VALUES (xxx), (xxx)
  • UPDATE Multiple Tables
  • DELETE Multiple Tables
• DDL
  • CREATE TABLE
  • ALTER
  • DROP
  • TRUNCATE
  • CREATE VIEW
  • CREATE INDEX
  • CREATE OR REPLACE
• TCL
  • SET
  • COMMIT
  • ROLLBACK
  • SAVEPONIT
  • BEGIN
• MySQL database administrator command
  • USE
  • SHOW DATABASES
  • SHOW TABLES
  • DESCRIBE & DESC

SQL Parse

• Lexer
• Standard Parser
• Multiple SQL Parser
• Duplicate Parentheses

SQL Rewrite

• LIMIT Offset Rewrite
• AVG To SUM/COUNT Rewrite
• ORDER BY Derived Columns Rewrite
• GROUP BY Derived Columns Rewrite
• INSERT Derived Primary Key Rewrite
• GROUP BY Only Optimized Rewrite

Route

• Standard Router
• Cartesian Router
• Unicast Router
• Broadcast Router
• Hint Router

Merge

• Streaming Merger
• Memory Merger
• Decorator Merger
• Metadata Merger

Sharding

• Databases
• Tables
• Default Data Source
• Broadcast Tables

Read-Write Split

• Read Write Split
• Consistent with Same Thread
• Force Hint Master Database
• Multiple Slaves Replica
• Multiple Masters Replica

Distribute Sequence

• Strategy API
• Snowflake algorithm

Orchestration

Registry Center

• Zookeeper
• Etcd
• Eureka

Dynamic configuration

• Dynamic Data Source
• Dynamic Sharding Strategy

Government

• Circuit breaker
• Enable/Disable Data Source
• Health Check
• LoadBalance
• Flow Limit
• Failover

APM

• Tracing Collector
• Open Tracing

BASE Transaction

Best Efforts Delivery

• Post DML event
• Transaction Journal Storage
• Synchronized Delivery
• Asynchronized Delivery

Try Confirm Cancel

• Post DML event
• Transaction Journal Storage
• Try
• Confirm
• Cancel

Operation Tool

Auto Scale Out

• Bin Log Parse
• Redo Log Parse
• Data Migration

Administrator Console

• Configuration Panel
• Runtime Control Panel
• Tracing Panel
• Metrics Panel
• RBAC