MySQL5.6升级5.7步骤
升级步骤:
1、对mysql5.6进行全库备份(******)用于失败倒回2、关闭mysql5.6版本数据库
3、将mysql5.7软件部署
4、修改配置信息
5、修改启动脚本
6、启动mysql5.7数据库
7、mysql_upgrade升级数据库相关参数
8、重启数据库,测试升级结果
首先对数据库进行物理备份,利用Percona Xtrabackup.
关闭5.6的数据库
安装5.7的二进制安装包.
修改/etc/profile 改变环境变量指向5.7.执行source /etc/profile 生效
编辑5.7的system启动文件
[Unit]Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
ExecStart=/data/app/mysql/bin/mysqld --defaults-file=/mysql/3306/my.cnf
LimitNOFILE = 5000
启动数据库
systemctl start mysqld
使用mysql_upgrade 检查
[root@db01 ~]# mysql_upgrade -S /mysql/mysql.sockChecking if update is needed.
Checking server version.
Running queries to upgrade MySQL server.
Checking system database.
mysql.columns_priv OK
mysql.db OK
mysql.engine_cost OK
mysql.event OK
mysql.func OK
mysql.general_log OK
mysql.gtid_executed OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.innodb_index_stats OK
mysql.innodb_table_stats OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.server_cost OK
mysql.servers OK
mysql.slave_master_info OK
mysql.slave_relay_log_info OK
mysql.slave_worker_info OK
mysql.slow_log OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
Upgrading the sys schema.
Checking databases.
sys.sys_config OK
world.city OK
world.country OK
world.countrylanguage OK
Upgrade process completed successfully.
Checking if update is needed.
重启数据库
[root@db01 ~]# systemctl restart mysqld[root@db01 ~]# netstat -lntp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 8902/sshd
tcp 0 0 127.0.0.1:5432 0.0.0.0:* LISTEN 8912/postmaster
tcp6 0 0 :::3306 :::* LISTEN 10347/mysqld
tcp6 0 0 :::22 :::* LISTEN 8902/sshd
tcp6 0 0 ::1:5432 :::* LISTEN 8912/postmaster
以上是 MySQL5.6升级5.7步骤 的全部内容, 来源链接: utcz.com/z/533463.html