Instalar Percona en Red Hat 6

En la última versión de Red Hat (6.0), encontré un problema a la hora de instalar percona (mysql), que no fue otro que incompatibilidades con el software preinstalado del sistema con el nuevo servidor de base de datos, en su versión 5.5.
shell> yum install Percona-Server-server-55.x86_64
...
Transaction Check Error:
 file /usr/lib64/libmysqlclient.so from install of Percona-Server-shared-55-5.5.16-rel22.0.189.rhel6.x86_64 conflicts with file from package Percona-Server-shared-51-5.1.59-rel13.0.325.rhel6.x86_64
 file /usr/lib64/libmysqlclient_r.so from install of Percona-Server-shared-55-5.5.16-rel22.0.189.rhel6.x86_64 conflicts with file from package Percona-Server-shared-51-5.1.59-rel13.0.325.rhel6.x86_64
 file /usr/lib64/mysql/plugin/libfnv1a_udf.a from install of Percona-Server-shared-55-5.5.16-rel22.0.189.rhel6.x86_64 conflicts with file from package Percona-Server-shared-51-5.1.59-rel13.0.325.rhel6.x86_64
 file /usr/lib64/mysql/plugin/libfnv_udf.a from install of Percona-Server-shared-55-5.5.16-rel22.0.189.rhel6.x86_64 conflicts with file from package Percona-Server-shared-51-5.1.59-rel13.0.325.rhel6.x86_64
 file /usr/lib64/mysql/plugin/libmurmur_udf.a from install of Percona-Server-shared-55-5.5.16-rel22.0.189.rhel6.x86_64 conflicts with file from package Percona-Server-shared-51-5.1.59-rel13.0.325.rhel6.x86_64

Error Summary
-------------

Para solucionarlos, detallo a continuación los pasos.
  1. Agregar el respositorio oficial
    shell> rpm -Uhv http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm
    Retrieving percona.com/.../percona-release-0.0-1.x86_64.rpm
    Preparing...######################################### [100%]
       1:percona-release################################# [100%]
    
    o lo agregamos manualmente:
    shell> vi /etc/yum.repos.d/Percona.repo
    [percona]
    name = CentOS $releasever - Percona
    baseurl=http://repo.percona.com/centos/$releasever/os/$basearch/
    enabled = 1
    gpgkey = file:///etc/pki/rpm-gpg/RPM-GPG-KEY-percona
    gpgcheck = 1
    Si hacemos esto, también tenemos que agregar la clave GPG del repositorio,
    shell> vi /etc/pki/rpm-gpg/RPM-GPG-KEY-percona
    El contenido está en Percona GPG key.
  2. Actualizamos el sistema con el nuevo repositorio. Esto nos actualizará ciertas librerías de mysql por las de percona.
    shell> yum update
    ...
     Installing : Percona-Server-shared-compat-5.5.16-...   1/3
     Installing : Percona-Server-shared-51-5.1.59-...       2/3
     Erasing    : mysql-libs-5.1.52-1.el6_0.1.x86_64        3/3  
    
  3. Buscar el software a instalar, en nuestro caso la versión 5.5 de percona.
    shell> yum search percona
    ...
    Percona-Server-client-55.x86_64: Client
    Percona-Server-devel-55.x86_64:  Devel
    Percona-Server-server-55.x86_64: Server
    Percona-Server-shared-55.x86_64: Shared
    Percona-Server-test-55.x86_64:   test
    ...
    
  4. Al instalar la versión 5.5 de Percona-Server, esta falla, tal como detallamos al inicio.
    shell> yum install Percona-Server-server-55.x86_64
    ...
    Downloading Packages:
    (1/2): Percona-Server-server-55-5.5.16-...     | 17 MB  00:02
    (2/2): Percona-Server-shared-55-5.5.16-...     | 779 kB 00:00
    -------------------------------------------------------------
    Total                                 5.2 MB/s | 18 MB  00:03
    Running rpm_check_debug
    Running Transaction Test
    
    Transaction Check Error:
      file /usr/lib64/libmysqlclient.so from install of Percona-Server-shared-55-5.5.16-rel22.0.189.rhel6.x86_64 conflicts with file from package Percona-Server-shared-51-5.1.59-rel13.0.325.rhel6.x86_64
      file /usr/lib64/libmysqlclient_r.so from install of Percona-Server-shared-55-5.5.16-rel22.0.189.rhel6.x86_64 conflicts with file from package Percona-Server-shared-51-5.1.59-rel13.0.325.rhel6.x86_64
      file /usr/lib64/mysql/plugin/libfnv1a_udf.a from install of Percona-Server-shared-55-5.5.16-rel22.0.189.rhel6.x86_64 conflicts with file from package Percona-Server-shared-51-5.1.59-rel13.0.325.rhel6.x86_64
      file /usr/lib64/mysql/plugin/libfnv_udf.a from install of Percona-Server-shared-55-5.5.16-rel22.0.189.rhel6.x86_64 conflicts with file from package Percona-Server-shared-51-5.1.59-rel13.0.325.rhel6.x86_64
      file /usr/lib64/mysql/plugin/libmurmur_udf.a from install of Percona-Server-shared-55-5.5.16-rel22.0.189.rhel6.x86_64 conflicts with file from package Percona-Server-shared-51-5.1.59-rel13.0.325.rhel6.x86_64
    
    Error Summary
    -------------
    
  5. Observamos que el error que da es por que la versión 5.5 entra en conflicto con la versión 5.1. Para solucionarlo, simplemente desinstalamos el paquete "Percona-Server-shared-51-5.1.59-rel13.0.325.rhel6.x86_64", que se instaló al realizar el update. Si no se realiza el update, entraría en conflicto con el paquete "mysql-libs-5.1.52-1.el6_0.1.x86_64".
    shell> rpm -qa |grep Percona
    Percona-Server-shared-51-5.1.59-rel13.0.325.rhel6.x86_64
    Percona-Server-shared-compat-5.5.16-rel22.0.189.rhel6.x86_64
    shell> rpm -e Percona-Server-shared-51-5.1.59-...
    
  6. Volvemos a intentar instalar la versión 5.5 del servidor y ahora vemos que sí funciona.
    shell> yum install Percona-Server-server-55.x86_64
    ...
     Installing : Percona-Server-shared-55-5.5.16-...       1/2
     Installing : Percona-Server-server-55-5.5.16-...       2/2
    ...
    Complete!
    
  7. Aprovechamos para instalar también el cliente mysql-percona.
    shell> yum install Percona-Server-client-55.x86_64
    ...
     Installing : Percona-Server-client-55-5.5.16-...       1/1
    ...
    Complete!
    
  8. Creamos el fichero de configuración de mysql, /etc/my.cnf con los parámetros que interesen.
    shell> cat /etc/my.cnf
    [mysqld]
    server-id=15
    tmpdir=/dev/shm
    datadir=/srv/mysql
    user=mysql
    innodb_file_per_table   = 1
    max_connections         = 300
    innodb_flush_method     = O_DIRECT
    ...
    
  9. Creamos la estructura de la base de datos necesario para comenzar a funcionar.
    shell> mkdir /srv/mysql
    shell> chown mysql_mysql /srv/mysql/
    shell> mysql_install_db --datadir=/srv/mysql
    Installing MySQL system tables...
    111024 11:30:40 [Note] Flashcache bypass: disabled
    111024 11:30:40 [Note] Flashcache setup error is : ioctl failed
    
    OK
    ...
    /usr/bin/mysqladmin -u root password 'new-password'
    ...
    shell> mysqladmin -u root password 'your_root_passwd'
  10. Arrancamos el servidor mysql por primera vez.
    shell> /etc/init.d/mysql start
    shell> mysql -u root -p
    Enter password:
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 1
    Server version: 5.5.16-55-log Percona Server (GPL).
    
    mysql> show databases;
    +--------------------+
    | Database           |
    +--------------------+
    | information_schema |
    | mysql              |
    | performance_schema |
    | test               |
    +--------------------+
    4 rows in set (0.00 sec)
    


1 comentario :

Formulario de contacto

Nombre

Correo electrónico *

Mensaje *

Últimos comentarios