Skip to content

v5.4.19

Latest
Compare
Choose a tag to compare
@lulu2panpan lulu2panpan released this 30 Apr 01:23
· 9 commits to main since this release

新功能&优化

  1. 主从DDL复制新增支持针对function类型的复制
  2. 主从DDL复制新增支持针对sequence类型的复制
  3. 主从DDL复制新增支持针对view类型的复制
  4. 主从DDL复制新增支持针对procedure类型的复制
  5. 主从DDL复制新增支持针对账号、角色和权限类型的复制
  6. 主从DDL复制新增支持针对alter tablegroup类型的复制
  7. 主从DDL复制新增支持针对alter index类型的复制
  8. 主从DDL复制新增支持针对多流binlog场景下的一致性协调对齐复制
  9. 主从复制新增支持按时间戳创建复制链路能力
  10. 主从复制新增通过SQL命令校验上下游数据一致性的能力
  11. 主从复制新增从实例角色,Slave集群具备实例级只读的能力
  12. 主从复制性能优化,单链路rps从3w/s提升至5w/s
  13. 主从复制完善基于server_id的双向复制能力,新增命令行指定过滤规则和server_id异常自检能力
  14. 主从复制DML写入支持where条件全镜像匹配能力
  15. 多流binlog支持binlog stream name和user name绑定,使用绑定账号执行binlog相关SQL时,无需增加with选项

Bug修复

  1. 修复multi alter add/drop column语句导致元数据列序错误,进而导致的binlog链路中断问题
  2. 修复multi alter add/drop/rename index语句导致元数据丢失索引,进而导致binlog中记录错误DDL SQL的问题
  3. 修复meta_build_physical_ddl_sql_blacklist_regex参数存在配置缺陷,导致alter ddl sql包含user关键字时ddl被过滤问题
  4. 修复drop index ddl sql无法输出到binlog问题

New Features & Optimizations

  1. Master-slave DDL replication now supports the replication of the function type.
  2. Master-slave DDL replication now supports the replication of the sequence type.
  3. Master-slave DDL replication now supports the replication of the view type.
  4. Master-slave DDL replication now supports the replication of the procedure type.
  5. Master-slave DDL replication now supports the replication of accounts, roles, and permission types.
  6. Master-slave DDL replication now supports the replication of the alter table group type.
  7. Master-slave DDL replication now supports the replication of the alter index type.
  8. Master-slave DDL replication now supports consistency coordination alignment replication in scenarios with multiple stream binlogs.
  9. Master-slave replication now supports creating replication links by timestamp.
  10. Master-slave replication now supports the ability to verify data consistency between upstream and downstream through SQL commands.
  11. Master-slave replication now adds instance-level read-only capabilities for slave clusters from the instance role.
  12. Performance optimization for master-slave replication, with single-link rps increased from 30k/s to 50k/s.
  13. Master-slave replication enhances two-way replication capability based on server_id, adding command-line specified filtering rules, and server_id anomaly self-check capability.
  14. Master-slave replication DML write supports full mirror matching capability with where conditions.
  15. Multi-stream binlog supports binding of binlog stream name and user name; executing binlog-related SQL with the bound account does not require an additional with option.

Bug Fixes

  1. Fixed the issue where multi alter add/drop column statements caused metadata column sequence errors, which led to the interruption of binlog links.
  2. Fixed the issue where multi alter add/drop/rename index statements caused loss of metadata indexes, which led to errors in DDL SQL recordings in binlogs.
  3. Fixed the configuration defect in the meta_build_physical_ddl_sql_blacklist_regex parameter, which caused DDLs containing the user keyword to be filtered when altering DDL SQL.
  4. Fixed the problem that drop index ddl sql could not be output to binlog.