CentOS6.x upgrade MySQL 5.1 to 5.6

Source: Internet
Author: User
Tags yum repolist

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:

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.