禁用MySQL数据库连接的反向解析

 未分类  No Responses »
6 月 162014
 

140608 14:33:56 [Warning] IP address ‘113.6.248.158’ could not be resolved: Name or service not known
140609 10:08:20 [Warning] IP address ‘61.183.60.152’ could not be resolved: Name or service not known
140610 2:40:45 [Warning] IP address ‘23.107.60.2’ has been resolved to the host name ‘23.107.60.2.rdns.as15003.net’, which resembles IPv4-address itself.
140612 13:03:26 [Warning] IP address ‘10.165.64.186’ could not be resolved: Name or service not known
140613 11:59:54 [Warning] IP address ‘119.253.176.56’ could not be resolved: Name or service not known
[root@db data]# vi /etc/my.cnf
skip-name-resolve
[root@db data]# service mysqld restart
Shutting down MySQL…. SUCCESS!
Starting MySQL.. SUCCESS!
[root@db data]#

MySQL导入大数据库时的故障分析

 未分类  No Responses »
6 月 162014
 

查看备份数据库文件大小约11GB
[root@msr11 ~]# ll
total 10857420
-rw——-. 1 root root 1048 Jun 12 07:29 anaconda-ks.cfg
-rw-r–r– 1 root root 11049373430 Jun 16 09:47 linuxcache.140616.sql
-rw-r–r–. 1 root root 8526 Jun 12 07:29 install.log
-rw-r–r–. 1 root root 3384 Jun 12 07:28 install.log.syslog
-r–r–r– 1 root root 68592501 Jun 12 08:10 VMwareTools-8.6.11-1310128.tar.gz
drwxr-xr-x 7 201 201 4096 Sep 5 2013 vmware-tools-distrib
[root@msr11 ~]#

执行导入数据库操作是中断并出现错误提示
[root@msr11 ~]# time mysql -u root -pmysqlpass linuxcache <linuxcache.140616.sql
ERROR 1153 (08S01) at line 1557: Got a packet bigger than ‘max_allowed_packet’ bytes

real 0m18.396s
user 0m2.516s
sys 0m0.176s
[root@msr11 ~]#

编辑my.cnf修改设置为大于当前数据库文件大小并重启数据库服务
[root@msr11 mysql]# vi /etc/my.cnf
max_allowed_packet=12G
[root@msr11 ~]# service mysqld restart
Stopping mysqld: [ OK ]
Starting mysqld: [ OK ]
[root@msr11 ~]#

重新导入数据库文件
[root@msr11 ~]# time mysql -u root -pmysqlpass linuxcache <linuxcache.140616.sql

real 38m7.555s
user 3m33.893s
sys 0m13.377s
[root@msr11 ~]#

处于同步状态的MySQL Slave服务区所产生的错误信息
mysql> show slave status\G;
Slave_IO_Running: No
Slave_SQL_Running: Yes
Last_IO_Error: Got a packet bigger than ‘slave_max_allowed_packet’ bytes

修改配置后数据复制任务不再报错
[root@msr12 mysql]# service mysqld stop
Stopping mysqld: [ OK ]
[root@msr12 mysql]# vi /etc/my.cnf
max_allowed_packet=12G