Apache ShardingSphere 5.0.0-beta Release and Features

Release Features:

1. Highlight Features

DistSQL — A New SQL Type for a Distributed Database Ecosystem

  • RDL (Resource & Rule Definition Language): create, modify and delete resources and rules.
  • RQL (Resource & Rule Query Language): query and show resources and rules.
  • SCTL (ShardingSphere Control Language): hint, distributed transaction switching, distributed query execution plan and other incremental functions.

Full Join PostgreSQL Open-Source Ecosystem

ShardingSphere Pluggable Architecture

2. New Features

New Open Observability

3. Enhancements

Enhanced Distributed Query Capability

Enhanced Distributed User and Privilege Control

Simplified API Changes Capabilities

4. Other Features

Performance Improvements: Optimized Metadata Loading Performance

Usability: New Performance Testing System

Other New Features:

  1. New DistSQL for loading and presenting ShardingSphere’s configuration.
  2. Support for join queries and sub-queries across different databased instances.
  3. Data gateway is added to support heterogeneous databases.
  4. Support create and modify user permission online or dynamically.
  5. New automated probes module.

API Changes:

  1. API in read and write splitting module configuration changed to read-write-splitting.
  2. API for ShardingProxy user permission configuration changed to Authority.
  3. Using dataSourceClassName to optimize the dataSource configuration of ShardingJDBC.
  4. Automated ShardingTable configuration strategy, provide standard built-in shard table.
  5. Removed ShardingProxy acceptor-size configuration option.
  6. Added built-in shard algorithm SPI so users can set up the shard algorithm through class name like in the version 4.x.


  1. Startup metadata loading performance has been significantly improved.
  2. Greatly enhanced the parsing abilities for Oracle/SQLServer/PostgreSQL database.
  3. Supporting initialization of the user permission MySQL/PostgreSQL/SQLServer/Oracle.
  4. Supporting DDL language for data encryption.
  5. When sharding and encryption are used together, SQL is supported for modifying the table named owner.
  6. Using SELECT* to rewrite SQL, overwrite columns to add escape characters to avoid column conflicts with keywords.
  7. Supporting PostgreSQL JSON/JSONB/ for pattern matching operator parsing.
  10. Supporting PostgreSQL EXPLAIN.
  11. Supporting PostgreSQL START/END TRANSACTION.
  12. Supporting PostgreSQL ALTER/DROP INDEX.
  13. Supporting PostgreSQL dialect CREATE TABLESPACE.
  15. Supporting MySQL/PostgreSQL ALTER TABLE RENAME.
  16. Supporting PostgreSQL protocol Close command.


  1. New registry storage structure.
  2. Removed support for NACOS and Apollo’s Configuration Centre.
  3. ShardingScaling introduces ElasticJob to handle migration tasks.
  4. Refactoring the storage and online update of the kernel metadata information.

Bug fixes:

  1. Fixed issue where SELECT * wildcard SQL could not be used for read/write separation.
  2. The custom sharding algorithm did not match the configuration type and the class instance did not meet expectations issue is fixed.
  3. Fixed the NoSuchTableException when executing DROP TABLE IF EXISTS.
  4. Fixed UPDATE … SET … rewrite error.
  5. Fixed CREATE/ALTER TABLE statement using foreign key to reference TABLE overwrite error.
  6. Fixed the issue when querying subqueries in the temporal table field verification exception.
  7. Fixed Oracle/SQL92 SELECT … WHERE … LIKE class cast exception.
  8. Fixed MySQL SELECT EXISTS … FROM … parsing exception.
  9. Fixed SHOW INDEX result exception.
  10. Fixed the rewrite and merge result exception for SELECT… GROUP BY …
  11. Fixed the encryption and decryption error for CREATE TABLE rewrite.
  12. Fixed issue with PostgreSQL Proxy reading text parameter values incorrectly.
  13. Fixed PostgreSQL Proxy support for array objects.
  14. Fixed ShardingProxy Datatype conversion issues.
  15. PostgreSQL Proxy supports the use of the Numeric type.
  16. Fixed the issue with incorrect Tag for PostgreSQL Proxy transactions related to Command Complete.
  17. Fixed the issue that might return packets that were not expected by the client.

Community Contribution:



Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Apache ShardingSphere

Apache ShardingSphere

Transform any DBMS in a distributed database system & enhance it with sharding, elastic scaling features & more. https://linktr.ee/ApacheShardingSphere