New features

1. Support session information synchronization mechanism
2. Support public cloud shared proxy CPU resource tenant isolation
3. Support random routing
4. Support specifying ip routing
5. Support to configure tenant isolation
6. Support OB_MYSQL_COM_STMT_RESET
7. Support Primary Zone routing
8. Fast fail-fast for request probes is supported. POC use only
9. Support text PS
10. Support OB_MYSQL_COM_RESET_CONNECTION
11. Support connection string ClusterId custom separator
12. Support non-Alibaba cloud environment, use remote ip as virtual ip
13. 【OB Sharding】Support SHOW INDEX FROM statement
14. 【OB Sharding】Support truncate syntax
15. 【OB Sharding】Support SHOW FULL TABLES statement
16. 【OB Sharding】SHOW KEYS FROM statement
17. 【OB Sharding】Support SHOW FULL COLUMNS statement
18. 【OB Sharding】When the scan_all switch is false, union and union all are supported;
19. 【OB Sharding】When the scan_all switch is true, union all is supported
20. 【OB Sharding】show table, show index, etc. support like syntax
21. 【OB Sharding】Limited support for subqueries
22. 【OB Sharding】Support to adjust the memory limit according to the container memory size
23. Turn off the default parameter for fast-fail request probes. Off by default
24. Adjust the whitelist policy, no longer use the client_ip sent by the client, and directly use the tcp peer IP

Improvements

1. Add max_used_connections to reduce log printing when client connection is disconnected
2. locality changes support all_dummy refresh
3. Intercept configuration table multi-row insertion
4. Compatible with MySQL 8.0, HandleShake Capability adds multi related value
5. Optimize partially duplicated logs

Bug fixes

1. Fix the memory problem caused by accessing internal tables and abnormally obtaining partition information
2. Fixed OB_MYSQL_COM_STMT_EXECUTE protocol, ref_cursor reported error fetch out of sequence under function
3. Fix the issue that the enable_client_ip_checkout parameter does not take effect when there is a connect attr parameter
4. Fix the Sharding scenario, the select table name of the sub-database and sub-table is case-sensitive, resulting in an error report
5. Fix the Sharding scenario, the select of sub-database and sub-table will be intercepted and unsupported syntax problem
6. Fixed an issue where a single SQL was sent multiple times, causing the SQL to take more than 40ms
7. Fix performance issues introduced by random partitions
8. Fix the problem of disconnection of changUser command under normal protocol
9. Fixed the problem that file systems such as xfs cannot accurately determine whether it is a directory using the readdir system call
10. Fix the problem that rslist startup fails more than 3 times and does not fall back to the original rslist
11. Fixed inaccurate sql routing caused by text PS escape symbols
12. Fix name super long text PS, prepare stage odp core
13. Fix text PS case insensitivity
14. Fix the error Unknown prepared statement handle when executing the text PS large request
15. Fix text PS date type route as partition key, text ps parameter routing is not allowed
16. Fix text PS trigger pl routing is not allowed
17. Fix text PS name contains illegal characters, execute error 1243
18. Fix the problem that user, value, etc. are used as keywords in lexical analysis
19. Fixed the problem that SSL cannot be used for the link between Client and Proxy
20. 【OB Sharding】Fixed that the hint with partition key cannot calculate the partition key when inserting
21. 【OB Sharding】Fixed that if the partition key is after the 64th column in the insert statement, it will report that it cannot be calculated
22. 【OB Sharding】Fix the problem of disconnection of sequence query
23. 【OB Sharding】Fix the core caused by not supporting sum(case when) in the function
24. When hot restart, if the old connection receives the COM_PING command, the old Proxy will actively disconnect the connection
25. 【OBSharding】 Fix the syntax parsing problem of delete and update