Summary of issues encountered by Lamp installation MySQL

1: Missing Libaio package, Libaio is Linux an asynchronous non-blocking way to read and write to a file's interface.

[Email protected] mysql]#./scripts/mysql_install_db--user=mysql--datadir=/data/mysqlinstalling MySQL system tables ...../bin/mysqld:error while loading shared libraries:libaio.so.1:cannot open Shared object file:no such file or direct Ory

Workaround: Install ↓

Solution:yum-y Install Libaio-devel

2: Missing OpenSSL package

[Email protected] mysql]#./scripts/mysql_install_db--user=mysqlinstalling MySQL system tables..../bin/mysqld:error While loading shared Libraries:libssl.so.6:cannot open Shared object file:no such file or directory

Workaround: First check all $PATH directories contain libssl* link library, if there is, can do soft link change name, if not, install ↓

Solution:yum-y Install Openssl-devel

[Email protected] mysql]# cd/usr/lib[[email protected] lib]# ls libssl.solibssl.so[[email protected] lib]# ln-s Libssl. So Libssl.so.6[[email protected] lib] #ln-s libcrypto.so libcrypto.so.6

3: During the installation process, check the configuration file for errors

[[email protected] mysql]#./scripts/mysql_install_db--defaults-file=my_wresp.cnf--user=mysqlinstalling MySQL System tables ... 131213 17:13:28 [ERROR] Wsrep:query cache is not supported (size=67108864 type=1) 131213 17:13:28 [ERROR] aborting

Workaround: Test in the process in accordance with the error information can be modified, as for the reasons, after the matter.

Solution: Remove all query Cache-related configuration options

[Email protected]]# CAT/ETC/MY.CNF | grep queyr_cachequery_cache_size = 64mquery_cache_limit = 2M

4: Same treatment as above

131213 18:03:21 [ERROR] wsrep:parallel applying (Wsrep_slave_threads > 1) requires Innodb_autoinc_lock_mode = 2.131213 18:03:21 [ERROR] Abortingadd in my_wsrep.cnf:innodb_autoinc_lock_mode=2

5: Missing related modules

131215 0:15:31 [note] wsrep: requesting state transfer: success, donor :  0tar: this does not look like a tar archivetar: exiting  with failure status due to previous errorsWSREP_SST: [ERROR]  Error while getting data from donor node: exit codes: 0 2   (20131215 00:15:34.320) wsrep_sst: [error] cleanup after exit with  status:32  (20131215 00:15:34.332) wsrep_sst: [info] removing the sst_in_progress  file  (20131215 00:15:34.349) 131215 0:15:34 [error] wsrep: process  completed with error: wsrep_sst_xtrabackup --role  ' Joiner '  --address  ' 192.168.1.46 '  --auth  '  --datadir  '/usr/local/mysql/var/'  --defaults-file  '/etc/ My.cnf '  --parent  ' 2714 ': 32  (broken pipe) 131215 0:15:34 [error] wsrep: failed to read  uuid:seqno from joiner script.131215 0:15:34 [ERROR] WSREP: SST  failed: 32  (broken pipe) 131215 0:15:34 [error] aborting

Solution:

#yum Install perl-time-hires#yum-y install perl-dbd-mysql.x86_64#yum-y install libaio*

6. Ports are occupied

WSREP_SST: [INFO] Evaluating socat-u tcp-listen:4444,reuseaddr stdio | Tar Xfi---recursive-unlink-h; Rc= (${pipestatus[@]}) (20140128 15:35:07.478) 2014/01/28 15:35:07 socat[10521.3077941584] E bind (one, {AF=2 0.0.0.0:4444 }, (+): Address already in Usetar:this does don't look like a tar archivetar:exiting with failure status due to previous E Rrors

Workaround, locate the port-occupied program, kill (more violent, can also switch ports, but initial installation for simplicity, violence)

Solution:

[[email protected] ~]# lsof-i: 4444 lsof:no pwd entry for UID 503 COMMAND PID USER FD TYPE DEVICE size/off NODE NAME Lsof:no pwd entry for UID 503 socat 5256 503 11u IPv4 13450 0t0 TCP *:krb524 (LISTEN) [[email protected] ~]# kill-9 52 [[email protected] ~]# lsof-i: 4444 [[email protected] ~]# lsof-i: 4444

This article is from the "Old seven Linux Operations Management" blog, please be sure to keep this source http://asd9577.blog.51cto.com/4291946/1937107

Summary of issues encountered by Lamp installation MySQL