mysql 3节点MGR升级_2023-06-22t09:49:52.698z-优快云博客

本文链接：https://blog.youkuaiyun.com/u013469501/article/details/114406406

这篇博客记录了MySQL 3节点MGR（Group Replication）从8.0.16到8.0.17的升级过程。在升级过程中，详细展示了节点的日志输出，包括数据字典升级、表不存在的错误以及组复制的启动状态。最终成功完成升级并确认组成员信息。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

mysql 3节点mgr升级

mgr1:备节点，mgr2:主节点，mgr3:备节点（先升级mgr1和mgr3）

升级目标：8.0.16--->8.0.17

升级过程中，mgr1节点的mysqld1.log日志输出如下：

2021-03-06T09:49:35.822817Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2021-03-06T09:49:35.823178Z 0 [System] [MY-010116] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.17) starting as process 4522
2021-03-06T09:49:36.431349Z 1 [System] [MY-011090] [Server] Data dictionary upgrading from version '80016' to '80017'.
2021-03-06T09:49:38.408197Z 1 [System] [MY-013413] [Server] Data dictionary upgrade from version '80016' to '80017' completed.
mysqld: Table 'information_schema.TABLES' doesn't exist
mysqld: Table 'information_schema.ROUTINES' doesn't exist
mysqld: Table 'information_schema.TABLES' doesn't exist
mysqld: Table 'information_schema.TABLES' doesn't exist
mysqld: Table 'information_schema.TRIGGERS' doesn't exist
mysqld: Table 'performance_schema.threads' doesn't exist
mysqld: Table 'performance_schema.threads' doesn't exist
mysqld: Table 'performance_schema.threads' doesn't exist
mysqld: Table 'performance_schema.threads' doesn't exist
mysqld: Table 'performance_schema.threads' doesn't exist
mysqld: Table 'performance_schema.threads' doesn't exist
mysqld: Table 'performance_schema.accounts' doesn't exist
mysqld: Table 'performance_schema.accounts' doesn't exist
mysqld: Table 'performance_schema.threads' doesn't exist
mysqld: Table 'performance_schema.threads' doesn't exist
mysqld: Table 'performance_schema.accounts' doesn't exist
mysqld: Table 'perfor