pinba-server/pinba-server

simple pinba server with storage in clickhouse/loki

1.0.2 2019-04-09 16:59 UTC

Requires

• google/protobuf: ^3.7
• workerman/workerman: ^3.5

MIT

• morozovsk

• php
• server
• pinba
• swoole
• workerman
• clickhouse
• pinbaserver
• loki

README

Requirements

• php
• clickhouse

Installation

• cd /opt
• git clone https://github.com/pinba-server/pinba-server.git
• cd pinba-server
• php composer.phar install
• clickhouse-client -n < clickhouse/pinba.requests.sql

Usage

• php workerman_clickhouse.php start -d
• php workerman_clickhouse.php stop

Systemd autostart script

• sudo cp systemd/pinba-server.service /usr/lib/systemd/system/pinba-server.service
• sudo systemctl daemon-reload && systemctl enable pinba-server && systemctl start pinba-server

Stats for 24 hours with about 10 RPS on php-fpm and 450 RPS on nginx:

table	rows	size, Mb	description
requests	1kk	26	raw data
report_by_all	56k	2	aggregated data by minutes
nginx_requests	45kk	0	raw data, engine=null
nginx_report_by_all	300k	9	aggregated data by minutes

Info

• publications: reddit(en), habr(ru)
• the installation of ClickHouse, pinba-server, pinba module for php and nginx on Ubuntu 18.04 LTS and Centos 7.

Grafana

dashboard #10011

License

MIT License.

See also

• ClickHouse-Ninja/Proton - golang version of pinba-server for clickhouse
• olegfedoseev/pinba-influxdb - golang version of pinba-server for influxdb
• nginxhouse - nginx logs visualizer