Zabbix ã TimescaleDB ããŒã¿ããŒã¹ãããã¯ãšã³ããšããŠã©ã®ããã«åäœããããèŠãŠãããŸãã ãŒãããå§ããæ¹æ³ãšPostgreSQLãã移è¡ããæ¹æ³ã玹ä»ããŸãã XNUMX ã€ã®æ§æã®æ¯èŒããã©ãŒãã³ã¹ ãã¹ããæäŸããŸãã
HighLoad++ ã·ããªã¢ 2019ããã ã¹ã¯ ããŒã«ã 24æ16æ¥ã00æã è«æã
ã¢ã³ãã¬ã€ã»ã°ã·ã¥ãã³ (ä»¥äž â AG): â ç§ã¯ZABBIXãã¯ãã«ã«ãµããŒããšã³ãžãã¢ïŒä»¥äžãZabbixãïŒã®ãã¬ãŒããŒã§ãã ç§ã¯ãã¯ãã«ã« ãµããŒã㧠6 幎以äžåããŠãããããã©ãŒãã³ã¹ãçŽæ¥çµéšããŠããŸããã ä»æ¥ã¯ãéåžžã® PostgreSQL 10 ãšæ¯èŒããå Žåã® TimescaleDB ãæäŸã§ããããã©ãŒãã³ã¹ã«ã€ããŠèª¬æããŸãããŸããäžè¬çã«ã©ã®ããã«åäœãããã«ã€ããŠã®å°å
¥éšåãããã€ã説æããŸãã
çç£æ§ã®æ倧ã®èª²é¡: ããŒã¿åéããããŒã¿ ã¯ã¬ã³ãžã³ã°ãŸã§
ãŸãããã¹ãŠã®ç£èŠã·ã¹ãã ãçŽé¢ããç¹å®ã®ããã©ãŒãã³ã¹ã®èª²é¡ããããŸãã çç£æ§ã®æåã®èª²é¡ã¯ãããŒã¿ãè¿ éã«åéããŠåŠçããããšã§ãã
åªããç£èŠã·ã¹ãã ã¯ããã¹ãŠã®ããŒã¿ãè¿
éãã€ã¿ã€ã ãªãŒã«åä¿¡ããããªã¬ãŒåŒã«åŸã£ãŠåŠçãã€ãŸããããã€ãã®åºæº (ããã¯ã·ã¹ãã ã«ãã£ãŠç°ãªããŸã) ã«åŸã£ãŠåŠçãããã®ããŒã¿ãããŒã¿ããŒã¹ã§äœ¿çšããããã«ããŒã¿ããŒã¹ã«ä¿åããå¿
èŠããããŸããæªæ¥ã
XNUMX çªç®ã®ããã©ãŒãã³ã¹äžã®èª²é¡ã¯ãå±¥æŽã®ä¿åã§ãã ããŒã¿ããŒã¹ã«é »ç¹ã«ä¿åãããšãäžå®æéã«ããã£ãŠåéããããããã®ã¡ããªã¯ã¹ã«ãã°ããç°¡åã«ã¢ã¯ã»ã¹ã§ããŸãã æãéèŠãªããšã¯ããã®ããŒã¿ã¯ååŸãããããã¬ããŒããã°ã©ããããªã¬ãŒãäžéšã®ãããå€ãã¢ã©ãŒããªã©ã«äœ¿çšã§ãããšããããšã§ãã
5 çªç®ã®ããã©ãŒãã³ã¹ã®èª²é¡ã¯ãå±¥æŽã®ã¯ãªã¢ã§ããã€ãŸããXNUMX 幎é (æ°ã«æãŸã㯠XNUMX ãæ) ã«ããã£ãŠåéããã詳现ãªã¡ããªã¯ã¹ãä¿åããå¿
èŠããªããªãæç¹ã«å°éãããšãã§ãã äžéšã®ãããã¯ãŒã¯ ããŒããŸãã¯äžéšã®ãã¹ãã¯åé€ãããŠãããã¡ããªã¯ã¹ã¯ãã§ã«å€ããªã£ãŠåéãããªããªã£ããããã¡ããªã¯ã¹ã¯äžèŠã«ãªããŸããã ããŒã¿ããŒã¹ã倧ãããªããããªãããã«ãããããã¹ãŠãã¯ãªãŒã³ã¢ããããå¿
èŠããããŸãã äžè¬ã«ãå±¥æŽã®ã¯ãªã¢ã¯ã¹ãã¬ãŒãžã«ãšã£ãŠé倧ãªãã¹ãã§ããããšãå€ããããã©ãŒãã³ã¹ã«éåžžã«å€§ããªåœ±é¿ãäžããããšããããããŸãã
ãã£ãã·ã¥ã®åé¡ã解決ããã«ã¯ã©ãããã°ããã§ãã?
ããã§ã¯ç¹ã« Zabbix ã«ã€ããŠèª¬æããŸãã Zabbix ã§ã¯ãæåãš XNUMX çªç®ã®åŒã³åºãã¯ãã£ãã·ã¥ã䜿çšããŠè§£æ±ºãããŸãã
ããŒã¿ã®åéãšåŠç - ãã¹ãŠã®ããŒã¿ãä¿åããããã« RAM ã䜿çšããŸãã ãããã®ããŒã¿ã«ã€ããŠããã«è©³ãã説æããŸãã
ãŸããããŒã¿ããŒã¹åŽã§ã¯ãã°ã©ãããã®ä»ã®äž»èŠãªéžæã«å¯ŸããŠãã£ãã·ã¥ãè¡ãããŸãã
Zabbix ãµãŒããŒèªäœã®åŽã§ã®ãã£ãã·ã¥: ConfigurationCacheãValueCacheãHistoryCacheãTrendsCache ããããŸãã ããã¯äœã§ããïŒ
ConfigurationCache ã¯ãã¡ããªã¯ã¹ããã¹ããããŒã¿é
ç®ãããªã¬ãŒãä¿åããã¡ã€ã³ã®ãã£ãã·ã¥ã§ãã ååŠçã®åŠçãããŒã¿ã®åéãã©ã®ãã¹ãããã©ã®ãããªé »åºŠã§åéããããªã©ãå¿
èŠãªãã¹ãŠã®æ
å ±ãå«ãŸããŸãã ããŒã¿ããŒã¹ã«ã¢ã¯ã»ã¹ããŠäžèŠãªã¯ãšãªãäœæããªãããã«ããããã¯ãã¹ãŠ ConfigurationCache ã«ä¿åãããŸãã ãµãŒããŒã®èµ·ååŸããã®ãã£ãã·ã¥ãæŽæ° (äœæ) ãã(æ§æèšå®ã«å¿ããŠ) å®æçã«æŽæ°ããŸãã
Zabbix ã§ã®ãã£ãã·ã¥ã ããŒã¿åé
ããã§ã®å³ã¯éåžžã«å€§ãããªããŸãã
ãã®ã¹ããŒã ã®äž»ãªãã®ã¯æ¬¡ã®ã³ã¬ã¯ã¿ãŒã§ãã
ãããã¯ã¢ã»ã³ã㪠ããã»ã¹ãã®ãã®ã§ãããããŸããŸãªã¿ã€ãã®ã¢ã»ã³ããªãæ
åœããããŸããŸãªãããŒã©ãŒãã§ãã icmpãipmiãããã³ããŸããŸãªãããã³ã«ãä»ããŠããŒã¿ãåéããããããã¹ãŠååŠçã«è»¢éããŸãã
ååŠçå±¥æŽãã£ãã·ã¥
ãŸããèšç®ãããããŒã¿èŠçŽ (Zabbix ã«è©³ãã人ã¯ç¥ã£ãŠããã§ããã)ãã€ãŸãèšç®ãããéèšããŒã¿èŠçŽ ãããå Žåã¯ããããã ValueCache ããçŽæ¥ååŸããŸãã åãæ¹ã¯åŸã»ã©èª¬æããŸãã ããããã¹ãŠã®ã³ã¬ã¯ã¿ãŒã¯ãConfigurationCache ã䜿çšããŠãžã§ããåä¿¡ããååŠçã«æž¡ããŸãã
ååŠçã§ã¯ãConfigurationCache ã䜿çšããŠååŠçã¹ããããååŸãããã®ããŒã¿ãããŸããŸãªæ¹æ³ã§åŠçããŸãã ããŒãžã§ã³ 4.2 ããã¯ããããã·ã«ç§»åããŸããã ååŠçèªäœããªããªãé£ããæäœãªã®ã§ãããã¯éåžžã«äŸ¿å©ã§ãã ãŸããéåžžã«å€§èŠæš¡ãª Zabbix ããããå€æ°ã®ããŒã¿èŠçŽ ããããåéé »åºŠãé«ãå Žåãäœæ¥ã倧å¹
ã«ç°¡çŽ åãããŸãã
ãããã£ãŠãååŠçã䜿çšããŠãã®ããŒã¿ãäœããã®æ¹æ³ã§åŠçããåŸãããã«åŠçããããã« HistoryCache ã«ä¿åããŸãã ããã§ããŒã¿åéã¯çµäºã§ãã ã¡ã€ã³ã®å·¥çšã«ç§»ããŸãã
ãã¹ããªãŒã·ã³ãµãŒã®äœå
Zabbix ã®äž»ãªããã»ã¹ (ã¢ããªã·ã㯠ã¢ãŒããã¯ãã£ã§ãããã) ã¯å±¥æŽåæã§ãã ããã¯ãåããŒã¿èŠçŽ ãã€ãŸãåå€ã®ã¢ãããã¯ãªåŠçãç¹ã«æ±ãã¡ã€ã³ ããã»ã¹ã§ãã
- å€ãæ¥ãŸã (HistoryCache ããååŸããŸã)ã
- Configuration syncer ã§ãã§ãã¯ããŸããèšç®ã®ããªã¬ãŒããããã©ãã - ããããèšç®ããŸãã
ååšããå Žå - æ§æã«åŸã£ãŠå¿ èŠã«å¿ããŠãã€ãã³ããäœæããã¢ã©ãŒããäœæããããã«ãšã¹ã«ã¬ãŒã·ã§ã³ãäœæããŸãã - åŸç¶ã®åŠçãéèšã®ããã®ã¬ã³ãŒãã®ããªã¬ãŒã éå» XNUMX æéãªã©ã«éèšããå Žåããã®å€ã¯å±¥æŽããŒãã«ã«ä¿åãããªãããã« ValueCache ã«ãã£ãŠèšæ¶ãããŸãã ãããã£ãŠãValueCache ã«ã¯ãããªã¬ãŒãèšç®èŠçŽ ãªã©ã®èšç®ã«å¿ èŠãªããŒã¿ãæžã蟌ãŸããŸãã
- 次ã«ãå±¥æŽåææ©èœããã¹ãŠã®ããŒã¿ãããŒã¿ããŒã¹ã«æžã蟌ã¿ãŸãã
- ããŒã¿ããŒã¹ã¯ãããããã£ã¹ã¯ã«æžã蟌ã¿ãŸããããã§åŠçããã»ã¹ãçµäºããŸãã
ããŒã¿ããŒã¹ã ãã£ãã·ã³ã°
ããŒã¿ããŒã¹åŽã§ã¯ãã€ãã³ãã«é¢ããã°ã©ããã¬ããŒãã衚瀺ãããå ŽåãããŸããŸãªãã£ãã·ã¥ããããŸãã ãããããã®ã¬ããŒãã§ã¯ãããã«ã€ããŠã¯è§ŠããŸããã
MySQL ã®å Žåã¯ãInnodb_buffer_pool ãšãåæ§ã«æ§æã§ããããŸããŸãªãã£ãã·ã¥ããããŸãã
ããããäž»ãªãã®ã¯æ¬¡ã®ãšããã§ãã
- å ±æãããã¡;
- å¹æçãªãã£ãã·ã¥ãµã€ãº;
- å ±æããŒã«ã
ãã¹ãŠã®ããŒã¿ããŒã¹ã«ã¯ãã¯ãšãªã«ããå¿
èŠãšãªãããŒã¿ã RAM ã«ä¿åã§ããç¹å®ã®ãã£ãã·ã¥ããããšè¿°ã¹ãŸããã 圌ãã¯ãã®ããã®ç¬èªã®æè¡ãæã£ãŠããŸãã
ããŒã¿ããŒã¹ã®ããã©ãŒãã³ã¹ã«ã€ããŠ
ãããã£ãŠãZabbix ãµãŒããŒãããŒã¿ãåéããŠèšé²ãããšãã競äºç°å¢ãååšããŸãã åèµ·åãããšãå±¥æŽããèªã¿åããValueCache ãªã©ã«æžã蟌ã¿ãŸãã ããã§ã¯ãWeb ã€ã³ã¿ãŒãã§ã€ã¹äžã«æ§ç¯ããã Zabbix API ã䜿çšããã¹ã¯ãªãããšã¬ããŒããäœæã§ããŸãã Zabbix API ã¯ããŒã¿ããŒã¹ã«å ¥ããã°ã©ããã¬ããŒãããŸãã¯ããçš®ã®ã€ãã³ããæè¿ã®åé¡ã®ãªã¹ããååŸããããã«å¿ èŠãªããŒã¿ãåãåããŸãã
ãŸããéåžžã«äººæ°ã®ããèŠèŠåãœãªã¥ãŒã·ã§ã³ãšããŠããŠãŒã¶ãŒã䜿çšããŠãã Grafana ããããŸãã Zabbix API ãšããŒã¿ããŒã¹ã®äž¡æ¹ãä»ããŠçŽæ¥ãã°ã€ã³ã§ããŸãã ãŸããããŒã¿ãååŸããããã«äžå®ã®ç«¶äºãçºçããŸããçµæãšãã¹ãã®è¿
éãªæäŸã«æºæ ããã«ã¯ãããŒã¿ããŒã¹ããã现ãããããé©åã«èª¿æŽããå¿
èŠããããŸãã
å±¥æŽãã¯ãªã¢ããŸãã Zabbix ã«ã¯ããŠã¹ããŒããŒãããŸã
Zabbix ã§äœ¿çšããã XNUMX çªç®ã®åŒã³åºãã¯ãHousekeeper ã䜿çšããå±¥æŽã®ã¯ãªã¢ã§ãã Housekeeper ã¯ãã¹ãŠã®èšå®ã«åŸããŸããã€ãŸããããŒã¿èŠçŽ ã¯ãä¿åããæé (æ¥åäœ)ãåŸåãä¿åããæéãããã³å€æŽã®ãã€ããã¯ã¹ã瀺ããŸãã
TrendCache ã«ã€ããŠã¯è§ŠããŸããã§ãããTrendCache ã¯ãã®å Žã§èšç®ããŸããããŒã¿ãå°çããããã XNUMX æééèšã (ã»ãšãã©ã®å Žåãéå» XNUMX æéã®æ°å€ã§ã)ãéã¯å¹³å/æå°ã§ãXNUMX æéã« XNUMX åèšé²ããŸããå€åã®ãã€ããã¯ã¹ã®è¡š (ããã¬ã³ãã) ã ãããŠã¹ããŒããŒãã¯éåžžã®éžæã䜿çšããŠããŒã¿ããŒã¹ãèµ·åããããŒã¿ããŒã¹ããããŒã¿ãåé€ããŸãããããã¯åžžã«å¹æçã§ãããšã¯éããŸããã
å¹æããªãããšãã©ã®ããã«ç解ããã°ããã§ããããïŒ å éšããã»ã¹ã®ããã©ãŒãã³ã¹ ã°ã©ãã§æ¬¡ã®å³ã確èªã§ããŸãã
å±¥æŽåææ©èœã¯åžžã«ããžãŒç¶æ
ã§ã (èµ€ãã°ã©ã)ã ãããŠäžçªäžã«ãããèµ€ããã°ã©ãã ããã¯ãããŒã¿ããŒã¹ãæå®ãããã¹ãŠã®è¡ãåé€ããã®ãéå§ããŠåŸ
æ©ãããããŠã¹ããŒããŒãã§ãã
ã¢ã€ãã ID ãååŸããŸããããæåŸã® 5 ãåé€ããå¿ èŠããããŸãã ãã¡ããã€ã³ããã¯ã¹ã«ããã ããããéåžžãããŒã¿ã»ããã¯éåžžã«å€§ãããããŒã¿ããŒã¹ã¯äŸç¶ãšããŠããŒã¿ã»ããããã£ã¹ã¯ããèªã¿åã£ãŠãã£ãã·ã¥ã«çœ®ããŸãããããã¯ããŒã¿ããŒã¹ã«ãšã£ãŠéåžžã«ã³ã¹ãã®ãããæäœã§ãã ãµã€ãºã«ãã£ãŠã¯ãç¹å®ã®ããã©ãŒãã³ã¹äžã®åé¡ãçºçããå¯èœæ§ããããŸãã
Housekeeper ã¯ç°¡åãªæ¹æ³ã§ç¡å¹ã«ã§ããŸãã䜿ãæ £ãã Web ã€ã³ã¿ãŒãã§ã€ã¹ãçšæãããŠããŸãã 管çå šè¬ã®èšå® (ãããŠã¹ããŒããŒãã®èšå®) ã§ã¯ãå éšå±¥æŽãšåŸåã®ããã®å éšããŠã¹ããŒãã³ã°ãç¡å¹ã«ããŸãã ãããã£ãŠãHousekeeper ã¯ãããå¶åŸ¡ããªããªããŸããã
次ã«äœãã§ããã§ããããïŒ ããããªãã«ããã®ã§ãã°ã©ãã¯æšªã°ãã«ãªããŸãã...ãã®å Žåãããã«ã©ã®ãããªåé¡ãçºçããå¯èœæ§ããããŸãã? äœã圹ç«ã€ã§ããããïŒ
ããŒãã£ã·ã§ãã³ã°ïŒã»ã¯ã·ã§ã³åïŒ
éåžžãããã¯ããªã¹ãããåãªã¬ãŒã·ã§ãã« ããŒã¿ããŒã¹ã§ç°ãªãæ¹æ³ã§æ§æãããŸãã MySQL ã«ã¯ç¬èªã®ãã¯ãããžãŒããããŸãã ãã ããPostgreSQL 10 ãš MySQL ã«é¢ããŠã¯ãå šäœçã«ã¯éåžžã«äŒŒãŠããŸãã ãã¡ããããã®å®è£ æ¹æ³ãããã©ãŒãã³ã¹ãžã®åœ±é¿ã«ã€ããŠã¯ãå éšçã«ã¯å€ãã®éãããããŸãã ãã ããäžè¬ã«ãæ°ããããŒãã£ã·ã§ã³ãäœæãããšãç¹å®ã®åé¡ãçºçããããšããããããŸãã
èšå® (1 æ¥ã«äœæããããŒã¿ã®é) ã«å¿ããŠãéåžžã¯æå°å€ãèšå®ãããŸãããã㯠1 æ¥/ãããã§ãããã¬ã³ãããã€ãŸãå€æŽã®ãã€ããã¯ã¹ã®å Žåã¯ãXNUMX ãæ/æ°ãããããã§ãã éåžžã«å€§èŠæš¡ãªã»ããã¢ãããããå Žåã¯ããããå€ããå¯èœæ§ããããŸãã
ã»ããã¢ããã®ãµã€ãºã«ã€ããŠããã«èšã£ãŠã¿ãŸãããã5 ç§ãããæ倧 5 ã®æ°ããå€ (ãããã nvps) - ããã¯å°èŠæš¡ãªãã»ããã¢ããããšã¿ãªãããŸãã å¹³å â 25 ç§ããã XNUMX ïœ XNUMX ã®å€ã äžèšã¯ãã§ã«å€§èŠæš¡ãªã€ã³ã¹ããŒã«ã§ãããããŒã¿ããŒã¹ã®éåžžã«æ éãªæ§æãå¿ èŠãšããéåžžã«å€§èŠæš¡ãªã€ã³ã¹ããŒã«ã§ãã
éåžžã«å€§èŠæš¡ãªã€ã³ã¹ããŒã«ã§ã¯ã1 æ¥ãæé©ã§ã¯ãªãå¯èœæ§ããããŸãã ç§ã¯å人çã«ãMySQL äžã§ 40 æ¥ããã XNUMX ã®ã¬ãã€ãã®ããŒãã£ã·ã§ã³ãèŠãããšããããŸã (ããã«å€ãã®ããŒãã£ã·ã§ã³ããããããããŸãã)ã ããã¯éåžžã«å€§éã®ããŒã¿ã§ãããããããã€ãã®åé¡ãçºçããå¯èœæ§ããããŸãã ãããæžããå¿ èŠããããŸãã
ãªãããŒãã£ã·ã§ã³åå²ãå¿ èŠãªã®ã§ãããã?
Partitioning ãæäŸãããã®ã¯ã誰ããç¥ã£ãŠãããšæããŸãããããŒãã«ã®ããŒãã£ã·ã§ãã³ã°ã§ãã å€ãã®å Žåããããã¯ãã£ã¹ã¯äžã®å¥åã®ãã¡ã€ã«ã§ãããã¹ãã³èŠæ±ã§ãã éåžžã®ããŒãã£ã·ã§ã³åå²ã®äžéšã§ããå ŽåãXNUMX ã€ã®ããŒãã£ã·ã§ã³ãããæé©ã«éžæãããŸãã
ç¹ã«ãZabbix ã®å Žåãç¯å²ããšã«äœ¿çšãããŸããã€ãŸããã¿ã€ã ã¹ã¿ã³ã (éåžžã®æ°å€ããšããã¯ã®éå§ããã®æé) ã䜿çšãããŸãã äžæ¥ã®å§ãŸããšçµãããæå®ããŸãããããããŒãã£ã·ã§ã³ã§ãã ãããã£ãŠãXNUMX æ¥åã®ããŒã¿ãèŠæ±ããŠããå Žåã(倧ããªããŒãã«ã§ã¯ãªã) XNUMX ã€ã®ãã¡ã€ã«ããã£ãã·ã¥ã«ããŒãããŠè¿ãã ãã§æžããããããŒã¿ããŒã¹ãããã¹ãŠãããéãååŸãããŸãã
å€ãã®ããŒã¿ããŒã¹ã§ã¯ãæ¿å
¥ (XNUMX ã€ã®åããŒãã«ãžã®æ¿å
¥) ãé«éåãããŸãã ä»ã¯æœè±¡çã«è©±ããŠããŸãããããããããšãããåŸãŸãã å€ãã®å ŽåãããŒãã£ã·ã§ãã³ã°ã圹ç«ã¡ãŸãã
NoSQLçšã®Elasticsearch
æè¿ã3.4 㧠NoSQL ãœãªã¥ãŒã·ã§ã³ãå®è£ ããŸããã Elasticsearchã«æžã蟌ãæ©èœãè¿œå ããŸããã ç¹å®ã®çš®é¡ãæžãããšãã§ããŸããæ°åãŸãã¯èšå·ã®ãããããéžæããŸãã æååããã¹ããããã®ã§ãElasticsearch ã«ãã°ãæžã蟌ãããšãã§ããŸã... ãããã£ãŠãWeb ã€ã³ã¿ãŒãã§ã€ã¹ã Elasticsearch ã«ã¢ã¯ã»ã¹ããŸãã ããã¯å Žåã«ãã£ãŠã¯ããŸãæ©èœããŸãããçŸæç¹ã§ã¯äœ¿çšã§ããŸãã
ã¿ã€ã ã¹ã±ãŒã«DBã ãã€ããŒããŒãã«
4.4.2 ã§ã¯ãTimescaleDB ã®ãã㪠XNUMX ã€ã®ããšã«æ³šæãæããŸããã ããã¯äœã§ããïŒ ãã㯠PostgreSQL ã®æ¡åŒµæ©èœã§ããã€ãŸãããã€ãã£ãã® PostgreSQL ã€ã³ã¿ãŒãã§ã€ã¹ãåããŠããŸãã ããã«ããã®æ¡åŒµæ©èœã䜿çšãããšãæç³»åããŒã¿ãããå¹ççã«æäœããèªåããŒãã£ã·ã§ãã³ã°ãè¡ãããšãã§ããŸãã ããã¯ã©ã®ãããªãã®ãïŒ
ããã¯ãã€ããŒããŒãã«ã§ããTimescale ã«ã¯ãã®ãããªæŠå¿µããããŸãã ããã¯äœæãããã€ããŒããŒãã«ã§ããããã£ã³ã¯ãå«ãŸããŠããŸãã ç§ã®èšæ¶ãééã£ãŠããªããã°ããã£ã³ã¯ã¯ããŒãã£ã·ã§ã³ã§ãããåããŒãã«ã§ãã æ¬åœã«å¹æçã§ãã
TimescaleDB ãš PostgreSQL
TimescaleDB ã¡ãŒã«ãŒãä¿èšŒããŠããããã«ãã¯ãšãªãç¹ã«æ¿å ¥ã®åŠçã«ã¯ããæ£ç¢ºãªã¢ã«ãŽãªãºã ã䜿çšãããŠãããããŒã¿ã»ããæ¿å ¥ã®ãµã€ãºãå¢å ããŠãã»ãŒäžå®ã®ããã©ãŒãã³ã¹ãç¶æã§ããŸãã ã€ãŸããPostgres ã 200 åè¡ãè¶ ãããšãéåžžã® Postgres ã¯å€§å¹ ã«äœäžãå§ããããã©ãŒãã³ã¹ãæåéããŒãã«ãªããŸããäžæ¹ãTimescale ã䜿çšãããšãã©ããªéã®ããŒã¿ã§ãã§ããã ãå¹ççã«æ¿å ¥ãè¡ãããšãã§ããŸãã
TimescaleDBãã€ã³ã¹ããŒã«ããã«ã¯ã©ãããã°ããã§ãã? ããã¯ç°¡åã§ãïŒ
ããã¯ããã¥ã¡ã³ãã«èšèŒãããŠãããããããããã±ãŒãžããã€ã³ã¹ããŒã«ã§ããŸã...å ¬åŒã® Postgres ããã±ãŒãžã«äŸåããŸãã æåã§ã³ã³ãã€ã«ã§ããŸãã ããŸããŸããŒã¿ããŒã¹çšã«ã³ã³ãã€ã«ããå¿ èŠããããŸããã
Zabbix ã§ã¯ãåã«æ¡åŒµæ©èœãæå¹ã«ããã ãã§ãã Postgresã§Extentionã䜿ã£ãŠããæ¹ã¯ãExtentionãæå¹åããŠã䜿çšããŠããZabbixããŒã¿ããŒã¹çšã«äœæããã ãã§ãã
ãããŠæåŸã®ã¹ãããã¯âŠ
ã¿ã€ã ã¹ã±ãŒã«DBã å±¥æŽããŒãã«ã®ç§»è¡
ãã€ããŒããŒãã«ãäœæããå¿ èŠããããŸãã ããã«ã¯ããã€ããŒããŒãã«ã®äœæãšããç¹å¥ãªé¢æ°ããããŸãã ãã®äžã§ãæåã®ãã©ã¡ãŒã¿ã¯ããã®ããŒã¿ããŒã¹ã§å¿ èŠãªããŒãã«ã§ã (ãã€ããŒããŒãã«ãäœæããå¿ èŠããããŸã)ã
äœæãããã£ãŒã«ããš chunk_time_interval (ããã¯ãã£ã³ã¯ (䜿çšããå¿
èŠãããããŒãã£ã·ã§ã³) ã®ééã§ãã86 㯠400 æ¥ã§ãã
Migrate_data ãã©ã¡ãŒã¿ãŒ: true ã«æ¿å ¥ãããšãçŸåšã®ããŒã¿ããã¹ãŠäºåã«äœæããããã£ã³ã¯ã«ç§»è¡ãããŸãã
ç§èªèº«ã merge_data ã䜿çšããŸããããããŒã¿ããŒã¹ã®èŠæš¡ã«ããããŸãããããªãã®æéãããããŸãã XNUMX ãã©ãã€ã以äžãããŸããããäœæããã®ã« XNUMX æé以äžããããŸããã å Žåã«ãã£ãŠã¯ããã¹ãäžã«ãããã¹ã (history_text) ãšæåå (history_str) ã®å±¥æŽããŒã¿ã転éããªãããã«åé€ããŸããããããã¯ç§ã«ãšã£ãŠããŸãèå³ã®ãªããã®ã§ããã
ãããŠãdb_extention ã§æåŸã®æŽæ°ãè¡ããŸããtimescaledb ãã€ã³ã¹ããŒã«ããŠãããŒã¿ããŒã¹ãç¹ã« Zabbix ã db_extention ã®ååšãèªèã§ããããã«ããŸãã 圌ã¯ãããã¢ã¯ãã£ãåããTimescaleDB ã«å¿ èŠãªãæ©èœãã䜿çšããŠãæ£ããæ§æãšããŒã¿ããŒã¹ãžã®ã¯ãšãªã䜿çšããŸãã
ãµãŒããŒæ§æ
20å°ã®ãµãŒããŒã䜿çšããŸããã æåã®ãµãŒããŒã¯ã16 ããã»ããµã10.8 ã®ã¬ãã€ãã® RAM ãåããããªãå°ããªä»®æ³ãã·ã³ã§ãã Postgres XNUMXãæ§æããŸããã
ãªãã¬ãŒãã£ã³ã° ã·ã¹ãã 㯠Debianããã¡ã€ã« ã·ã¹ãã 㯠xfs ã§ããã Zabbix èªäœã䜿çšãããã®ãé€ããŠããã®ç¹å®ã®ããŒã¿ããŒã¹ã䜿çšããããã®æå°éã®èšå®ãäœæããŸããã åããã·ã³äžã« Zabbix ãµãŒããŒãPostgreSQLãããã³ããŒã ãšãŒãžã§ã³ãããããŸããã
LoadableModule ã䜿çšããŠããŸããŸãªçµæãè¿
éã«çæãã 50 åã®ã¢ã¯ãã£ã ãšãŒãžã§ã³ãã䜿çšããŸããã æååãæ°å€ãªã©ãçæããã®ã¯åœŒãã§ãã ããŒã¿ããŒã¹ã«å€§éã®ããŒã¿ãè©°ã蟌ã¿ãŸããã åœåãæ§æã«ã¯ãã¹ãããšã« 5 ã®ããŒã¿èŠçŽ ãå«ãŸããŠããããããå®éã®ã»ããã¢ããã«ããããã«ãã»ãŒåããŒã¿èŠçŽ ã«ããªã¬ãŒãå«ãŸããŠããŸããã å Žåã«ãã£ãŠã¯ãè€æ°ã®ããªã¬ãŒã䜿çšããå¿
èŠãããããšããããŸãã
50 åã®ãšãŒãžã§ã³ãã䜿çšãã (ããã«è¿œå ãã) ã ãã§ãªããåçããŒã¿èŠçŽ ã䜿çšããŠæŽæ°ééã 4 ç§ã«ççž®ããããšã§ãæŽæ°ééãšè² è·èªäœã調æŽããŸããã
æ§èœãã¹ãã PostgreSQL: 36 NVP
æåã®èµ·åãæåã®ã»ããã¢ããã¯ããã®ããŒããŠã§ã¢äžã®çŽç²ãª PostreSQL 10 ã§ãã (35 ç§ããã 200 ã®å€)ã äžè¬ã«ãç»é¢ã§ãããããã«ãããŒã¿ã®æ¿å ¥ã«ã¯ã»ãã®æ°ç§ããããŸããSSD ãã©ã€ã (20 ã®ã¬ãã€ã) ã§ã¯ãã¹ãŠãè¯å¥œã§é«éã§ãã ãã ãXNUMX GB ã¯ããã«ãã£ã±ãã«ãªã£ãŠããŸããŸãã
å°æ¥çã«ã¯ããã®ãããªã°ã©ããããããç»å Žããã§ãããã ããã¯ãæšæºã® Zabbix ãµãŒã㌠ããã©ãŒãã³ã¹ ããã·ã¥ããŒãã§ãã
æåã®ã°ã©ã㯠35 ç§ãããã®å€ã®æ° (éãå·Šäž)ããã®å Žå㯠XNUMX ã®å€ã§ãã ãã (äžå€®äžéš) ã¯ãã«ã ããã»ã¹ã®èªã¿èŸŒã¿ã§ããã (å³äž) ã¯å
éšããã»ã¹ (å±¥æŽåææ©èœãšããŠã¹ããŒããŒ) ã®èªã¿èŸŒã¿ã§ãããã (äžå€®äžéš) ã¯ããªãé·ãéå®è¡ãããŠããŸãã
ãã®ã°ã©ã (äžå€®äž) ã¯ãValueCache ã®äœ¿çšéãã€ãŸãããªã¬ãŒã«å¯Ÿãã ValueCache ã®ãããæ° (XNUMX ç§ãããæ°åã®å€) ã瀺ããŠããŸãã ãã XNUMX ã€ã®éèŠãªã°ã©ã㯠XNUMX çªç®ã®ã°ã©ã (å·Šäž) ã§ãå ã»ã©èª¬æãã HistoryCache ã®äœ¿çšæ³ã瀺ããŠããŸããããã¯ããŒã¿ããŒã¹ã«æ¿å ¥ããåã®ãããã¡ã§ãã
æ§èœãã¹ãã PostgreSQL: 50 NVP
次ã«ãåãããŒããŠã§ã¢ã§è² è·ã 50 ç§ããã 10 ã®å€ã«å¢å ããŸããã Housekeeper ãããŒããããšãèšç®ã«ãã 2 ïœ 3 ç§ã§ XNUMX åã®å€ãèšé²ãããŸããã å®éã次ã®ã¹ã¯ãªãŒã³ã·ã§ããã«ç€ºãããŠããå 容ã¯æ¬¡ã®ãšããã§ãã
ã家æ¿å©Šãã¯ãã§ã«ä»äºã«æ¯éããããå§ããŠããŸãããäžè¬çã«ãæŽå²ãå»ãçœ åž«ã®è² è·ã¯äŸç¶ãšã㊠60% ã®ã¬ãã«ã«ãããŸã (20 çªç®ã®ã°ã©ããå³äž)ã Housekeeper ã®å®è¡äžãHistoryCache ã¯ãã§ã«ã¢ã¯ãã£ãã«åãå§ããŠããŸã (å·Šäž)ã çŽååã®ã¬ãã€ããXNUMX% ããã£ã±ãã§ããã
æ§èœãã¹ãã PostgreSQL: 80 NVP
次ã«ã80 ç§ããã XNUMX ã®å€ã«å¢ãããŸããã
ããŒã¿èŠçŽ æ°ã¯çŽ 400 äžãããªã¬ãŒæ°ã¯ 280 äžã§ããã ã芧ã®ãšãããã€ã³ãµãŒãã¯æŽå²çãªã·ã³ã«ãŒïŒ30åãããŸããïŒã®è² è·ãšããç¹ã§ãã§ã«ããªãé«ãã£ãã§ãã 次ã«ããã¹ã㪠ã·ã³ã«ãŒããã£ãã·ã¥ãªã©ã®ããŸããŸãªãã©ã¡ãŒã¿ãå¢ãããŸããããã®ããŒããŠã§ã¢ã§ã¯ããã¹ã㪠ã·ã³ã«ãŒã®è² è·ãæ倧å€ãŸã§å¢å ãå§ããã»ãŒãæ£äžããç¶æ
ã«ãªããŸãããããã«å¿ããŠãHistoryCache ã®è² è·ãéåžžã«é«ããªããŸããã
ãã®éãã£ãšããã¹ãŠã®ã·ã¹ãã ãã©ã¡ãŒã¿ (ããã»ããµã®äœ¿çšç¶æ³ãRAM) ãç£èŠãããã£ã¹ã¯äœ¿çšçãæ倧ã§ããããšãçºèŠããŸããããã®ããŒããŠã§ã¢ããã®ä»®æ³ãã·ã³äžã®ãã®ãã£ã¹ã¯ã®æ倧容éã«éããŸããã ãPostgresãã¯ããã®ãããªåŒ·åºŠã§éåžžã«æŽ»çºã«ããŒã¿ããã³ããå§ãããã£ã¹ã¯ã«ã¯æžã蟌ã¿ãèªã¿åããè¡ãæéããªããªããŸãã...
ãã§ã« 48 åã®ããã»ããµãš 128 ã®ã¬ãã€ãã® RAM ãåããå¥ã®ãµãŒããŒã䜿çšããŸããã
ãŸãããããã調æŽãããŸãã - å±¥æŽåæåš (60 å) ãã€ã³ã¹ããŒã«ãã蚱容å¯èœãªããã©ãŒãã³ã¹ãéæããŸããã å®éãç§ãã¡ã¯ãæ£äžããã§ã¯ãããŸãããããããããããçç£æ§ã®éçã§ããããã§ã«äœããã®å¯Ÿå¿ãå¿
èŠã«ãªã£ãŠããŸãã
æ§èœãã¹ãã TimescaleDB: 80 NVP
ç§ã®äž»ãªã¿ã¹ã¯ã¯ãTimescaleDB ã䜿çšããããšã§ããã åã°ã©ãã¯èœã¡èŸŒã¿ã瀺ããŠããŸãã
ãããã®å€±æã¯ãŸãã«ããŒã¿ç§»è¡ã§ãã ãã®åŸãZabbix ãµãŒããŒã§ã¯ãã芧ã®ãšãããå±¥æŽã·ã³ã«ãŒã®èªã¿èŸŒã¿ãããã¡ã€ã«ã倧å¹
ã«å€æŽãããŸããã ããã«ãããã»ãŒ 3 åã®éãã§ããŒã¿ãæ¿å
¥ã§ããHistoryCache ã®äœ¿çšéãå°ãªããªããããããŒã¿ã¯äºå®éãã«é
ä¿¡ãããŸãã ç¹°ãè¿ããŸããã80 ç§ããã XNUMX ã®å€ã¯ããªãé«ãã¬ãŒãã§ã (ãã¡ãããYandex ã®å Žåã§ã¯ãããŸãã)ã å
šäœãšããŠãããã¯ãµãŒããŒã XNUMX å°ããããªã倧èŠæš¡ãªã»ããã¢ããã§ãã
PostgreSQL ããã©ãŒãã³ã¹ ãã¹ã: 120 NVP
次ã«ãããŒã¿èŠçŽ æ°ã®å€ã 125 äžã«å¢ãããXNUMX ç§ããã XNUMX ãšããèšç®å€ãåãåããŸããã
ãããŠã次ã®ãããªã°ã©ããåŸãããŸããã
ååãšããŠãããã¯åäœããã»ããã¢ããã§ãããããªãé·æéåäœããå¯èœæ§ããããŸãã ãããã1,5 ãã©ãã€ãã®ãã£ã¹ã¯ããæã£ãŠããªãã£ãã®ã§ãæ°æ¥ã§äœ¿ãåã£ãŠããŸããŸããã æãéèŠãªããšã¯ãåæã«æ°ããããŒãã£ã·ã§ã³ã TimescaleDB äžã«äœæãããããšã§ãããããã¯ããã©ãŒãã³ã¹ã«ã¯ãŸã£ãã圱é¿ãããŸããã§ããããã㯠MySQL ã«ã€ããŠã¯èšããŸããã
éåžžãããŒãã£ã·ã§ã³ã¯å€éã«äœæãããŸããããã¯ãéåžžãããŒãã«ã®æ¿å ¥ãæäœããããã¯ããããµãŒãã¹ã®äœäžã«ã€ãªããå¯èœæ§ãããããã§ãã ãã®å Žåã¯ããã§ã¯ãããŸããïŒ äž»ãªã¿ã¹ã¯ã¯ãTimescaleDB ã®æ©èœããã¹ãããããšã§ããã çµæã¯æ¬¡ã®ãããªæ°åã«ãªããŸãã: 120 ç§ããã XNUMX äžã®å€ã
ã³ãã¥ããã£ã«ã¯æ¬¡ã®ãããªäŸããããŸãã
ãŸãããã®äººç©ã¯ TimescaleDB ããªã³ã«ããio.weight ã䜿çšããéã®ããã»ããµã®è² è·ã軜æžãããŸããã ãŸããTimescaleDB ã®å°å
¥ã«ãããå
éšããã»ã¹èŠçŽ ã®äœ¿çšãæžå°ããŸããã ããã«ããããã¯éåžžã®ãã³ã±ãŒã ãã£ã¹ã¯ãã€ãŸãéåžžã®ãã£ã¹ã¯ (SSD ã§ã¯ãªã) äžã®éåžžã®ä»®æ³ãã·ã³ã§ãã
ãã£ã¹ã¯ã®ããã©ãŒãã³ã¹ã«ãã£ãŠå¶éãããå°èŠæš¡ãªã»ããã¢ããã®å Žåãç§ã®æèŠã§ã¯ãTimescaleDB ã¯éåžžã«åªãããœãªã¥ãŒã·ã§ã³ã§ãã ããã«ãããããŒã¿ããŒã¹çšã«é«éãªããŒããŠã§ã¢ã«ç§»è¡ããåã«äœæ¥ãç¶ããããšãã§ããŸãã
ã¢ã¹ã¯ã¯ã§ã®ã«ã³ãã¡ã¬ã³ã¹ããªã¬ã§ã®ãµããããªã©ãç§ãã¡ã®ã€ãã³ãã«çããããæåŸ ããŸãã ãã¬ã°ã©ã ããã©ãŒã©ã ãIRC ãªã©ã®ãã£ãã«ã䜿çšããŠãã ããã ã質åãããããŸããããç§ãã¡ã®ãã¹ã¯ãŸã§ãè¶ããã ãããäœã§ããçžè«ããã ããŸãã
èŽè¡ã®è³ªå
èŽè¡ããã®è³ªå (以äžãA): - TimescaleDB ã®æ§æãéåžžã«ç°¡åã§ãããã»ã©ããã©ãŒãã³ã¹ãåäžããã®ã§ããã°ãããããããã Postgres 㧠Zabbix ãæ§æããããã®ãã¹ã ãã©ã¯ãã£ã¹ãšããŠäœ¿çšããå¿ èŠããããŸãã? ãããŠããã®ãœãªã¥ãŒã·ã§ã³ã«ã¯èœãšãç©Žãæ¬ ç¹ã¯ãããŸããããããšãçµå±ã®ãšãããèªå㧠Zabbix ãäœæããããšã«æ±ºããå ŽåãPostgres ãç°¡åã«äœ¿çšã§ããTimescale ãããã«ããã«ã€ã³ã¹ããŒã«ããåé¡ãèããã«äœ¿çšã§ããŸãã?
AG: â ã¯ããããã¯è¯ãæšå¥šäºé
ã ãšæããŸããTimescaleDB æ¡åŒµæ©èœãåãã Postgres ãããã«äœ¿çšããŠãã ããã ãã§ã«è¿°ã¹ãããã«ããã®ãæ©èœãã¯å®éšçãªãã®ã§ããã«ãããããããå€ãã®è¯ãã¬ãã¥ãŒãå¯ããããŠããŸãã ããããå®éã®ãã¹ãã§ã¯ãããã (TimescaleDB ã䜿çšãã) åªãããœãªã¥ãŒã·ã§ã³ã§ããããšã瀺ãããŠãããä»åŸé²åãããšæããŸãã ç§ãã¡ã¯ãã®æ¡åŒµæ©èœãã©ã®ããã«éçºãããããç£èŠããŠãããå¿
èŠã«å¿ããŠå€æŽãå ããŸãã
éçºäžã§ãã£ãŠããç§ãã¡ã¯ãã®ããç¥ããããæ©èœãã® XNUMX ã€ã«äŸåããŠããŸãããããã¯ããã£ã³ã¯ãå°ãç°ãªãæ¹æ³ã§æäœããããšãå¯èœã§ããã ãããã次ã®ãªãªãŒã¹ã§ã¯ãããåé€ããããããç§ãã¡ã¯ãã®ã³ãŒããžã®äŸåããããªããã°ãªããŸããã§ããã å€ãã®ã»ããã¢ããã§ãã®ãœãªã¥ãŒã·ã§ã³ã䜿çšããããšããå§ãããŸãã MySQL ã䜿çšããŠããå Žå... å¹³åçãªã»ããã¢ããã§ã¯ãã©ã®ãœãªã¥ãŒã·ã§ã³ã§ãåé¡ãªãæ©èœããŸãã
AïŒ â ã³ãã¥ããã£ããã®æåŸã®ã°ã©ãã«ã¯ããHousekeeperããå«ãã°ã©ãããããŸããã
圌ã¯åãç¶ããã Housekeeper 㯠TimescaleDB ã䜿ã£ãŠäœãããŸãã?
AG: â ä»ã¯ç¢ºããªããšã¯èšããŸãã â ã³ãŒããèŠãŠãããã«è©³ããã話ããŸãã TimescaleDB ã¯ãšãªã䜿çšããŠãã£ã³ã¯ãåé€ããã®ã§ã¯ãªããäœããã®æ¹æ³ã§ãã£ã³ã¯ãéçŽããŸãã ãã®æè¡çãªè³ªåã«ã¯ãŸã çããæºåãã§ããŠããŸããã ä»æ¥ãææ¥ã®ã¹ã¿ã³ãã§è©³çŽ°ãããããŸãã
AïŒ â Timescale ã§ã®åé€æäœã®ããã©ãŒãã³ã¹ã«ã€ããŠãåæ§ã®è³ªåããããŸãã
A (èŽè¡ããã®åç): â ããŒãã«ããããŒã¿ãåé€ãããšããåé€ãä»ããŠè¡ãå Žåã¯ãããŒãã«ãåŠçããå¿
èŠããããŸããåé€ãã¯ãªãŒã³ã¢ãããå°æ¥ã®ããã¥ãŒã ã®ããã«ãã¹ãŠãããŒã¯ããå¿
èŠããããŸãã Timescale ã§ã¯ããã£ã³ã¯ããããããããããã§ããŸãã ãã£ããèšããšãããã°ããŒã¿ã«ãããã¡ã€ã«ã«ãåé€ããŠïŒããšæ瀺ããã ãã§ãã
Timescale ã¯ããã®ãããªãã£ã³ã¯ãããååšããªãããšãåã«ç解ããŸãã ãŸããã¯ãšãª ãã©ã³ããŒã«çµ±åãããŠãããããããã¯ã䜿çšããŠéžæããã®ä»ã®æäœã§æ¡ä»¶ããã£ãããããã®ãã£ã³ã¯ãããååšããªãããšãããã«ç解ããŸãããããããã«ã¯è¡ããŸãã!ã (ããŒã¿ã¯å©çšã§ããŸãã)ã ããã ãã§ãïŒ ã€ãŸããããŒãã« ã¹ãã£ã³ã¯ãã€ã㪠ãã¡ã€ã«ã®åé€ã«çœ®ãæãããããããé«éã§ãã
AïŒ â é SQL ã®ãããã¯ã«ã€ããŠã¯ãã§ã«è§ŠããŸããã ç§ã®ç解ããéããZabbix ã¯å®éã«ããŒã¿ãå€æŽããå¿ èŠã¯ãªããããã¯ãã¹ãŠãã°ã®ãããªãã®ã§ãã ããŒã¿ãå€æŽã§ããªããšåæã«ãã¯ããã«é«éã«ä¿åãèç©ãé åžã§ããç¹æ®ãªããŒã¿ããŒã¹ã䜿çšããããšã¯å¯èœã§ãããããããšãã°ãKafka ã«äŒŒã Clickhouse ãªã©ã§ãããã? Kafka ããã°ã§ãã äœãšãããããçµ±åããããšã¯å¯èœã§ããããïŒ
AG: âè·éãããå¯èœã§ãã ããŒãžã§ã³ 3.4 以éãç¹å®ã®ãæ©èœããè¿œå ãããŸããããã¹ãŠã®å±¥æŽãã¡ã€ã«ãã€ãã³ãããã®ä»ãã¹ãŠããã¡ã€ã«ã«æžã蟌ãããšãã§ããŸãã ãããŠãäœããã®ãã³ãã©ãŒã䜿çšããŠä»ã®ããŒã¿ããŒã¹ã«éä¿¡ããŸãã å®éãå€ãã®äººãåäœæ¥ããŠããŒã¿ããŒã¹ã«çŽæ¥æžã蟌ã¿ãŸãã å®è¡äžã«ãå±¥æŽã·ã³ã«ãŒã¯ããããã¹ãŠããã¡ã€ã«ã«æžã蟌ã¿ããããã®ãã¡ã€ã«ãå転ãããªã©ããŠãããã Clickhouse ã«è»¢éã§ããŸãã èšç»ã«ã€ããŠã¯èšããŸãããããããã NoSQL ãœãªã¥ãŒã·ã§ã³ (Clickhouse ãªã©) ã®ãããªããµããŒããç¶ç¶ãããã§ãããã
AïŒ â äžè¬çã«ãpostgres ãå®å šã«åé€ã§ããããšãããããŸããã?
AG: â ãã¡ãããZabbix ã§æãé£ããéšåã¯å±¥æŽããŒãã«ã§ãããæãå€ãã®åé¡ãã€ãã³ããçºçããŸãã ãã®å Žåãã€ãã³ããé·æéä¿åãããåŸåãå«ãå±¥æŽãä»ã®é«éã¹ãã¬ãŒãžã«ä¿åããã°ãéåžžã¯åé¡ãªããšæããŸãã
AïŒ â ããšãã°ãClickhouse ã«åãæ¿ããå Žåããã¹ãŠãã©ã®ãããéãåäœããããèŠç©ããããšã¯ã§ããŸãã?
AG: â ãã¹ãããŠããŸããã Clickhouse ã«ã¯ç¬èªã®ã€ã³ã¿ãŒãã§ãŒã¹ããããããå°ãªããšãåãæ°åã¯éåžžã«ç°¡åã«éæã§ãããšæããŸããã確å®ãªããšã¯èšããŸããã ãã¹ãããæ¹ãè¯ãã§ãã ããã¯ãã¹ãŠããã¹ãã®æ°ãªã©ã®æ§æã«ãã£ãŠç°ãªããŸãã æ¿å ¥ããããšã¯ XNUMX ã€ã®ããšã§ããããã®ããŒã¿ã Grafana ãªã©ã§ååŸããå¿ èŠããããŸãã
AïŒ â ã€ãŸããç§ãã¡ã¯å¯ŸçãªæŠãã«ã€ããŠè©±ããŠããã®ã§ãã£ãŠããããã®é«éããŒã¿ããŒã¹ã®å€§ããªå©ç¹ã«ã€ããŠè©±ããŠããããã§ã¯ãªããšããããšã§ããïŒ
AG: â çµ±åãããšãããæ£ç¢ºãªãã¹ããè¡ââããããšæããŸãã
AïŒ â å€ãè¯ãRRDã¯ã©ããžè¡ã£ãã®ã§ããããïŒ SQL ããŒã¿ããŒã¹ã«åãæ¿ããçç±ã¯äœã§ãã? åœåããã¹ãŠã®ã¡ããªã¯ã¹ã¯ RRD ã§åéãããŸããã
AG: â Zabbix ã«ã¯ãããããéåžžã«å€ãããŒãžã§ã³ã§ RRD ããããŸããã SQL ããŒã¿ããŒã¹ã¯åžžã«ååšããŠããŸãããããã¯å€å žçãªã¢ãããŒãã§ãã å€å žçãªã¢ãããŒã㯠MySQL ã PostgreSQL ã§ã (ãããã¯éåžžã«é·ãéååšããŠããŸãã)ã SQL ããŒã¿ããŒã¹ãš RRD ããŒã¿ããŒã¹ã«å ±éã®ã€ã³ã¿ãŒãã§ã€ã¹ã䜿çšããããšã¯ã»ãšãã©ãããŸããã§ããã
ããã€ãã®åºå ð
ãã€ãã宿æ³ããã ãããããšãããããŸãã ç§ãã¡ã®èšäºãæ°ã«å
¥ã£ãŠããŸãã? ãã£ãšèå³æ·±ãã³ã³ãã³ããèŠããã§ãã? 泚æããããå人ã«å§ãããããŠç§ãã¡ããµããŒãããŠãã ããã
ã¢ã ã¹ãã«ãã ã®ãšã¯ã€ãã¯ã¹ Tier IV ããŒã¿ã»ã³ã¿ãŒã§ã¯ Dell R730xd ã 2 åå®ã? ããã ã
åºæïŒ habr.com