Lipoti la Daria Vilkova la Zabbix Meetup Online
Ndikufuna ndikudziwitseni za PostgreSQL ndi chida chowunikira makina ogwiritsira ntchito omwe kampani yathu imapanga pogwiritsa ntchito Zabbix.
Tidasankha Zabbix ngati chida chathu chowunikira kalekale chifukwa ndi nsanja yotseguka yothandizidwa ndi gulu logwira ntchito lomwe limadziwika kwambiri ku Russia.
Tidapanga wothandizira - Mamonsu, yemwe adapereka kuwunika kosinthika kuposa zida zomwe zidaloledwa panthawiyo, ndikuwonetsetsa kusonkhanitsa ma metric ndikutumiza kwawo ku Zabbix Server. Pakampani yathu, Mamonsu amagwiritsidwa ntchito pofufuza.
Mamonsu
Mamonsu ndi wothandizira (Zabbix Trapper) wowunikira PostgreSQL ndi makina ogwiritsira ntchito. Mamonsu (yolembedwa mu Python) imakupatsani mwayi wokonza PostgreSQL ndi zowunikira zowunikira mu mphindi zisanu.
Mamonsu ali ndi zida zowonjezera:
- mamonsu tune ndi lamulo lomwe limasintha zoikamo mu fayilo ya kasinthidwe ya PostgreSQL pamakina omwe wothandizira wa Mamonsu amayikidwa.
- lipoti la mamonsu ndi lamulo lomwe limapereka mayankho okhudza makina ogwiritsira ntchito ndi PostgreSQL.
Mamonsu amaikidwa pa seva ya DBMS, amasonkhanitsa zambiri, amazipanga mu JSON, zomwe zimatumizidwa kuti ziwonekere ku Zabbix Server, kumene payenera kukhala template ya ma metrics ake.
Mamonsu ntchito ndondomeko
Zinthu za Mamonsu
- Kuchita bwino ndi PostgreSQL. Kulumikizana kosalekeza ku PostgreSQL ndiye mwayi waukulu wa Mamonsu. Pachifukwa ichi, chiwerengero chachikulu cha maulumikizidwe ndi ofanana ndi chiwerengero chachikulu cha ma database omwe amalumikizana nawo.
- Kukulitsa. Mamonsu ndi "plugin" wothandizira kwathunthu, ndipo chifukwa cha dongosolo lokhazikika la plugin iliyonse komanso kuphweka kwa Python, mutha kuphunzira mosavuta kulemba kapena kusintha mapulagini okhazikika, mwachitsanzo magawo otolera ma metrics.
- Kufalikira kwakukulu kwa ma metrics pakuwunika kwa PotgreSQL, kuphatikiza ma metric pazowonjezera zina.
- Kuyamba mwachangu, Kupezeka kunja kwa bokosi.
- Kukweza ma templates ndi mafayilo osintha, komanso kukweza ku Zabbix Server.
- Mtanda-nsanja, zomwe ndizofunikira kwa makasitomala athu omwe amagwiritsa ntchito magawo osiyanasiyana a Linux, kuphatikizapo apakhomo.
- BSD-clause license.
Pakalipano timapereka mapulagini ambiri ndipo mumtundu uliwonse wotsatira timayesa kuwonjezera china chatsopano.
- 14 mapulagini a PostgreSQL,
- 8 mapulagini a OS Linux,
- 4 mapulagini a OS Windows.
Mamonsu amasonkhanitsa zoposa 110 PostgreSQL ndi ma metric ogwiritsira ntchito:
- 70 PostgreSQL metrics,
- 40 OS Linux metrics,
- 8 OS Windows metrics.
Ma metrics ofunikira amaphatikizapo kupezeka kwa DBMS, kuchuluka kwa maulumikizidwe, kukula kwa database, malo ochezera, liwiro lowerenga / kulemba, zotsekera, kuchuluka kwa njira za autovacuum, ndi kuchuluka kwa m'badwo wa WAL. Mndandanda wathunthu wama metric omwe alipo, komanso kufotokozera mwatsatanetsatane zida zonse, likupezeka mu pa tsamba la GitHub.
Mndandanda wama metric omwe alipo pa GitHub
Yambitsani Mamonsu mu mphindi 5
Mutha kukhazikitsa PostgreSQL ndi kuyang'anira makina ogwiritsira ntchito pogwiritsa ntchito Mamonsu mu mphindi 5 potsatira njira zisanu zosavuta.
- Kukhazikitsa Mamonsu. Mamonsu amatha kumangidwa kuchokera kugwero kapena kugwiritsa ntchito mapaketi omwe alipo.
$ git clone ... && cd mamonsu && python setup.py
build && python setup.py install
- Kupanga migwirizano. Ndikofunikira kufotokozera magawo olumikizirana a PostgreSQL ndi Zabbix Server mu fayilo ya agent.conf.
/etc/mamonsu/agent.conf
- Kutumiza template ku Zabbix Server.
$ mamonsu zabbix template export
/usr/share/mamonsu/example.xml
- Powonjezera wolandila ku Zabbix Server. Template yotumizidwa kunja idzalumikizidwa yokha kwa wolandila watsopano pa Zabbix Server.
$ mamonsu zabbix host create mamonsu-demo
- Yambitsani.
$ service mamonsu start
Njira zachitukuko za Mamonsu
Monga gawo la chitukuko cha Mamonsu, tikukonzekera kukonzanso ma metric ndikupanga mapulagini atsopano, mwachitsanzo pulogalamu yowonjezera yowunikira kukula kwa matebulo amodzi. Tikukonzekeranso kukonza ndi kupanga zida zowonjezera, komanso kukulitsa luso lodzipangira nokha kudzera mu lamulo mamonsu nyimbo.
Module yowunikira ya PostgreSQL yophatikizidwa mu Zabbix Agent 2
Dalaivala wachangu komanso wotchuka amagwiritsidwa ntchito kulumikiza ku PostgreSQL (PG driver ndi toolkit for Go).
Pakalipano tikugwiritsa ntchito mawonekedwe awiri: Exporter, yomwe imayitana wothandizira ndi kiyi, ndi Configurator Zabbix Agent 2, yomwe imawerenga ndikuyang'ana magawo okhudzana ndi seva omwe atchulidwa mu fayilo yosinthira.
Tidayesetsa kukhathamiritsa magwiridwe antchito a DBMS mwa kugawa ma metrics ndikugwiritsa ntchito chowongolera ma metrics ndi magulu a metric, komanso kugwiritsa ntchito magulu a metric mu JSON monga zosinthika zodalira (zinthu zodalira), ndi zopezeka zotsika (malamulo opeza).
Zofunikira zazikulu
- kusunga kulumikizana kosalekeza kwa PostgreSQL pakati pa macheke;
- kuthandizira pakapita nthawi zovotera;
- yogwirizana ndi mitundu ya PostgreSQL kuyambira 10, ndi Zabbix Server kuyambira mtundu 4.4;
- kuthekera kolumikizana ndikuwunika zochitika zingapo za PostgreSQL nthawi imodzi chifukwa Zabbix Agent 2 imakulolani kuti mupange magawo angapo.
Magawo olumikizirana a PostgreSQL
Pazonse, magawo atatu olumikizirana ndi PostgreSQL akupezeka, mwachitsanzo, ntchito ndi zosintha:
- Padziko lonse,
- Magawo
- Macro.
-
Magawo a Global amayikidwa pamlingo wa wothandizira, magawo a Session ndi Macros amasankha magawo olumikizirana ndi database.
-
Magawo olumikizira ku PostgreSQL - Magawo amayikidwa mufayilo zabbix_agent2.conf.
Magawo olumikizirana a PostgreSQL - Magawo
- Pambuyo pa mawu osakira magawo dzina lapadera la gawo likuwonetsedwa, lomwe liyenera kufotokozedwa mu fungulo (template).
- magawo URI ΠΈ Winawake zofunikira pa gawo lililonse.
- Ngati dzina la database silinatchulidwe, dzina losasinthika la database la magawo onse a PostgreSQL limagwiritsidwa ntchito, lomwe limafotokozedwanso mufayilo yosinthira.
- Magawo olumikizira ku PostgreSQL - Macros amafotokozedwa mu kiyi ya metric mu template (yofanana ndi njira yomwe imagwiritsidwa ntchito mu Zabbix Agent 1), mwachitsanzo, amapangidwa mu template kenako amafotokozedwa ngati magawo mu kiyi. Pankhaniyi, mndandanda wa macros umakhazikika, mwachitsanzo, mwachitsanzo, URI nthawi zonse amatchulidwa koyamba.
Magawo olumikizirana a PostgreSQL - Macros
Module yowunikira ya PostgreSQL ilinso ndi ma metric opitilira 95, omwe amakulolani kuti muzitha kuwerengera magawo osiyanasiyana a PostgreSQL, kuphatikiza:
- chiwerengero cha maulumikizidwe,
- kuchuluka kwa database,
- kusungitsa mafayilo a wal,
- control points,
- kuchuluka kwa matebulo "otupa",
- kubwereza,
- replica lag.
Ma metric a PostgreSQL sakhala odziwitsa popanda magawo ogwiritsira ntchito. Koma Zabbix Agent 2 amadziwa kale kusonkhanitsa magawo ogwiritsira ntchito, kotero kuti tipeze chithunzi chonse timangogwirizanitsa ma tempuleti ofunikira ku node ya netiweki.
Wothandizira
Wothandizira ndiye gawo lalikulu la gawo lomwe pempho lokha limachitidwa ndipo limakupatsani mwayi wopeza ma metric.
Kuti mupeze metric yosavuta:
- Pangani fayilo kuti mulandire metric yatsopano:
zabbix/src/go/plugins/postgres/handler_uptime.go
- Timalumikiza phukusi ndikutchula makiyi apadera a metrics:
- Timapanga chothandizira ndi pempho, mwachitsanzo, timayambitsa kusintha komwe kudzakhala ndi zotsatira zake:
- Timagwira ntchito:
Ndikofunikira kuyang'ana pempho la zolakwika, pambuyo pake zotsatira zake zidzatengedwa ndi ndondomeko ya Zabbix Agent 2.
- Lembani kiyi yatsopano ya metric:
Mukalembetsa metric, mutha kumanganso wothandizira ndi metric yatsopano.
Gawoli likupezeka kuyambira Zabbix 5.0 patsamba . Mu mtundu uwu wa Zabbix, magawo amayikidwa padera kudzera pa host ndi doko. Mu Zabbix 5.0.2, yomwe idzatulutsidwa posachedwa, magawo ogwirizanitsa adzaphatikizidwa kukhala URI imodzi.
Zikomo chifukwa cha chidwi chanu!
maulalo othandiza
Source: www.habr.com