Skip to content

v4.0.0
Compare
Choose a tag to compare
@LINxiansheng LINxiansheng released this 01 Nov 06:28
· 51 commits to master since this release
v4.0.0
9d5c90e

About this version

Item Description
Release time 2021-11-01
Release number V4.0.0
Commit number 9d5c90e

New features

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

Improvements

  • Add max_used_connections to reduce log printing when client connection is disconnected
  • locality changes support all_dummy refresh
  • Intercept configuration table multi-row insertion
  • Compatible with MySQL 8.0, HandleShake Capability adds multi related value
  • Optimize partially duplicated logs
  • Whitelist optimization, telnet detection directly disconnects

Bug fixes

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

版本信息

名称 描述
发布时间 2022 年 11 月 01 日
版本号 v4.0.0
提交号 9d5c90e

功能

  • 支持 session 信息同步机制
  • 支持公有云共享代理 CPU 资源租户隔离
  • 支持 随机路由
  • 支持 指定 ip 路由
  • 支持 配置租户隔离
  • 支持 OB_MYSQL_COM_STMT_RESET
  • 支持 Primary Zone 路由
  • 支持 请求探测快速失败。仅限 POC 使用
  • 支持 文本 PS
  • 支持 OB_MYSQL_COM_RESET_CONNECTION
  • 支持 连接串 ClusterId 自定义分隔符
  • 支持非阿里云环境，使用 remote ip 作为 virtual ip
  • 【OB Sharding】支持 SHOW INDEX FROM 语句
  • 【OB Sharding】支持 truncate 语法
  • 【OB Sharding】支持 SHOW FULL TABLES 语句
  • 【OB Sharding】SHOW KEYS FROM 语句
  • 【OB Sharding】支持 SHOW FULL COLUMNS 语句
  • 【OB Sharding】scan_all开关是 false 的时候，支持 union、union all；
  • 【OB Sharding】scan_all开关是 true 的时候，支持 union all
  • 【OB Sharding】show table 、show lndex 等支持like 语法
  • 【OB Sharding】有限支持子查询
  • 【OB Sharding】支持根据容器内存大小调整内存上限
  • 关闭 请求探测快速失败 的默认参数。默认关闭
  • 调整白名单策略，不再使用客户端传过来的client_ip，直接使用tcp对端IP

优化

  • 客户端连接断开时，添加 max_used_connections 减少的日志打印
  • locality变更支持all_dummy刷新
  • 拦截配置表多行插入
  • MySQL 8.0 兼容，HandleShake Capability 新增 multi 相关值
  • 优化部分重复日志
  • 白名单优化，telnet 探测直接断连接

BUG修复

  • 修复访问内部表，异常获取分区信息导致的内存问题
  • 修复 OB_MYSQL_COM_STMT_EXECUTE 协议，ref_cursor 在function下报错fetch out of sequence 的问题
  • 修复 enable_client_ip_checkout 参数在有 connect attr 参数时不生效的问题
  • 修复 Sharding 场景，分库分表的 select 表名区分大小写，导致的报错问题
  • 修复 Sharding 场景，分库分表的 select 会被拦截不支持的语法问题
  • 修复 单条SQL 多次发送，导致的 SQL 耗时超过 40ms 问题
  • 修复随机分区引入的性能问题
  • 修复 changUser 命令在普通协议下断连接问题
  • 修复 xfs 等文件系统使用 readdir 系统调用无法准确判断是否为目录的问题
  • 修复 rslist 方式启动，失败超过3次，没有回退到原始 rslist 的问题
  • 修复文本 PS 转义符号引起的sql路由不准
  • 修复名字超长文本 PS ，prepare阶段odp core
  • 修复文本 PS 大小写不敏感
  • 修复文本 PS large request 中执行报错Unknown prepared statement handle
  • 修复文本 PS date 类型路由作为分区键，文本ps传参路由不准
  • 修复文本 PS 触发pl路由不准
  • 修复文本 PS 名字中含有非法字符，execute报错1243
  • 修复词法解析中把user、value等作为关键字的问题
  • 修复 Client 与 Proxy 链路无法使用 SSL 问题
  • 【OB Sharding】修复带分区键的 hint 在 insert 的时候， 无法计算分区键
  • 【OB Sharding】修复 insert 语句如果分区键在第 64 个列之后，会报无法计算
  • 【OB Sharding】修复 sequence查询断连的问题
  • 【OB Sharding】修复函数中不支持sum(case when)导致的core
  • 修复 热重启时，如果老连接接收到 OB_MYSQL_COM_PING 命令，老 Proxy 会主动断开连接的问题
  • 【OB Sharding】修复 delete 和 update 的语法解析问题
Assets 6
Loading