Official announcement! Apache ShardingSphere 5.0.0 is officially released

November 10th is the third anniversary of Apache ShardingSphere's entry into the Apache Foundation. On this special day, we are very pleased to announce that Apache ShardingSphere has ushered in the official release of the 5.0.0 GA version. After nearly two years of optimization and polishing, ShardingSphere 5.0.0 GA version officially opened a new stage with a pluggable architecture as the core, realizing the comprehensive data governance from a single application scenario of data fragmentation in the past to a complex application environment. Identity change and ability improvement.

5.0.0 The specific version release information is as follows:

1 New feature

• Support annotation analysis
• Elastic scaling: initial support for openGauss
• Elastic scaling: increase the SPI interface of the detection algorithm for whether the incremental synchronization has been completed
• Elastic scaling: add data verification algorithm SPI interface
• Elastic scaling: automatic table creation before migration basically supports MySQL and openGauss
• Elastic scaling: more complete integration with proxy, support for automatic switch configuration after migration
• Elastic scaling: provide more DistSQL support, data verification, switch configuration, etc.
• Elastic scaling: support DistSQL to automatically trigger migration
• Added DistSQL syntax: Shadow rule management
• Added DistSQL syntax: flexible scaling task management
• Added DistSQL syntax: Proxy instance fuse
• Added DistSQL syntax: Disable read-write separation and read library
• Added DistSQL syntax: ALTER RESOURCE
• Added DistSQL syntax: DROP SHARDING ALGORITHM
• Added DistSQL syntax: CREATE SHARDING ALGORITHM
• Added DistSQL syntax: CREATE DEFAULT SHARDING [TABLE | DATABASE] STRATEGY
• Added DistSQL syntax: SHOW ALL VARIABLES
• Added DistSQL syntax: SHOW VARIABLE variableName;
• Proxy supports openGauss

2 API changes

• ShardingSphere-JDBC adds schema name configuration
• Add default shard key configuration
• The default authority provider is adjusted from NATIVE to ALL_PRIVILEGES_PERMITTED
• SCTL grammar adjustment, merged with DistSQL RAL grammar
• SHOW RESOURCES DistSQL adjusted to SHOW SCHEMA RESOURCES
• Shadow library pressure test: remove shadow logical fields and support shadow algorithm

3 enhanced

• Metadata reconstruction and performance improvement
• Support MySQL union/union all statement parsing
• Support PostgreSQL ABORT statement
• Support PostgreSQL CREATE INDEX statement to automatically generate indexes when no index is specified
• Support SQL statement execution with logical schema
• Support binding table configuration with different shard keys
• ShardingSphere kernel performance optimization
• Proxy supports queries to some information_schema tables to optimize client connection experience
• DistSQL supports using quotation marks to use keywords as parameter names
• The password in the ADD RESOURCE statement supports special characters
• ADD RESOURCE supports custom JDBC parameters and connection pool properties
• DROP RESOURCE supports the optional parameter ignore single tables, which is used to ignore single table rule restrictions
• Support to use DistSQL to create sharding table rule based on read-write separation rules
• SHOW DATABASES statement supports like syntax
• CREATE SHARDING TABLE RULE supports using inline expressions to specify resources
• CREATE SHARDING TABLE RULE supports the use of dataNodes to configure fragmentation
• CREATE SHARDING TABLE RULE supports reuse of existing algorithms
• SET VARIABLE, support to modify Proxy configuration
• Complete PostgreSQL protocol (support Portal, unspecified type of data, etc.)
• Proxy supports switching Netty thread pool to improve performance in some scenarios
• The fetch size of the interaction between the proxy and the database is configurable
• Elastic scaling: perfect support for PostgreSQL
• Elastic scaling: data verification supports parallel computing at the source and target ends

4 Refactoring

• Refactor SingleTable function to support Encrypt multiple data sources
• Refactor the examples and adjust the module structure
• Adjust the persistent data structure of the registry node
• Elastic scaling: Refactoring whether the incremental synchronization has been completed and the detection algorithm is implemented by default
• Elastic scaling: the default implementation of the reconstruction data verification algorithm
• Elastic scaling: remove HTTP API and independent packaging
• Shadow library stress test: remove DML rewrite process
• Shadow library pressure test: support DDL routing

5 bug fix

• Fix INTERVAL fragmentation algorithm problem
• Repair SHOW INDEX FROM TABLE FROM TABLE statement rewriting exception
• Fix Encrypt multi-table association rewrite exception
• Fix the subquery index out of range exception
• Repair Oracle paging exception
• Fix the rewrite exception when KeyGenerateStrategy is not configured in the Sharding scenario
• Fix Oracle dialect case leading to abnormal federation execution engine
• Fix the rewriting exception when Sharding/Encrypt is integrated and used
• Fix the problem of abnormal Oracle metadata loading
• Fix the problem that the SHOW RESOURCES statement cannot display custom attributes
• Fix the problem that SQL execution exception does not throw
• Fix Etcd cannot send node new events
• Fixed an issue where data rows containing null values may be lost in the query results of PostgreSQL Proxy
• Fix the problem that the order of PostgreSQL metadata columns may be out of order
• Fix the problem that the Proxy character encoding may be incorrect

🔗Download link: https://shardingsphere.apache.org/document/current/cn/downloads/

🔗Update log: https://github.com/apache/shardingsphere/blob/master/RELEASE-NOTES.md

🔗Project address: https://shardingsphere.apache.org/

6 Community Construction

The release of Apache ShardingSphere 5.0.0 is inseparable from the support and contributions of community users. During the total of 168 Contributors submitted 4468 PR to help the full release of the ShardingSphere 5.0.0 version. Thanks to the community partners for their strong support.

Once again, everyone is welcome to test using ShardingSphere 5.0.0 , and welcome everyone to participate in the community discussion!