grafana绘图配置查询变量+多级变量联动

最新推荐文章于 2025-04-14 16:12:02 发布

CleverCode

最新推荐文章于 2025-04-14 16:12:02 发布

阅读量1.5w

点赞数 6

CC 4.0 BY-SA版权

分类专栏：架构师

本文链接：https://blog.youkuaiyun.com/CleverCode/article/details/104324039

1 centos7安装grafana

官网 https://grafana.com/grafana/download

# https://dl.grafana.com/oss/release/grafana-6.4.2-1.x86_64.rpm
# sudo yum localinstall grafana-6.4.2-1.x86_64.rpm

启动+开机启动

# systemctl restart grafana-server
# systemctl enable grafana-server

需要先启动grafana-server服务，后开启3000端口

# firewall-cmd --add-port=3000/tcp

第一次访问：http://172.16.159.132:3000 账号：admin 密码：admin 需要修改新密码：cc123456
第二次访问，使用新密码：http://172.16.159.132:3000 账号：admin 密码：cc123456

2 准备mysql数据库

1 准备sql语句

create database dolphin;

grant all privileges on dolphin.* to dolphin@'%' identified by 'dolphinBJ2019***';

use dolphin;

CREATE TABLE `teams` (
  `id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  `name` VARCHAR(255) NOT NULL DEFAULT '',
  `ctime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `utime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=INNODB DEFAULT CHARSET=utf8mb4;


CREATE TABLE `apps` (
  `id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  `teamid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  `name` VARCHAR(255) NOT NULL DEFAULT '',
  `ctime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `utime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=INNODB DEFAULT CHARSET=utf8mb4;


CREATE TABLE `items` (
  `id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0