Scientific Linux(ver.6.6)上でMySQL-5.5.44にRPMアップデート
July 6, 2015 – 6:16 pm自宅に設置しているLinux Server上のMySQLのversionを5.5.44にアップグレードした。
数日前のPHPの更新作業に引き続き、サーバ環境の高度化に向けて行なっている一連の更新作業のひとつ。
なお、更新に際しては、PHPの更新作業の際に追加した Les RPM de Remi の yum Repositoryを使用した。
以下、更新作業内容をメモしておいた。
更新の意図と必要：
Scientific Linux(以下SL) 6.1のもとに自宅サーバを再構築した際、MySQLのvers.は 5.1.52であった。
現時点で、vers.は5.1.77に（自動）更新されているが、このブログが動作している WordPressでは、MySQL-5.5以上のversionが推奨されている。前回PHPをアップグレードしたこの機会に、MySQLも推奨Versionに対応するよう、更新作業を実施することにした。
更新作業の手順：
冒頭にも述べているように、PHPの更新作業と同様にLes RPM de Remiの yum Repository を活用し、yum update により更新した。
以下、更新時のログを以下に示す：
- MySQLの更新
# yum --enablerepo=remi update mysql\* Loaded plugins: refresh-packagekit, security Setting up Update Process Resolving Dependencies --> Running transaction check ---> Package mysql.x86_64 0:5.1.73-3.el6_5 will be updated ---> Package mysql.x86_64 0:5.5.44-1.el6.remi will be an update ---> Package mysql++.x86_64 0:3.0.9-3.el6 will be updated ---> Package mysql++.x86_64 0:3.1.0-7.el6.remi will be an update --> Processing Dependency: libmysqlclient_r.so.16(libmysqlclient_16)(64bit) for package: mysql++-3.1.0-7.el6.remi.x86_64 --> Processing Dependency: libmysqlclient_r.so.16()(64bit) for package: mysql++-3.1.0-7.el6.remi.x86_64 ---> Package mysql++-devel.x86_64 0:3.0.9-3.el6 will be updated ---> Package mysql++-devel.x86_64 0:3.1.0-7.el6.remi will be an update ---> Package mysql++-manuals.x86_64 0:3.0.9-3.el6 will be updated ---> Package mysql++-manuals.x86_64 0:3.1.0-7.el6.remi will be an update ---> Package mysql-bench.x86_64 0:5.1.73-3.el6_5 will be updated ---> Package mysql-bench.x86_64 0:5.5.44-1.el6.remi will be an update --> Processing Dependency: perl(GD) for package: mysql-bench-5.5.44-1.el6.remi.x86_64 ---> Package mysql-devel.x86_64 0:5.1.73-3.el6_5 will be updated ---> Package mysql-devel.x86_64 0:5.5.44-1.el6.remi will be an update ---> Package mysql-embedded.x86_64 0:5.1.73-3.el6_5 will be updated ---> Package mysql-embedded.x86_64 0:5.5.44-1.el6.remi will be an update ---> Package mysql-embedded-devel.x86_64 0:5.1.73-3.el6_5 will be updated ---> Package mysql-embedded-devel.x86_64 0:5.5.44-1.el6.remi will be an update ---> Package mysql-libs.x86_64 0:5.1.73-3.el6_5 will be updated ---> Package mysql-libs.x86_64 0:5.5.44-1.el6.remi will be an update ---> Package mysql-server.x86_64 0:5.1.73-3.el6_5 will be updated ---> Package mysql-server.x86_64 0:5.5.44-1.el6.remi will be an update ---> Package mysql-test.x86_64 0:5.1.73-3.el6_5 will be updated ---> Package mysql-test.x86_64 0:5.5.44-1.el6.remi will be an update --> Running transaction check ---> Package compat-mysql51.x86_64 0:5.1.54-1.el6.remi will be installed ---> Package perl-GD.x86_64 0:2.44-3.el6 will be installed --> Processing Dependency: gd >= 2.0.28 for package: perl-GD-2.44-3.el6.x86_64 --> Processing Dependency: libgd.so.2()(64bit) for package: perl-GD-2.44-3.el6.x86_64 --> Running transaction check ---> Package gd.x86_64 0:2.0.35-11.el6 will be installed --> Finished Dependency Resolution Dependencies Resolved ====================================================================================================================================== Package Arch Version Repository Size ====================================================================================================================================== Updating: mysql x86_64 5.5.44-1.el6.remi remi 5.8 M mysql++ x86_64 3.1.0-7.el6.remi remi 156 k mysql++-devel x86_64 3.1.0-7.el6.remi remi 170 k mysql++-manuals x86_64 3.1.0-7.el6.remi remi 1.0 M mysql-bench x86_64 5.5.44-1.el6.remi remi 418 k mysql-devel x86_64 5.5.44-1.el6.remi remi 164 k mysql-embedded x86_64 5.5.44-1.el6.remi remi 2.8 M mysql-embedded-devel x86_64 5.5.44-1.el6.remi remi 5.6 M mysql-libs x86_64 5.5.44-1.el6.remi remi 777 k mysql-server x86_64 5.5.44-1.el6.remi remi 10 M mysql-test x86_64 5.5.44-1.el6.remi remi 6.9 M Installing for dependencies: compat-mysql51 x86_64 5.1.54-1.el6.remi remi 1.4 M gd x86_64 2.0.35-11.el6 sl 141 k perl-GD x86_64 2.44-3.el6 sl 179 k Transaction Summary ====================================================================================================================================== Install 3 Package(s) Upgrade 11 Package(s) Total size: 36 M Total download size: 34 M Is this ok [y/N]: y Downloading Packages: (1/13): gd-2.0.35-11.el6.x86_64.rpm | 141 kB 00:01 (2/13): mysql-5.5.44-1.el6.remi.x86_64.rpm | 5.8 MB 00:14 (3/13): mysql++-3.1.0-7.el6.remi.x86_64.rpm | 156 kB 00:02 (4/13): mysql++-devel-3.1.0-7.el6.remi.x86_64.rpm | 170 kB 00:01 (5/13): mysql++-manuals-3.1.0-7.el6.remi.x86_64.rpm | 1.0 MB 00:07 (6/13): mysql-bench-5.5.44-1.el6.remi.x86_64.rpm | 418 kB 00:02 (7/13): mysql-devel-5.5.44-1.el6.remi.x86_64.rpm | 164 kB 00:01 (8/13): mysql-embedded-5.5.44-1.el6.remi.x86_64.rpm | 2.8 MB 00:12 (9/13): mysql-embedded-devel-5.5.44-1.el6.remi.x86_64.rpm | 5.6 MB 00:17 (10/13): mysql-libs-5.5.44-1.el6.remi.x86_64.rpm | 777 kB 00:02 (11/13): mysql-server-5.5.44-1.el6.remi.x86_64.rpm | 10 MB 00:24 (12/13): mysql-test-5.5.44-1.el6.remi.x86_64.rpm | 6.9 MB 00:17 (13/13): perl-GD-2.44-3.el6.x86_64.rpm | 179 kB 00:01 -------------------------------------------------------------------------------------------------------------------------------------- Total 316 kB/s | 34 MB 01:50 Running rpm_check_debug Running Transaction Test Transaction Test Succeeded Running Transaction Updating : mysql-libs-5.5.44-1.el6.remi.x86_64 1/25 WARNING : This MySQL RPM is not an official Fedora / Red Hat build and it overrides the official one. Don't file bugs on Fedora Project nor Red Hat. Use dedicated forums http://forums.famillecollet.com/ warning: /etc/my.cnf created as /etc/my.cnf.rpmnew Updating : mysql-5.5.44-1.el6.remi.x86_64 2/25 Updating : mysql-devel-5.5.44-1.el6.remi.x86_64 3/25 Updating : mysql-server-5.5.44-1.el6.remi.x86_64 4/25 Installing : gd-2.0.35-11.el6.x86_64 5/25 Installing : perl-GD-2.44-3.el6.x86_64 6/25 Installing : compat-mysql51-5.1.54-1.el6.remi.x86_64 7/25 Updating : mysql++-3.1.0-7.el6.remi.x86_64 8/25 Updating : mysql-embedded-5.5.44-1.el6.remi.x86_64 9/25 Updating : mysql-embedded-devel-5.5.44-1.el6.remi.x86_64 10/25 Updating : mysql++-devel-3.1.0-7.el6.remi.x86_64 11/25 Updating : mysql-bench-5.5.44-1.el6.remi.x86_64 12/25 Updating : mysql-test-5.5.44-1.el6.remi.x86_64 13/25 Updating : mysql++-manuals-3.1.0-7.el6.remi.x86_64 14/25 Cleanup : mysql++-devel-3.0.9-3.el6.x86_64 15/25 Cleanup : mysql-embedded-devel-5.1.73-3.el6_5.x86_64 16/25 Cleanup : mysql-test-5.1.73-3.el6_5.x86_64 17/25 Cleanup : mysql-devel-5.1.73-3.el6_5.x86_64 18/25 Cleanup : mysql-bench-5.1.73-3.el6_5.x86_64 19/25 Cleanup : mysql++-manuals-3.0.9-3.el6.x86_64 20/25 Cleanup : mysql-server-5.1.73-3.el6_5.x86_64 21/25 Cleanup : mysql-5.1.73-3.el6_5.x86_64 22/25 Cleanup : mysql++-3.0.9-3.el6.x86_64 23/25 Cleanup : mysql-libs-5.1.73-3.el6_5.x86_64 24/25 Cleanup : mysql-embedded-5.1.73-3.el6_5.x86_64 25/25 Verifying : mysql-embedded-5.5.44-1.el6.remi.x86_64 1/25 Verifying : mysql++-devel-3.1.0-7.el6.remi.x86_64 2/25 Verifying : mysql-libs-5.5.44-1.el6.remi.x86_64 3/25 Verifying : compat-mysql51-5.1.54-1.el6.remi.x86_64 4/25 Verifying : mysql-test-5.5.44-1.el6.remi.x86_64 5/25 Verifying : mysql-bench-5.5.44-1.el6.remi.x86_64 6/25 Verifying : mysql++-manuals-3.1.0-7.el6.remi.x86_64 7/25 Verifying : gd-2.0.35-11.el6.x86_64 8/25 Verifying : mysql-5.5.44-1.el6.remi.x86_64 9/25 Verifying : mysql-devel-5.5.44-1.el6.remi.x86_64 10/25 Verifying : mysql-server-5.5.44-1.el6.remi.x86_64 11/25 Verifying : mysql-embedded-devel-5.5.44-1.el6.remi.x86_64 12/25 Verifying : perl-GD-2.44-3.el6.x86_64 13/25 Verifying : mysql++-3.1.0-7.el6.remi.x86_64 14/25 Verifying : mysql-5.1.73-3.el6_5.x86_64 15/25 Verifying : mysql++-manuals-3.0.9-3.el6.x86_64 16/25 Verifying : mysql-embedded-5.1.73-3.el6_5.x86_64 17/25 Verifying : mysql-devel-5.1.73-3.el6_5.x86_64 18/25 Verifying : mysql-embedded-devel-5.1.73-3.el6_5.x86_64 19/25 Verifying : mysql-test-5.1.73-3.el6_5.x86_64 20/25 Verifying : mysql-libs-5.1.73-3.el6_5.x86_64 21/25 Verifying : mysql-bench-5.1.73-3.el6_5.x86_64 22/25 Verifying : mysql++-devel-3.0.9-3.el6.x86_64 23/25 Verifying : mysql++-3.0.9-3.el6.x86_64 24/25 Verifying : mysql-server-5.1.73-3.el6_5.x86_64 25/25 Dependency Installed: compat-mysql51.x86_64 0:5.1.54-1.el6.remi gd.x86_64 0:2.0.35-11.el6 perl-GD.x86_64 0:2.44-3.el6 Updated: mysql.x86_64 0:5.5.44-1.el6.remi mysql++.x86_64 0:3.1.0-7.el6.remi mysql++-devel.x86_64 0:3.1.0-7.el6.remi mysql++-manuals.x86_64 0:3.1.0-7.el6.remi mysql-bench.x86_64 0:5.5.44-1.el6.remi mysql-devel.x86_64 0:5.5.44-1.el6.remi mysql-embedded.x86_64 0:5.5.44-1.el6.remi mysql-embedded-devel.x86_64 0:5.5.44-1.el6.remi mysql-libs.x86_64 0:5.5.44-1.el6.remi mysql-server.x86_64 0:5.5.44-1.el6.remi mysql-test.x86_64 0:5.5.44-1.el6.remi Complete!
- 更新後のVersionの確認
# mysql -u user_name -ppassword -D mysql -e "SELECT VERSION()" +-----------+ | VERSION() | +-----------+ | 5.5.44 | +-----------+