Grafana使用总结

安装

# 官网下载 http://docs.grafana.org/
sudo rpm -Uvh grafana-5.3.2-1.x86_64.rpm

配置

vim /etc/grafana/grafana.ini
-----------------------------------
[auth.anonymous] 
# 设置允许匿名 
enabled = true 
# 设置允许匿名的组织 
org_name = Main Org. 
# 设置允许匿名的组织角色 
org_role = Viewer
-----------------------------------

使用

sudo service grafana-server start
http://localhost:3000/

# mysql示例
SELECT
  UNIX_TIMESTAMP(stamp) as time_sec,
  pod_total as value,
  'pod_total' as metric
FROM ha.pod_status
WHERE ip='$host'
ORDER BY stamp ASC

# prometheus示例
sum (kafka_burrow_topic_partition_offset{topic='stream.features.face_24503'})

重置密码

sqlite3 /var/lib/grafana/grafana.db
sqlite> update user set password = '59acf18b94d7eb0694c61e60ce44c110c7a683ac6a8f09580d626f90f4a242000746579358d77dd9e570e83fa24faa88a8a6', salt = 'F3FAxVm33R' where login = 'admin';
sqlite> .exit
# 以上变更之后admin账户密码恢复为admin