• W
    New features · 9d5c90e5
    Wesley Wang 提交于
    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
    9d5c90e5
ob_errno.cpp 188.9 KB