数据库服务器健康检查脚本

最新推荐文章于 2022-08-18 09:23:02 发布
最新推荐文章于 2022-08-18 09:23:02 发布
阅读量442 收藏
点赞数
分类专栏： 笔记整理 学习笔记 实践笔记
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/xiaobei_cug/article/details/79195977
版权 
#!/bin/bash
#author: xiaobei
#create: 2017-10-07
#parameters:none
#version:1.0
#perpose:to install database silently
#modified:none
############################################################################
excuter=`whoami`
__functin_name__=""
current_dir=`pwd`
function log_info ()
{
DATE_N=`date "+%Y-%m-%d %H:%M:%S"`
#USER_N=`whoami`
USER_N=$1
echo "${DATE_N} ${USER_N} execute $__functin_name__ [INFO] $2"
echo "${DATE_N} ${USER_N} execute $__functin_name__ [INFO] $2" >> check.log
}
function log_error ()
{
DATE_N=`date "+%Y-%m-%d %H:%M:%S"`
$USER_N=`whoami`
USER_N=$1
echo -e "\033[41;37m ${DATE_N} ${USER_N} execute $__functin_name__ [ERROR] $2 \033[0m"
echo -e "${DATE_N} ${USER_N} execute $__functin_name__ [ERROR] $2 " >> check.log
}
function fn_log () 
{
if [  $? -eq 0  ]
then
    log_info "$1" "$2 sucessed."
    echo -e "\033[32m $@ sucessed. \033[0m"
else
    log_error "$1" "$2 failed."
    echo -e "\033[41;37m $@ failed. \033[0m"
    exit 1
fi
}
#################################################################
#read config
#################################################################
function read_config ()
{ 
  __functin_name__="read_config"
  if [ -f $current_dir"/conf.ini" ]; then
       . "$current_dir/conf.ini"
    rm -f report/*
    mkdir -p report
    report_file="report/$report_file"
      sed -i "s/awr_days=[1-9]/awr_days=$awr_days/g" awrauto.sh
      sed -i "s/addm_days=[1-9]/addm_days=$addm_days/g" addmauto.sh
      sed -i "s/ash_days=[1-9]/ash_days=$ash_days/g" ashauto.sh 
      fn_log "root" "read config file"
else 
      echo "conf.ini file is not accessible,please check!"
      exit 1
fi
}
##################################################################
#write to html
##################################################################
function write2html ()
{
     echo $1 >> $report_file
}
##################################################################
#config the top func and label of html
##################################################################
function top_html ()
{
__functin_name__="top_html"
 write2html "<html xmlns="http://www.w3.org/1999/xhtml">"
 write2html "<head>"
 write2html "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" />" 
 write2html "<title>service health check</title>"
 write2html "<script type="text/javascript">"
 write2html " function xlh(){" 
for t in `seq 7`
do
write2html "var tbl$t = document.getElementById(\"tbl$t\");"
write2html "var rows$t = tbl$t.rows.length;"

write2html "  for(var i=1;i<rows$t;i++){"
write2html "   if(i%2 == 0){"
write2html "      tbl$t.rows[i].style.backgroundColor = \"#FFFFCC\";"
write2html "   }"
write2html " }"
write2html "tbl$t.rows[0].style.backgroundColor = \"0066CC\";"
write2html "tbl$t.rows[0].style.font = \"Arial\";"
write2html "tbl$t.rows[0].style.color = \"white\";"
done
write2html "}"
write2html "</script>"
write2html "</head>"
write2html "<body onload=\"xlh()\">"
fn_log "root" "write the top of html report"
}
function bot_html ()
{
__functin_name__="bot_html"
write2html "</body>" 
write2html "</html>"
fn_log "root" "write the bottom of html report"
}
function basic_info ()
{
__functin_name__="basic_info"
write2html "<h style=\"color:0066CC;font:Arial;font-weight:bold\">CHUNXING service health check report</h>"
write2html "<hr />"
 write2html "<p style="font:Arial\;font-weight:bold\;color:0066CC">check info</p>"
 write2html "<table id=\"tbl1\" cellspacing="3">"
 write2html "<tr>"
 write2html "<td>name</td>"
write2html "<td>details</td>"
 write2html "</tr>" 
 write2html "<tr>"
 write2html "<td>project name</td>"
write2html "<td>$project_name</td>"
 write2html "</tr>"
 write2html "<tr>"
 write2html "<td>check date</td>"
 write2html "<td>`date "+%Y-%m-%d %H:%M:%S"`</td>"
 write2html "</tr>"
 write2html "<tr>"
 write2html "<td>check by</td>"
 write2html "<td>$author</td>"
 write2html "</tr>"
 write2html "</table>"
 fn_log "root" "output the basic infomation of checking"
}
function hard_info ()
{
__functin_name__="hard_info"
 write2html "<p style="font:Arial\;font-weight:bold\;color:0066CC">hard resource info</p>"
 write2html "<table id=\"tbl2\" cellspacing="3">"
 write2html "<tr>"
 write2html "<td>name </td>"
 write2html "<td>details</td>"
 write2html "</tr>"
 write2html "<tr>"
 write2html "<td>hostname of service </td>"
 write2html "<td>`hostname`</td>"
 write2html "</tr>"
 write2html "<tr>"
 write2html "<td>ip address</td>"
 write2html "<td>`(ifconfig eth0| grep "inet addr" | awk '{ print $2}' | awk -F: '{print $2}')`</td>"
 write2html "</tr>"
 write2html "<tr>"
 write2html "<td>operation system</td>"
 write2html "<td>`cat /etc/redhat-release`</td>"
 write2html "</tr>"
 write2html "<tr>"
 write2html "<td>cpu info</td>"
 write2html "<td>`cat /proc/cpuinfo | grep name | awk -F: '{print $2}'`</td>"
 write2html "</tr>"
 write2html "<tr>"
 write2html "<td>number of cpus</td>"
 write2html "<td>`lscpu | grep "^CPU(s):" | awk -F: '{print $2}'`</td>"
 write2html "</tr>"
 write2html "</tr>"
 write2html "<tr>"
 write2html "<td>volume of disks</td>"
 volume=`df -h | awk '{print $2}' | grep -v S | grep -v M`
 volume=`echo $volume | sed 's/ /\+/g'`
 write2html "<td>$volume</td>"
 write2html "</tr>"
 write2html "</table>"
 fn_log "root" "output the hard resource infomation of service"
}
function iptable_info ()
{
 __functin_name__="iptable_info"
 write2html "<p style="font:Arial\;font-weight:bold\;color:0066CC">iptables info</p>"
 write2html "<table id=\"tbl3\" cellspacing="3">"
 write2html "<tr>"
 write2html "<td>name</td>"
 write2html "<td>details</td>"
 write2html "</tr>"
 write2html "<tr>"
 write2html "<td>iptables status </td>"
 status=`service iptables status | awk -F: '{print $2}'`
 write2html "<td>$status</td>"
 write2html "</tr>"
 write2html "<tr>"
 write2html "<td>suggestions</td>"
 if [ "$status" = " Firewall is not running." ]
 then
     write2html "<td>start iptables</td>"
 else 
    write2html "<td></td>"
fi
 write2html "</tr>"
write2html "</table>"
fn_log "root" "output the iptables infomation"
}
function database_info()
{
__functin_name__="database_info"
 write2html "<p style="font:Arial\;font-weight:bold\;color:0066CC">database info</p>"
 verdsion_tmp=`su - oracle -c "sqlplus / as sysdba <<EOF
exit
EOF"`
conf_para=`su - oracle -c "sqlplus / as sysdba <<EOF
show parameter memory_target;
exit
EOF"`
version=`echo $conf_para | awk -F 'Production' '{print $1}' | awk -F ':' '{print $2}'`
 write2html "<table id=\"tbl4\" cellspacing="3">"
  write2html "<tr>"
 write2html "<td>name </td>"
 write2html "<td>details</td>"
 write2html "</tr>"
 write2html "<tr>"
 write2html "<td>database version </td>"
 write2html "<td>$version</td>"
 write2html "</tr>"
 write2html "<tr>"
 write2html "<td>memory target</td>"
memory_target_temp=${conf_para#*memory_target}
memory_target=`echo ${memory_target_temp%SQL*} | awk '{print $NF}'`
 write2html "<td>$memory_target</td>"
 write2html "</tr>"
conf_para=`su - oracle -c "sqlplus / as sysdba <<EOF
show parameter memory_max_target;
exit
EOF"`
memory_target_temp=${conf_para#*memory_max_target}
memory_max_target=`echo ${memory_target_temp%SQL*} | awk '{print $NF}'`
 write2html "<tr>"
 write2html "<td>memory max target</td>"
 write2html "<td>$memory_max_target</td>"
 write2html "</tr>"
conf_para=`su - oracle -c "sqlplus / as sysdba <<EOF
show parameter pga_aggregate_target;
exit
EOF"`
memory_target_temp=${conf_para#*pga_aggregate_target}
memory_max_target=`echo ${memory_target_temp%SQL*} | awk '{print $NF}'`
 write2html "<tr>"
 write2html "<td>pga aggregate target</td>"
 write2html "<td>$memory_max_target</td>"
 write2html "</tr>"
conf_para=`su - oracle -c "sqlplus / as sysdba <<EOF
show parameter sga_target;
exit
EOF"`
memory_target_temp=${conf_para#*sga_target}
memory_max_target=`echo ${memory_target_temp%SQL*} | awk '{print $NF}'`
 write2html "<tr>"
 write2html "<td>sga target</td>"
 write2html "<td>$memory_max_target</td>"
 write2html "</tr>"
data_para=`su - oracle -c "sqlplus / as sysdba <<EOF
select * from nls_database_parameters;
exit
EOF"`
NLS_CHARACTERSET=`echo ${data_para#*NLS_CHARACTERSET}`
NLS_CHARACTERSET=`echo ${NLS_CHARACTERSET%NLS_ISO_CURRENCY*}`
 write2html "<tr>"
 write2html "<td>characterset</td>"
 write2html "<td>$NLS_CHARACTERSET</td>"
 write2html "</tr>"
NLS_LANGUAGE=`echo ${data_para#*NLS_LANGUAGE}`
NLS_LANGUAGE=`echo ${data_para#*NLS_LANGUAGE} | awk '{print $1}'`
 write2html "<tr>"
 write2html "<td>nls language</td>"
 write2html "<td>$NLS_LANGUAGE</td>"
 write2html "</tr>"

proc_para=`su - oracle -c "sqlplus / as sysdba <<EOF
@$current_dir"/exesql.sql"
exit
EOF"`
proc=`echo $proc_para | awk -F 'DATAFILE' '{print $1}' | awk '{print $NF}'`
 write2html "<tr>"
 write2html "<td>process</td>"
 write2html "<td>$proc</td>"
 write2html "</tr>"
 status=`su - oracle -c "lsnrctl status"`
 status=`echo ${status#*'Services Summary...'}`
 status=`echo ${status%'The command completed successfully'*}`
 write2html "<tr>"
 write2html "<td>database status</td>"
 write2html "<td>$status</td>"
 write2html "</tr>"
 temp=`echo ${proc_para%CONTROLFILE*}`
 data_file=`echo ${temp#*DATAFILE} | sed 's/ /\r\n/g' | sed 's/-//g'`
 write2html "<tr>"
 write2html "<td>data file</td>"
 write2html "<td>$data_file</td>"
 write2html "</tr>"
 temp=`echo ${proc_para%LOGFILE*}`
 control_file=`echo ${temp#*CONTROLFILE} | sed 's/ /\r\n/g' | sed 's/-//g'`
 write2html "<tr>"
 write2html "<td>control file</td>"
 write2html "<td>$control_file</td>"
 write2html "</tr>"
temp=`echo ${proc_para#*LOGFILE}`
log_file=`echo ${temp%SQL>*} | sed 's/ /\r\n/g' | sed 's/-//g'`
 write2html "<tr>"
 write2html "<td>log file</td>"
 write2html "<td>$log_file</td>"
 write2html "</tr>"
write2html "</table>"
fn_log "root" "output database parameter infomation"
}
function task_info()
{
__functin_name__="task_info"
task_info=`su - oracle -c "crontab -l"`
 write2html "<p style="font:Arial\;font-weight:bold\;color:0066CC">task info</p>"
 write2html "<table id=\"tbl5\" cellspacing="3">"
 write2html "<tr>"
 write2html "<td>user</td>"
 write2html "<td>task_info</td>"
 write2html "</tr>" 
 write2html "<tr>"
 write2html "<td>oracle</td>"
 write2html "<td>$task_info</td>"
 write2html "</tr>"
 write2html "</table>"
 fn_log "root" "output timing infomation"
}
function report_info()
{
__functin_name__="report_info"
awr_info=`su - oracle -c "sh $current_dir/awrauto.sh"`
fn_log "oracle" "produce awr report"
mv /home/oracle/awrrpt.html $current_dir/report/
 write2html "<p style="font:Arial\;font-weight:bold\;color:0066CC">report info</p>"
 write2html "<table id=\"tbl6\" cellspacing="3">"
 write2html "<tr>"
 write2html "<td>report_name</td>"
 write2html "<td>report_link</td>"
 write2html "</tr>"
 write2html "<tr>"
 write2html "<td>awr</td>"
 write2html "<td><a href="awrrpt.html">awr report link</a></td>"
 write2html "</tr>"

ash_info=`su - oracle -c "sh $current_dir/ashauto.sh"`
fn_log "oracle" "produce ash report"
mv /home/oracle/ashrpt.html $current_dir/report/
 write2html "<tr>"
 write2html "<td>ash</td>"
 write2html "<td><a href="ashrpt.html">ash report link</a></td>"
 write2html "</tr>"

addm_info=`su - oracle -c "sh $current_dir/addmauto.sh"`
fn_log "oracle" "produce addm report"
mv /home/oracle/addm.txt $current_dir/report
 write2html "<tr>"
 write2html "<td>addm</td>"
 write2html "<td><a href="addm.txt">addm report link</a></td>"
 write2html "</tr>"

awrinfo_info=`su - oracle -c "sh $current_dir/awrinfoauto.sh"`
mv /home/oracle/awrinfo.txt $current_dir/report
fn_log "oracle" "produce awrinfo report"
 write2html "<tr>"
 write2html "<td>awrinfo</td>"
 write2html "<td><a href="awrinfo.txt">awrinfo report link</a></td>"
 write2html "</tr>"
 write2html "</table>"
 fn_log "oracle" "produce report info"
}
function manual_sent()
{
__functin_name__="manual_sent"
 write2html "<p style="font:Arial\;font-weight:bold\;color:0066CC">manual execute command</p>"
 write2html "<table id=\"tbl7\" cellspacing="3">"
  write2html "<tr>"
 write2html "<td>check column</td>"
 write2html "<td>sql sentence</a></td>"
 write2html "</tr>"
 redo_size="select group# ,bytes/1024/1024 size_m,status,archived from v\$log;"
 write2html "<tr>"
 write2html "<td>check redo size</td>"
 write2html "<td>$redo_size</td>"
 write2html "</tr>"
 tablespace_used_rate="select tablespace_name \"tablespace_name\",to_char(round(maxbytes / 1024, 2), '99990.00') || 'g' \"size(g)\",to_char(round(used / 1024, 2), '99990.00') || 'g' \"used(g)\",to_char(round((maxbytes - used) / 1024, 2), '99990.00') || 'g' \"avail(g)\",to_char(round( used / maxbytes /0.0001) / 100, '99990.00') || '%' \"used%\" from (select a.tablespace_name tablespace_name,floor(a.bytes / 1024 / 1024) bytes,floor(b.free / 1024 / 1024) free, floor((a.bytes - b.free) / 1024 / 1024) used, floor(a.maxbytes / 1024 / 1024) maxbytes from (select tablespace_name tablespace_name, sum(bytes) bytes, sum(maxbytes) maxbytes from dba_data_files group by tablespace_name) a, (select tablespace_name tablespace_name, sum(bytes) free from dba_free_space group by tablespace_name) b where a.tablespace_name = b.tablespace_name ) order by floor( used / maxbytes/0.00001) desc;"
 write2html "<tr>"
 write2html "<td>check tablespace used rate</td>"
 write2html "<td>$tablespace_used_rate</td>"
 write2html "</tr>"
 index_table_consistency="select t.owner,t.index_name,t.table_owner,t.table_name from dba_indexes t  where t.owner <> t.table_owner;"
 write2html "<tr>"
 write2html "<td>check consistency between index and table</td>"
 write2html "<td>$index_table_consistency</td>"
 write2html "</tr>"
extent_sum_too_much="select owner,segment_name,segment_type,tablespace_name bytes_g,extents  from (select t.owner,t.segment_name,t.segment_type, t.tablespace_name,round(t.bytes/1024/1024/1024,2) bytes_g,t.extents from dba_segments t order by t.extents desc) where rownum<21;"
 write2html "<tr>"
 write2html "<td>check extent sum</td>"
 write2html "<td>$extent_sum_too_much</td>"
 write2html "</tr>"
close_to_max_extent_object="select t.owner,t.segment_name,t.segment_type,t.tablespace_name,t.next_extent from dba_segments t where t.extents = t.max_extents-10;"
 write2html "<tr>"
 write2html "<td>check object close to max extent</td>"
 write2html "<td>$close_to_max_extent_object</td>"
 write2html "</tr>"
 auto_extent_switch="select file_id,file_name,tablespace_name,autoextensible from dba_data_files;"
 write2html "<tr>"
 write2html "<td>check auto extent switch</td>"
 write2html "<td>$auto_extent_switch</td>"
 write2html "</tr>"
exceed_next_extent="select s.owner,s.segment_name,s.segment_type,s.tablespace_name, s.next_extent from dba_segments s where s.next_extent > (select max(f.bytes) from dba_free_space f where f.tablespace_name = s.tablespace_name) order by s.owner;"
 write2html "<tr>"
 write2html "<td>check tablespace almost exceed next extent</td>"
 write2html "<td>$exceed_next_extent</td>"
 write2html "</tr>"
statistics_info="select table_name,num_rows,sample_percent, last_analyzed from (select table_name,num_rows,round(sample_size/decode(num_rows,0,1,num_rows)*100,0)||'%' sample_percent, to_char(last_analyzed, 'yyyy-mm-dd hh24:mi:ss') last_analyzed from dba_tables where owner like $db_user order by num_rows desc) where rownum < 31;"
 write2html "<tr>"
 write2html "<td>check table statistical info</td>"
 write2html "<td>$statistics_info</td>"
 write2html "</tr>"
 write2html "</table>"
  fn_log "root" "manual execute sqls"
}
read_config
top_html
basic_info
hard_info
iptable_info
database_info
task_info
report_info
manual_sent
bot_html
xiaobei_cug
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
C003 数据库巡检脚本
郭言亮的博客
07-04 1130
脚本文件放在D:\Check_oracle目录下，截图如下： CRT是SecureCRT软件，LOGS存放生成的日志文件，ServerList是服务器列表 DAILYCheck.bat文件内容： REM DAILYCheck.bat @echo off Setlocal ENABLEDELAYEDEXPANSION Set strDate=%date:~0,4%%date:~5,...
API 服务器健康状态自检
a1991376352的博客
07-28 1051
由于后期我们会实现很多路由对应的处理函数，如果量大的话，router文件会变得非常大因此，我们也可以将处理函数放到handler目录中此目录将用于保存服务器检查相关处理函数短小的处理函数可以直接编写匿名函数放在router中，长函数建议拆分//加载模块-处理函数模块化​//在Load函数中添加//-modifyhere-添加健康检查的handlersvcd{}该代码块定义了一个叫sd的路由分组，在该分组下注册了/health、/disk、/cpu、/ram、、、函数。...
Nginx后端Web服务器健康检查
进阶的蜗牛
06-22 943
Nginx后端Web服务器健康检查 背景： 有一个问题，当Nginx没有后端检测功能，当后端某一服务器无法提供服务时，该链接先被转发到这台机器，然后发现该机故障，而后才转发到其它机器，导致资源浪费。 因此引入 nginx_upstream_check_module 模块，该模块用于提供负载均衡器内节点的健康检查，通过它可以用来检测后端服务的健康状态。如果后端服务不可用，则后面的请求就不会转发到该节点上。 操作 # yum -y install patch # cd /usr/local/src/ngin
数据库oracle健康检查,ORACLE数据库健康检查
weixin_33483080的博客
04-13 822
数据库管理员如何进行ORACLE数据库的健康检查检查数据库状态检查文件系统检查警告日志文件(alert_SID.log)定期检查警告日志、TRC文件及listener日志查看数据库连接信息检查数据库当日备份的有效性。检查数据文件的状态检查表空间的使用情况检查数据库的等待事件锁表问题的处理解锁处理查看数据库的性能查看监听日志检查数据库状态确认所有的INSTANCE状态以及listener状态正常,登...
DM8 数据库健康状态检查
最新发布
qq_41364256的博客
08-18 453
DM8 数据库健康状态检查
MySQL健康检查（一）
VincentQB的博客
01-27 4519
MySQL健康检查
Oracle 数据库健康检查及脚本
weixin_33937778的博客
11-11 810
2019独角兽企业重金招聘Python工程师标准>>> ...
Nginx实战系列之功能篇----后端节点健康检查
weixin_33858485的博客
12-23 729
       公司前一段对业务线上的nginx做了整理，重点就是对nginx上负载均衡器的后端节点做健康检查。目前，nginx对后端节点健康检查的方式主要有3种，这里列出：1、ngx_http_proxy_module 模块和ngx_http_upstream_module模块（自带）     官网地址：http://nginx.org/cn/docs/http/ngx_http_proxy_mo...
数据库健康指标
05-30
运行时间长的sql语句，TRIGGER的统计，db_link统计，无查询条件，分区全扫，查询需要回收高水位的表，查看索引超过列一般的表，查询物化视图，查询无效的对象，查询三表关联的sql语句的脚本，查询占有系统表空间的应用级表，查询数据库中超过100个字段的表，查寻数据库中索引总个数的脚本的相关脚本
服务器健康状态检查脚本
weixin_34077371的博客
02-26 1269
在日常工作中，我们经常会定期的检查各个服务器的状态，通过此shell脚本系统可以定期的将每日服务器的检查结果发送到邮箱中，此脚本在正式环境中已稳定运行。 因为我们需要通过邮件发送检测结果，首先必须在服务器上开启sendmail服务并设置为开机自启动，然后需要在/etc/mail.rc中设置相应的参数，/etc/mail.rc中参数的设置如下： set fro...
检查mysql数据库脚本_使用shell检查并修复mysql数据库表的脚本
weixin_32242475的博客
01-20 230
#!/bin/sh#code by scpman#功能:检查并修复mysql数据库表#将此脚本加到定时中，脚本执行时，等会读库,列出要修复的所有表，然后计时，开始修复#修复过程中将损坏的表记录下来，修复完成后，将损坏的表，发邮件通知。fix_logs='/tmp/fix.log'user=''pass=''check_fix(){dblist=`/usr/bin/find /usr/dlm_db/...
服务器健康检查系统
weixin_34250709的博客
10-16 362
2019独角兽企业重金招聘Python工程师标准>>> ...
数据库状态检查脚本
qq_43348295的博客
02-26 2883
背景：客户数据库为双主数据库由于疫情原因，监控项目推迟将进行人为巡检MySQL。 脚本以下功能： 1、 检查数据库是否能正常连接。 2、 检查主从状态。 3、 检查由于达到了mysql的最大连接数导致的失败。 4、 检查由于mysql服务器错误导致连接失败的数量 5、 统计QPS，TPS，mysql提交的事务数量 #!/bin/bash #date：2020-02-24 #作者 Jinclan@1...
Nginx 的负载均衡模式及实现原理
姜皓的博客
11-25 1615
Nginx 的负载均衡模式及实现原理1）什么是 Nginx？2）负载均衡策略2.1）轮询策略2.2）最少连接数负载均衡2.3）加权负载均衡2.4） ip-hash 负载均衡3）健康检测4）Nginx 缓存5）总结 1）什么是 Nginx？ Nginx 是一款开源的高性能轻量级 Web 服务器（也叫 HTTP 服务器），它主要提供的功能是：反向代理、负载均衡和HTTP 缓存。它于 2004 年首次公开发布，2011 年成立同名公司以提供支持，2019 年 3 月被 F5 Networks 以 6.7 亿美元收
《浅谈F5健康检查常用的几种方式》—那些你应该知道的知识（二）
热门推荐
BBIE的博客
09-16 1万+
负载均衡作为实现应用高可用和高可靠的一种方式，已成为目前数据中心内不可或缺的一个环节，并扮演着越来越重要的作用，而F5正是这一领域的佼佼者。要实现应用的高可用，如何探测负载均衡后端应用的可用性是其中非常重要的一个环节，该环节又被称作应用的健康检查。 本文将在下面的章节中，就作者工作中使用的几种F5健康检查的方式做简单的介绍和分析。主要包括TCP_HALF_OPEN、TCP ECV、HTTP GE...
简单的mysql 性能和健康程度巡检
weixin_34303897的博客
03-23 437
简单的mysql 性能和健康程度巡检
apisix健康检查测试
Flytiger
07-27 2740
被动健康检查不会对目标产生额外的流量，主动进行健康检查会产生额外流量。主动健康检查需要在target中配置要探测URL（可以简单配置为“/”）和判定健康或不健康的状态码，而被动运行状况检查不需要这种配置。在实际使用中，使用被动健康检查可能会误杀一些还处于正常状态的target可以承接的流量，所以应该谨慎使用被动模式；对target进行探活探死的时候，不能进行有冲突的配置，比如HTTP403在主动探测模式下认为是健康的返回码，而在被动模式下却认为是不健康的返回码；；.........
MySQL服务健康检查脚本
weixin_34198881的博客
11-12 630
#!/bin/sh #date:2015-12-07 #filename:check_mysql.sh #作者：linuxzkq #Email:1729294227@qq.com #version:v1.0 #port=`netstat -tunlp|grep 3306|wc -l` #process=`ps -ef|grep mysqld|grep -...
DB2数据库基础详解
- **db2look**：用于查看数据库对象的DDL脚本。 - **Commonprocess**：涉及DB2的并行处理和共享资源。 10. **表空间状态**：表空间的健康状况和容量管理。 11. **约束**： - **唯一约束**：确保列中值的唯一性...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值