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: metabase
  namespace: cqlfn-info
spec:
  replicas: 1
  revisionHistoryLimit: 3
  selector:
    matchLabels:
      app: metabase
  template:
    metadata:
      labels:
        app: metabase
    spec:
      containers:
        - image: metabase/metabase:latest
          name: metabase
          imagePullPolicy: Always
          ports:
            - containerPort: 3000
          volumeMounts:
            - mountPath: /etc/localtime
              name: timezone
            - mountPath: /usr/share/zoneinfo/Asia/Shanghai
              name: timezone
          env:
            - name: TZ
              value: 'Asia/Shanghai'
            - name: MB_DB_TYPE
              value: 'mysql'
            - name: MB_DB_HOST
			 value: 'mysql8.cqlfn-info'
            - name: MB_DB_DBNAME
              value: 'metabase'
            - name: MB_DB_PORT
              value: '3306'
            - name: MB_DB_USER
              value: 'r**t'
            - name: MB_DB_PASS
              value: 'c***********5'
      volumes:
        - name: timezone
          hostPath:
            path: /usr/share/zoneinfo/Asia/Shanghai
      imagePullSecrets:
        - name: login
      nodeSelector:
        kubernetes.io/hostname: paas-biz2
---
apiVersion: v1
kind: Service
metadata:
  name: metabase
  namespace: cqlfn-info
spec:
  type: ClusterIP   # 通过IP访问，这里可改为NodePort
  ports:
  - port: 3000
    targetPort: 3000
  selector:
    app: metabase