Lamp安装MySQL遇到的问题汇总-创新互联
1: 缺少 libaio 包, libaio是Linux下的一个异步非阻塞方式读写文件的接口。
从事四川绵阳服务器托管,服务器租用,云主机,雅安服务器托管,申请域名,CDN,网络代维等服务。[root@12 MySQL]# ./scripts/mysql_install_db --user=mysql --datadir=/data/mysql Installing MySQL system tables... ./bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory解决办法:安装↓
Solution:yum -y install libaio-devel
2: 缺少 openssl 包
[root@12 mysql]# ./scripts/mysql_install_db --user=mysql Installing MySQL system tables... ./bin/mysqld: error while loading shared libraries: libssl.so.6: cannot open shared object file: No such file or directory解决办法:先检查所有所有的 $PATH 目录是否包含libssl*链接库,如果有,可以做软链接改变名字,如果没有,安装↓
Solution:yum -y install openssl-devel
[root@12 mysql]# cd /usr/lib [root@12 lib]# ls libssl.so libssl.so [root@12 lib]# ln -s libssl.so libssl.so.6 [root@12 lib]#ln -s libcrypto.so libcrypto.so.63:在安装过程中,检查配置文件的错误
[root@12 mysql]# ./scripts/mysql_install_db --defaults-file=my_wresp.cnf --user=mysql Installing MySQL system tables... 131213 17:13:28 [ERROR] WSREP: Query cache is not supported (size=67108864 type=1) 131213 17:13:28 [ERROR] Aborting解决办法:测试过程中就按照错误信息修改即可,至于原因,事后再行计较。
Solution:删除所有query cache相关的配置选项
[root@12 ]# cat /etc/my.cnf | grep queyr_cache query_cache_size = 64M query_cache_limit = 2M4:与上面相同处理
131213 18:03:21 [ERROR] WSREP: Parallel applying (wsrep_slave_threads > 1) requires innodb_autoinc_lock_mode = 2. 131213 18:03:21 [ERROR] Aborting add in my_wsrep.cnf:innodb_autoinc_lock_mode=25:缺少相关的模块
131215 0:15:31 [Note] WSREP: Requesting state transfer: success, donor: 0 tar: This does not look like a tar archive tar: Exiting with failure status due to previous errors WSREP_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] AbortingSolution :
#yum install perl-Time-HiRes #yum -y install perl-DBD-MySQL.x86_64 #yum -y install libaio*6. 端口被占用
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(11, {AF=2 0.0.0.0:4444}, 16): Address already in use tar: This does not look like a tar archive tar: Exiting with failure status due to previous errors解决办法,找到占用端口的程序,杀掉(比较暴力,也可以换端口,但是初次安装为简单起见,暴力)
Solution:
[root@12 ~]# 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) [root@12 ~]# kill -9 5256 [root@12 ~]# lsof -i :4444 [root@12 ~]# lsof -i :4444另外有需要云服务器可以了解下创新互联cdcxhl.cn,海内外云服务器15元起步,三天无理由+7*72小时售后在线,公司持有idc许可证,提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案,具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势,专为企业上云打造定制,能够满足用户丰富、多元化的应用场景需求。
网站题目:Lamp安装MySQL遇到的问题汇总-创新互联
本文来源:http://pwwzsj.com/article/dpspjc.html