Umbiko ka-Daria Vilkova we-Zabbix Meetup Online
Ngifuna ukukwazisa ngethuluzi le-PostgreSQL kanye nesistimu yokusebenza, elithuthukiswa inkampani yethu isebenzisa i-Zabbix.
Sikhethe i-Zabbix njengethuluzi lethu lokuqapha isikhathi eside ngoba iyinkundla yomthombo ovulekile esekelwa umphakathi osebenzayo odume kakhulu e-Russia.
Sakhe umenzeli osebenzayo - i-Mamonsu, ehlinzeke ngokuqapha okuvumelana nezimo kakhulu kunamathuluzi ajwayelekile ngaleso sikhathi ayevunyelwe, futhi yaqinisekisa ukuqoqwa kwamamethrikhi kanye nokuthunyelwa kwawo Kuseva ye-Zabbix. Enkampanini yethu, iMamonsu isetshenziswa ekucwaningweni kwamabhuku.
UMamonsu
I-Mamonsu iyi-ejenti esebenzayo (i-Zabbix Trapper) yokuqapha i-PostgreSQL kanye nesistimu yokusebenza. I-Mamonsu (ebhalwe ku-Python) ikuvumela ukuthi ulungiselele i-PostgreSQL nezilungiselelo zokuqapha uhlelo lokusebenza ngemizuzu emihlanu.
I-Mamonsu inamathuluzi engeziwe:
- I-mamonsu tune iwumyalo ohlela izilungiselelo kufayela lokumisa le-PostgreSQL lomshini lapho kufakwe khona i-ejenti ye-Mamonsu.
- I-mamonsu report iwumyalo okhiqiza izimpendulo mayelana nesistimu yokusebenza kanye ne-PostgreSQL.
I-Mamonsu ifakwe kuseva ye-DBMS, iqoqa ulwazi, iluhlanganise lube yi-JSON, eluthumela kuseva ye-Zabbix ukuze ibonakale, lapho kufanele kube khona isifanekiso samamethrikhi ayo.
Uhlelo lokusebenza lweMamonsu
Izici Mamonsu
- Ukusebenza kahle nge-PostgreSQL. Ukuxhumana okuqhubekayo ku-PostgreSQL kuyinzuzo enkulu ye-Mamonsu. Kulokhu, inombolo enkulu yokuxhumana ilingana nenani eliphakeme lemininingwane exhumeke kuyo.
- Ukunwetshwa. I-Mamonsu iyi-ejenti "ye-plugin", futhi ngenxa yesakhiwo esinqunyiwe se-plugin ngayinye kanye nobulula obuhlobene bePython, umuntu angafunda kalula ukubhala okusha noma ukuhlela ama-plugin ajwayelekile, okungukuthi imingcele yokuqoqwa kwamamethrikhi.
- Ukufakwa okubanzi kwamamethrikhi okuqapha ye-PotgreSQL kufaka phakathi amamethrikhi esandiso esithile.
- ukuqalisa ngokushesha, ukutholakala ngaphandle kwebhokisi.
- Ilayisha izifanekiso namafayela okumisa, kanye nokulayisha Kuseva ye-Zabbix.
- Cross-platform, okubalulekile kumakhasimende ethu asebenzisa ukusatshalaliswa kweLinux okuhlukahlukene, okuhlanganisa nezasekhaya.
- Ilayisense yesigatshana se-BSD.
Okwamanje sinikeza ama-plugin amaningi futhi enguqulweni ngayinye elandelayo sizama ukwengeza okuthile okusha.
- Ama-plugins ayi-14 we-PostgreSQL,
- 8 ama-plugin we-OS Linux,
- 4 ama-plugin we-OS Windows.
I-Mamonsu iqoqa ngaphezulu kwe-110 PostgreSQL namamethrikhi esistimu yokusebenza:
- 70 PostgreSQL metrics,
- 40 OS Linux metrics,
- 8 OS Windows metrics.
Amamethrikhi angukhiye ahlanganisa ukutholakala kwe-DBMS, inombolo yoxhumo, usayizi wesizindalwazi, izindawo zokuhlola, isivinini sokufunda/sokubhala, izingidi, inombolo yezinqubo ze-autovacuum, kanye nesivinini sokukhiqiza i-WAL. Uhlu oluphelele lwamamethrikhi atholakalayo, kanye nencazelo enemininingwane yawo wonke amathuluzi, kuyatholakala ku kusayithi le-GitHub.
Uhlu lwamamethrikhi atholakalayo ku-GitHub
Gijimani iMamonsu emizuzwini emi-5
Ukusetha ukuqapha kwe-PostgreSQL kanye nesistimu yokusebenza usebenzisa i-Mamonsu, ungakwenza ngemizuzu emi-5 ngokulandela izinyathelo ezi-5 ezilula.
- Ifaka i-Mamonsu. I-Mamonsu ingakhiwa ngomthombo noma isebenzise amaphakheji atholakalayo.
$ git clone ... && cd mamonsu && python setup.py
build && python setup.py install
- Ukusethwa koxhumano. Kuyadingeka ukusetha izinhlaka zokuxhuma ze-PostgreSQL neseva ye-Zabbix kufayela le-agent.conf.
/etc/mamonsu/agent.conf
- Khipha isifanekiso kuseva ye-Zabbix.
$ mamonsu zabbix template export
/usr/share/mamonsu/example.xml
- Ingeza umsingathi Kuseva ye-Zabbix. Isifanekiso esithunyelwe sizoxhunywa ngokuzenzakalelayo kumsingathi omusha Kuseva ye-Zabbix.
$ mamonsu zabbix host create mamonsu-demo
- Qalisa.
$ service mamonsu start
I-Mamonsu Development Directions
Njengengxenye yokuthuthukiswa kwe-Mamonsu, sihlela ukwenza ngcono ama-metrics futhi sidale ama-plugin amasha, njenge-plugin yokuqapha usayizi wamathebula ngamanye. Futhi sihlela ukuthuthukisa nokudala amathuluzi engeziwe, kanye nokwandisa amandla okushuna okuzenzakalelayo ngomyalo mamosu tune.
Imojula yokuqapha ye-PostgreSQL njengengxenye ye-Zabbix Agent 2
Umshayeli osheshayo nodumile usetshenziswa ukuxhuma ku-PostgreSQL (umshayeli we-PG kanye nekhithi yamathuluzi ye-Go).
Kuze kube manje, sisebenzisa izixhumanisi ezimbili: Umthumeli, obiza isibambi ngokhiye, kanye ne-Configurator Zabbix Agent 2, efunda futhi ihlole imingcele yokuxhumana neseva ecaciswe kufayela lokumisa.
Sizame ukuthuthukisa umsebenzi we-DBMS ngokuhlanganisa amamethrikhi nokusebenzisa isibambi (isibambi) samamethrikhi namaqembu wemethrikhi, kanye nokusebenzisa amaqembu amamethrikhi ku-JSON njengokuhluka okuncikile (izinto ezincikile), kanye nokutholwa kwezinga eliphansi (imithetho yokutholwa ).
Izici Eziyinhloko
- ukugcina uxhumano oluqhubekayo ku-PostgreSQL phakathi kwamasheke;
- ukusekelwa kwezikhawu zokuvota eziguquguqukayo;
- ukuhambisana nezinguqulo ze-PostgreSQL eziqala ku-10 kanye ne-Zabbix Server kusukela kunguqulo 4.4;
- ikhono lokuxhuma nokuqapha izimo ze-PostgreSQL eziningi ngesikhathi esisodwa ngenxa yokuthi i-Zabbix Agent 2 ikuvumela ukuthi udale izikhathi eziningi.
I-PostgreSQL Connection Parameter Levels
Sekukonke, amazinga amathathu amapharamitha wokuxhuma we-PostgreSQL ayatholakala, okungukuthi imisebenzi nezilungiselelo:
- Umhlaba jikelele,
- iseshini,
- Amamakhro.
-
Amapharamitha weGlobal asethwe ezingeni le-ejenti, amapharamitha weSeshini kanye namaMacros achaza imingcele yokuxhuma kusizindalwazi.
-
Amapharamitha wokuxhuma ku-PostgreSQL - Amaseshini asethwe kufayela zabbix_agent2.conf.
Izinketho Zokuxhuma I-PostgreSQL - Izikhathi
- Ngemva kwegama elingukhiye sessions kucacisiwe igama leseshini eliyingqayizivele, okufanele licaciswe kukhiye (isifanekiso).
- Amapharamitha URI ΠΈ I-UserName okudingekayo kuso sonke isikhathi.
- Uma igama lesizinda lingashiwongo, igama lesisekelo elivamile elizenzakalelayo lawo wonke amaseshini e-PostgreSQL liyasetshenziswa, eliphinde lisethwe kufayela lokumisa.
- Amapharamitha okuxhumana ku-PostgreSQL - Amamakhro asethwe kukhiye wemethrikhi kusifanekiso (efana nendlela esetshenziswe ku-Zabbix Agent 1), okungukuthi akhiwa kusifanekiso abese ecaciswa njengamapharamitha kukhiye. Kulokhu, ukulandelana kwama-macros kuhleliwe, okungukuthi, isibonelo, URI njalo esohlwini lokuqala.
Amapharamitha wokuxhuma we-PostgreSQL - Macros
Imojula yokuqapha ye-PostgreSQL isivele ihlanganisa amamethrikhi angaphezu kuka-95 akuvumela ukuthi umboze uhla olubanzi lwamapharamitha we-PostgreSQL, okuhlanganisa:
- inombolo yokuxhumana
- usayizi wesizindalwazi,
- gcina amafayela we-wal kungobo yomlando,
- izindawo zokuhlola,
- inani lamatafula "akhukhumele",
- isimo sokuphindaphinda,
- ukulibaziseka kwe-replica.
Amamethrikhi e-PostgreSQL awanalo ulwazi ngaphandle kwamapharamitha wesistimu yokusebenza. Kodwa i-Zabbix Agent 2 isivele iyazi ukuthi iqoqa kanjani imingcele yesistimu yokusebenza, ngakho-ke ukuze sithole isithombe esigcwele, sivele sixhume izifanekiso ezidingekayo kumsingathi.
Isibambi
Isibambi siyiyunithi eyinhloko yemojuli lapho isicelo ngokwaso senziwa futhi esikuvumela ukuthi uthole amamethrikhi.
Ukuze uthole imethrikhi elula:
- Dala ifayela ukuze uthole imethrikhi entsha:
zabbix/src/go/plugins/postgres/handler_uptime.go
- Sixhuma iphakheji bese sicacisa ukhiye (okhiye) oyingqayizivele wamamethrikhi:
- Sakha isibambi (isibambi) ngesicelo, okungukuthi, siqala okuhlukile okuzoqukatha umphumela:
- Senza isicelo:
Kuyadingeka ukuhlola isicelo samaphutha, ngemuva kwalokho umphumela uzothathwa yinqubo ye-Zabbix Agent 2.
- Bhalisa ukhiye omusha we-metric:
Ngemva kokubhalisa imethrikhi, ungakwazi ukwakha kabusha i-ejenti nge-metric entsha.
Imojula iyatholakala kusukela ku-Zabbix 5.0 esizeni . Kule nguqulo ye-Zabbix, amapharamitha asethwe ngokwehlukana ngomsingathi kanye nembobo. Ku-Zabbix 5.0.2, ezokhishwa maduze, imingcele yokuxhuma izopakishwa ibe yi-URI eyodwa.
Π‘ΠΏΠ°ΡΠΈΠ±ΠΎ Π·Π° Π²Π½ΠΈΠΌΠ°Π½ΠΈΠ΅!
Izixhumanisi eziwusizo
Source: www.habr.com