X5 㯠43 ã®é éã»ã³ã¿ãŒãš 4 å°ã®èªç€Ÿãã©ãã¯ãéå¶ãã029 åºèãžã®è£œåã®éåãã®ãªãäŸçµŠãä¿èšŒããŠããŸãããã®èšäºã§ã¯ãå庫ã€ãã³ããç£èŠããããã®å¯Ÿè©±åã·ã¹ãã ãäžããäœæããç§ã®çµéšãå ±æããŸãããã®æ å ±ã¯ãããŸããŸãªååã管çããæ°åã®é éã»ã³ã¿ãŒãæã€å瀟ã®ç©æµæ åœè ã«ãšã£ãŠåœ¹ç«ã¡ãŸãã
éåžžãç£èŠããã³ããžãã¹ ããã»ã¹ç®¡çã·ã¹ãã ã®æ§ç¯ã¯ãã¡ãã»ãŒãžãšã€ã³ã·ãã³ãã®åŠçããå§ãŸããŸããåæã«ãããžãã¹ ã€ãã³ãã®çºçãã®ãã®ãèªååããã€ã³ã·ãã³ããèšé²ããå¯èœæ§ã«é¢ããéèŠãªæè¡çãã€ã³ããèŠéãããŠããŸãã WMSãTMS ãªã©ã®ã»ãšãã©ã®ããžãã¹ ã·ã¹ãã ã«ã¯ãç¬èªã®ããã»ã¹ãç£èŠããããã®ããŒã«ãçµã¿èŸŒãŸããŠããŸãããã ããããããç°ãªãã¡ãŒã«ãŒã®ã·ã¹ãã ã§ããå ŽåããŸãã¯ç£èŠæ©èœãååã«éçºãããŠããªãå Žåã¯ãé«äŸ¡ãªå€æŽã泚æããããè¿œå èšå®ã®ããã«å°éã®ã³ã³ãµã«ã¿ã³ããéãå¿
èŠããããŸãã
ã·ã¹ãã ããææšãååŸããããã®ãœãŒã¹ (ããŒãã«) ã®ç¹å®ã«é¢é£ããã³ã³ãµã«ãã£ã³ã°ã®ã»ãã®äžéšã ããå¿ èŠãªã¢ãããŒããèããŠã¿ãŸãããã
åœç€Ÿã®å庫ã®ç¹åŸŽã¯ãè€æ°ã®å庫管çã·ã¹ãã (WMS Exceed) ã XNUMX ã€ã®ç©æµæœèšã§çšŒåããŠããããšã§ããå庫ã¯ãè«ççã«ã ãã§ãªããååã®ä¿ç®¡ã«ããŽãªãŒ (ãã©ã€ãã¢ã«ã³ãŒã«ãå·åãªã©) ã«å¿ããŠåå²ãããŠããŸãã XNUMX ã€ã®ç©æµæœèšå ã«ã¯è€æ°ã®å庫æ£ãããããããããç¬èªã® WMS ã«ãã£ãŠç®¡çãããŠããŸãã
å庫å
ã§çºçããããã»ã¹ã®å
šäœåãææ¡ããããã«ã管çè
ã¯å WMS ã®ã¬ããŒãã XNUMX æ¥ã«æ°ååæããå庫ãªãã¬ãŒã¿ãŒ (è·å人ãããã«ãŒãã¹ã¿ãã«ãŒ) ããã®ã¡ãã»ãŒãžãåŠçããæ
å ±ããŒãã«åæ ããããã«å®éã®éçšææšãèŠçŽããŸãã
管çè ã®æéãç¯çŽããããã«ãç§ãã¡ã¯å庫ã€ãã³ãã®éçšç®¡çã®ããã®å®äŸ¡ãªã·ã¹ãã ãéçºããããšã«ããŸãããæ°ããã·ã¹ãã ã¯ãå庫ããã»ã¹ã®éçšããã©ãŒãã³ã¹ã®ãããããªãææšã衚瀺ããããšã«å ããŠã管çè ãã€ã³ã·ãã³ããèšé²ããã¿ã¹ã¯ã®å®æœãç£èŠããŠç¹å®ã®ææšã«åœ±é¿ãäžããåå ãæé€ããã®ã«ã圹ç«ã¡ãŸããäŒç€Ÿã® IT ã¢ãŒããã¯ãã£ã®äžè¬çãªç£æ»ãå®æœããåŸãå¿ èŠãªã·ã¹ãã ã®åã ã®éšåãäœããã®åœ¢ã§ãã§ã«åœç€Ÿã®ç°å¢ã«ååšããŠããããããã«å¯ŸããŠèšå®ã®èª¿æ»ãšå¿ èŠãªãµããŒã ãµãŒãã¹ã®äž¡æ¹ãå¿ èŠã§ããããšãããããŸãããæ®ã£ãŠããã®ã¯ãã³ã³ã»ããå šäœãåäžã®ã¢ãŒããã¯ã㣠ãœãªã¥ãŒã·ã§ã³ã«ãŸãšããéçºç¯å²ãèŠç©ããããšã ãã§ãã
æ°ããã·ã¹ãã ãæ§ç¯ããããã«å¿ èŠãªäœæ¥éãè©äŸ¡ããåŸããããžã§ã¯ããããã€ãã®æ®µéã«åå²ããããšã決å®ãããŸããã
- å庫ããã»ã¹ã®ææšã®åéãææšãšåå·®ã®å¯èŠåãšç®¡ç
- ããã»ã¹æšæºã®èªååãšéžè±ã«å¯Ÿããããžãã¹ãµãŒãã¹ãµãŒãã¹ãžã®ã¢ããªã±ãŒã·ã§ã³ã®ç»é²
- è² è·äºæž¬ã«ããããã¢ã¯ãã£ããªã¢ãã¿ãªã³ã°ãšç®¡çè åãã®æšå¥šäºé ã®äœæã
æåã®æ®µéã§ãã·ã¹ãã ã¯è€åæœèšã®ãã¹ãŠã® WMS ããéçšããŒã¿ã®æºåãããã¹ã©ã€ã¹ãåéããå¿ èŠããããŸããèªã¿åãã¯ã»ãŒãªã¢ã«ã¿ã€ã (5 åæªæºã®éé) ã§è¡ãããŸãããã€ã³ãã¯ãã·ã¹ãã ããããã¯ãŒã¯å šäœã«å±éãããšãã«ãæ°åã®ãŠã§ã¢ããŠã¹ã® DBMS ããããŒã¿ãååŸããå¿ èŠãããããšã§ããåä¿¡ããéçšããŒã¿ã¯ã·ã¹ãã ã³ã¢ã®ããžãã¯ã«ãã£ãŠåŠçãããèšç»ãããææšããã®åå·®ãèšç®ãããçµ±èšãèšç®ãããŸãããã®ããã«ããŠåŠçãããããŒã¿ã¯ãããããããã°ã©ããå³ã®åœ¢ã§ç®¡çè ã®ã¿ãã¬ãããå庫æ å ±ããŒãã«è¡šç€ºãããå¿ èŠããããŸãã
第 XNUMX 段éã®ãã€ãããå®è£
ã«é©ããã·ã¹ãã ãéžæããéã«ãZabbix ãéžæããŸããããã®ã·ã¹ãã ã¯ãå庫ã·ã¹ãã ã® IT ããã©ãŒãã³ã¹ãç£èŠããããã«ãã§ã«äœ¿çšãããŠããŸããå庫éçšã®ããžãã¹ ã¡ããªã¯ã¹ãåéããããã®å¥ã®ã€ã³ã¹ããŒã«ãè¿œå ããããšã§ãå庫ã®å¥å
šæ§ã®å
šäœåãææ¡ã§ããŸãã
ã·ã¹ãã ã®äžè¬çãªã¢ãŒããã¯ãã£ã¯å³ã®ããã«ãªããŸããã
å WMS ã€ã³ã¹ã¿ã³ã¹ã¯ãç£èŠã·ã¹ãã ã®ãã¹ããšããŠå®çŸ©ãããŸããã¡ããªã¯ã¹ã¯ãæºåããã SQL ã¯ãšãªã䜿çšããŠã¹ã¯ãªãããå®è¡ããããšã«ãããããŒã¿ ã»ã³ã¿ãŒ ãããã¯ãŒã¯å
ã®äžå€®ãµãŒããŒã«ãã£ãŠåéãããŸããããŒã¿ããŒã¹ãžã®çŽæ¥ã¢ã¯ã»ã¹ãæšå¥šãããŠããªãã·ã¹ãã (SAP EWM ãªã©) ãç£èŠããå¿
èŠãããå Žåã¯ãææžåããã API é¢æ°ãžã®ã¹ã¯ãªããåŒã³åºãã䜿çšããŠã€ã³ãžã±ãŒã¿ãŒãååŸããããPython/vbascript ã§ç°¡åãªããã°ã©ã ãäœæãããã§ããŸãã
Zabbix ãããã· ã€ã³ã¹ã¿ã³ã¹ã¯ãã¡ã€ã³ ãµãŒããŒããã®è² è·ãåæ£ããããã«ãŠã§ã¢ããŠã¹ ãããã¯ãŒã¯ã«ãããã€ãããŸãããããã·ãéããŠããã¹ãŠã®ããŒã«ã« WMS ã€ã³ã¹ã¿ã³ã¹ãšã®é£æºãä¿èšŒãããŸãã次åãZabbix ãµãŒããŒããã©ã¡ãŒã¿ããªã¯ãšã¹ããããšããZabbix ãããã·ãåãããã¹ãäžã§ã¹ã¯ãªãããå®è¡ãããWMS ããŒã¿ããŒã¹ããã¡ããªã¯ã¹ããªã¯ãšã¹ãããŸãã
äžå€®ã® Zabbix ãµãŒããŒã«ã°ã©ããšãŠã§ã¢ããŠã¹ ã€ã³ãžã±ãŒã¿ãŒã衚瀺ããããã«ãGrafana ããããã€ããŸãã Grafana ã¯ãå庫æ¥åã®ã€ã³ãã©ã°ã©ãã£ãã¯ãå«ãæºåãããããã·ã¥ããŒãã衚瀺ããã ãã§ãªããææšã®éžè±ãç£èŠããããžãã¹ ã€ã³ã·ãã³ãã«å¯ŸåŠããããã«å庫ãµãŒãã¹ ã·ã¹ãã ã«èªåã¢ã©ãŒããéä¿¡ããããã«ã䜿çšãããŸãã
äŸãšããŠãå庫ã®åãåããšãªã¢ã§ã®è² è·å¶åŸ¡ã®å®è£ ãèããŠã¿ãŸããããå庫ã®ãã®é åã«ãããããã»ã¹ããã©ãŒãã³ã¹ã®äž»ãªææšãšããŠã以äžãéžæãããŸããã
- ã¹ããŒã¿ã¹ïŒèšç»ãå°çãæžé¡ãè·éãããåºçºïŒãèæ ®ãããåä»ãšãªã¢ã®è»äž¡ã®æ°ã
- é 眮ããã³è£å ãšãªã¢ã®äœæ¥è² è·ïŒä¿ç®¡æ¡ä»¶ã«ããïŒã
èšå®
ã·ã¹ãã ã®äž»èŠã³ã³ããŒãã³ã (SQLclãZabbixãGrafana) ã®ã€ã³ã¹ããŒã«ãšæ§æã«ã€ããŠã¯ãããŸããŸãªãœãŒã¹ã§èª¬æãããŠãããããããã§ã¯ç¹°ãè¿ããŸããã SQLplus ã®ä»£ããã« SQLcl ã䜿çšãããã®ã¯ãSQLcl (Java ã§èšè¿°ããã Oracle DBMS ã®ã³ãã³ã ã©ã€ã³ ã€ã³ã¿ãŒãã§ã€ã¹) ã Oracle ã¯ã©ã€ã¢ã³ãã®è¿œå ã€ã³ã¹ããŒã«ãå¿ èŠãšããããã®ãŸãŸäœ¿çšã§ããããã§ãã
Zabbixã䜿çšããŠå庫æ¥åããã»ã¹ææšãç£èŠããéã«æ³šæãã¹ãäž»ãªãã€ã³ããšãããããå®çŸããããã®æ¹æ³ã®XNUMXã€ã«ã€ããŠèª¬æããŸãããŸããããã¯ã»ãã¥ãªãã£ã«é¢ããæçš¿ã§ã¯ãããŸãããæ¥ç¶ã®ã»ãã¥ãªãã£ãšæ瀺ãããæ¹æ³ã®äœ¿çšã«ã€ããŠã¯ããã€ããã ãœãªã¥ãŒã·ã§ã³ãæ¬çšŒåã«ç§»è¡ããããã»ã¹ã§è¿œå ã®æ€èšãå¿ èŠã§ãã
äž»ãªããšã¯ããã®ãããªã·ã¹ãã ãå®è£ ããå Žåãã·ã¹ãã ãæäŸããèšå®ã䜿çšããŠããã°ã©ãã³ã°ãªãã§å®è¡ã§ããããšã§ãã
Zabbix ç£èŠã·ã¹ãã ã«ã¯ãç£èŠå¯Ÿè±¡ã·ã¹ãã ããã¡ããªã¯ã¹ãåéããããã®ããã€ãã®ãªãã·ã§ã³ãçšæãããŠããŸããããã¯ãç£èŠå¯Ÿè±¡ãã¹ããçŽæ¥ããŒãªã³ã°ãããããã¹ãã® zabbix_sender ãä»ããŠãµãŒããŒã«ããŒã¿ãéä¿¡ããããé«åºŠãªæ¹æ³ (äœã¬ãã«ã®æ€åºãã©ã¡ãŒã¿ãŒãæ§æããæ¹æ³ãªã©) ã«ãã£ãŠå®è¡ã§ããŸãããã®åé¡ã解決ããã«ã¯ãäžå€®ãµãŒããŒã«ãããã¹ãã®çŽæ¥ããŒãªã³ã°æ¹æ³ãéåžžã«é©ããŠããŸããããã«ãããã¡ããªã¯ã¹ååŸã®ã·ãŒã±ã³ã¹ãå®å šã«å¶åŸ¡ã§ããããã«ãªããåç£èŠå¯Ÿè±¡ãã¹ãã«é åžããããšãªããXNUMX ã»ããã®èšå®/ã¹ã¯ãªããã䜿çšã§ããããã«ãªããŸãã
ã·ã¹ãã ã®ãããã°ãšã»ããã¢ããã®ããã¹ã察象ããšããŠãåãå ¥ã管çã« WMS ã¯ãŒã¯ã·ãŒãã䜿çšããŸãã
- åä»ã®è»äž¡ãå°çãããã¹ãŠã®è»äž¡: ãçŸåšæå»ãã 72 æéãã®æéã®ã¹ããŒã¿ã¹ãæã€ãã¹ãŠã®è»äž¡ - SQL ã¯ãšãªèå¥å: è»ãååŸãã.
- ãã¹ãŠã®è»äž¡ã¹ããŒã¿ã¹ã®å±¥æŽ: 72 æé以å ã«å°çãããã¹ãŠã®è»äž¡ã®ã¹ããŒã¿ã¹ - SQL ã¯ãšãªèå¥å: è»æŽå².
- åãå ¥ãäºå®è»äž¡ïŒãäºå®ãã¹ããŒã¿ã¹ã«å°çãããã¹ãŠã®è»äž¡ã®ã¹ããŒã¿ã¹ãçŸåšæå»ããã®æéééã-24æéãããã³ã+24æéã - SQLã¯ãšãªèå¥åïŒ è»ã§.
ãããã£ãŠããŠã§ã¢ããŠã¹ã®ããã©ãŒãã³ã¹ææšã®ã»ããã決å®ããåŸãWMS ããŒã¿ããŒã¹çšã® SQL ã¯ãšãªãæºåããŸããã¯ãšãªãå®è¡ããã«ã¯ãã¡ã€ã³ ããŒã¿ããŒã¹ã§ã¯ãªãããã®ãããããã³ããŒãã€ãŸãã¹ã¿ã³ãã€ã䜿çšããããšããå§ãããŸãã
ã¹ã¿ã³ã〠Oracle DBMS ã«æ¥ç¶ããŠããŒã¿ãåä¿¡ããŸãããã¹ãããŒã¿ããŒã¹ã«æ¥ç¶ããããã®IPã¢ãã¬ã¹ 192.168.1.106ã Zabbix ãµãŒããŒäžã® SQLcl äœæ¥ãã©ã«ããŒã® TNSNames.ORA ã«æ¥ç¶ãã©ã¡ãŒã¿ãŒãä¿åããŸãã
# cat /opt/sqlcl/bin/TNSNames.ORA
WH1_1=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.106)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = WH1_1)
)
)
ããã«ããããã°ã€ã³/ãã¹ã¯ãŒããšããŒã¿ããŒã¹åã®ã¿ãæå®ããŠãEZconnect çµç±ã§åãã¹ãã«å¯Ÿã㊠SQL ã¯ãšãªãå®è¡ã§ããããã«ãªããŸãã
# sql znew/Zabmon1@WH1_1
æºåãã SQL ã¯ãšãªã Zabbix ãµãŒããŒäžã®äœæ¥ãã©ã«ããŒã«ä¿åããŸãã
/etc/zabbix/sql
ãããŠããµãŒããŒã® zabbix ãŠãŒã¶ãŒãžã®ã¢ã¯ã»ã¹ãèš±å¯ããŸãã
# chown zabbix:zabbix -R /etc/zabbix/sql
ãªã¯ãšã¹ãã®ãããã¡ã€ã«ã¯ãZabbix ãµãŒããŒããã¢ã¯ã»ã¹ããããã®äžæã®èå¥åãåãåããŸãã SQLcl ãä»ããåããŒã¿ããŒã¹ ã¯ãšãªã¯ãããã€ãã®ãã©ã¡ãŒã¿ãè¿ããŸãããªã¯ãšã¹ãããšã« XNUMX ã€ã®ã¡ããªã¯ã¹ã®ã¿ãåŠçã§ãã Zabbix ã®ä»æ§ãèæ ®ããŠãè¿œå ã®ã¹ã¯ãªããã䜿çšããŠã¯ãšãªçµæãåã ã®ã¡ããªã¯ã¹ã«è§£æããŸãã
ã¡ã€ã³ ã¹ã¯ãªãããæºåããŸããããããã wh_Metrics.sh ãšåŒã³ãŸããããã¯ãããŒã¿ããŒã¹ãžã® SQL ã¯ãšãªãåŒã³åºããçµæãä¿åããããŒã¿ååŸã®æåã瀺ãã€ã³ãžã±ãŒã¿ãŒãå«ãæè¡çãªã¡ããªã¯ã¹ãè¿ããŸãã
#!/bin/sh
## МаÑÑÑПйка ПкÑÑжеМОÑ</i>
export ORACLE_HOME=/usr/lib/oracle/11.2/client64
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib64:/usr/lib:$ORACLE_HOME/bin
export TNS_ADMIN=$ORACLE_HOME/network/admin
export JAVA_HOME=/
alias sql="opt/sqlcl/bin/sql"
## заЎаÑÐŒ пÑÑÑ Ðº ÑÐ°Ð¹Ð»Ñ Ñ sql-запÑПÑПЌ О паÑаЌеÑÑОзПваММПе ÐžÐŒÑ Ñайла
scriptLocation=/etc/zabbix/sql
sqlFile=$scriptLocation/sqlScript_"$2".sql
## заЎаÑÐŒ пÑÑÑ Ðº ÑÐ°Ð¹Ð»Ñ ÐŽÐ»Ñ Ñ
ÑÐ°ÐœÐµÐœÐžÑ ÑезÑлÑÑаÑПв
resultFile=/etc/zabbix/sql/mon_"$1"_main.log
## МаÑÑÑаОваеЌ ÑÑÑÐŸÐºÑ Ð¿ÐŸÐŽÐºÐ»ÑÑÐµÐœÐžÑ Ðº ÐÐ
username="$3"
password="$4"
tnsname="$1"
## запÑаÑОваеЌ ÑезÑлÑÑÐ°Ñ ÐžÐ· ÐÐ
var=$(sql -s $username/$password@$tnsname < $sqlFile)
## ÑПÑЌаÑОÑÑеЌ ÑезÑлÑÑÐ°Ñ Ð·Ð°Ð¿ÑПÑа О запОÑÑваеЌ в Ñайл
echo $var | cut -f5-18 -d " " > $resultFile
## пÑПвеÑÑеЌ МалОÑОе ПÑОбПк
if grep -q ora "$resultFile"; then
echo null > $resultFile
echo 0
else
echo 1
fi
Zabbix ãããã·æ§æèšå® (ããã©ã«ãã§ã¯ - /usr/local/share/zabbix/externalscripts).
ã¹ã¯ãªãããçµæãåãåãããŒã¿ããŒã¹ã® ID ã¯ãã¹ã¯ãªãã ãã©ã¡ãŒã¿ãŒãšããŠæž¡ãããŸããããŒã¿ããŒã¹ ID ã¯ãTNSNames.ORA ãã¡ã€ã«ã®èšå®è¡ãšäžèŽããå¿ èŠããããŸãã
SQL ã¯ãšãªåŒã³åºãã®çµæã¯ã次ã®ãããªãã¡ã€ã«ã«ä¿åãããŸãã mon_base_id_main.log ããã§ãbase_id = ã¹ã¯ãªãããã©ã¡ãŒã¿ãšããŠåãåã£ãããŒã¿ããŒã¹èå¥åããµãŒããŒããè€æ°ã®ããŒã¿ããŒã¹ã«åæã«ãªã¯ãšã¹ãããã£ãå Žåã«åããŠãããŒã¿ããŒã¹èå¥åã«ããçµæãã¡ã€ã«ã®åå²ãæäŸãããŸããã¯ãšãªã¯ã䞊ã¹æ¿ããããå€ã® XNUMX 次å é åãè¿ããŸãã
次ã®ã¹ã¯ãªãã (getMetrica.sh ãšããŸã) ã¯ããªã¯ãšã¹ãã®çµæãå«ããã¡ã€ã«ããæå®ãããã¡ããªã¯ã¹ãååŸããããã«å¿ èŠã§ãã
#!/bin/sh
## ПпÑеЎелÑеЌ ÐžÐŒÑ Ñайла Ñ ÑезÑлÑÑаÑПЌ запÑПÑа
resultFile=/etc/zabbix/sql/mon_â$1â_main.log
## ÑазбОÑаеЌ ЌаÑÑОв зМаÑеМОй ÑезÑлÑÑаÑа ÑÑеЎÑÑваЌО ÑкÑОпÑа:
## пÑО ÑабПÑе ÑП ÑÑаÑÑÑаЌО, запÑÐŸÑ Ð²ÐŸÐ·Ð²ÑаÑÐ°ÐµÑ ÐœÐ°ÐŒ ЎвÑЌеÑÐœÑй ЌаÑÑОв (RSLT) в вОЎе
## {ÑÑаÑÑÑ1 зМаÑеМОе1 ÑÑаÑÑÑ2 зМаÑеМОе2âŠ} ÑазЎелÑММÑÑ
пÑПбелаЌО (зМаÑеМОе IFS)
## паÑаЌеÑÑПЌ запÑПÑа пеÑеЎаÑÐŒ кПЎ ÑÑаÑÑÑа О ÑкÑÐžÐ¿Ñ Ð²ÐµÑÐœÑÑ Ð·ÐœÐ°ÑеМОе
IFS=â â
str=$(cat $resultFile)
status_id=null
read âra RSLT <<< â$strâ
for i in â${RSLT[@]}â; do
if [[ â$status_idâ == null ]]; then
status_id=â$I"
elif [[ â$status_idâ == â$2â ]]; then
echo â$iâ
break
else
status_id=null
fi
done
ããã§ãZabbix ãæ§æããå庫åãå ¥ãããã»ã¹ã®ã€ã³ãžã±ãŒã¿ãŒã®ç£èŠãéå§ããæºåãæŽããŸããã
Zabbix ãšãŒãžã§ã³ãã¯åããŒã¿ããŒã¹ ããŒãã«ã€ã³ã¹ããŒã«ãããæ§æãããŸãã
ã¡ã€ã³ãµãŒããŒã§ã¯ãZabbix ãããã·ã䜿çšããŠãã¹ãŠã®ãµãŒããŒãå®çŸ©ããŸããèšå®ãè¡ãã«ã¯ã次ã®ãã¹ã«ç§»åããŸãã
管ç â ãããã· â ãããã·ã®äœæ
å¶åŸ¡å¯Ÿè±¡ãã¹ãã次ã®ããã«å®çŸ©ããŸãã
èšå® â ãã¹ã â ãã¹ãã®äœæ
ãã¹ãåã¯ããšãŒãžã§ã³ãæ§æãã¡ã€ã«ã§æå®ãããŠãããã¹ãåãšäžèŽããå¿
èŠããããŸãã
ããŒãã®ã°ã«ãŒããšãããŒã¿ããŒã¹ã®ããããŒãã® IP ã¢ãã¬ã¹ãŸã㯠DNS åãæå®ããŸãã
ã¡ããªã¯ã¹ãäœæãããã®ããããã£ãæå®ããŸãã
èšå® â ããŒã â ãããŒãåã â ããŒã¿èŠçŽ >ããŒã¿èŠçŽ ã®äœæ
1) ããŒã¿ããŒã¹ãããã¹ãŠã®ãã©ã¡ãŒã¿ãã¯ãšãªããããã®ã¡ã€ã³ ã¡ããªãã¯ãäœæããŸã
ããŒã¿èŠçŽ ã®ååãèšå®ããã¿ã€ããå€éšæ€èšŒãã瀺ããŸãã ãããŒããã£ãŒã«ãã§ã¯ãOracle ããŒã¿ããŒã¹ã®ååãSQL ã¯ãšãªã®ååãããŒã¿ããŒã¹ã«æ¥ç¶ããããã®ãã°ã€ã³ãšãã¹ã¯ãŒãããã©ã¡ãŒã¿ãšããŠæž¡ãã¹ã¯ãªãããå®çŸ©ããŸããã¯ãšãªã®æŽæ°ééã 5 å (300 ç§) ã«èšå®ããŸãã
2) åè»äž¡ã¹ããŒã¿ã¹ã®æ®ãã®ã¡ããªãã¯ãäœæããŸãããããã®ã¡ããªã¯ã¹ã®å€ã¯ãã¡ã€ã³ã¡ããªã¯ã¹ã®ãã§ãã¯çµæã«åºã¥ããŠçæãããŸãã
ããŒã¿èŠçŽ ã®ååãèšå®ããã¿ã€ããå€éšæ€èšŒãã瀺ããŸãã ãããŒããã£ãŒã«ãã§ã¯ãOracle ããŒã¿ããŒã¹ã®ååãšå€ã远跡ããã¹ããŒã¿ã¹ ã³ãŒãããã©ã¡ãŒã¿ãšããŠæž¡ãã¹ã¯ãªãããå®çŸ©ããŸããçµæããã¡ã€ã«ã«æžã蟌ãŸãããŸã§ã®æéã確ä¿ã§ããããã«ãã¯ãšãªã®æŽæ°ééãã¡ã€ã³ ã¡ããªã㯠(10 ç§) ããã 310 ç§é·ãèšå®ããŸããã
ã¡ããªã¯ã¹ãæ£ããååŸããã«ã¯ããã§ãã¯ãã¢ã¯ãã£ãã«ããé åºãéèŠã§ããããŒã¿åä¿¡æã®ç«¶åãé¿ããããã«ããŸãã¹ã¯ãªãã wh_Metrics.sh ãåŒã³åºããŠã¡ã€ã³ ã¡ããªã¯ã¹ GetCarsByStatus ãã¢ã¯ãã£ãã«ããŸãã
èšå® â ããŒã â 'ããŒãå' â ããŒã¿èŠçŽ â ãµããã£ã«ã¿ãŒãå€éšãã§ãã¯ããå¿ èŠãªãã§ãã¯ãå ¥ããŠãæå¹åããã¯ãªãã¯ããŸãã
次ã«ãæ®ãã®ã¡ããªã¯ã¹ã XNUMX åã®æäœã§ã¢ã¯ãã£ãåãããã¹ãŠãŸãšããŠéžæããŸãã
çŸåšãZabbix ã¯å庫ããžãã¹ææšã®åéãéå§ããŠããŸãã
次ã®èšäºã§ã¯ãGrafana ã®æ¥ç¶ãšãããŸããŸãªã«ããŽãªã®ãŠãŒã¶ãŒåãã®å庫æ¥åã®æ å ±ããã·ã¥ããŒãã®äœæã«ã€ããŠè©³ãã説æããŸãããŸããGrafanaãããŒã¹ã«å庫æ¥åã®éžè±ç£èŠãå®çŸããéžè±ã®ç¯å²ãåçŸæ§ã«å¿ããŠãAPIçµç±ã§å庫管çãµãŒãã¹ã»ã³ã¿ãŒã·ã¹ãã ã«ã€ã³ã·ãã³ããç»é²ãããã管çè ã«ã¡ãŒã«ã§ç°¡åã«éç¥ãããããããšãå¯èœã§ãã
åºæïŒ habr.com