MySQL 8.0.26 之后数据库参数变化

使用之前的 MySQL 8.0 的参数文件安装完成 8.0.26 之后发现数据库日志报了 The syntax ‘log_slave_updates’ is deprecated and will be removed in a future release. Please use log_replica_upda tes instead. 等一堆 Warning,具体如下:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
2022-05-05T10:15:13.061219+08:00 0 [Warning] [MY-011068] [Server] The syntax 'log_slave_updates' is deprecated and will be removed in a future release. Please use log_replica_upda
tes instead.
2022-05-05T10:15:13.061237+08:00 0 [Warning] [MY-011068] [Server] The syntax 'log_slow_slave_statements' is deprecated and will be removed in a future release. Please use log_slow
_replica_statements instead.
2022-05-05T10:15:13.061271+08:00 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2022-05-05T10:15:13.061309+08:00 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2022-05-05T10:15:13.061346+08:00 0 [Warning] [MY-011068] [Server] The syntax 'slave_net_timeout' is deprecated and will be removed in a future release. Please use replica_net_time
out instead.
2022-05-05T10:15:13.061361+08:00 0 [Warning] [MY-011068] [Server] The syntax 'slave_parallel_type' is deprecated and will be removed in a future release. Please use replica_parall
el_type instead.
2022-05-05T10:15:13.061377+08:00 0 [Warning] [MY-011068] [Server] The syntax 'slave_parallel_workers' is deprecated and will be removed in a future release. Please use replica_par
allel_workers instead.
2022-05-05T10:15:13.061392+08:00 0 [Warning] [MY-011068] [Server] The syntax 'slave_preserve_commit_order' is deprecated and will be removed in a future release. Please use replic
a_preserve_commit_order instead.
2022-05-05T10:15:13.061409+08:00 0 [Warning] [MY-011069] [Server] The syntax '--slave-rows-search-algorithms' is deprecated and will be removed in a future release.
2022-05-05T10:15:13.061424+08:00 0 [Warning] [MY-011068] [Server] The syntax 'slave_transaction_retries' is deprecated and will be removed in a future release. Please use replica_
transaction_retries instead.

毕竟是生产环境,数据库日志报一堆告警也是要处理下,经过查看官方文档 https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-26.html#mysqld-8-0-26-feature 发现从 8.0.26 之后,进行了一些修改。这早在 Jul 1, 2020 MySQL 的官方博客就有了说明:MySQL Terminology Updates https://dev.mysql.com/blog-archive/mysql-terminology-updates/

此 Warning 不影响任何使用,如果要避免,可以按照日志提示将相关参数用新参数替换即可。

原文作者: liups.com

原文链接: http://www.liups.com/posts/c9dd7259/

许可协议: 知识共享署名-非商业性使用 4.0 国际许可协议