Chirevo chaDaria Vilkova cheZabbix Meetup Online
Ndinoda kukuzivisa iwe kuPostgreSQL uye yekutarisa sisitimu yekushandisa iyo kambani yedu inovandudza ichishandisa Zabbix.
Isu takasarudza Zabbix sechishandiso chedu chekutarisa kare kare nekuti inzvimbo yakavhurika sosi inotsigirwa nenharaunda inoshanda ine mukurumbira muRussia.
Isu takagadzira inoshanda mumiriri - Mamonsu, iyo yakapa inochinjika yekutarisa pane yakajairwa maturusi aibvumidzwa panguva iyoyo, uye ive nechokwadi chekuunganidzwa kwemametric uye kutumira kwavo kuZabbix Server. Mukambani yedu, Mamonsu inoshandiswa pakuita ongororo.
Mamonsu
Mamonsu inhengo inoshanda (Zabbix Trapper) yekutarisa PostgreSQL uye sisitimu yekushandisa. Mamonsu (yakanyorwa muPython) inokutendera kuti ugadzirise PostgreSQL uye inoshanda sisitimu yekutarisa marongero mumaminitsi mashanu.
Mamonsu ane mamwe maturusi:
- mamonsu tune murairo unogadzirisa marongero muPostgreSQL faira yekumisikidza yemuchina unoisirwa mumiriri weMamonsu.
- mamonsu report murairo unogadzira mhinduro nezve sisitimu yekushandisa uye PostgreSQL.
Mamonsu akaiswa paDBMS server, anounganidza ruzivo, anozvibatanidza muJSON, iyo inotumirwa kuti ionekwe kuZabbix Server, apo panofanira kunge kune template yemametric ayo.
Mamonsu operation scheme
Mamonsu features
- Kushanda nemazvo nePostgreSQL. Kubatana kunoramba kuripo kuPostgreSQL ndiyo mukana mukuru weMamonsu. Muchiitiko ichi, nhamba yakawanda yekubatanidza yakaenzana nenhamba yakawanda yedatabases iyo inobatanidza.
- Kuwedzera. Mamonsu inonyatso plug-in mumiriri, uye nekuda kweiyo yakagadziriswa chimiro cheplugin yega yega uye kupusa kwePython, unogona nyore kudzidza kunyora nyowani kana kugadzirisa akajairwa plugins, i.e. metrics yekuunganidza paramita.
- Kufukidzwa kwakakura kwemametrics ekutarisa yePotgreSQL, kusanganisira metrics yeamwe ekuwedzera.
- Kurumidza kutanga, Kuwanikwa kunze kwebhokisi.
- Kuisa matemplate uye mafaira ekugadzirisa, pamwe nekuisa kuZabbix Server.
- Muchinjikwa-chikuva, iyo yakakosha kune vatengi vedu vanoshandisa akasiyana Linux kugovera, kusanganisira epamba.
- BSD-clause rezinesi.
Parizvino tinopa akawanda plugins uye mune yega yega inotevera vhezheni tinoedza kuwedzera chimwe chinhu chitsva.
- 14 plugins yePostgreSQL,
- 8 plugins ye OS Linux,
- 4 plugins yeOS Windows.
Mamonsu anounganidza anopfuura 110 PostgreSQL uye inoshanda sisitimu metrics:
- 70 PostgreSQL metrics,
- 40 OS Linux metrics,
- 8 OS Windows metrics.
Makiyi metrics anosanganisira kuwanikwa kweDBMS, nhamba yekubatanidza, saizi yedatabase, nzvimbo dzekutarisa, kuverenga / kunyora kumhanya, kukiya, nhamba ye autovacuum maitiro, uye WAL chizvarwa chiyero. Rondedzero yakazara yemametric anowanikwa, pamwe netsanangudzo yakadzama yezvishandiso zvese, inowanikwa mukati
Rondedzero yemametrics aripo paGitHub
Tanga Mamonsu mumaminitsi mashanu
Unogona kuseta PostgreSQL uye yekutarisa sisitimu yekutarisa uchishandisa Mamonsu mumaminetsi mashanu nekutevera mashanu akareruka matanho.
- Kuisa Mamonsu. Mamonsu anogona kuvakwa kubva kunobva kana kushandisa mapakeji aripo.
$ git clone ... && cd mamonsu && python setup.py
build && python setup.py install
- Kugadzika ma connections. Izvo zvinodikanwa kutsanangura maparameter ekubatanidza ePostgreSQL neZabbix Server muagent.conf faira.
/etc/mamonsu/agent.conf
- Kuendesa kunze template kuZabbix Server.
$ mamonsu zabbix template export
/usr/share/mamonsu/example.xml
- Kuwedzera mugamuchiri kuZabbix Server. Iyo template inotumirwa kunze ichabatanidzwa otomatiki kune nyowani nyowani paZabbix Server.
$ mamonsu zabbix host create mamonsu-demo
- Kutanga.
$ service mamonsu start
Mamonsu development directions
Sechikamu chekuvandudzwa kweMamonsu, tinoronga kunatsa mametrics uye kugadzira plugins nyowani, semuenzaniso plugin yekutarisa saizi yematafura ega. Isu tinorongawo kuvandudza nekugadzira mamwe maturusi, pamwe nekuwedzera otomatiki tuning kugona kuburikidza nekuraira mamosu tune.
PostgreSQL yekutarisa module inosanganisirwa muZabbix Agent 2
Mutyairi anokurumidza uye ane mukurumbira anoshandiswa kubatanidza kuPostgreSQL
Parizvino tiri kushandisa maviri mainterfaces: Exporter, iyo inodaidza mubati nekiyi, uye Configurator Zabbix Agent 2, iyo inoverenga uye inotarisa sevha yekubatanidza paramita inotsanangurwa mufaira rekugadzirisa.
Takaedza kukwidziridza mashandiro eDBMS nekuisa mametrics nekushandisa mubati wemetrics uye metric mapoka, pamwe nekushandisa metric mapoka muJSON seanotsamira akasiyana (dependency zvinhu), uye yakaderera-level kuwanikwa (discovery rules).
Zvinhu zvakakosha
- kuchengetedza kubatana kunoramba kuripo kuPostgreSQL pakati pecheki;
- tsigiro yenguva dzekuvhota dzinochinjika;
- inowirirana nePostgreSQL shanduro dzinotanga kubva pagumi, uye Zabbix Server kutanga kubva muvhezheni 10;
- kugona kubatanidza uye kutarisa akati wandei PostgreSQL zviitiko panguva imwe chete nekuda kwekuti Zabbix Agent 2 inobvumidza iwe kugadzira akawanda masesheni.
PostgreSQL yekubatanidza parameter mazinga
Pakazara, matatu mazinga ekubatanidza paramita kuPostgreSQL anowanikwa, kureva mabasa uye marongero:
- Pasi rose,
- Zvidzidzo
- Macros.
-
Iwo eGlobal paramita akaiswa padanho reagent, iyo Session uye Macros paramita inotaridza iyo yekubatanidza paramita yedhatabhesi.
-
Yekubatanidza paramita kuPostgreSQL - Zvikamu zvakaiswa mufaira zabbix_agent2.conf.
PostgreSQL yekubatanidza paramita - Zvikamu
- Mushure meiyo keyword muzvirongwa zita rakasiyana rechikamu rinoratidzwa, iro rinofanira kutsanangurwa mukiyi (template).
- parameters URI ΠΈ UserName inodiwa pachikamu chega chega.
- Kana zita redhatabhesi risingataurwe, iro rakajairwa dhatabhesi zita rese PostgreSQL masesheni rinoshandiswa, iro rinotsanangurwa zvakare mufaira rekugadzirisa.
- Kubatanidza paramita kuPostgreSQL - Macros inotsanangurwa mukiyi metric mutemplate (yakafanana nenzira inoshandiswa muZabbix Agent 1), i.e. inogadzirwa mutemplate uye yozotsanangurwa sema paramita mukiyi. Muchiitiko ichi, kutevedzana kwemacros kunogadziriswa, kureva, semuenzaniso, URI inogara yakanyorwa pekutanga.
PostgreSQL yekubatanidza paramita - Macros
Iyo PostgreSQL yekutarisa module inotosanganisira anopfuura makumi mapfumbamwe neshanu metrics, ayo anobvumidza iwe kuvhara yakaringana yakakura yePostgreSQL paramita, kusanganisira:
- nhamba yekubatanidza,
- huwandu hwe databases,
- kuchengetedza wal mafaira,
- control points,
- nhamba yematafura "akaputika",
- kudzokorora chimiro,
- replica lag.
PostgreSQL metrics haina ruzivo pasina inoshanda system paramita. Asi Zabbix Agent 2 inotoziva nzira yekuunganidza inoshanda sisitimu paramita, saka kuti tiwane mufananidzo wakakwana tinongobatanidza matemplate anodiwa kune network node.
Handler
Mubati ndiye yuniti huru yemodule umo chikumbiro pachacho chinoitwa uye chinokutendera kuti uwane metrics.
Kuti uwane metric iri nyore:
- Gadzira faira kuti ugamuchire metric itsva:
zabbix/src/go/plugins/postgres/handler_uptime.go
- Isu tinobatanidza pasuru uye tinotsanangura yakasarudzika metrics kiyi (s):
- Isu tinogadzira mubati nechikumbiro, i.e. isu tinotanga shanduko inozove nemhedzisiro:
- Tinoita chikumbiro:
Izvo zvinodiwa kuti utarise chikumbiro chekukanganisa, mushure meizvozvo mhedzisiro ichatorwa neiyo Zabbix Agent 2 maitiro.
- Nyora kiyi itsva yemetric:
Mushure mekunyoresa metric, unogona kuvakazve mumiriri neiyo metric nyowani.
Iyo module inowanikwa kutanga kubva kuZabbix 5.0 pane webhusaiti
Π‘ΠΏΠ°ΡΠΈΠ±ΠΎ Π·Π° Π²Π½ΠΈΠΌΠ°Π½ΠΈΠ΅!
Useful links
Source: www.habr.com