apache/shardingsphere 5.0.0-alpha

on GitHub

5.0.0-alpha

New Feature

1. The pluggable architecture is available and support function extension through the SPI.
2. Independent SQL parsing engine is available to get SQL parsed AST for the different database dialects.
3. New RDL feature for ShardingSphere Proxy supports creating sharding rules and sharding tables.
4. ShardingSphere-Scaling supports resuming data migration from break-point.
5. ShardingSphere-Scaling supports using ShardingSphere JDBC to migrate data to new cluster.
6. ShardingSphere shadow database is available.

API Changes

1. New sharding/encryption/shadow/queryReplica API.
2. New sharding algorithm and strategy API.
3. New API for ShardingSphere Scaling to create task.
4. Remove DefaultDataSourceName setting item.
5. The separator of the parameter configuration item is changed from - the dot ‘.’ to minus sign ‘-’.
6. Change parameter allow.range.query.with.inline.sharding from global parameter to sharding algorithm parameter.

Refactor

1. Refactor the architecture of SQL parsing module base on the database dialects.
2. Use SPI mechanism to reconstruct online metadata change processing.
3. Rename Orchestration module to Governance module.
4. Rename MasterSlave module to QueryReplica module.
5. Refactor the metadata structure in the governance registration center.
6. Refactor GovernmentShardingSphereDataSource.
7. ShardingSphere UI merges configuration center and registration center display layout.

Enhancement

1. Upgrade the minimum supported version of JDK to Java8.
2. Update Zookeeper curator to version 5.1.0.
3. Update Google Guava to version 29.0-jre.
4. The enhancement for MySQL SQL syntax definition and parsing process.
5. The enhancement for PostgreSQL syntax definition and parsing process.
6. The enhancement for sub-queries in different database dialects.
7. Support MySQL view operations for non-sharding tables
8. Support MySQL stored functions and procedure operations for non-sharding tables.
9. Support SQLServer Top syntax.
10. Optimize the metadata loading to improve the startup speed.
11. Optimize batch insert performance.
12. Supports the use of Oracle RAC JDBC URL.
13. XA transaction manager adds support for Oracle database.
14. ShardingSphere Proxy supports the use of p6sy driver.
15. Add help information to the ShardingSphere Proxy startup script.

Bug fixes

1. Fix alias rewriting error when processing OrderBy condition.
2. Fix SQL rewriting error when MYSQL Insert statement contains expression.
3. Fix parameter calculation error in update on duplicate SQL.
4. Fix generatedKeys gets wrong when batch inserting.
5. Fix the abnormal issue of multi-table verification in DML statement update operation.
6. Fix the NPE problem caused by executing SQL when the table does not exist.
7. Fix the exception when using the Show table command for an unconfigured table.
8. Fix metadata loading error when Oracle database has multiple qualified users.
9. Fix the issue that replica node cannot be enabled online.
10. Fix the problem that ShardingSphere-JDBC does not support PostgreSQL array type.
11. Fix the problem that ShardingSphere-Proxy does not respond when querying long blob data.