Upgrade to Pro — share decks privately, control downloads, hide ads and more …

«Обновления в плагине Grafana Zabbix» — Александр Зобнин, Grafana Labs

Badoo Tech
June 26, 2018
9.5k

«Обновления в плагине Grafana Zabbix» — Александр Зобнин, Grafana Labs

Александр занимается непосредственно разработкой Grafana, а также поддержкой и развитием плагина для Zabbix.

Он расскажет о новых возможностях, которые появились в плагине за последнее время, заглянет под капот и покажет, как SQL data sources в Grafana позволяют повысить производительность отрисовки графиков. Также поделится планами по переносу плагина на backend.

Выступление на Zabbix Moscow Meetup 2018 в офисе Badoo.

Badoo Tech

June 26, 2018
Tweet

More Decks by Badoo Tech

Transcript

  1. Grafana-Zabbix
    plugin update

    View full-size slide

  2. • Visualize

    • Dynamic dashboards

    • 30+ data sources

    • Alerting

    • Plugins

    View full-size slide

  3. Updates

    v3.6 - v3.9

    View full-size slide

  4. Triggers Panel

    View full-size slide

  5. Background
    highlight
    TV view

    View full-size slide

  6. Triggers Panel
    • Multiple datasources support

    • Filtering by tags

    View full-size slide

  7. Direct DB connection
    fetching history data from DB

    View full-size slide

  8. Zabbix API
    Backend
    Frontend

    View full-size slide

  9. Zabbix API
    Backend
    Frontend

    View full-size slide

  10. Zabbix API
    Backend
    Frontend

    View full-size slide

  11. Zabbix API
    Backend
    Frontend

    View full-size slide

  12. Zabbix API
    Zabbix DS

    View full-size slide

  13. SELECT itemid AS metric,
    clock / {intervalSec} * {intervalSec} AS time,
    {aggFunc}(value) AS value
    FROM {historyTable}
    WHERE itemid IN ({itemids})
    AND clock > {timeFrom} AND clock < {timeTill}
    GROUP BY 1, 2
    ORDER BY time ASC

    View full-size slide

  14. SELECT itemid AS metric,
    clock / {intervalSec} * {intervalSec} AS time,
    {aggFunc}(value) AS value
    FROM {historyTable}
    WHERE itemid IN ({itemids})
    AND clock > {timeFrom} AND clock < {timeTill}
    GROUP BY 1, 2
    ORDER BY time ASC

    View full-size slide

  15. Backend
    Frontend
    Aggregated data

    View full-size slide

  16. Zabbix API
    Zabbix DS
    History, Trend
    Host, Item, …

    View full-size slide

  17. Zabbix DS
    In progress

    View full-size slide

  18. What’s next?

    View full-size slide

  19. Backend plugins
    •Alerting

    •Improve caching

    •Move data processing to backend

    View full-size slide

  20. Data flow
    Zabbix API
    Query
    Cache
    Proxy
    Processing

    View full-size slide

  21. Zabbix API
    Query
    Cache
    Proxy
    Processing Query
    Cache
    Proxy
    Processing
    Client 1 Client 2

    View full-size slide

  22. Zabbix API
    Query
    Client 1
    Query
    Client 2
    Cache
    Proxy Processing
    Backend

    View full-size slide

  23. Александр Зобнин
    [email protected]
    [email protected]
    github.com/alexanderzobnin/grafana-zabbix/

    View full-size slide