-
Notifications
You must be signed in to change notification settings - Fork 205
upgrade v2.2303.0 to v2.2304.0 #1486
ColdWaterLW
started this conversation in
Upgrade
-
版本升级方案
老版本升级到2.2304.0 需要对SQLE的元数据表进行结构变更,变更内容如下:
表execute_sql_detail和audit_plan_report_sqls_v2的列audit_result弃用,新增列audit_results,新的列相比旧的列变化如下:
- 该列的类型由TEXT类型变更为JSON类型
- 该列的内容由普通文本字符串变更为JSON字符串,举例:
变更前:
[error]除了自增列及大字段列之外,每个列都必须添加默认值\n[error]新建表必须加入 if not exists,保证重复执行不报错
变更后:
[{"rule_name":"ddl_check_column_without_default","level":"error","message":"除了自增列及大字段列之外,每个列都必须添加默认值"},{"rule_name":"ddl_check_table_without_if_not_exists","level":"error","message":"新建表必须加入 if not exists,保证重复执行不报错"}]升级说明
- 由于改动较大,无法直接使用SQL进行改表升级,因此本次升级使用升级工具进行,升级工具在 release 内下载,文件名
sqle-upgrade-2303-2304 - 建议在升级前备份SQLE业务库,然后执行升级脚本upgrade-tool-2303-2304。
升级工具的使用
1. 工具参数如下:
Usage: upgrade-2303-2304 [flags] Flags: -h, --help help for upgrade-2303-2304 --mysql-host string mysql host (default "localhost") --mysql-password string mysql password (default "sqle") --mysql-port string mysql port (default "3306") --mysql-user string mysql user (default "sqle") --schema string schema for sqle (default "sqle")
2. 示例:
./sqle-upgrade-2303-2304 \
--mysql-user {your_user} \
--mysql-password {your_pass} \
--mysql-host {your_mysq_host} \
--mysql-port {your_mysql_port} \
--schema sqle版本不兼容的 issue 列表
Beta Was this translation helpful? Give feedback.
All reactions
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment