Ingxelo kaDaria Vilkova yeZabbix Meetup Online
Ndingathanda ukukwazisa kwi-PostgreSQL kunye nesixhobo sokubeka iliso kwinkqubo ephuhliswa yinkampani yethu isebenzisa i-Zabbix.
Sakhetha i-Zabbix njengesixhobo sethu sokuhlola ixesha elidlulileyo kuba liqonga lomthombo ovulekileyo oxhaswa luluntu olusebenzayo oludume kakhulu eRashiya.
Senze i-arhente esebenzayo - i-Mamonsu, ebonelela ngokubeka iliso okuguquguqukayo ngakumbi kunezixhobo eziqhelekileyo ezivunyelwe ngelo xesha, kwaye yaqinisekisa ukuqokelela kweemetriki kunye nokuthunyelwa kwazo kwi-Zabbix Server. Kwinkampani yethu, iMamonsu isetyenziswa xa kusenziwa uphicotho.
Mamonsu
I-Mamonsu yi-arhente esebenzayo (i-Zabbix Trapper) yokubeka iliso kwi-PostgreSQL kunye nenkqubo yokusebenza. I-Mamonsu (ebhalwe kwiPython) ikuvumela ukuba uqwalasele i-PostgreSQL kunye nezicwangciso zokubeka iliso kwinkqubo kwimizuzu emihlanu.
UMamonsu unezixhobo ezongezelelweyo:
- mamonsu tune ngumyalelo ohlela izicwangciso kwiPostgreSQL ifayile yoqwalaselo kumatshini apho iarhente yeMamonsu ifakwe khona.
- mamonsu ingxelo ngumyalelo ovelisa iimpendulo malunga nenkqubo yokusebenza kunye nePostgreSQL.
I-Mamonsu ifakwe kwi-server ye-DBMS, iqokelela ulwazi, iqulunqe kwi-JSON, ethunyelwa ukuba ibonwe kwi-Zabbix Server, apho kufuneka kubekho itemplate yeemetriki zayo.
Inkqubo yokusebenza kweMamonsu
Iimpawu zeMamonsu
- Ukusebenza ngokufanelekileyo ngePostgreSQL. Uqhagamshelo oluqhubekayo kwiPostgreSQL yeyona nto iluncedo yeMamonsu. Kule meko, inani eliphezulu lokudibanisa lilingana nenani eliphezulu leedatha apho lidibanisa khona.
- Ukwandiswa. I-Mamonsu yi-agent ye-plug-in ngokupheleleyo, kwaye ngenxa yesakhiwo esisisigxina seplagin nganye kunye nokulula okuhlobene kwePython, unokufunda ngokulula indlela yokubhala entsha okanye ukuhlela iiplagi eziqhelekileyo, oko kukuthi imilinganiselo yokuqokelela i-metrics.
- Ugutyulo olubanzi lweemetrikhi zokubeka iliso yePotgreSQL, kubandakanywa neemetrics zolwandiso oluthile.
- Ukuqala ngokukhawuleza, Ukufumaneka ngaphandle kwebhokisi.
- Ukulayisha iitemplates kunye neefayile zoqwalaselo, kunye nokulayisha kwi-Zabbix Server.
- Iqonga lomnqamlezo, okubalulekileyo kubathengi bethu abasebenzisa ukuhanjiswa kweLinux ezahlukeneyo, kubandakanya ezasekhaya.
- Ilayisenisi yegatya le-BSD.
Okwangoku sinikezela ngeeplagi ezininzi kwaye kwinguqulelo nganye elandelayo sizama ukongeza into entsha.
- Iiplagi ezili-14 zePostgreSQL,
- Iiplagi ezi-8 ze-OS Linux,
- Iiplagi ezi-4 ze-OS Windows.
UMamonsu uqokelela ngaphezulu kwe-110 PostgreSQL kunye neemetriki zenkqubo yokusebenza:
- 70 PostgreSQL metrics,
- 40 OS Linux metrics,
- 8 OS Windows imitha.
Iimethrikhi eziphambili ziquka ukufumaneka kwe-DBMS, inani loxhumo, ubungakanani bedatha yedatha, iindawo zokuhlola, isantya sokufunda / ukubhala, ukukhiya, inani leenkqubo ze-autovacuum, kunye nesantya sokuvelisa i-WAL. Uluhlu olupheleleyo lweemethrikhi ezikhoyo, kunye nenkcazo eneenkcukacha yazo zonke izixhobo, ziyafumaneka kwiwebhusayithi yeGitHub.
Uluhlu lweemetriki ezikhoyo kwi-GitHub
Qalisa i-Mamonsu kwimizuzu emi-5
Unokuseta i-PostgreSQL kunye nokujonga inkqubo yokusebenza usebenzisa i-Mamonsu kwimizuzu emi-5 ngokulandela amanyathelo ama-5 alula.
- Kufakwa iMamonsu. I-Mamonsu inokwakhiwa kwimvelaphi okanye kusetyenziswa iipakethe ezikhoyo.
$ git clone ... && cd mamonsu && python setup.py
build && python setup.py install
- Ukuseta imidibaniso. Kuyimfuneko ukucacisa iiparameters zoqhagamshelwano zePostgreSQL kunye neZabbix Server kwifayile ye-agent.conf.
/etc/mamonsu/agent.conf
- Ukuthumela itemplate kwi-Zabbix Server.
$ mamonsu zabbix template export
/usr/share/mamonsu/example.xml
- Ukongeza umamkeli kwiSeva yeZabbix. Itemplate ethunyelwe ngaphandle iya kudityaniswa ngokuzenzekelayo kumamkeli omtsha kwiSeva yeZabbix.
$ mamonsu zabbix host create mamonsu-demo
- Qalisa.
$ service mamonsu start
Izalathiso zophuhliso lweMamonsu
Njengenxalenye yophuhliso lweMamonsu, siceba ukucokisa iimethrikhi kunye nokwenza iiplagi ezintsha, umzekelo iplagin yokubeka iliso kubungakanani beetafile zomntu ngamnye. Kwakhona siceba ukuphucula kunye nokudala izixhobo ezongezelelweyo, kunye nokwandisa izakhono zokuzilungisa ngokuzenzekelayo ngomyalelo mamonsu tune.
Imodyuli yokubeka iliso ye-PostgreSQL ibandakanywe kwi-Agent 2 ye-Zabbix
Umqhubi okhawulezayo nodumileyo usetyenziselwa ukuqhagamshela kwiPostgreSQL (Umqhubi we-PG kunye nekhithi yezixhobo zeGo).
Okwangoku sisebenzisa ujongano ezimbini: Umthumeli ngaphandle, obiza umphathi ngesitshixo, kunye ne-Configurator Zabbix Agent 2, efunda kwaye ijonga iparameters zoqhagamshelwano lomncedisi ezichazwe kwifayile yoqwalaselo.
Sizame ukunyusa ukusebenza kwe-DBMS ngokucwangcisa iimethrikhi kunye nokusebenzisa umphathiswa weemetriki kunye namaqela eemitha, kunye nokusebenzisa amaqela eemitha kwi-JSON njengezinto ezixhomekeke kwizinto ezixhomekeke kuyo (izinto ezixhomekeke kuyo), kunye nokufumanisa okuphantsi (imithetho yokufumanisa).
Iimpawu eziphambili
- ukugcina uxhulumaniso oluzingileyo kwi-PostgreSQL phakathi kweetshekhi;
- inkxaso yamathuba okuvota aguqukayo;
- iyahambelana neenguqulelo ze-PostgreSQL eziqala kwi-10, kunye ne-Zabbix Server eqala kwi-4.4;
- ukukwazi ukudibanisa kunye nokubeka iliso kwiimeko ezininzi ze-PostgreSQL ngaxeshanye ngenxa yokuba i-Zabbix Agent 2 ikuvumela ukuba wenze iiseshoni ezininzi.
Amanqanaba eparamitha yoqhagamshelo lwePostgreSQL
Lilonke, amanqanaba amathathu onxibelelwano lweeparamitha kwiPostgreSQL ayafumaneka, oko kukuthi imisebenzi kunye noseto:
- Ehlabathini lonke,
- Iiseshoni
- Iimakhro.
-
Iiparamitha zeGlobal zibekwe kwinqanaba le-ejenti, iiparamitha zeSeshini kunye ne-Macros zinquma iiparamitha zokuxhuma kwisiseko sedatha.
-
Iiparamitha zoqhagamshelo kwiPostgreSQL - Iiseshoni zisetwe kwifayile zabbix_agent2.conf.
Iiparamitha zokuqhagamshelwa kwePostgreSQL - Iiseshoni
- Emva kwegama elingundoqo Session kubonisiwe igama leseshoni eyodwa, ekufuneka licaciswe kwisitshixo (itemplate).
- Parameters I-URI ΠΈ Lomsebenzisi efunekayo kwiseshoni nganye.
- Ukuba igama lesiseko sedatha alichazwanga, igama elingagqibekanga lesiseko sedatha kuzo zonke iiseshoni zePostgreSQL liyasetyenziswa, elikwacaciswe kwifayile yoqwalaselo.
- Iiparamitha zokuxhuma kwi-PostgreSQL - Ii-Macros zichazwe kwisitshixo se-metric kwi-template (efana nendlela esetyenziswe kwi-Agent ye-Zabbix 1), oko kukuthi zenziwa kwi-template kwaye zichazwe njengeeparameters kwisitshixo. Kule meko, ukulandelelana kwe-macros kulungiswe, oko kukuthi, umzekelo, I-URI isoloko idweliswa kuqala.
Iiparamitha zoqhagamshelo lwePostgreSQL - iiMacros
Imodyuli yokubeka iliso yePostgreSQL sele ibandakanya ngaphezulu kwe-95 metrics, ekuvumela ukuba ugqume uluhlu olubanzi lweeparamitha zePostgreSQL, kubandakanya:
- inani loqhagamshelo,
- umthamo wogcino-lwazi,
- ukugcina iifayile ze-wal,
- iindawo zokulawula,
- inani leetafile "ezidumbileyo",
- imo yokuphindaphinda,
- i-replica lag.
Iimetriki zePostgreSQL azinalwazi ngaphandle kweeparamitha zenkqubo yokusebenza. Kodwa i-Agent ye-2 ye-Zabbix sele iyazi indlela yokuqokelela iiparameters zenkqubo yokusebenza, ukuze ufumane umfanekiso opheleleyo sidibanisa nje iitemplates eziyimfuneko kwi-node yenethiwekhi.
Umphathi
Umphathi yeyona yunithi ingundoqo yemodyuli apho isicelo ngokwaso siphunyezwa kwaye ekuvumela ukuba ufumane iimetriki.
Ukufumana i-metric elula:
- Yenza ifayile ukufumana i-metric entsha:
zabbix/src/go/plugins/postgres/handler_uptime.go
- Sidibanisa ipakethe kwaye sikhankanya isitshixo esisodwa semetrics:
- Senza isibambi ngesicelo, o.k.t. siqalisa ukuguquguquka okuya kuba nesiphumo:
- Senza isicelo:
Kuyimfuneko ukujonga isicelo seempazamo, emva koko umphumo uya kuthathwa yinkqubo ye-Zabbix Agent 2.
- Bhalisa isitshixo semetric entsha:
Emva kokubhalisa i-metric, unokwakha kwakhona iarhente ngemetric entsha.
Imodyuli iyafumaneka ukuqala kwiZabbix 5.0 kwiwebhusayithi . Kolu guqulelo lwe-Zabbix, iiparamitha zisetwe ngokwahlukeneyo nge-host kunye ne-port. Kwi-Zabbix 5.0.2, eya kukhutshwa ngokukhawuleza, iiparamitha zokudibanisa ziya kudibaniswa zibe yi-URI enye.
Π‘ΠΏΠ°ΡΠΈalu
amakhonkco aluncedo
umthombo: www.habr.com