Problemas al instalar MySQL y Galera en CentOS 6.5

r2j Seguir

Lambda
SEO
Desde
23 Dic 2011
Mensajes
2.830
Estoy intentando instalar mysql con galera en centos 6.5 pero tengo muchos problemas, no se si es la versión de mysql que da problemas (está modificada para que acepte esta tecnología)

Lo que hago es lo siguiente:

Insertar CODE, HTML o PHP:
yum update -y && yum install wget libevent perl mysql-y
wget https://launchpad.net/codership-mysql/5.6/5.6.16-25.5/+download/MySQL-server-5.6.16_wsrep_25.5-1.rhel6.x86_64.rpm
wget https://launchpad.net/galera/3.x/25.3.5/+download/galera-25.3.5-1.rhel6.x86_64.rpm
rpm -Uvh --force MySQL-server-5.6.16_wsrep_25.5-1.rhel6.x86_64.rpm
rpm -Uvh galera-25.3.5-1.rhel6.x86_64.rpm

Hasta aquí todo bien, vamos a hacer un start al servicio mysqld

Insertar CODE, HTML o PHP:
[root@db1 ~]# /etc/init.d/mysql start
Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/db1.pid).
[root@db1 ~]# /etc/init.d/mysql status
 ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists

Voy a mirar que dice en /var/lib/mysql/db1.err

Insertar CODE, HTML o PHP:
[root@db1 ~]# cat /var/lib/mysql/db1.err 
140517 11:19:56 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140517 11:19:56 mysqld_safe WSREP: Running position recovery with --log_error='/var/lib/mysql/wsrep_recovery.zt0hQM' --pid-file='/var/lib/mysql/db1-recover.pid'
2014-05-17 11:19:57 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
140517 11:19:57 mysqld_safe WSREP: Failed to recover position:  2014-05-17 11:19:57 10980 [Note] Plugin 'FEDERATED' is disabled. 2014-05-17 11:19:57 10980 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-05-17 11:19:57 10980 [Note] InnoDB: The InnoDB memory heap is disabled 2014-05-17 11:19:57 10980 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-05-17 11:19:57 10980 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-05-17 11:19:57 10980 [Note] InnoDB: Using Linux native AIO 2014-05-17 11:19:57 10980 [Note] InnoDB: Not using CPU crc32 instructions 2014-05-17 11:19:57 10980 [Note] InnoDB: Initializing buffer pool, size = 128.0M InnoDB: mmap(137363456 bytes) failed; errno 12 2014-05-17 11:19:57 10980 [ERROR] InnoDB: Cannot allocate memory for the buffer pool 2014-05-17 11:19:57 10980 [ERROR] Plugin 'InnoDB' init function returned error. 2014-05-17 11:19:57 10980 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2014-05-17 11:19:57 10980 [ERROR] Unknown/unsupported storage engine: InnoDB 2014-05-17 11:19:57 10980 [ERROR] Aborting 2014-05-17 11:19:57 10980 [Note] Binlog end 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'partition' 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'INNODB_METRICS' 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'INNODB_CMPMEM' 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'INNODB_CMP' 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'INNODB_LOCKS' 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'INNODB_TRX' 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'BLACKHOLE' 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'ARCHIVE' 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'MEMORY' 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'MRG_MYISAM' 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'CSV' 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'MyISAM' 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'sha256_password' 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'mysql_old_password' 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'mysql_native_password' 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'wsrep' 2014-05-17 11:19:57 10980 [Note] Shutting down plugin 'binlog' 2014-05-17 11:19:57 10980 [Note] /usr/sbin/mysqld: Shutdown complete

Parece que el inno_db tiene un problema, ¿cómo lo puedo arreglar?

Gracias de antemano :welcoming:
 

OscarS

Épsilon
Verificación en dos pasos activada
Desde
6 Ago 2011
Mensajes
922
Revisa tu my.cnf, hazle un backup y dejalo vacio reinicia mysql y ve si va.

Saludos.
 

r2j

Lambda
SEO
Desde
23 Dic 2011
Mensajes
2.830
Revisa tu my.cnf, hazle un backup y dejalo vacio reinicia mysql y ve si va.

Saludos.

Me sale el mismo error, lo que tenía en el my.cnf (viene por defecto)

Insertar CODE, HTML o PHP:
[root@db1 ~]# cat /etc/my.cnf 
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
 

OscarS

Épsilon
Verificación en dos pasos activada
Desde
6 Ago 2011
Mensajes
922
Por eso mismo te digo, borrale todo lo de adentro (haciendo respaldo) he intenta, te dio ese error aun?

Me sale el mismo error, lo que tenía en el my.cnf (viene por defecto)

Insertar CODE, HTML o PHP:
[root@db1 ~]# cat /etc/my.cnf 
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
 

r2j

Lambda
SEO
Desde
23 Dic 2011
Mensajes
2.830
Por eso mismo te digo, borrale todo lo de adentro (haciendo respaldo) he intenta, te dio ese error aun?

Sigue sin funcionar, seguiré investigando

---------- Post agregado el 18-may-2014 hora: 15:03 ----------


ES un error derivado de otro problema o eso creo
 
Arriba