k8s安装Metabase开源报表系统

metabase是什么？

  metabase是一款开源的简易但强大同时又无缝兼容大数据和传统数据库的分析工具，帮助公司每一个人对企业数据的学习挖掘，进而达到更好的数据化运营和决策。

Metabase is a simple and powerful analytics tool which lets anyone learn and make decisions from their company’s data. No technical knowledge required! We hope you love it.

metabase能做什么？

1. 连接不同数据库进行数据可视化；
2. 数据分析，看板展示；
3. 数据报表；

支持的数据源

K8S安装部署，首先准备一个Mysql 8.0 以上的版本，如果用的8.0以下版本会报错；

---
apiVersion: apps/v1
kind: Deployment
metadata:name: metabasenamespace: cqlfn-info
spec:replicas: 1revisionHistoryLimit: 3selector:matchLabels:app: metabasetemplate:metadata:labels:app: metabasespec:containers:- image: metabase/metabase:latestname: metabaseimagePullPolicy: Alwaysports:- containerPort: 3000volumeMounts:- mountPath: /etc/localtimename: timezone- mountPath: /usr/share/zoneinfo/Asia/Shanghainame: timezoneenv:- name: TZvalue: 'Asia/Shanghai'- name: MB_DB_TYPEvalue: 'mysql'- name: MB_DB_HOSTvalue: 'mysql8.cqlfn-info'- name: MB_DB_DBNAMEvalue: 'metabase'- name: MB_DB_PORTvalue: '3306'- name: MB_DB_USERvalue: 'r**t'- name: MB_DB_PASSvalue: 'c***********5'volumes:- name: timezonehostPath:path: /usr/share/zoneinfo/Asia/ShanghaiimagePullSecrets:- name: loginnodeSelector:kubernetes.io/hostname: paas-biz2
---
apiVersion: v1
kind: Service
metadata:name: metabasenamespace: cqlfn-info
spec:type: ClusterIP   # 通过IP访问，这里可改为NodePortports:- port: 3000targetPort: 3000selector:app: metabase