1. 28 10月, 2022 1 次提交
    • 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