{"id":32681,"date":"2019-10-31T21:48:22","date_gmt":"2019-10-31T18:48:22","guid":{"rendered":"https:\/\/prohoster.info\/blog\/statistika-i-monitoring-php-skriptov-v-realnom-vremeni-clickhouse-i-grafana-idut-na-pomoshh-k-pinba\/"},"modified":"2019-10-31T21:48:22","modified_gmt":"2019-10-31T18:48:22","slug":"statistika-i-monitoring-php-skriptov-v-realnom-vremeni-clickhouse-i-grafana-idut-na-pomoshh-k-pinba","status":"publish","type":"post","link":"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/statistika-i-monitoring-php-skriptov-v-realnom-vremeni-clickhouse-i-grafana-idut-na-pomoshh-k-pinba","title":{"rendered":"Statistika ja PHP skriptide j\u00e4lgimine reaalajas. ClickHouse ja Grafana tulevad Pinba'le appi.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Selles artiklis r\u00e4\u00e4gin, kuidas kasutada pinbat koos ClickHouse'i ja Grafana'ga, asendades pinba_engine'i ja pinboardi.<\/p>\n<p>PHP-projektis on pinba t\u00f5en\u00e4oliselt ainus usaldusv\u00e4\u00e4rne viis m\u00f5ista, mis toimub j\u00f5udlusega. T\u00f5si, tavaliselt rakendatakse pinbat ainult siis, kui juba on probleeme ja ei ole selge, kust alustada.<\/p>\n<p>Sageli ei tea keegi, kui sageli kutsutakse kindlat skripti esile sekundis\/minuutis ning optimiseerimine algab \u201ekatseliselt\u201d, alustades tundlikest kohtadest.<\/p>\n<p>M\u00f5ni anal\u00fc\u00fcsib nginx'i logisid, kuid teine j\u00e4lgib aeglaseid p\u00e4ringuid andmebaasis.<\/p>\n<p>Muidugi, pinba ei oleks liialdatud, kuid on mitmeid p\u00f5hjuseid, miks see ei ole kaugeltki igas projektis.<\/p>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/habrastorage.org\/webt\/br\/zm\/qz\/brzmqzc8itwc2lt3gjp0q2p-kse.png\"><img decoding=\"async\" alt=\"Statistika ja PHP skriptide j\u00e4lgimine reaalajas. ClickHouse ja Grafana tulevad Pinba&#039;le appi.\" src=\"\/wp-content\/uploads\/2019\/04\/cdf2dc9af2a131d1f9aaef6bbde9b914.jpg\" style=\"display:block;margin: 0 auto;\" \/><\/a><\/noindex><br \/>\n<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><br \/>\nEsimene p\u00f5hjus on installimine.<\/p>\n<p>Kuna pinba juurutamisest mingi \u201et\u00f5hususe\u201d saamiseks on v\u00e4ga soovitav n\u00e4ha n\u00e4itajaid mitte ainult viimase minuti jooksul, vaid ka pikema aja jooksul (p\u00e4evadest kuudeni).<\/p>\n<p>Selleks on vajalik:<\/p>\n<ul>\n<li>paigaldada php jaoks laiendus (ja v\u00f5ib-olla soovite nginx'i moodulit)<\/li>\n<li>kompileerida mysql'i jaoks laiendus<\/li>\n<li>paigaldada pinboard ja seadistada cron<\/li>\n<\/ul>\n<p>\nKuna piiratud teavet Pinba kohta, on paljudel j\u00e4\u00e4nud mulje, et see t\u00f6\u00f6tas ainult php5 all ja j\u00e4i ammu aegunuks, kuid nagu me j\u00e4rgnevalt n\u00e4eme \u2013 see ei ole t\u00f5si.<\/p>\n<p>Esimene samm on k\u00f5ige lihtsam, peate lihtsalt k\u00e4ivitama j\u00e4rgmise k\u00e4su:<\/p>\n<pre><code class=\"bash\">apt install php-pinba<\/code><\/pre>\n<p>\nTegemist on t\u00e4iustatud laiendusega, mis on saadaval kuni php 7.3 sisse arvatud ja te ei pea midagi kompileerima.<\/p>\n<p>P\u00e4rast paigaldamisk\u00e4sku saame kohe t\u00f6\u00f6tava laienduse, mis kogub ja saadab iga skripti metrikat (t\u00e4itmise aeg, m\u00e4lu jms) formaadis <noindex><a rel=\"nofollow\" href=\"https:\/\/ru.wikipedia.org\/wiki\/Protocol_Buffers\">protobuf<\/a><\/noindex> UDP-le aadressile 127.0.0.1:30002.<\/p>\n<p>Praegu keegi neid UDP-pakette ei p\u00fc\u00fca ega t\u00f6\u00f6tle, kuid see ei m\u00f5juta teie PHP-skriptide kiirus ega stabiilsust.<\/p>\n<p>Kuni hiljuti oli ainus rakendus, mis suutis neid UDP-pakette p\u00fc\u00fcda ja t\u00f6\u00f6delda, <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/tony2001\/pinba_engine\">pinba_engine<\/a><\/noindex>. \u041e\u043f\u0438\u0441\u0430\u043d\u0438\u0435 &#171;<noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/tony2001\/pinba_engine\/wiki\/Installation\">lihtne ja sisutihe<\/a><\/noindex>&#187; \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0438 \u043e\u0442\u0431\u0438\u0432\u0430\u0435\u0442 \u0436\u0435\u043b\u0430\u043d\u0438\u0435 \u043a\u043e\u0433\u0434\u0430-\u043b\u0438\u0431\u043e \u0435\u0449\u0451 \u0440\u0430\u0437 \u044d\u0442\u043e \u0447\u0438\u0442\u0430\u0442\u044c \u0438 \u0432\u043d\u0438\u043a\u0430\u0442\u044c. \u0412 \u043a\u0438\u043b\u043e\u043c\u0435\u0442\u0440\u043e\u0432\u044b\u0445 \u0441\u043f\u0438\u0441\u043a\u0430\u0445 \u0437\u0430\u0432\u0438\u0441\u0438\u043c\u043e\u0441\u0442\u0435\u0439 \u0435\u0441\u0442\u044c \u043a\u0430\u043a \u043d\u0430\u0437\u0432\u0430\u043d\u0438\u044f \u043f\u0430\u043a\u0435\u0442\u043e\u0432, \u0442\u0430\u043a \u0438 \u043d\u0430\u0437\u0432\u0430\u043d\u0438\u044f \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c \u0438 \u0441\u0441\u044b\u043b\u043a\u0438 \u043d\u0430 \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u044b\u0435 \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u044b \u0441 \u0438\u0445 \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u043e\u0439, \u0430 \u0443 \u0442\u0435\u0445 \u0441\u0432\u043e\u0438 \u0441\u0441\u044b\u043b\u043a\u0438 \u043d\u0430 \u0434\u0440\u0443\u0433\u0438\u0435 \u0437\u0430\u0432\u0438\u0441\u0438\u043c\u043e\u0441\u0442\u0438. \u0420\u0430\u0437\u0431\u0438\u0440\u0430\u0442\u044c\u0441\u044f \u0441 \u044d\u0442\u043e\u0439 \u043b\u0430\u0431\u0443\u0434\u043e\u0439 \u043d\u0438 \u0443 \u043a\u043e\u0433\u043e \u043d\u0435 \u0445\u0432\u0430\u0442\u0430\u0435\u0442 \u043d\u0438 \u0432\u0440\u0435\u043c\u0435\u043d\u0438, \u043d\u0438 \u0436\u0435\u043b\u0430\u043d\u0438\u044f.<\/p>\n<p>Installimisprotsess <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/badoo\/pinba2\">pinba2<\/a><\/noindex> ei muutunud <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/badoo\/pinba2\/blob\/master\/docs\/index.md#installation\">eriti lihtsamaks<\/a><\/noindex>.<\/p>\n<p>V\u00f5imalik, et kunagi saab pinba10 installida \u00fche v\u00f5i kahe k\u00e4suga, lugemata tohutut materjali, et aru saada, kuidas seda teha, kuid praegu ei ole see nii.<\/p>\n<p>Kui te ikkagi installisite pinba_engine'i, siis see on alles pool t\u00f6\u00f6st. Ilma <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/intaro\/pinboard\">pinboard<\/a><\/noindex> peate piirduma ainult viimase m\u00f5ne minuti andmetega v\u00f5i koguma, salvestama ja visualiseerima andmeid ise. Hea, et pinboard'i installimine on piisavalt lihtne. <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/intaro\/pinboard\/wiki\/Installation\">installimine<\/a><\/noindex>.<\/p>\n<p>Tundub, miks peaksime seet\u00f5ttu kannatama, kui k\u00f5ik PHP meetrikad juba saadetakse UDP-porti Protobuf formaadis ja ainus, mis on vajalik, on kirjutada rakendus, mis neid p\u00fc\u00fcab ja salvestab m\u00f5nda ladustamisruumi? Ilmselt need arendajad, kellele see m\u00f5te tuli, asusid kohe kirjutama oma versioone, millest osa j\u00f5udis GitHubi.<\/p>\n<p>J\u00e4rgnevalt on \u00fclevaade neljast avatud l\u00e4htekoodiga projektist, mis salvestavad meetrikad ladustamisruumidesse, millest need andmed on lihtne v\u00e4lja v\u00f5tta ja visualiseerida, n\u00e4iteks Grafana abil.<\/p>\n<h4><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/olegfedoseev\/pinba-server\">olegfedoseev\/pinba-server<\/a><\/noindex> (november 2017) <\/h4>\n<p>\nUDP server Go keeles, mis salvestab meetrikad OpenTSDB-sse. Kui OpenTSDB-d juba teie projektis kasutatakse, siis v\u00f5ib see lahendus teile sobida, muul juhul soovitan m\u00f6\u00f6da minna.<\/p>\n<h4><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/olegfedoseev\/pinba-influxdb\">olegfedoseev\/pinba-influxdb<\/a><\/noindex> (juuni 2018)<\/h4>\n<p>\nUDP server Go keeles, sama <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/users\/Aryoh\/\">Habrayuzeri<\/a><\/noindex>, mis seekord salvestab meetrikad InfluxDB-sse. Paljudes projektides kasutatakse juba praegu InfluxDB-d j\u00e4lgimiseks, seega v\u00f5ib see lahendus neile h\u00e4sti sobida.<\/p>\n<p>Plussid:<\/p>\n<ul>\n<li>InfluxDB <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/olegfedoseev\/pinba-influxdb#influxdb-preparation\">lubab<\/a><\/noindex> koondada saadud meetrikad, ja originaal kustutada m\u00e4\u00e4ratud aja jooksul.<\/li>\n<\/ul>\n<p>\nMiinused:<\/p>\n<ul>\n<li>see lahendus ei salvesta teavet ajataimerite kohta.<\/li>\n<li>InfluxDB salvestab veebilehtede aadresse siltidena ning kui teil on palju unikaalseid lehe aadresse, v\u00f5ib see viia <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/449352\/#comment_20085878\">suurema m\u00e4lukasutuse.<\/a><\/noindex> \u043e\u043f\u0435\u0440\u0430\u0442\u0438\u0432\u043d\u043e\u0439 \u043f\u0430\u043c\u044f\u0442\u0438. \u0421 \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0451\u043d\u043d\u043e\u0433\u043e \u043c\u043e\u043c\u0435\u043d\u0442\u0430 \u043e\u043d &#171;<noindex><a rel=\"nofollow\" href=\"https:\/\/habrastorage.org\/webt\/2v\/68\/th\/2v68thch8ajln7abt-ghsmsbxgs.png\">hakkab m\u00e4lus ruumi v\u00f5tma nagu hull.<\/a><\/noindex>&#171;. (<noindex><a rel=\"nofollow\" href=\"https:\/\/medium.com\/@valyala\/insert-benchmarks-with-inch-influxdb-vs-victoriametrics-e31a41ae2893\">allikas<\/a><\/noindex>)<\/li>\n<\/ul>\n<p><\/p>\n<h4><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/ClickHouse-Ninja\/Proton\">ClickHouse-Ninja\/Proton<\/a><\/noindex> (jaanuar 2019) <\/h4>\n<p>\nudp server go-s, mis salvestab metrikaid ClickHouse'i. See lahendus on minu s\u00f5bra oma. Just p\u00e4rast sellega tutvumist otsustasin, et on aeg p\u00fchenduda pinbale ja ClickHouse'ile.<\/p>\n<p>Plussid:<\/p>\n<ul>\n<li>ClickHouse sobib selliste \u00fclesannete jaoks ideaalselt, see v\u00f5imaldab andmeid nii kokku suruda, et saate salvestada k\u00f5ik toored andmed isegi ilma agregatsioonideta.<\/li>\n<li>Kui on vajadus, saate kergesti saadud meetrikaid agregatsiooni alla viia.<\/li>\n<li>Valmis \u0161abloon Grafanale.<\/li>\n<li>Salvestab teavet ajas<\/li>\n<\/ul>\n<p>\nMiinused:<\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"http:\/\/lurkmore.to\/%D0%A4%D0%B0%D1%82%D0%B0%D0%BB%D1%8C%D0%BD%D1%8B%D0%B9_%D0%BD%D0%B5%D0%B4%D0%BE%D1%81%D1%82%D0%B0%D1%82%D0%BE%D0%BA\">Fataaniline puudus<\/a><\/noindex><\/li>\n<li>Puudub konfigureerimise fail, kus oleks v\u00f5imalik seadistada andmebaasi ja tabelite nimed, serveri aadress ja port.<\/li>\n<li>Toores andmete salvestamisel kasutatakse abiteabelt s\u00f5nastikku veebilehtede ja domeenide aadresside salvestamiseks, mis muudab edasised p\u00e4ringud keeruliseks.<\/li>\n<li>Muud pisiasjad, mis tulenevad esimesest miinusest.<\/li>\n<\/ul>\n<p><\/p>\n<h4><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/pinba-server\/pinba-server\">pinba-server\/pinba-server<\/a><\/noindex> (aprill 2019) <\/h4>\n<p>\nPHP-l p\u00f5hinev UDP server, mis salvestab m\u00f5\u00f5dikud ClickHouse'i. See on minu lahendus, mis on tekkinud tutvumisest pinba, ClickHouse'i ja protobuf'iga. Kui ma sellega tegeledes proovin, siis kirjutasin \"proof of concept\", mis \u00fcllatas mind, kuna ei kasutanud m\u00e4rkimisv\u00e4\u00e4rseid ressursse (30 MB RAM'i ja v\u00e4hem kui 1% \u00fcheksast protsessorituumast), seet\u00f5ttu otsustasin selle avalikkusega jagada.<\/p>\n<p>Plussid \u2014 samad, mis eelnevas lahenduses, ja olen kasutanud tuttavaid nimetusi originaalsest pinba_engine'ist. Samuti olen lisanud konfi, mis v\u00f5imaldab k\u00e4ivitada mitu pinba serveri instantsi korraga, et salvestada m\u00f5\u00f5dikud erinevatesse tabelitesse \u2014 see on kasulik, kui soovite koguda andmeid mitte ainult PHP-st, vaid ka Nginx'ist.<br \/>\nMiinused \u2014 \"fatiline puudus\" ning v\u00e4ikesed detailid, mis ei pruugi teid rahuldada, kuid minu lahendus on \"lihtne nagu toss\" ja koosneb vaid umbes 100 koodireast, nii et iga PHP arendaja saab m\u00f5ne minutiga muuta seda, mis ei meeldi.<\/p>\n<p><b>T\u00f6\u00f6printsiip<\/b><\/p>\n<p>Kuuldub udp-port 30002. K\u00f5ik sissetulevad paketid dekodeeritakse vastavalt protobuf-skeemile ja kogutakse. Iga minuti j\u00e4rel tehakse klikhausse \u00fche partii sisestamine tabelisse pinba.requests. (k\u00f5ik parameetrid on seadistatavad <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/pinba-server\/pinba-server\/blob\/master\/config.json\">konfiguratsioonis<\/a><\/noindex>)<\/p>\n<p><b>Veidi klikhausest<\/b><\/p>\n<p>Clickhouse toetab erinevaid andmete salvestamise mootorite. K\u00f5ige sagedamini kasutatav on MergeTree. <\/p>\n<p>Kui te mingil hetkel otsustate hoida kogutud andmeid igavesti ja toorsed andmed ainult viimase aja jaoks, siis saate luua materialiseeritud vaate grupiga ning puhastada p\u00f5hitahti pinba.requests regulaarselt, samas kui k\u00f5ik andmed j\u00e4\u00e4vad materialiseeritud vaatesse. Veelgi enam, kui loote tabeli pinba.requests, saate m\u00e4\u00e4rata \u201eengine = Null\u201d, siis toored andmed ei salvestata \u00fcldse kettale, kuid need j\u00f5uavad ikkagi materialiseeritud vaatesse ja salvestatakse kogutuna. Sellist skeemi kasutan nginx'i m\u00f5\u00f5dikute jaoks, kuna nginx'il on mul 50 korda rohkem p\u00e4ringuid kui php-l.<\/p>\n<p>Nii, olete l\u00e4inud pika tee ja ma ei tahaks teid pooleli j\u00e4tta, seega j\u00e4rgneb \u00fcksikasjalik juhend minu lahenduse installimisest ja seadistamisest, samuti k\u00f5ik, mis teile vajalik, ning takistused, mille p\u00e4rast mitte \u00fckski laev ei purunenud. Kogu installimisprotsess on kirjeldatud Ubuntu 18.04 LTS ja CentOS 7 jaoks, teistel distributsioonidel ja versioonidel v\u00f5ib protsess veidi erineda.<\/p>\n<h4>Installeerimine<\/h4>\n<p>\nK\u00f5ik vajalikud k\u00e4sud olen kokku pannud <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/pinba-server\/pinba-server\/tree\/master\/docker\">Dockerfile<\/a><\/noindex> juhiste kordamise h\u00f5lbustamiseks. Allpool on ainult takistused, millega v\u00f5ib kokku puutuda.<\/p>\n<p><b>php-pinba<\/b><\/p>\n<p>P\u00e4rast installimist veenduge, et failis \/etc\/php\/7.2\/fpm\/conf.d\/20-pinba.ini on k\u00f5ik valikud avatud. M\u00f5nes distributsioonis (n\u00e4iteks CentOS) v\u00f5ivad need olla suletud.<\/p>\n<pre><code class=\"plaintext\">extension=pinba.so\npinba.enabled=1\npinba.server=127.0.0.1:30002<\/code><\/pre>\n<p>\n<b>clickhouse<\/b><\/p>\n<p>Installimise ajal k\u00fcsib ClickHouse teilt parooli seadmist default kasutajale. Vaikimisi on see kasutaja kergesti ligip\u00e4\u00e4setav k\u00f5igilt IP-delt, seega kui teil ei ole serveris tulem\u00fc\u00fcri, seadke kindlasti parool. Seda on v\u00f5imalik teha ka p\u00e4rast installimist failis \/etc\/clickhouse-server\/users.xml.<\/p>\n<p>Tasub t\u00e4hele panna, et clickhouse kasutab mitmeid porte, sealhulgas 9000. Seda porti kasutatakse m\u00f5nedes distributsioonides (n\u00e4iteks CentOS) ka php-fpm-iks. Kui see port on juba kasutusel, saate selle config.xml failis teiseks muuta.<\/p>\n<p><b>grafana plugina jaoks clickhouse'ile<\/b><\/p>\n<p>P\u00e4rast grafana installimist kasutage kasutajanime admin ja parooli admin. Esmakordsel sisenemisel palub grafana teil m\u00e4\u00e4rata uus parool.<\/p>\n<p>\u0414\u0430\u043b\u0435\u0435 \u0437\u0430\u0445\u043e\u0434\u0438\u043c \u0432 \u043c\u0435\u043d\u044e &#171;+&#187; -&gt; import \u0438 \u0443\u043a\u0430\u0437\u044b\u0432\u0430\u0435\u043c \u043d\u043e\u043c\u0435\u0440 \u0434\u0430\u0448\u0431\u043e\u0440\u0434\u0430 \u0434\u043b\u044f \u0438\u043c\u043f\u043e\u0440\u0442\u0430 <noindex><a rel=\"nofollow\" href=\"https:\/\/grafana.com\/dashboards\/10011\">10011<\/a><\/noindex>. Olen selle dashboardi teie jaoks ette valmistanud ja \u00fcles laadinud, et te ei peaks seda uuesti ise tegema.<\/p>\n<p>Grafana toetab clickhouse'iga t\u00f6\u00f6tamist kolmanda osapoole plugina kaudu, kuid kolmanda osapoole pluginatega ei t\u00f6\u00f6ta grafana h\u00e4iret teavitused (pilet selle kohta on juba mitu aastat ootel).<\/p>\n<p><b>pinba-server<\/b><\/p>\n<p>Protobufi ja libeventi paigaldamine ei ole kohustuslik, kuid parandab pinba-serveri j\u00f5udlust. Kui installite pinba-serveri kausta, mis on erinev \/opt, tuleb teil ka systemd skripti failis muudatusi teha. <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/pinba-server\/pinba-server\/blob\/master\/systemd\/pinba-server.service\">systemd skript<\/a><\/noindex> faili.<\/p>\n<p><b>pinba-modul nginx'ile<\/b><\/p>\n<p>Mooduli kompileerimiseks on vajalikud sama versiooniga nginx-i allikafailid, mis on juba teie serveris, samuti samad kompileerimisvalikud, muidu l\u00e4bib kogumine edukalt, kuid mooduli \u00fchendamisel ilmneb t\u00f5rge, et \"moodul on binaarselt \u00fchilduv\". Kompileerimisvalikuid saab vaadata k\u00e4su nginx -V abil.<\/p>\n<p><b>Elu nipid<\/b><\/p>\n<p>K\u00f5ik minu saidid t\u00f6\u00f6tavad ainult https-re\u017eiimis. Schema v\u00e4li kaotab oma t\u00e4henduse, seet\u00f5ttu kasutan seda web\/console lahutamiseks.<\/p>\n<p>Veebis saadaval olevates skriptides kasutan:<\/p>\n<pre><code class=\"php\">if (ini_get('pinba.enabled')) {\n    pinba_schema_set('web');\n}\n<\/code><\/pre>\n<p>\nJa konsoolis (n\u00e4iteks cron-skriptides):<\/p>\n<pre><code class=\"php\">if (ini_get('pinba.enabled')) {\n    pinba_schema_set('console');\n}<\/code><\/pre>\n<p>\nMinu Grafana armatuurlaud sisaldab web\/console l\u00fclitit statistika eraldi vaatamiseks.<\/p>\n<p>Lisaks saab Pinbasse saata oma silte, n\u00e4iteks:<\/p>\n<pre><code class=\"php\">pinba_tag_set('country', $countryCode);<\/code><\/pre>\n<p>\n<b>Sellega on k\u00f5ik. <\/b><\/p>\n<p>Palun vastake artikli alla pandud k\u00fcsimustele.<\/p>\n<p>Traditsiooniliselt hoiatab, et ma ei anna n\u00f5u ega aita l\u00e4bi Habra ja sotsiaalmeedia isiklikes s\u00f5numites.<\/p>\n<p>Esitage pilet GitHubis.<\/p>\n<p>Samuti on palve toetada meeldimistega <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/en\/post\/449818\/\">ingliskeelset versiooniga<\/a><\/noindex> selle artikli <noindex><a rel=\"nofollow\" href=\"https:\/\/www.reddit.com\/r\/PHP\/comments\/bigszu\/statistics_and_monitoring_of_php_scripts_in_real\/\">Redditis<\/a><\/noindex>.<\/p>\n<p class=\"for_users_only_msg\">Ainult registreeritud kasutajad saavad k\u00fcsitluses osaleda. <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/auth\/login\/\">Logige sisse<\/a><\/noindex>, palun.<\/p>\n<h2 class=\"default-block__polling-title\">Millist operatsioonis\u00fcsteemi serveris kasutate?<\/h2>\n<ul class=\"content-list content-list_polling\">\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    Ubuntu<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    CentOS<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    Debian<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    Gentoo<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    Red Hat<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    Fedora<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    OpenSUSE<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    SuSE<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    Unix<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    Windows<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    muu<\/p>\n<\/li>\n<\/ul>\n<p>    H\u00e4\u00e4letas 114 kasutajat. 11 kasutajat j\u00e4i erapooletuks.<\/p>\n<h2 class=\"default-block__polling-title\">Millist php versiooni te serveris kasutate?<\/h2>\n<ul class=\"content-list content-list_polling\">\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    7.3<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    7.2<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    7.1<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    7.0<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    5<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    muu<\/p>\n<\/li>\n<\/ul>\n<p>    H\u00e4\u00e4letas 105 kasutajat. 17 kasutajat j\u00e4i erapooletuks.<\/p>\n<h2 class=\"default-block__polling-title\">Kas olete kunagi pinbat kasutanud?<\/h2>\n<ul class=\"content-list content-list_polling\">\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    jah<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    ei, aga tahaksin<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    ei ja ei tahaks<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    ei ja ei ole sellest kuulnud<\/p>\n<\/li>\n<\/ul>\n<p>    H\u00e4\u00e4letas 100 kasutajat. 14 kasutajat j\u00e4i erapooletuks.<\/p>\n<h2 class=\"default-block__polling-title\">Millist pinba serveri versiooni sooviksite proovida?<\/h2>\n<ul class=\"content-list content-list_polling\">\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    pinba_engine (mysql engine)<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    pinba2 (mysql engine)<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    pinboard (php + mysql)<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    olegfedoseev\/pinba-server (go + OpenTSDB)<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    olegfedoseev\/pinba-influxdb (go + influxdb)<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    pinba-server\/pinba-server (go + clickhouse)<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    pinba-server\/pinba-server (php + clickhouse)<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    kirjutan enda omi<\/p>\n<\/li>\n<li class=\"content-list__item content-list__item_polling\">\n<p>                    muu<\/p>\n<\/li>\n<\/ul>\n<p>    H\u00e4\u00e4letas 39 kasutajat. 47 kasutajat j\u00e4i erapooletuks.<br \/>\n<br \/>Allikas: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/444610\/\">habr.com<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u0412 \u044d\u0442\u043e\u0439 \u0441\u0442\u0430\u0442\u044c\u0435 \u044f \u0440\u0430\u0441\u0441\u043a\u0430\u0436\u0443, \u043a\u0430\u043a \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c pinba \u0441\u043e\u0432\u043c\u0435\u0441\u0442\u043d\u043e \u0441 clickhouse \u0438 grafana \u0432\u043c\u0435\u0441\u0442\u043e pinba_engine \u0438 pinboard. \u041d\u0430 php-\u043f\u0440\u043e\u0435\u043a\u0442\u0435 pinba \u2014 \u043f\u043e\u0436\u0430\u043b\u0443\u0439 \u0435\u0434\u0438\u043d\u0441\u0442\u0432\u0435\u043d\u043d\u044b\u0439 \u043d\u0430\u0434\u0451\u0436\u043d\u044b\u0439 \u0441\u043f\u043e\u0441\u043e\u0431 \u043f\u043e\u043d\u044f\u0442\u044c, \u0447\u0442\u043e \u043f\u0440\u043e\u0438\u0441\u0445\u043e\u0434\u0438\u0442 \u0441 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c\u044e. \u041f\u0440\u0430\u0432\u0434\u0430 \u043e\u0431\u044b\u0447\u043d\u043e pinba \u0432\u043d\u0435\u0434\u0440\u044f\u0435\u0442\u0441\u044f \u0442\u043e\u043b\u044c\u043a\u043e \u0442\u043e\u0433\u0434\u0430, \u043a\u043e\u0433\u0434\u0430 \u0443\u0436\u0435 \u043d\u0430\u0431\u043b\u044e\u0434\u0430\u044e\u0442\u0441\u044f \u043f\u0440\u043e\u0431\u043b\u0435\u043c\u044b \u0438 \u043d\u0435 \u043f\u043e\u043d\u044f\u0442\u043d\u043e \u00ab\u0433\u0434\u0435 \u043a\u043e\u043f\u0430\u0442\u044c\u00bb. \u0427\u0430\u0441\u0442\u043e \u043d\u0438\u043a\u0442\u043e \u043f\u043e\u043d\u044f\u0442\u0438\u044f \u043d\u0435 \u0438\u043c\u0435\u0435\u0442, \u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0440\u0430\u0437 \u0432 \u0441\u0435\u043a\u0443\u043d\u0434\u0443\/\u043c\u0438\u043d\u0443\u0442\u0443 \u0432\u044b\u0437\u044b\u0432\u0430\u0435\u0442\u0441\u044f [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":24468,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-32681","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.10 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u0412 \u044d\u0442\u043e\u0439 \u0441\u0442\u0430\u0442\u044c\u0435 \u044f \u0440\u0430\u0441\u0441\u043a\u0430\u0436\u0443, \u043a\u0430\u043a \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c pinba \u0441\u043e\u0432\u043c\u0435\u0441\u0442\u043d\u043e \u0441 clickhouse \u0438 grafana \u0432\u043c\u0435\u0441\u0442\u043e pinba_engine \u0438 pinboard. \u041d\u0430 php-\u043f\u0440\u043e\u0435\u043a\u0442\u0435 pinba \u2014 \u043f\u043e\u0436\u0430\u043b\u0443\u0439 \u0435\u0434\u0438\u043d\u0441\u0442\u0432\u0435\u043d\u043d\u044b\u0439 \u043d\u0430\u0434\u0451\u0436\u043d\u044b\u0439 \u0441\u043f\u043e\u0441\u043e\u0431 \u043f\u043e\u043d\u044f\u0442\u044c, \u0447\u0442\u043e \u043f\u0440\u043e\u0438\u0441\u0445\u043e\u0434\u0438\u0442 \u0441 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c\u044e. \u041f\u0440\u0430\u0432\u0434\u0430 \u043e\u0431\u044b\u0447\u043d\u043e pinba \u0432\u043d\u0435\u0434\u0440\u044f\u0435\u0442\u0441\u044f \u0442\u043e\u043b\u044c\u043a\u043e \u0442\u043e\u0433\u0434\u0430, \u043a\u043e\u0433\u0434\u0430 \u0443\u0436\u0435 \u043d\u0430\u0431\u043b\u044e\u0434\u0430\u044e\u0442\u0441\u044f \u043f\u0440\u043e\u0431\u043b\u0435\u043c\u044b \u0438 \u043d\u0435 \u043f\u043e\u043d\u044f\u0442\u043d\u043e \u00ab\u0433\u0434\u0435 \u043a\u043e\u043f\u0430\u0442\u044c\u00bb. \u0427\u0430\u0441\u0442\u043e \u043d\u0438\u043a\u0442\u043e \u043f\u043e\u043d\u044f\u0442\u0438\u044f \u043d\u0435 \u0438\u043c\u0435\u0435\u0442, \u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0440\u0430\u0437 \u0432 \u0441\u0435\u043a\u0443\u043d\u0434\u0443\/\u043c\u0438\u043d\u0443\u0442\u0443 \u0432\u044b\u0437\u044b\u0432\u0430\u0435\u0442\u0441\u044f\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/statistika-i-monitoring-php-skriptov-v-realnom-vremeni-clickhouse-i-grafana-idut-na-pomoshh-k-pinba\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.10\" \/>\n\t\t<meta property=\"og:locale\" content=\"et_EE\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47\u0421\u0442\u0430\u0442\u0438\u0441\u0442\u0438\u043a\u0430 \u0438 \u043c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433 PHP \u0441\u043a\u0440\u0438\u043f\u0442\u043e\u0432 \u0432 \u0440\u0435\u0430\u043b\u044c\u043d\u043e\u043c \u0432\u0440\u0435\u043c\u0435\u043d\u0438. ClickHouse \u0438 Grafana \u0438\u0434\u0443\u0442 \u043d\u0430 \u043f\u043e\u043c\u043e\u0449\u044c \u043a Pinba | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u0412 \u044d\u0442\u043e\u0439 \u0441\u0442\u0430\u0442\u044c\u0435 \u044f \u0440\u0430\u0441\u0441\u043a\u0430\u0436\u0443, \u043a\u0430\u043a \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c pinba \u0441\u043e\u0432\u043c\u0435\u0441\u0442\u043d\u043e \u0441 clickhouse \u0438 grafana \u0432\u043c\u0435\u0441\u0442\u043e pinba_engine \u0438 pinboard. \u041d\u0430 php-\u043f\u0440\u043e\u0435\u043a\u0442\u0435 pinba \u2014 \u043f\u043e\u0436\u0430\u043b\u0443\u0439 \u0435\u0434\u0438\u043d\u0441\u0442\u0432\u0435\u043d\u043d\u044b\u0439 \u043d\u0430\u0434\u0451\u0436\u043d\u044b\u0439 \u0441\u043f\u043e\u0441\u043e\u0431 \u043f\u043e\u043d\u044f\u0442\u044c, \u0447\u0442\u043e \u043f\u0440\u043e\u0438\u0441\u0445\u043e\u0434\u0438\u0442 \u0441 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c\u044e. \u041f\u0440\u0430\u0432\u0434\u0430 \u043e\u0431\u044b\u0447\u043d\u043e pinba \u0432\u043d\u0435\u0434\u0440\u044f\u0435\u0442\u0441\u044f \u0442\u043e\u043b\u044c\u043a\u043e \u0442\u043e\u0433\u0434\u0430, \u043a\u043e\u0433\u0434\u0430 \u0443\u0436\u0435 \u043d\u0430\u0431\u043b\u044e\u0434\u0430\u044e\u0442\u0441\u044f \u043f\u0440\u043e\u0431\u043b\u0435\u043c\u044b \u0438 \u043d\u0435 \u043f\u043e\u043d\u044f\u0442\u043d\u043e \u00ab\u0433\u0434\u0435 \u043a\u043e\u043f\u0430\u0442\u044c\u00bb. \u0427\u0430\u0441\u0442\u043e \u043d\u0438\u043a\u0442\u043e \u043f\u043e\u043d\u044f\u0442\u0438\u044f \u043d\u0435 \u0438\u043c\u0435\u0435\u0442, \u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0440\u0430\u0437 \u0432 \u0441\u0435\u043a\u0443\u043d\u0434\u0443\/\u043c\u0438\u043d\u0443\u0442\u0443 \u0432\u044b\u0437\u044b\u0432\u0430\u0435\u0442\u0441\u044f\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/statistika-i-monitoring-php-skriptov-v-realnom-vremeni-clickhouse-i-grafana-idut-na-pomoshh-k-pinba\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2019-10-31T18:48:22+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2019-10-31T18:48:22+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47PHP skriptide statistika ja seire reaalajas. ClickHouse ja Grafana tulevad Pinbale appi | ProHoster","description":"Selles artiklis r\u00e4\u00e4gin, kuidas kasutada pinbat koos clickhouse'i ja grafanaga, asendades pinba_engine'i ja pinboardi. Php projektis on pinba t\u00f5en\u00e4oliselt ainus usaldusv\u00e4\u00e4rne viis m\u00f5ista, mis toimub j\u00f5udlusega. T\u00f5si, tavaliselt rakendatakse pinbat ainult siis, kui probleemid juba esinevad ja ei ole selge, kus kaevata. Tihti ei tea keegi, kui mitu korda sekundis\/minuutis seda kutsutakse.","canonical_url":"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/statistika-i-monitoring-php-skriptov-v-realnom-vremeni-clickhouse-i-grafana-idut-na-pomoshh-k-pinba","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"et_EE","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u0421\u0442\u0430\u0442\u0438\u0441\u0442\u0438\u043a\u0430 \u0438 \u043c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433 PHP \u0441\u043a\u0440\u0438\u043f\u0442\u043e\u0432 \u0432 \u0440\u0435\u0430\u043b\u044c\u043d\u043e\u043c \u0432\u0440\u0435\u043c\u0435\u043d\u0438. ClickHouse \u0438 Grafana \u0438\u0434\u0443\u0442 \u043d\u0430 \u043f\u043e\u043c\u043e\u0449\u044c \u043a Pinba | ProHoster","og:description":"\u0412 \u044d\u0442\u043e\u0439 \u0441\u0442\u0430\u0442\u044c\u0435 \u044f \u0440\u0430\u0441\u0441\u043a\u0430\u0436\u0443, \u043a\u0430\u043a \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c pinba \u0441\u043e\u0432\u043c\u0435\u0441\u0442\u043d\u043e \u0441 clickhouse \u0438 grafana \u0432\u043c\u0435\u0441\u0442\u043e pinba_engine \u0438 pinboard. \u041d\u0430 php-\u043f\u0440\u043e\u0435\u043a\u0442\u0435 pinba \u2014 \u043f\u043e\u0436\u0430\u043b\u0443\u0439 \u0435\u0434\u0438\u043d\u0441\u0442\u0432\u0435\u043d\u043d\u044b\u0439 \u043d\u0430\u0434\u0451\u0436\u043d\u044b\u0439 \u0441\u043f\u043e\u0441\u043e\u0431 \u043f\u043e\u043d\u044f\u0442\u044c, \u0447\u0442\u043e \u043f\u0440\u043e\u0438\u0441\u0445\u043e\u0434\u0438\u0442 \u0441 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c\u044e. \u041f\u0440\u0430\u0432\u0434\u0430 \u043e\u0431\u044b\u0447\u043d\u043e pinba \u0432\u043d\u0435\u0434\u0440\u044f\u0435\u0442\u0441\u044f \u0442\u043e\u043b\u044c\u043a\u043e \u0442\u043e\u0433\u0434\u0430, \u043a\u043e\u0433\u0434\u0430 \u0443\u0436\u0435 \u043d\u0430\u0431\u043b\u044e\u0434\u0430\u044e\u0442\u0441\u044f \u043f\u0440\u043e\u0431\u043b\u0435\u043c\u044b \u0438 \u043d\u0435 \u043f\u043e\u043d\u044f\u0442\u043d\u043e \u00ab\u0433\u0434\u0435 \u043a\u043e\u043f\u0430\u0442\u044c\u00bb. \u0427\u0430\u0441\u0442\u043e \u043d\u0438\u043a\u0442\u043e \u043f\u043e\u043d\u044f\u0442\u0438\u044f \u043d\u0435 \u0438\u043c\u0435\u0435\u0442, \u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0440\u0430\u0437 \u0432 \u0441\u0435\u043a\u0443\u043d\u0434\u0443\/\u043c\u0438\u043d\u0443\u0442\u0443 \u0432\u044b\u0437\u044b\u0432\u0430\u0435\u0442\u0441\u044f","og:url":"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/statistika-i-monitoring-php-skriptov-v-realnom-vremeni-clickhouse-i-grafana-idut-na-pomoshh-k-pinba","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2019-10-31T18:48:22+00:00","article:modified_time":"2019-10-31T18:48:22+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"32681","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":"2026-01-21 12:02:19","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-03-01 02:54:26","updated":"2026-01-21 12:02:19"},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/32681","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/comments?post=32681"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/32681\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media\/24468"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media?parent=32681"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/categories?post=32681"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/tags?post=32681"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}