Skip to content

Latest commit

 

History

History
194 lines (166 loc) · 3.44 KB

ROADMAP.md

File metadata and controls

194 lines (166 loc) · 3.44 KB

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