Shulou(Shulou.com)06/01 Report--

First, reasons for upgrading

Because of the version of bug, DB is often crash. This may be due to problems with innodb's adoption of new statistics collection.

Related web page: 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 and one slave

Start using MariaDB,systemd installed in rpm yum mode.

III. Upgrade steps

1. Download the rpm package MariaDB 10.1.26 on the official website and decompress it to the server.

2. Close the slave database

# systemctl stop mysql

3. Copy a data catalog if conditions permit

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 and start the database

7. Execute mysql_upgrade

# mysql_upgrade-uroot-p

8. Restore the main library in the same way.

The above methods are only applicable to the state where the service is allowed to be down for a few minutes. There is no technical content, the official upgrade plan: https://mariadb.com/kb/en/mariadb/upgrading-between-minor-versions-of-mariadb/

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.