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.
- 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. - 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 - 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 ...
- 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 -------------
- 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-...
- 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!
- 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!
- 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 ...
- 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'
- 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)
Gracias por el aporte, voy a probarlo....
ResponderEliminar