使用之前的 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,具体如下:
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 不影响任何使用,如果要避免,可以按照日志提示将相关参数用新参数替换即可。