CentOS6.x upgrade MySQL 5.1 to 5.6
Some virtual machines and cloud host providers still use the old version of the installation suite. The pre-installed application software version is very low. Some IDCs use ECs instances. The pre-installed MySQL version is 5.1.x. The newer MySQL 5.6 has made many improvements in performance, functionality, and security.
To benefit from the latest version, you need to upgrade the existing system to 5.5 + (the latest version is 5.7). I keep it conservative and upgrade it to 5.6.20.
The test data is explained from 5.1 to 5.5 +, and the MySQL performance will be significantly improved. You need to establish a test environment to practice it yourself.
1. Update rpm first
Download the latest rpm file from the MySQL Yum Repository: http://dev.mysql.com/downloads/repo/yum/
(You need an Oracle account and some usage information to go To the download page)
What I need to download is: mysql-community-release-el6-5.noarch.rpm
2. Install this release package
> Yum localinstall mysql-community-release-el6-5.noarch.rpm
You can run the following command to confirm that the repository has been successfully added:
Yum repolist enabled | grep "mysql. *-community .*
3. Install the MySQL server
> Yum install mysql-community-server
The target file of the new version is/usr/bin/mysql. If the original pre-installed path is under/bin, replace it with a soft link, for example, ln-s/usr/bin/mysql/bin/
In this way, you can easily switch between different versions as needed. (Sometimes version rollback is required to locate the problem)
4. Restart the server.
> Service mysqld restart
Confirm version information:
[Root @ west195246 bin] # mysql-V
Mysql Ver 14.14 Distrib 5.6.20, for Linux (x86_64) using EditLine wrapper
Refer:
Http://dev.mysql.com/doc/refman/5.6/en/linux-installation-yum-repo.html#yum-repo-setup
Http://dev.mysql.com/doc/refman/5.6/en/replace-third-party-yum.html
-------------------------------------- Split line --------------------------------------
Install MySQL in Ubuntu 14.04
MySQL authoritative guide (original book version 2nd) Clear Chinese scan PDF
Ubuntu 14.04 LTS install LNMP Nginx \ PHP5 (PHP-FPM) \ MySQL
Build a MySQL Master/Slave server in Ubuntu 14.04
Build a highly available distributed MySQL cluster using Ubuntu 12.04 LTS
Install MySQL5.6 and Python-MySQLdb in the source code of Ubuntu 12.04
MySQL-5.5.38 universal binary Installation
-------------------------------------- Split line --------------------------------------
This article permanently updates the link address: