MARIADB Minor Version upgrade 10.1.22-10.1.26

First, the reason for the upgrade

DB is often crash because of version bugs. The reason may be that the INNODB uses new statistical information collection issues.

Related pages: https://jira.mariadb.org/browse/MDEV-12281

https://bugs.mysql.com/bug.php?id=84940

Second, upgrade the environment

Linux:centos 7

Architecture: one Master one from

The MARIADB,SYSTEMD boot is installed using the RPM Yum method.

Third, upgrade steps

1, download mariadb 10.1.26 rpm package, unzip to the server

2. Close the database

# systemctl Stop MySQL

3, the condition allows, the copy of a data directory

4. Backup configuration file My.cnf

5. Upgrade version

# yum Install mariadb-10.1.26-centos7-x86_64-server.rpm mariadb-10.1.26-centos7-x86_64-client.rpm mariadb-10.1.26-centos7-x86_64-common.rpm mariadb-10.1.26-centos7-x86_64-shared.rpm

6, restore the configuration file my.cnf, start the database

7, the implementation of Mysql_upgrade

# mysql_upgrade-uroot-p

8, the same way, restore the main library.

The above method only applies to the state of the service allowing a few minutes of downtime. No technical content, official upgrade program: https://mariadb.com/kb/en/mariadb/upgrading-between-minor-versions-of-mariadb/

This article is from the "11570138" blog, please be sure to keep this source http://11580138.blog.51cto.com/11570138/1956408

MARIADB Minor Version upgrade 10.1.22-10.1.26