antony@notes:~/kubernetes$ cat "Kubernetes-Grafana.md"
Kubernetes Grafana
Kubernetes Grafana
[TOC]
部署 Grafana on K8S
環境準備 CNT.2022.v4 K8S 叢集建置完成 以下 K8S 公設完成部署
- MetalLB
- Ingress NGINX Controller
- Local Path Provisioner
在 Windows 系統的 cmd 視窗登入 m1 主機
部署 Grafana
$ kubectl create ns gf
$ kubectl apply -f https://web.flymks.com/grafana/v1/grafana.yaml
## 確認部署狀態
$ kubectl get all -n gf
NAME READY STATUS RESTARTS AGE
pod/grafana-84ff489848-lrqr4 1/1 Running 0 6m18s
pod/mariadb-7fc4547b95-krc9c 1/1 Running 0 6m18s
NAME TYPE CLUSTER-IP EXTERNAL-IP PORT(S) AGE
service/grafana ClusterIP 10.98.0.180 <none> 3000/TCP 6m18s
service/mariadb ClusterIP None <none> <none> 6m18s
NAME READY UP-TO-DATE AVAILABLE AGE
deployment.apps/grafana 1/1 1 1 6m18s
deployment.apps/mariadb 1/1 1 1 6m18s
NAME DESIRED CURRENT READY AGE
replicaset.apps/grafana-84ff489848 1 1 1 6m18s
replicaset.apps/mariadb-7fc4547b95 1 1 1 6m18s登入 Grafana
打開瀏覽器，網址 http://gf.k8s.org
帳號：grafana 密碼：Grafana12345
新增 Data Sources
點 ‘Configuration’ (左側齒輪) 點 ‘Add data source’ (中間藍色框) 點 ‘Mysql’ MySQL Connection
- Host: mariadb.landlord.svc:3306
- Database: landlord
- User: landlord
- Password: mymariadblandlord
新增 Dashboard
點 ‘Create’ (左側 +) 點 ‘Refresh dashboard’ (右上倒三角) 點 ‘5s’ 點 ‘Save dashboard’ 取名為 Building
新增 Panel
版面說明
設定時鐘
Panel 選單選取 ‘Clock’ Panel 設定
- Panel options
- Title: Time
- Time Format
- Clock Type: 24 Hour
- Font size: 20px
- Font size: Bold
- Date Options
- Font size: 16px
設計 History 表格
Panel 選單選 ‘Table’ Panel 設定 Panel options Title: History Database Query Edit SQL SELECT * FROM history Format as: Table