MySQL 8.3 发布, 它带来哪些新变化？

数据运维 2024-01-22 大树手机阅读

1月16号 MySQL 官方发布 8.3 创新版和 8.0.36 长期支持版本 (该版本没有新增功能，更多是修复bug )，本文基于官方文档说一下 8.3 版本带来的变化。

一增加的特性

1.1 GTID_NEXT 支持增加 TAG 选项。

之前的版本中 GTID_NEXT=UUID:number ，现在可以增加一个 tag 字符串 GTID_NEXT=UUID:[TAG]:number ，用来对事务进行标示。具体的用例如下:

mysql> show master status \G *************************** 1. row *************************** File: mysql-bin.000001 Position: 158 Binlog_Do_DB: Binlog_Ignore_DB: Executed_Gtid_Set: 1 row in set, 1 warning (0.00 sec) mysql> insert into t(a) values(2); Query OK, 1 row affected (0.00 sec) mysql> show master status \G *************************** 1. row *************************** File: mysql-bin.000001 Position: 435 Binlog_Do_DB: Binlog_Ignore_DB: Executed_Gtid_Set: 00008300-0000-0000-0000-000000008300:1 1 row in set, 1 warning (0.00 sec) ### 在会话级别设置 gtid_next 的值 mysql> set session gtid_next='00008300-0000-0000-0000-000000008300:yangyidba:3'; Query OK, 0 rows affected (0.00 sec) mysql> insert into t(a) values(2); Query OK, 1 row affected (0.00 sec) mysql> show master status \G *************************** 1. row *************************** File: mysql-bin.000001 Position: 722 Binlog_Do_DB: Binlog_Ignore_DB: Executed_Gtid_Set: 00008300-0000-0000-0000-000000008300:1:yangyidba:3 ## 变成系统值和手工指定的2个值的结合 1 row in set, 1 warning (0.00 sec) mysql> insert into t(a) values(2); Query OK, 1 row affected (0.00 sec) mysql> show master status \G *************************** 1. row *************************** File: mysql-bin.000001 Position: 995 Binlog_Do_DB: Binlog_Ignore_DB: Executed_Gtid_Set: 00008300-0000-0000-0000-000000008300:1:yangyidba:1:3 1 row in set, 1 warning (0.00 sec) mysql> set session gtid_next='00008300-0000-0000-0000-000000008300:yangyidba:2'; Query OK, 0 rows affected (0.00 sec) mysql> insert into t(a) values(2); Query OK, 1 row affected (0.00 sec) mysql> show master status \G *************************** 1. row *************************** File: mysql-bin.000001 Position: 1296 Binlog_Do_DB: Binlog_Ignore_DB: Executed_Gtid_Set: 00008300-0000-0000-0000-000000008300:1:yangyidba:1-3 1 row in set, 1 warning (0.00 sec) mysql> set session gtid_next='AUTOMATIC'; Query OK, 0 rows affected (0.00 sec) mysql> insert into t(a) values(2); Query OK, 1 row affected (0.00 sec) mysql> show master status \G *************************** 1. row *************************** File: mysql-bin.000001 Position: 1296 Binlog_Do_DB: Binlog_Ignore_DB: Executed_Gtid_Set: 00008300-0000-0000-0000-000000008300:1-2:yangyidba:1-3 1 row in set, 1 warning (0.00 sec)