Nkwupụta sitere na Daria Vilkova maka Zabbix Meetup Online
Achọrọ m ịme ka ị mata PostgreSQL na ngwaọrụ nlekota sistemụ arụmọrụ, nke ụlọ ọrụ anyị na-eji Zabbix na-emepụta.
Anyị ahọrọla Zabbix dị ka ngwá ọrụ nleba anya anyị ogologo oge n'ihi na ọ bụ oghere mepere emepe nke obodo na-arụsi ọrụ ike na-akwado nke ukwuu na Russia.
Anyị mepụtara onye na-arụsi ọrụ ike - Mamonsu, nke nyere nleba anya na-agbanwe agbanwe karịa ngwaọrụ ọkọlọtọ n'oge ahụ kwere, ma hụ na nchịkọta nke metrics na iziga ha na Zabbix Server. Na ụlọ ọrụ anyị, a na-eji Mamonsu na nyocha.
Mamonsu
Mamonsu bụ onye na-arụsi ọrụ ike (Zabbix Trapper) maka nlekota PostgreSQL na sistemụ arụmọrụ. Mamonsu (nke edere na Python) na-enye gị ohere ịhazi PostgreSQL na ntọala nlekota sistemụ n'ime nkeji ise.
Mamonsu nwere ngwaọrụ ndị ọzọ:
- mamonsu tune bụ iwu na-edezi ntọala dị na faịlụ nhazi PostgreSQL maka igwe arụnyere onye nnọchite Mamonsu na ya.
- akụkọ mamonsu bụ iwu na-ewepụta azịza gbasara sistemụ arụmọrụ yana PostgreSQL.
A na-etinye Mamonsu na ihe nkesa DBMS, na-anakọta ozi, na-ede ya na JSON, nke na-eziga ya na Zabbix Server maka ikiri anya, ebe kwesịrị inwe template maka metrics ya.
Atụmatụ ọrụ Mamonsu
Atụmatụ Mamonsu
- Arụ ọrụ nke ọma na PostgreSQL. Njikọ na-adịgide adịgide na PostgreSQL bụ isi uru nke Mamonsu. N'okwu a, ọnụ ọgụgụ kachasị elu nke njikọ hà nhata na ọnụọgụ ọdụ data nke ọ na-ejikọta.
- Mgbasawanye. Mamonsu bụ onye na-ahụ maka “plugin” nke ọma, n'ihi nhazi nke ngwa mgbakwunye ọ bụla yana ịdị mfe nke Python, mmadụ nwere ike mụta ngwa ngwa ka esi ede plugins ọhụrụ ma ọ bụ dezie ọkọlọtọ ọkọlọtọ, ya bụ metrics collection parameters.
- Mkpuchi metrics nleba anya zuru oke maka PotgreSQL gụnyere metrics gbatịpụrụ iche.
- mmalite ngwa ngwa, nnweta site na igbe.
- Na-ebugo ndebiri na faịlụ nhazi, yana ebugote na Zabbix Server.
- Cross-ikpo okwu, nke dị mkpa maka ndị ahịa anyị na-eji nkesa Linux dị iche iche, gụnyere nke ụlọ.
- Ikikere nkebiokwu BSD.
N'oge anyị na-enye ọtụtụ plugins na nke ọ bụla ọzọ version anyị na-agbalị itinye ihe ọhụrụ.
- 14 plugins maka PostgreSQL,
- 8 plugins maka OS Linux,
- 4 plugins maka OS Windows.
Mamonsu na-anakọta ihe karịrị 110 PostgreSQL yana metrik sistemụ arụmọrụ:
- 70 PostgreSQL metrik,
- 40 OS Linux metrik,
- 8 Windows metrik OS.
Metiriiki isi gụnyere nnweta DBMS, ọnụọgụ njikọ, nha nchekwa data, ebe nlele, ọsọ ọgụgụ/dee, mkpọchi, ọnụọgụ nke usoro akpaaka, yana ọsọ ọgbọ WAL. Ndepụta zuru ezu nke metrik dị, yana nkọwa zuru ezu nke ngwaọrụ niile, dị na
Ndepụta metrik dị na GitHub
Gbaa Mamonsu n'ime nkeji 5
Iji guzobe nlekota PostgreSQL na sistemụ arụmọrụ site na iji Mamonsu, ị nwere ike ime ya na nkeji 5 site na ịgbaso usoro 5 dị mfe.
- Ịwụnye Mamonsu. Enwere ike wuo Mamonsu site na isi mmalite ma ọ bụ jiri ngwugwu dị.
$ git clone ... && cd mamonsu && python setup.py
build && python setup.py install
- Ntọlite njikọ. Ọ dị mkpa ịtọ ntọala njikọ maka PostgreSQL na Zabbix Server na faịlụ agent.conf.
/etc/mamonsu/agent.conf
- Bupu ndebiri na sava Zabbix.
$ mamonsu zabbix template export
/usr/share/mamonsu/example.xml
- Na-agbakwụnye onye ọbịa na Zabbix Server. A ga-ejikọta ndebiri mbupụ na-akpaghị aka na onye ọbịa ọhụrụ na Zabbix Server.
$ mamonsu zabbix host create mamonsu-demo
- Mwepụta.
$ service mamonsu start
Ntuziaka mmepe Mamonsu
Dị ka akụkụ nke mmepe nke Mamonsu, anyị na-eme atụmatụ imezigharị metrics na ịmepụta plugins ọhụrụ, dị ka ngwa mgbakwunye maka nyochaa nha nke tebụl n'otu n'otu. Anyị na-eme atụmatụ imeziwanye ma mepụta ngwa ọrụ ndị ọzọ, yana ịgbasa ike ịmegharị akpaaka site na iwu ahụ mamonsu tune.
Modul nlekota PostgreSQL dịka akụkụ nke Zabbix Agent 2
A na-eji ọkwọ ụgbọ ala ọsọ ọsọ na ewu ewu jikọọ na PostgreSQL
Ka ọ dị ugbu a, anyị na-eji oghere abụọ: Exporter, nke na-akpọ onye njikwa site na igodo, yana Configurator Zabbix Agent 2, nke na-agụ ma na-enyocha paramita njikọ na ihe nkesa akọwapụtara na faịlụ nhazi.
Anyị gbalịrị ịkwalite ọrụ nke DBMS site n'ịchịkọta metrics na iji onye njikwa (handler) maka metrics na metric otu, yana iji otu metrics na JSON dị ka mgbanwe ndị dabere (ihe ndabere), na nchọpụta dị ala (iwu nchọpụta). ).
Njirimara igodo
- na-ejigide njikọ na-adịgide adịgide na PostgreSQL n'etiti nlele;
- nkwado maka oge ntuli aka na-agbanwe agbanwe;
- ndakọrịta na ụdị PostgreSQL malite na 10 na Zabbix Server malite na ụdị 4.4;
- ikike ijikọ na nyochaa ọtụtụ ihe atụ PostgreSQL n'otu oge n'ihi na Zabbix Agent 2 na-enye gị ohere ịmepụta ọtụtụ nnọkọ.
PostgreSQL Njikọ Ọkwa
Na mkpokọta, enwere ọkwa njikọ njikọ PostgreSQL atọ, ya bụ ọrụ na ntọala:
- Zuru ụwa ọnụ,
- nnọkọ,
- nnukwu macro.
-
Edebere paramita zuru ụwa ọnụ n'ọkwa onye nnọchi anya, nkeji oge na Macros na-akọwapụta paramita njikọ nchekwa data.
-
Ntọala njikọ na PostgreSQL - A na-edozi oge na faịlụ ahụ zabbix_agent2.conf.
Nhọrọ Njikọ PostgreSQL - Oge
- Mgbe isiokwu sessions akpọpụtara aha nnọkọ pụrụ iche, nke a ga-edepụtarịrị na igodo (ụkpụrụ).
- parameters URI и Aha njirimara achọrọ maka nnọkọ ọ bụla.
- Ọ bụrụ na akọwapụtaghị aha ntọala ahụ, a na-eji aha ntọala ndabere maka oge niile PostgreSQL, nke edobere na faịlụ nhazi.
- Njikọ njikọ na PostgreSQL - A na-edozi Macros na igodo metric na template (dị ka usoro eji na Zabbix Agent 1), ya bụ, a na-emepụta ha na template wee kọwaa dị ka paramita na igodo. N'okwu a, a na-edozi usoro nke macros, ya bụ, dịka ọmụmaatụ, URI mgbe niile na-edepụta mbụ.
Njikọ njikọ PostgreSQL - Macros
Modul nlekota PostgreSQL agụnyelarị ihe karịrị metrik 95 nke na-enye gị ohere ikpuchi oke ọkwa PostgreSQL, gụnyere:
- ọnụ ọgụgụ nke njikọ
- nha nchekwa data,
- na-edebe akwụkwọ ndekọ aha,
- ebe nlele,
- ọnụ ọgụgụ nke tebụl "bloated",
- ọnọdụ mmeghari,
- oyiri igbu oge.
Metiriks PostgreSQL abụghị ihe ọmụma na-enweghị oke sistemụ arụmọrụ. Mana Zabbix Agent 2 amaralarị ka esi achịkọta paramita sistemụ arụmọrụ, yabụ iji nweta foto zuru oke, anyị na-ejikọ naanị ndebiri dị mkpa na onye ọbịa.
Onye njikwa
Onye njikwa ahụ bụ akụkụ bụ isi nke modul nke a na-eme arịrịọ n'onwe ya na nke na-enye gị ohere ịnweta metrik.
Iji nweta metrik dị mfe:
- Mepụta faịlụ ka ị nweta metrik ọhụrụ:
zabbix/src/go/plugins/postgres/handler_uptime.go
- Anyị jikọtara ngwugwu ahụ wee kọwapụta igodo (igodo) pụrụ iche nke metrik:
- Anyị na-emepụta onye njikwa (onye njikwa) na arịrịọ, ya bụ, anyị na-ebute mgbanwe nke ga-enwe nsonaazụ:
- Anyị na-eme arịrịọ:
Ọ dị mkpa ịlele arịrịọ maka njehie, mgbe nke ahụ gasịrị, usoro Zabbix Agent 2 ga-ewere nsonaazụ ya.
- Deba aha igodo metric ọhụrụ:
Mgbe ị debanyere metric ahụ, ị nwere ike iji metrik ọhụrụ wughachi onye ọrụ ahụ.
Modul dị malite na Zabbix 5.0 na saịtị ahụ
Gwa anyị ihe ị ga-eme!
Njikọ ndị bara uru
isi: www.habr.com