Linux防止防火墙关闭数据库连接方法

修改操作系统参数：

net.ipv4.tcp_keepalive_intvl = 30
net.ipv4.tcp_keepalive_probes = 10
net.ipv4.tcp_keepalive_time = 60

（如上配置表示每分钟一次）

查询连接数据包（是否每分钟一次）

[root@sm_db ~]#  tcpdump -i eth0 host 135.50.5.36
tcpdump: verbose output suppressed, use -v or -vv for full protocol decode
listening on eth0, link-type EN10MB (Ethernet), capture size 96 bytes
15:30:50.066680 IP sm_db.igo-incognito > 135.50.5.36.syam-agent: . ack 2642839021 win 63784
15:30:50.071983 IP 135.50.5.36.syam-agent > sm_db.igo-incognito: . ack 1 win 65163
15:31:50.076050 IP sm_db.igo-incognito > 135.50.5.36.syam-agent: . ack 1 win 63784
15:31:50.081907 IP 135.50.5.36.syam-agent > sm_db.igo-incognito: . ack 1 win 65163
15:32:50.084964 IP sm_db.igo-incognito > 135.50.5.36.syam-agent: . ack 1 win 63784
15:32:50.091147 IP 135.50.5.36.syam-agent > sm_db.igo-incognito: . ack 1 win 65163
15:33:50.095900 IP sm_db.igo-incognito > 135.50.5.36.syam-agent: . ack 1 win 63784
15:33:50.101689 IP 135.50.5.36.syam-agent > sm_db.igo-incognito: . ack 1 win 65163
15:34:50.105838 IP sm_db.igo-incognito > 135.50.5.36.syam-agent: . ack 1 win 63784
15:34:50.111622 IP 135.50.5.36.syam-agent > sm_db.igo-incognito: . ack 1 win 65163
15:35:50.115779 IP sm_db.igo-incognito > 135.50.5.36.syam-agent: . ack 1 win 63784

15:35:50.121558 IP 135.50.5.36.syam-agent > sm_db.igo-incognito: . ack 1 win 65163

TCP 连接断连问题剖析

http://www.ibm.com/developerworks/cn/aix/library/0808_zhengyong_tcp/index.html