一、前言
前几篇博客中我们讲解了MySQL5.1与MySQL5.5之间的性能差异，MySQL5.5的性能有明显的提升，特别是对多核CPU的支持与TPS性能的提升。在这篇博客中我们将主要讲解MySQL 5.1.73升级为MySQL 5.5.35。下面我们继续……
二、概述
1.安装yum源
[root@node6 src]# wget [root@node6 src]# rpm -ivh epel-release-6-8.noarch.rpm
2.同步时间
[root@node6 src]# yum install -y ntp[root@node6 src]# ntpdate 202.120.2.101[root@node6 src]# hwclock –w
3.安装mysql 5.1依赖包
[root@node6 mysql-5.1.73]# yum -y install ncurses ncurses-devel
4.安装mysql5.5依赖包
[root@node6 ~]# yum install -y autoconf* automake* zlib* libxml* ncurses-devel* libgcrypt* libtool* openssl*
5.安装cmake
[root@node6 ~]# yum install -y cmake
三、安装MySQL 5.1.73
1.编译并安装mysql5.1
[root@node6 mysql-5.1.73]# tar xf mysql-5.1.73.tar.gz[root@node6 mysql-5.1.73]# cd mysql-5.1.73[root@node6 mysql-5.1.73]# ./configure –prefix=/usr/local/mysql –localstatedir=/data/mysql –enable-assembler –with-client-ldflags=-all-static –with-mysqld-ldflags=-all-static –with-pthread –enable-static –with-big-tables –without-ndb-debug –with-charset=utf8 –with-extra-charsets=all –without-debug –enable-thread-safe-client –enable-local-infile –with-plugins=max
上面配置内容省略……
This version of MySQL Cluster is no longer maintained.Please use the separate sources provided forMySQL Cluster instead. See formoredetails.Thank you forchoosing MySQL!Remember to check the platform specific part of the reference manualforhints about installing MySQL on your platform. Also have a lookat the files inthe Docs directory.
到这里我们编译配置就完成了，下面我们编译并安装。
[root@node6 mysql-5.1.73]# make && make install
注，编译与安装时间比较长请大家耐心等待，当然会看各位博友机器的配置，相对来说配置越好，相对的编译与安装时间相对就少。
2.创建数据目录并授权
[root@node6 mysql-5.1.73]# mkdir -pv /data/mysqlmkdir: 已创建目录 “/data/mysql”[root@node6 mysql-5.1.73]# useradd mysql [root@node6 mysql-5.1.73]# chown mysql.mysql /data/mysql/ [root@node6 mysql-5.1.73]# ll /data/ 总用量 20 drwx——. 2 root root 16384 8月 17 18:42 lost+found drwxr-xr-x. 2 mysql mysql 4096 1月 4 16:10 mysql
3.为mysql提供配置文件
[root@node6 mysql-5.1.73]# cp support-files/my-huge.cnf /etc/my.cnfcp：是否覆盖”/etc/my.cnf”？ y
4.简单修改一下配置文件
[root@node6 mysql-5.1.73]# vim /etc/my.cnf[client]default-character-set= utf8[mysqld]default-character-set= utf8 datadir= /data/mysql
5.提供启动脚本
[root@node6 mysql-5.1.73]# cp support-files/mysql.server /etc/init.d/mysqld [root@node6 mysql-5.1.73]# chmod +x /etc/init.d/mysqld[root@node6 ~]# chkconfig mysqld –add [root@node6 ~]# chkconfig mysqld on
6.初始化mysql
[root@node6 mysql-5.1.73]# /usr/local/mysql/bin/mysql_install_db –basedir=/usr/local/mysql/ –datadir=/data/mysql/ –user=mysqlInstalling MySQL system tables… 140104 16:18:43 [Warning] ‘–default-character-set’is deprecated and will be removed ina future release. Please use ‘–character-set-server’instead. 140104 16:18:43 [Warning] ‘–skip-locking’is deprecated and will be removed ina future release. Please use ‘–skip-external-locking’instead. OK Filling help tables… 140104 16:18:43 [Warning] ‘–default-character-set’is deprecated and will be removed ina future release. Please use ‘–character-set-server’instead. 140104 16:18:43 [Warning] ‘–skip-locking’is deprecated and will be removed ina future release. Please use ‘–skip-external-locking’instead. OKTo start mysqld at boot timeyou have to copysupport-files/mysql.server to the right place foryour systemPLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !To doso, start the server, thenissue the following commands:/usr/local/mysql//bin/mysqladmin-u root password ‘new-password’/usr/local/mysql//bin/mysqladmin-u root -h node6.test.com password ‘new-password’Alternatively you can run:/usr/local/mysql//bin/mysql_secure_installationwhichwill also give you the option of removing the testdatabases and anonymous user created by default. This is strongly recommended forproduction servers.See the manual formoreinstructions.You can start the MySQL daemon with:cd/usr/local/mysql/; /usr/local/mysql//bin/mysqld_safe&You can testthe MySQL daemon with mysql-test-run.plcd/usr/local/mysql//mysql-test; perl mysql-test-run.plPlease report any problems with the /usr/local/mysql//scripts/mysqlbugscript!
注，从上面的内容中我们看到了几个警告，我们查看一下。
140104 16:18:43 [Warning] ‘–default-character-set’is deprecated and will be removed ina future release. Please use ‘–character-set-server’instead.140104 16:18:43 [Warning] ‘–skip-locking’is deprecated and will be removed ina future release. Please use ‘–skip-external-locking’instead.OKFilling help tables…140104 16:18:43 [Warning] ‘–default-character-set’is deprecated and will be removed ina future release. Please use ‘–character-set-server’instead.140104 16:18:43 [Warning] ‘–skip-locking’is deprecated and will be removed ina future release. Please use ‘–skip-external-locking’instead.从上面的警告可以看到，–default-character-set、–skip-locking选项已经过时，建议使用–character-set-server、–skip-external-locking。
7.查看一下初始化目录
[root@node6 data]# ls /data/mysql/mysql mysql-bin.000001 mysql-bin.000002 mysql-bin.index test
8.启动一下mysql
[root@node6 ~]# service mysqld startStarting MySQL.. SUCCESS!为了一些琐事吵架，然后冷战，疯狂思念对方，最后和好。
