ืžืึธื ื™ื˜ืึธืจื™ื ื’ PostgreSQL ืžื™ื˜ Zabbix

ืžืึธื ื™ื˜ืึธืจื™ื ื’ PostgreSQL ืžื™ื˜ Zabbix
ื‘ืืจื™ื›ื˜ ืคื•ืŸ Daria Vilkova ืคึฟืึทืจ Zabbix Meetup Online

ืื™ืš ื•ื•ืึธืœื˜ ื•ื•ื™ ืฆื• ื‘ืึทืงืขื ืขืŸ ืื™ืจ ืฆื• ื“ื™ PostgreSQL ืื•ืŸ ืึธืคึผืขืจื™ื™ื˜ื™ื ื’ ืกื™ืกื˜ืขื ืžืึธื ื™ื˜ืึธืจื™ื ื’ ื’ืขืฆื™ื™ึทื’ ื•ื•ืึธืก ืื•ื ื“ื–ืขืจ ืคื™ืจืžืข ื“ืขื•ื•ืขืœืึธืคึผืก ื ื™ืฆืŸ Zabbix.

ืžื™ืจ ื”ืึธื‘ืŸ ืื•ื™ืกื“ืขืจื•ื•ื™ื™ืœื˜ Zabbix ื•ื•ื™ ืื•ื ื“ื–ืขืจ ืžืึธื ื™ื˜ืึธืจื™ื ื’ ื’ืขืฆื™ื™ึทื’ ืึท ืœืึทื ื’ ืฆื™ื™ึทื˜ ืฆื•ืจื™ืง ื•ื•ื™ื™ึทืœ ืขืก ืื™ื– ืึทืŸ ืึธืคึฟืŸ ืžืงื•ืจ ืคึผืœืึทื˜ืคืึธืจืžืข ื’ืขืฉื˜ื™ืฆื˜ ื“ื•ืจืš ืึทืŸ ืึทืงื˜ื™ื•ื• ืงื”ืœ ื•ื•ืึธืก ืื™ื– ื–ื™ื™ืขืจ ืคืึธืœืงืก ืื™ืŸ ืจื•ืกืœืึทื ื“.

ืžื™ืจ ื”ืึธื‘ืŸ ื‘ืืฉืืคืŸ ืึทืŸ ืึทืงื˜ื™ื•ื• ืึทื’ืขื ื˜ - Mamonsu, ื•ื•ืึธืก ื”ืึธื˜ ืฆื•ื’ืขืฉื˜ืขืœื˜ ืžืขืจ ืคืœืขืงืกืึทื‘ืึทืœ ืžืึธื ื™ื˜ืึธืจื™ื ื’ ื•ื•ื™ ื ืึธืจืžืึทืœ ืžื›ืฉื™ืจื™ื ืขืจืœื•ื™ื‘ื˜ ืื™ืŸ ื“ืขืจ ืฆื™ื™ื˜, ืื•ืŸ ื™ื ืฉื•ืจื“ ื“ื™ ื–ืึทืžืœื•ื ื’ ืคื•ืŸ ืžืขื˜ืจื™ืงืก ืื•ืŸ ื–ื™ื™ ืฉื™ืงืŸ ืฆื• Zabbix Server. ืื™ืŸ ืื•ื ื“ื–ืขืจ ืคื™ืจืžืข, ืžืึทืžืึธื ืกื• ืื™ื– ื’ืขื ื™ืฆื˜ ื•ื•ืขืŸ ืงืึทื ื“ืึทืงื˜ื™ื ื’ ืึทื“ืึทืฅ.

Mamonsu

Mamonsu ืื™ื– ืึทืŸ ืึทืงื˜ื™ื•ื• ืึทื’ืขื ื˜ (Zabbix Trapper) ืคึฟืึทืจ ืžืึธื ื™ื˜ืึธืจื™ื ื’ PostgreSQL ืื•ืŸ ื“ื™ ืึธืคึผืขืจื™ื™ื˜ื™ื ื’ ืกื™ืกื˜ืขื. ืžืึทืžืึธื ืกื• (ื’ืขืฉืจื™ื‘ืŸ ืื™ืŸ ืคึผื™ื˜ื”ืึธืŸ) ืึทืœืึทื•ื– ืื™ืจ ืฆื• ืงืึทื ืคื™ื’ื™ืขืจ ืคึผืึธืกื˜ื’ืจืขืกืงืœ ืื•ืŸ ืึทืคึผืขืจื™ื™ื˜ื™ื ื’ ืกื™ืกื˜ืขื ืžืึธื ื™ื˜ืึธืจื™ื ื’ ืกืขื˜ื˜ื™ื ื’ืก ืื™ืŸ ืคื™ื ืฃ ืžื™ื ื•ื˜.

Mamonsu ื”ืื˜ ื ืึธืš ืžื›ืฉื™ืจื™ื:

  • mamonsu tune ืื™ื– ืึท ื‘ืึทืคึฟืขืœ ื•ื•ืึธืก ืจืขื“ืึทื’ื™ืจืŸ ืกืขื˜ื˜ื™ื ื’ืก ืื™ืŸ ื“ื™ PostgreSQL ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ื˜ืขืงืข ืคึฟืึทืจ ื“ื™ ืžืึทืฉื™ืŸ ืื•ื™ืฃ ื•ื•ืึธืก ื“ื™ ืžืึทืžืึธื ืกื• ืึทื’ืขื ื˜ ืื™ื– ืื™ื ืกื˜ืึทืœื™ืจืŸ.
  • mamonsu ื‘ืึทืจื™ื›ื˜ ืื™ื– ืึท ื‘ืึทืคึฟืขืœ ื•ื•ืึธืก ื“ื–ืฉืขื ืขืจื™ื™ืฅ ืขื ื˜ืคึฟืขืจืก ื•ื•ืขื’ืŸ ื“ื™ ืึธืคึผืขืจื™ื™ื˜ื™ื ื’ ืกื™ืกื˜ืขื ืื•ืŸ PostgreSQL.

Mamonsu ืื™ื– ืื™ื ืกื˜ืึทืœื™ืจืŸ ืื•ื™ืฃ ื“ื™ DBMS ืกืขืจื•ื•ืขืจ, ืงืึทืœืขืงืฅ ืื™ื ืคึฟืึธืจืžืึทืฆื™ืข, ืงืึทืžืคึผื™ื™ืœื– ืขืก ืื™ืŸ JSON, ื•ื•ืึธืก ืื™ื– ื’ืขืฉื™ืงื˜ ืคึฟืึทืจ ื•ื•ื™ื–ืฉื•ื•ืึทืœืึทื–ื™ื™ืฉืึทืŸ ืฆื• Zabbix ืกืขืจื•ื•ื™ืจืขืจ, ื•ื•ื• ืขืก ื–ืึธืœ ื–ื™ื™ืŸ ืึท ืžื•ืกื˜ืขืจ ืคึฟืึทืจ ื“ื™ ืžืขื˜ืจื™ืงืก.

ืžืึธื ื™ื˜ืึธืจื™ื ื’ PostgreSQL ืžื™ื˜ Zabbix

ืžืึทืžืึธื ืกื• ืึธืคึผืขืจืึทืฆื™ืข ืกื›ืขืžืข

ืžืึทืžืึธื ืกื• ืคึฟืขื™ึดืงื™ื™ื˜ืŸ

  • ืืจื‘ืขื˜ืŸ ื™ืคืขืงื˜ื™ื•ื•ืœื™ ืžื™ื˜ PostgreSQL. ื ืคึผืขืจืกื™ืกื˜ืขื ื˜ ืงืฉืจ ืฆื• PostgreSQL ืื™ื– ื“ืขืจ ื”ื•ื™ืคึผื˜ ืžื™ื™ึทืœืข ืคื•ืŸ โ€‹โ€‹Mamonsu. ืื™ืŸ ื“ืขื ืคืึทืœ, ื“ื™ ืžืึทืงืกื™ืžื•ื ื ื•ืžืขืจ ืคื•ืŸ ืงืึทื ืขืงืฉืึทื ื– ืื™ื– ื’ืœื™ื™ึทืš ืฆื• ื“ื™ ืžืึทืงืกื™ืžื•ื ื ื•ืžืขืจ ืคื•ืŸ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื– ืฆื• ื•ื•ืึธืก ืขืก ืงืึทื ืขืงืฅ.
  • ืขืงืกื˜ืขื ืกื™ื‘ื™ืœื™ื˜ื™. Mamonsu ืื™ื– ืึท ื’ืึธืจ ืคึผืœื•ื’-ืื™ืŸ ืึทื’ืขื ื˜, ืื•ืŸ ื“ืึทื ืง ืฆื• ื“ื™ ืคืึทืจืคืขืกื˜ื™ืงื˜ ืกื˜ืจื•ืงื˜ื•ืจ ืคื•ืŸ ื™ืขื“ืขืจ ืคึผืœื•ื’ื™ืŸ ืื•ืŸ ื“ื™ ืงืึธืจืขื•ื• ืคึผืึทืฉื˜ืขืก ืคื•ืŸ Python, ืื™ืจ ืงืขื ืขืŸ ืœื™ื™ื›ื˜ ืœืขืจื ืขืŸ ื•ื•ื™ ืฆื• ืฉืจื™ื™ึทื‘ืŸ ื ื™ื™ึท ืึธื“ืขืจ ืจืขื“ืึทื’ื™ืจืŸ ื ืึธืจืžืึทืœ ืคึผืœื•ื’ื™ื ืก, ื“"ื” ืžืขื˜ืจื™ืง ื–ืึทืžืœื•ื ื’ ืคึผืึทืจืึทืžืขื˜ืขืจืก.
  • ื‘ืจื™ื™ื˜ ืงืึทื•ื•ืขืจื™ื“ื–ืฉ ืคื•ืŸ ืžืขื˜ืจื™ืงืก ืคึฟืึทืจ ืžืึธื ื™ื˜ืึธืจื™ื ื’ ืคึฟืึทืจ PotgreSQL, ืึทืจื™ื™ึทื ื’ืขืจืขื›ื ื˜ ืžืขื˜ืจื™ืงืก ืคึฟืึทืจ ืกืคึผืขืฆื™ืคื™ืฉ ื™ืงืกื˜ืขื ืฉืึทื ื–.
  • ืฉื ืขืœ ืึธื ื”ื™ื™ื‘, ืึทื•ื•ืึทื™ืœืึทื‘ื™ืœื™ื˜ื™ ืื•ื™ืก ืคื•ืŸ ื“ื™ ืงืขืกื˜ืœ.
  • ื•ืคึผืœืึธืึทื“ื™ื ื’ ื˜ืขืžืคึผืœืึทื˜ืขืก ืื•ืŸ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ื˜ืขืงืขืก, ื•ื•ื™ ื’ืขื–ื•ื ื˜ ื•ื•ื™ ื•ืคึผืœืึธืึทื“ื™ื ื’ ืฆื• Zabbix Server.
  • ืงืจื™ื™ื–-ืคึผืœืึทื˜ืคืึธืจืžืข, ื•ื•ืึธืก ืื™ื– ื•ื•ื™ื›ื˜ื™ืง ืคึฟืึทืจ ืื•ื ื“ื–ืขืจ ืงืึทืกื˜ืึทืžืขืจื– ื•ื•ืึธืก ื ื•ืฆืŸ ืคืึทืจืฉื™ื“ืŸ ืœื™ื ื•ืงืก ื“ื™ืกื˜ืจื™ื‘ื™ื•ืฉืึทื ื–, ืึทืจื™ื™ึทื ื’ืขืจืขื›ื ื˜ ื“ื™ื ืขืจ.
  • BSD-ืงืœืึธื– ื“ืขืจืœื•ื™ื‘ืขื ื™ืฉ.

ืื™ืŸ ื“ืขื ืžืึธืžืขื ื˜ ืžื™ืจ ืคืึธืจืฉืœืึธื’ืŸ ืคื™ืœืข ืคึผืœื•ื’ื™ื ืก ืื•ืŸ ืื™ืŸ ื™ืขื“ืขืจ ืกืึทื‘ืกืึทืงื•ื•ืึทื ื˜ ื•ื•ืขืจืกื™ืข ืžื™ืจ ืคึผืจื•ื‘ื™ืจืŸ ืฆื• ืœื™ื™ื’ืŸ ืขืคึผืขืก ื ื™ื™ึท.

  • 14 ืคึผืœื•ื’ื™ื ืก ืคึฟืึทืจ PostgreSQL,
  • 8 ืคึผืœื•ื’ื™ื ืก ืคึฟืึทืจ ืึทืก ืœื™ื ื•ืงืก,
  • 4 ืคึผืœื•ื’ื™ื ืก ืคึฟืึทืจ ืึทืก Windows.

Mamonsu ืงืึทืœืขืงืฅ ืžืขืจ ื•ื•ื™ 110 PostgreSQL ืื•ืŸ ืึทืคึผืขืจื™ื™ื˜ื™ื ื’ ืกื™ืกื˜ืขื ืžืขื˜ืจื™ืงืก:

  • 70 PostgreSQL ืžืขื˜ืจื™ืงืก,
  • 40 ืึทืก ืœื™ื ื•ืงืก ืžืขื˜ืจื™ืงืก,
  • 8 ืึทืก Windows ืžืขื˜ืจื™ืงืก.

ืฉืœื™ืกืœ ืžืขื˜ืจื™ืงืก ืึทืจื™ื™ึทื ื ืขืžืขืŸ DBMS ืึทื•ื•ื™ื™ืœืึทื‘ื™ืœืึทื˜ื™, ื ื•ืžืขืจ ืคื•ืŸ ืงืึทื ืขืงืฉืึทื ื–, ื“ืึทื˜ืึทื‘ื™ื™ืก ื’ืจื™ื™ืก, ื˜ืฉืขืงืคึผื•ื™ื ืฅ, ืœื™ื™ืขื ืขืŸ / ืฉืจื™ื™ึทื‘ืŸ ื’ื™ื›ืงื™ื™ึทื˜, ืœืึทืงืก, ื ื•ืžืขืจ ืคื•ืŸ ืึทื•ื˜ืึธื•ื•ืึทืงื•ื•ื ืคึผืจืึทืกืขืกืึทื– ืื•ืŸ WAL ื“ื•ืจ ืงื•ืจืก. ื ื’ืึทื ืฅ ืจืฉื™ืžื” ืคื•ืŸ ื‘ื ื™ืžืฆื ืžืขื˜ืจื™ืงืก, ื•ื•ื™ ื’ืขื–ื•ื ื˜ ื•ื•ื™ ืึท ื“ื™ื˜ื™ื™ืœื“ ื‘ืึทืฉืจื™ื™ึทื‘ื•ื ื’ ืคื•ืŸ ืึทืœืข ืžื›ืฉื™ืจื™ื, ืื™ื– ื‘ื ื™ืžืฆื ืื™ืŸ ืจื™ืคึผืึทื–ืึทื˜ืึธืจื™ื– ืื•ื™ืฃ ื“ื™ GitHub ื•ื•ืขื‘ื–ื™ื™ื˜ืœ.

ืžืึธื ื™ื˜ืึธืจื™ื ื’ PostgreSQL ืžื™ื˜ Zabbix

ืจืฉื™ืžื” ืคื•ืŸ ืคืึทืจืึทื ืขืŸ ืžืขื˜ืจื™ืงืก ืื•ื™ืฃ GitHub

ืงืึทื˜ืขืจ Mamonsu ืื™ืŸ 5 ืžื™ื ื•ื˜

ืื™ืจ ืงืขื ืขืŸ ืฉื˜ืขืœืŸ ืึทืจื•ื™ืฃ PostgreSQL ืื•ืŸ ืึธืคึผืขืจื™ื™ื˜ื™ื ื’ ืกื™ืกื˜ืขื ืžืึธื ื™ื˜ืึธืจื™ื ื’ ื ื™ืฆืŸ Mamonsu ืื™ืŸ 5 ืžื™ื ื•ื˜ ื“ื•ืจืš ื ืึธื›ืคืึธืœื’ืŸ 5 ืคึผืฉื•ื˜ ืกื˜ืขืคึผืก.

  1. ื™ื ืกื˜ืึธืœื™ื ื’ Mamonsu. ืžืึทืžืึธื ืกื• ืงืขื ืขืŸ ื–ื™ื™ืŸ ื’ืขื‘ื•ื™ื˜ ืคึฟื•ืŸ ืžืงื•ืจ ืึธื“ืขืจ ื ื™ืฆืŸ ืคืึทืจืึทื ืขืŸ ืคึผืึทืงืึทื“ื–ืฉืึทื–.

$ git clone ... && cd mamonsu && python setup.py

build && python setup.py install

  1. ื‘ืึทืฉื˜ืขื˜ื™ืงืŸ ืงืึทื ืขืงืฉืึทื ื–. ืขืก ืื™ื– ื ื™ื™ื˜ื™ืง ืฆื• ืกืคึผืขืฆื™ืคื™ืฆื™ืจืŸ ืงืึทื ืขืงืฉืึทืŸ ืคึผืึทืจืึทืžืขื˜ืขืจืก ืคึฟืึทืจ PostgreSQL ืื•ืŸ Zabbix Server ืื™ืŸ ื“ื™ agent.conf ื˜ืขืงืข.

/etc/mamonsu/agent.conf

  1. ืขืงืกืคึผืึธืจื˜ื™ื ื’ ืึท ืžื•ืกื˜ืขืจ ืฆื• Zabbix ืกืขืจื•ื•ื™ืจืขืจ.

$ mamonsu zabbix template export

/usr/share/mamonsu/example.xml

  1. ืึทื“ื™ื ื’ ืึท ื‘ืึทืœืขื‘ืึธืก ืฆื• Zabbix ืกืขืจื•ื•ื™ืจืขืจ. ื“ื™ ื™ืงืกืคึผืึธืจื˜ืึทื“ ื˜ืขืžืคึผืœืึทื˜ืข ื•ื•ืขื˜ ื–ื™ื™ืŸ ืื•ื™ื˜ืึธืžืึทื˜ื™ืฉ ืงืึธื ื ืขืงื˜ืขื“ ืฆื• ื“ื™ ื ื™ื™ึท ื‘ืึทืœืขื‘ืึธืก ืื•ื™ืฃ Zabbix ืกืขืจื•ื•ื™ืจืขืจ.

$ mamonsu zabbix host create mamonsu-demo

  1. ืงืึทื˜ืขืจ.

$ service mamonsu start

ืžืึทืžืึธื ืกื• ืึทื ื˜ื•ื•ื™ืงืœื•ื ื’ ืื™ื ืกื˜ืจื•ืงืฆื™ืขืก

ื•ื•ื™ ืึท ื˜ื™ื™ืœ ืคื•ืŸ ื“ืขืจ ืึทื ื˜ื•ื•ื™ืงืœื•ื ื’ ืคื•ืŸ Mamonsu, ืžื™ืจ ืคึผืœืึทื ื™ืจืŸ ืฆื• ืจืึทืคื™ื ื™ืจืŸ ื“ื™ ืžืขื˜ืจื™ืงืก ืื•ืŸ ืฉืึทืคึฟืŸ ื ื™ื™ึทืข ืคึผืœื•ื’ื™ื ืก, ืœืžืฉืœ ืึท ืคึผืœื•ื’ื™ืŸ ืคึฟืึทืจ ืžืึธื ื™ื˜ืึธืจื™ื ื’ ื“ื™ ื’ืจื™ื™ืก ืคื•ืŸ ื™ื—ื™ื“ ื˜ื™ืฉืŸ. ืžื™ืจ ืื•ื™ืš ืคึผืœืึทื ื™ืจืŸ ืฆื• ืคึฟืึทืจื‘ืขืกืขืจืŸ ืื•ืŸ ืฉืึทืคึฟืŸ ื ืึธืš ืžื›ืฉื™ืจื™ื, ื•ื•ื™ ื’ืขื–ื•ื ื˜ ื•ื•ื™ ื™ืงืกืคึผืึทื ื“ ืึทื•ื˜ืึธ-ื˜ื•ื ื™ื ื’ ืงื™ื™ืคึผืึทื‘ื™ืœืึทื˜ื™ื– ื“ื•ืจืš ื“ื™ ื‘ืึทืคึฟืขืœ ืžืึทืžืึธื ืกื• ื ื™ื’ืŸ.

PostgreSQL ืžืึธื ื™ื˜ืึธืจื™ื ื’ ืžืึธื“ื•ืœืข ืึทืจื™ื™ึทื ื’ืขืจืขื›ื ื˜ ืื™ืŸ Zabbix Agent 2

ื ืฉื ืขืœ ืื•ืŸ ืคืึธืœืงืก ืฉืึธืคืขืจ ืื™ื– ื’ืขื ื™ืฆื˜ ืฆื• ืคืึทืจื‘ื™ื ื“ืŸ ืฆื• PostgreSQL pgx (ืคึผื’ ืฉืึธืคืขืจ ืื•ืŸ ื˜ืึธืึธืœืงื™ื˜ ืคึฟืึทืจ ื’ื™ื™ืŸ).

ืื™ืฆื˜ ืžื™ืจ ื ื•ืฆืŸ ืฆื•ื•ื™ื™ ื™ื ื˜ืขืจืคื™ื™ืกื™ื–: ืขืงืกืคึผืึธืจื˜ืขืจ, ื•ื•ืึธืก ืจื•ืคื˜ ื“ื™ ื”ืึทื ื“ืœืขืจ ื“ื•ืจืš ืฉืœื™ืกืœ, ืื•ืŸ ืงืึธื ืคื™ื’ื•ืจืึทื˜ืึธืจ Zabbix ืึทื’ืขื ื˜ 2, ื•ื•ืึธืก ืœื™ื™ืขื ื˜ ืื•ืŸ ื˜ืฉืขืง ื“ื™ ืกืขืจื•ื•ืขืจ ืคึฟืึทืจื‘ื™ื ื“ื•ื ื’ ืคึผืึทืจืึทืžืขื˜ืขืจืก ืกืคึผืขืกื™ืคื™ืขื“ ืื™ืŸ ื“ื™ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ื˜ืขืงืข.

ืžื™ืจ ื’ืขืคืจื•ื•ื•ื˜ ืฆื• ืึทืคึผื˜ืึทืžื™ื™ื– ื“ื™ ืคืึธืจืฉื˜ืขืœื•ื ื’ ืคื•ืŸ ื“ื™ DBMS ื“ื•ืจืš ื’ืจื•ืคึผื™ื ื’ ืžืขื˜ืจื™ืงืก ืื•ืŸ ื ื™ืฆืŸ ืึท ื”ืึทื ื“ืœืขืจ ืคึฟืึทืจ ืžืขื˜ืจื™ืงืก ืื•ืŸ ืžืขื˜ืจื™ืง ื’ืจื•ืคึผืขืก, ื•ื•ื™ ื’ืขื–ื•ื ื˜ ื•ื•ื™ ื ื™ืฆืŸ ืžืขื˜ืจื™ืง ื’ืจื•ืคึผืขืก ืื™ืŸ JSON ื•ื•ื™ ืึธืคืขื ื’ื™ืง ื•ื•ืขืจื™ืึทื‘ืึทืœื– (ื“ืขืคึผืขื ื“ืขื ืกื™ ื–ืื›ืŸ), ืื•ืŸ ื ื™ื“ืขืจื™ืง-ืžื“ืจื’ื” ื•ืคื“ืขืงื•ื ื’ (ื•ืคื“ืขืงื•ื ื’ ื›ึผืœืœื™ื).

ืฉืœื™ืกืœ ืคึฟืขื™ึดืงื™ื™ื˜ืŸ

  • ื”ืึทืœื˜ืŸ ืึท ืคึผืขืจืกื™ืกื˜ืขื ื˜ ืงืฉืจ ืฆื• PostgreSQL ืฆื•ื•ื™ืฉืŸ ื˜ืฉืขืงืก;
  • ืฉื˜ื™ืฆืŸ ืคึฟืึทืจ ืคืœืขืงืกืึทื‘ืึทืœ ืคึผืึธืœืœื™ื ื’ ื™ื ื˜ืขืจื•ื•ืึทืœื–;
  • ืงืึทืžืคึผืึทื˜ืึทื‘ืึทืœ ืžื™ื˜ PostgreSQL ื•ื•ืขืจืกื™ืขืก ืกื˜ืึทืจื˜ื™ื ื’ ืคื•ืŸ 10, ืื•ืŸ Zabbix Server ืกื˜ืึทืจื˜ื™ื ื’ ืคื•ืŸ ื•ื•ืขืจืกื™ืข 4.4;
  • ื“ื™ ืคื™ื™ื™ืงื™ื™ื˜ ืฆื• ืคืึทืจื‘ื™ื ื“ืŸ ืื•ืŸ ืžืึธื ื™ื˜ืึธืจ ืขื˜ืœืขื›ืข PostgreSQL ื™ื ืกื˜ืึทื ืกื™ื– ืกื™ื™ืžืึทืœื˜ื™ื™ื ื™ืึทืกืœื™ ืจืขื›ื˜ ืฆื• ื“ืขื ืคืึทืงื˜ ืึทื– Zabbix Agent 2 ืึทืœืึทื•ื– ืื™ืจ ืฆื• ืฉืึทืคึฟืŸ ืงื™ื™ืคืœ ืกืขืฉืึทื ื–.

PostgreSQL ืคึฟืึทืจื‘ื™ื ื“ื•ื ื’ ืคึผืึทืจืึทืžืขื˜ืขืจ ืœืขื•ื•ืขืœืก

ืื™ืŸ ื’ืึทื ืฅ, ื“ืจื™ื™ ืœืขื•ื•ืขืœืก ืคื•ืŸ ืคึฟืึทืจื‘ื™ื ื“ื•ื ื’ ืคึผืึทืจืึทืžืขื˜ืขืจืก ืฆื• PostgreSQL ื–ืขื ืขืŸ ื‘ืืจืขื›ื˜ื™ื’ื˜, ื“"ื” ื˜ืึทืกืงืก ืื•ืŸ ืกืขื˜ื˜ื™ื ื’ืก:

  • ื’ืœืื‘ืืœืข,
  • ืกืขืฉืึทื ื–
  • ืžืึทืงืจืึธืก.

  1. ื“ื™ ื’ืœืื‘ืืœืข ืคึผืึทืจืึทืžืขื˜ืขืจืก ื–ืขื ืขืŸ ื‘ืึทืฉื˜ื™ืžื˜ ืื•ื™ืฃ ื“ืขืจ ืึทื’ืขื ื˜ ืžื“ืจื’ื”, ื“ื™ ืกืขืกื™ืข ืื•ืŸ ืžืึทืงืจืึธืก ืคึผืึทืจืึทืžืขื˜ืขืจืก ื‘ืึทืฉื˜ื™ืžืขืŸ ื“ื™ ืงืฉืจ ืคึผืึทืจืึทืžืขื˜ืขืจืก ืคึฟืึทืจ ื“ื™ ื“ืึทื˜ืึทื‘ื™ื™ืก.

  2. ืงืึทื ืขืงืฉืึทืŸ ืคึผืึทืจืึทืžืขื˜ืขืจืก ืฆื• PostgreSQL - ืกืขืฉืึทื ื– ื–ืขื ืขืŸ ื‘ืึทืฉื˜ื™ืžื˜ ืื™ืŸ ื“ืขืจ ื˜ืขืงืข zabbix_agent2.conf.

ืžืึธื ื™ื˜ืึธืจื™ื ื’ PostgreSQL ืžื™ื˜ Zabbix

PostgreSQL ืคึฟืึทืจื‘ื™ื ื“ื•ื ื’ ืคึผืึทืจืึทืžืขื˜ืขืจืก - ืกืขืฉืึทื ื–

  • ื ืึธืš ื“ื™ ืงื™ื•ื•ืขืจื“ ืกืขืกืกื™ืึธื ืก ืึท ื™ื™ื ืฆื™ืง ืกืขืกื™ืข ื ืึธืžืขืŸ ืื™ื– ืื ื’ืขื•ื•ื™ื–ืŸ, ื•ื•ืึธืก ืžื•ื–ืŸ ื–ื™ื™ืŸ ืกืคึผืขืกื™ืคื™ืขื“ ืื™ืŸ ื“ื™ ืฉืœื™ืกืœ (ื˜ืขืžืคึผืœ).
  • ืคึผืึทืจืึทืžืขื˜ืขืจืก URI ะธ UserName ืคืืจืœืื ื’ื˜ ืคึฟืึทืจ ื™ืขื“ืขืจ ืกืขืกื™ืข.
  • ืื•ื™ื‘ ื“ื™ ื“ืึทื˜ืึทื‘ื™ื™ืก ื ืึธืžืขืŸ ืื™ื– ื ื™ืฉื˜ ืกืคึผืขืกื™ืคื™ืขื“, ื“ื™ ืคืขืœื™ืงื™ื™ึทื˜ ืคึผืจืึธืกื˜ ื“ืึทื˜ืึทื‘ื™ื™ืก ื ืึธืžืขืŸ ืคึฟืึทืจ ืึทืœืข PostgreSQL ืกืขืฉืึทื ื– ืื™ื– ื’ืขื ื™ืฆื˜, ื•ื•ืึธืก ืื™ื– ืื•ื™ืš ืกืคึผืขืกื™ืคื™ืขื“ ืื™ืŸ ื“ื™ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ื˜ืขืงืข.

  1. ืงืึทื ืขืงืฉืึทืŸ ืคึผืึทืจืึทืžืขื˜ืขืจืก ืฆื• PostgreSQL - ืžืึทืงืจืึธืก ื–ืขื ืขืŸ ืกืคึผืขืกื™ืคื™ืขื“ ืื™ืŸ ื“ื™ ืžืขื˜ืจื™ืง ืฉืœื™ืกืœ ืื™ืŸ ื“ื™ ืžื•ืกื˜ืขืจ (ืขื ืœืขืš ืฆื• ื“ืขืจ ืื•ืคึฟืŸ ื’ืขื ื™ืฆื˜ ืื™ืŸ Zabbix Agent 1), ื“"ื” ื–ื™ื™ ื–ืขื ืขืŸ ื‘ืืฉืืคืŸ ืื™ืŸ ื“ื™ ืžื•ืกื˜ืขืจ ืื•ืŸ ื“ืขืžืึธืœื˜ ืกืคึผืขืฆื™ืคื™ืฆื™ืจื˜ ื•ื•ื™ ืคึผืึทืจืึทืžืขื˜ืขืจืก ืื™ืŸ ื“ื™ ืฉืœื™ืกืœ. ืื™ืŸ ื“ืขื ืคืึทืœ, ื“ื™ ืกื™ืงื•ื•ืึทื ืก ืคื•ืŸ ืžืึทืงืจืึธืก ืื™ื– ืคืึทืจืคืขืกื˜ื™ืงื˜, ื“"ื”, ืคึฟืึทืจ ื‘ื™ื™ึทืฉืคึผื™ืœ, URI ืื™ื– ืฉื˜ืขื ื“ื™ืง ืœื™ืกื˜ืขื“ ืขืจืฉื˜ืขืจ.

ืžืึธื ื™ื˜ืึธืจื™ื ื’ PostgreSQL ืžื™ื˜ Zabbix

PostgreSQL ืคึฟืึทืจื‘ื™ื ื“ื•ื ื’ ืคึผืึทืจืึทืžืขื˜ืขืจืก - ืžืึทืงืจืึธืก

ื“ื™ PostgreSQL ืžืึธื ื™ื˜ืึธืจื™ื ื’ ืžืึธื“ื•ืœืข ืฉื•ื™ืŸ ื›ื•ืœืœ ืžืขืจ ื•ื•ื™ 95 ืžืขื˜ืจื™ืงืก, ื•ื•ืึธืก ืœืึธื–ืŸ ืื™ืจ ืฆื• ื“ืขืงืŸ ืึท ืคืขืจืœื™ ื‘ืจื™ื™ื˜ ืงื™ื™ื˜ ืคื•ืŸ PostgreSQL ืคึผืึทืจืึทืžืขื˜ืขืจืก, ืึทืจื™ื™ึทื ื’ืขืจืขื›ื ื˜:

  • ื ื•ืžืขืจ ืคื•ืŸ ืงืึทื ืขืงืฉืึทื ื–,
  • ื‘ืึทื ื“ ืคื•ืŸ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–,
  • ืึทืจืงื™ื™ื•ื•ื™ื ื’ ื•ื•ืึทืœ ื˜ืขืงืขืก,
  • ืงืึธื ื˜ืจืึธืœ ื ืงื•ื“ื•ืช,
  • ื ื•ืžืขืจ ืคื•ืŸ "ื‘ืœืึธื•ื˜ื™ื“" ื˜ื™ืฉืŸ,
  • ืจืขืคึผืœืึทืงื™ื™ืฉืึทืŸ ืกื˜ืึทื˜ื•ืก,
  • ืจืขืคึผืœื™ืงืข ืึธืคึผืฉื˜ื™ื™.

PostgreSQL ืžืขื˜ืจื™ืงืก ื–ืขื ืขืŸ ื ื™ืฉื˜ ื™ื ืคืึธืจืžืึทื˜ื™ื•ื• ืึธืŸ ืึทืคึผืขืจื™ื™ื˜ื™ื ื’ ืกื™ืกื˜ืขื ืคึผืึทืจืึทืžืขื˜ืขืจืก. ืึธื‘ืขืจ Zabbix Agent 2 ื•ื•ื™ื™ืกื˜ ืฉื•ื™ืŸ ื•ื•ื™ ืฆื• ื–ืึทืžืœืขืŸ ืึทืคึผืขืจื™ื™ื˜ื™ื ื’ ืกื™ืกื˜ืขื ืคึผืึทืจืึทืžืขื˜ืขืจืก, ืึทื–ื•ื™ ืฆื• ื‘ืึทืงื•ืžืขืŸ ืึท ื’ืึทื ืฅ ื‘ื™ืœื“, ืžื™ืจ ื ืึธืจ ืคืึทืจื‘ื™ื ื“ืŸ ื“ื™ ื ื™ื™ื˜ื™ืง ื˜ืขืžืคึผืœืึทื˜ืขืก ืฆื• ื“ื™ ื ืขืฅ ื ืึธื“ืข.

ื”ืึทื ื“ืœืขืจ

ื“ืขืจ ื”ืึทื ื“ืœืขืจ ืื™ื– ื“ืขืจ ื”ื•ื™ืคึผื˜ ืึทืคึผืึทืจืึทื˜ ืคื•ืŸ ื“ื™ ืžืึธื“ื•ืœืข ืื™ืŸ ื•ื•ืึธืก ื“ื™ ื‘ืขื˜ืŸ ื–ื™ืš ืื™ื– ืขืงืกืึทืงื™ื•ื˜ืึทื“ ืื•ืŸ ื•ื•ืึธืก ืึทืœืึทื•ื– ืื™ืจ ืฆื• ื‘ืึทืงื•ืžืขืŸ ืžืขื˜ืจื™ืงืก.

ืฆื• ื‘ืึทืงื•ืžืขืŸ ืึท ืคึผืฉื•ื˜ ืžืขื˜ืจื™ืง:

  1. ืฉืึทืคึฟืŸ ืึท ื˜ืขืงืข ืฆื• ื‘ืึทืงื•ืžืขืŸ ืึท ื ื™ื™ึทืข ืžืขื˜ืจื™ืง:

zabbix/src/go/plugins/postgres/handler_uptime.go

  1. ืžื™ืจ ืคืึทืจื‘ื™ื ื“ืŸ ื“ืขื ืคึผืขืงืœ ืื•ืŸ ืกืคึผืขืฆื™ืคื™ืฆื™ืจืŸ ื“ื™ ื™ื™ื ืฆื™ืง ืžืขื˜ืจื™ืง ืฉืœื™ืกืœ (s):

ืžืึธื ื™ื˜ืึธืจื™ื ื’ PostgreSQL ืžื™ื˜ Zabbix

  1. ืžื™ืจ ืžืึทื›ืŸ ืึท ื”ืึทื ื“ืœืขืจ ืžื™ื˜ ื“ื™ ื‘ืขื˜ืŸ, ื“"ื” ืžื™ืจ ืึธื ื”ื™ื™ื‘ืŸ ืึท ื‘ื™ื™ึทื˜ืขื•ื•ื“ื™ืง ื•ื•ืึธืก ื•ื•ืขื˜ ืึทื ื˜ื”ืึทืœื˜ืŸ ื“ืขื ืจืขื–ื•ืœื˜ืึทื˜:

ืžืึธื ื™ื˜ืึธืจื™ื ื’ PostgreSQL ืžื™ื˜ Zabbix

  1. ืžื™ืจ ื•ื™ืกืคื™ืจืŸ ื“ื™ ื‘ืงืฉื”:

ืžืึธื ื™ื˜ืึธืจื™ื ื’ PostgreSQL ืžื™ื˜ Zabbix

ืขืก ืื™ื– ื ื™ื™ื˜ื™ืง ืฆื• ืงืึธื ื˜ืจืึธืœื™ืจืŸ ื“ื™ ื‘ืขื˜ืŸ ืคึฟืึทืจ ืขืจืจืึธืจืก, ื ืึธืš ื•ื•ืึธืก ื“ืขืจ ืจืขื–ื•ืœื˜ืึทื˜ ื•ื•ืขื˜ ื–ื™ื™ืŸ ืคึผื™ืงื˜ ืึทืจื•ื™ืฃ ื“ื•ืจืš ื“ื™ Zabbix Agent 2 ืคึผืจืึธืฆืขืก.

  1. ืจืขื’ื™ืกื˜ืจื™ืจืŸ ื“ื™ ื ื™ื™ึทืข ืžืขื˜ืจื™ืง ืฉืœื™ืกืœ:

ืžืึธื ื™ื˜ืึธืจื™ื ื’ PostgreSQL ืžื™ื˜ Zabbix

ื ืึธืš ืจืขื“ื–ืฉื™ืกื˜ืขืจื™ื ื’ ื“ื™ ืžืขื˜ืจื™ืง, ืื™ืจ ืงืขื ืขืŸ ืจื™ื‘ื™ืœื“ ื“ืขื ืึทื’ืขื ื˜ ืžื™ื˜ ื“ื™ ื ื™ื™ึทืข ืžืขื˜ืจื™ืง.

ื“ืขืจ ืžืึธื“ื•ืœืข ืื™ื– ื‘ืืจืขื›ื˜ื™ื’ื˜ ืคึฟื•ืŸ Zabbix 5.0 ืื•ื™ืฃ ื“ืขืจ ื•ื•ืขื‘ื–ื™ื™ื˜ืœ https://www.zabbix.com/download. ืื™ืŸ ื“ืขื ื•ื•ืขืจืกื™ืข ืคื•ืŸ โ€‹โ€‹Zabbix, ืคึผืึทืจืึทืžืขื˜ืขืจืก ื–ืขื ืขืŸ ื‘ืึทืฉื˜ื™ืžื˜ ืกืขืคึผืขืจืึทื˜ืœื™ ื“ื•ืจืš ื‘ืึทืœืขื‘ืึธืก ืื•ืŸ ืคึผืึธืจื˜. ืื™ืŸ Zabbix 5.0.2, ื•ื•ืึธืก ื•ื•ืขื˜ ื–ื™ื™ืŸ ืคืจื™ื™ ื‘ืึทืœื“, ื“ื™ ืงืฉืจ ืคึผืึทืจืึทืžืขื˜ืขืจืก ื•ื•ืขื˜ ื–ื™ื™ืŸ ืงืึทืžื‘ื™ื™ื ื“ ืื™ืŸ ืึท ืื™ื™ืŸ URI.

ื’ื•ื˜ ื’ืœื™ืง!

ื ื•ืฆื™ืง ืœื™ื ืงืก

ื’ื™ื˜ื”ื•ื‘ ืžืึทืžืึธื ืกื•

ืžืึทืžืึธื ืกื• ื“ืึทืงื™ื•ืžืขื ื˜ื™ื™ืฉืึทืŸ

ื–ืื‘ื™ืงืก ื’ื™ื˜

ืžืงื•ืจ: www.habr.com

ืœื™ื™ื’ืŸ ืึท ื‘ืึทืžืขืจืงื•ื ื’