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 により更新した。

以下、更新時のログを以下に示す:

  1. 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!
    

      

  2. 更新後のVersionの確認
    # mysql -u user_name -ppassword -D mysql -e "SELECT VERSION()"
    +-----------+
    | VERSION() |
    +-----------+
    | 5.5.44    |
    +-----------+
    

       

関連ポスト:


Post a Comment