Superset 安装指南

Apache Superset是一个开源的数据探索和可视化平台,设计上注重视觉吸引力和直观性。它提供了一个界面,用户可以用来探索和可视化数据集,创建和分享仪表板,以及运行数据分析。它支持各种数据库和数据引擎,包括MySQL,Postgres,Redshift,BigQuery,SQLite等。Superset的目标是让数据分析变得更加直观,无需编写复杂的SQL查询。

  • 约 15 分钟
  • 4,440 字

Docker 安装

1. 拉取稳定版

docker run --rm --network host --name superset amancevice/superset:2.1.0

2. 配置MySQL 数据库存储

5.7 或 8.0 均适用
创建 superset 用户并配置远程访问
SQL

create user superset
    identified by 'superset';    
SQL
# MysQL 5.7
GRANT ALL PRIVILEGES ON *.* TO 'superset'@'%' IDENTIFIED BY 'superset' WITH GRANT OPTION;
# MySQL 8.0
GRANT ALL PRIVILEGES ON *.* TO 'superset'@'%' WITH GRANT OPTION;

3.配置 Redis 缓存

安装过程忽略

4. 自定义配置 superset

存储到 MySQL, 缓存到 Redis
创建配置目录
纯文本
mkdir -p /etc/superset
创建配置文件
纯文本
cd /etc/superset/
touch superset_config.py
/etc/superset/superset_config.py
Python
import os

# MAPBOX_API_KEY = os.getenv("MAPBOX_API_KEY", "")
CACHE_CONFIG = {
    "CACHE_TYPE": "RedisCache",
    "CACHE_DEFAULT_TIMEOUT": 300,
    "CACHE_KEY_PREFIX": "superset_",
    "CACHE_REDIS_HOST": "redis",
    "CACHE_REDIS_PORT": 6379,
    "CACHE_REDIS_DB": 1,
    "CACHE_REDIS_URL": "redis://redis.example.com:6379/11",
}
FILTER_STATE_CACHE_CONFIG = {**CACHE_CONFIG, "CACHE_KEY_PREFIX": "superset_filter_"}
EXPLORE_FORM_DATA_CACHE_CONFIG = {**CACHE_CONFIG, "CACHE_KEY_PREFIX": "superset_explore_form_"}
SQLALCHEMY_DATABASE_URI = "mysql://superset:superset@mysql.example.com:3306/superset?charset=utf8mb4"
SQLALCHEMY_TRACK_MODIFICATIONS = True
SECRET_KEY = "thisISaSECRET_1234"

5.启动

指定自定义配置项 superset_config.py -v /etc/superset:/etc/superset 指定端口映射到主机的 28088 端口 -p 28088:8088
纯文本
docker run -d --restart always -v /etc/superset:/etc/superset --name superset amancevice/superset:2.1.0

6.首次启动后需要初始化

纯文本
docker exec -it superset superset-init
配置用户名 / 密码
纯文本
[root@jansora superset]# docker exec -it superset superset-init
Username [admin]: admin
User first name [admin]: 
User last name [user]: 
Email [admin@fab.org]: 
Password: 
Repeat for confirmation: 
Loaded your LOCAL configuration at [/etc/superset/superset_config.py]
logging was configured successfully
...

7. 配置到 nginx

Bash
server {
    listen 443 ssl http2;
    server_name superset.jansora.app;
    # ssl_ciphers    ECDHE-RSA-AES128-GCM-SHA256:ECDHE:ECDH:AES:HIGH:!NULL:!aNULL:!MD5:!ADH:!RC4;
    ssl_protocols    TLSv1 TLSv1.1 TLSv1.2;
    ssl_certificate     /etc/openresty/certs/lets-encrypt-jansora.app/jansora.app.crt;
    ssl_certificate_key /etc/openresty/certs/lets-encrypt-jansora.app/jansora.app.key;

    location / {
      proxy_pass_header Server;
      proxy_set_header Host $http_host;
      proxy_redirect off;
      proxy_set_header X-Real-IP $remote_addr;
      proxy_set_header X-Scheme $scheme;
      proxy_pass http://127.0.0.1:28088;
    }

}

访问测试

Kubernetes 安装 superset

与 Docker 安装类似

1.2.3.4 步骤同 Docker 安装

忽略

5. 配置到 ConfigMap

Bash
kubectl create configmap superset-config --from-file=/etc/superset/superset_config.py

6. 配置 Deployment

YAML
apiVersion: apps/v1
kind: Deployment
metadata:
  name: superset
spec:
  selector:
    matchLabels:
      app:  superset
  strategy:
    type: RollingUpdate
    rollingUpdate:
      maxSurge: 20
      maxUnavailable: 20
  replicas: 1
  template:
    metadata:
      labels:
        app: superset
    spec:
      containers:
        - name: superset
          image: amancevice/superset:2.1.0
          imagePullPolicy: IfNotPresent
          ports:
            - containerPort: 8088
          volumeMounts:
            - name: config-volume
              mountPath: /etc/superset/superset_config.py
              subPath: superset_config.py
      volumes:
        - name: config-volume
          configMap:
            name: superset-config

7. 配置 Service

YAML
apiVersion: v1
kind: Service
metadata:
  name: superset-service
spec:
  type: ClusterIP
  selector:
    app: superset
  ports:
    - protocol: TCP
      port: 8080
      targetPort: 8088
      name: http

8. 配置 ingress

YAML
apiVersion: networking.k8s.io/v1
kind: Ingress
metadata:
  name: superset-ingress

spec:
  ingressClassName: nginx
  rules:
    - host: superset.kubernetes.jansora.com
      http:
        paths:
          - backend:
              service:
                name: superset-service
                port:
                  number: 8080
            pathType: Prefix
            path: /

9. 初始化

Bash
root@master:~# kubectl get pods | grep superset
superset-665796cd87-5l4l7               1/1     Running            0                 5h3m
root@master:~# kubectl exec -it superset-665796cd87-5l4l7 -- superset-init
... 
init log
...

转发

Bash

server {
    listen 443 ssl http2;
    server_name superset.jansora.com;

    ssl_protocols    TLSv1 TLSv1.1 TLSv1.2;
    ssl_certificate     /etc/openresty/certs/lets-encrypt-jansora.com/jansora.com.crt;
    ssl_certificate_key /etc/openresty/certs/lets-encrypt-jansora.com/jansora.com.key;

    location / {
      proxy_pass http://kubernetes;
      proxy_set_header Host superset.kubernetes.jansora.com;
      proxy_set_header Upgrade $http_upgrade;
      proxy_set_header Connection upgrade;
      proxy_set_header Accept-Encoding gzip;
    }

}

访问测试

附: MAC 安装手稿

cd /Users/jansora/Library
python3 -m venv superset
export SUPERSET_HOME=/Users/jansora/Library/superset
$SUPERSET_HOME/bin/pip3 install apache-superset pillow -i https://pypi.tuna.tsinghua.edu.cn/simple
$SUPERSET_HOME/bin/superset db upgrade
$SUPERSET_HOME/bin/superset fab create-admin
nohup /Users/jansora/Library/superset/bin/superset run -p 19088 >/Users/jansora/Library/superset/superset.log 2>&1 &
纯文本
Username [admin]:
User first name [admin]:
User last name [user]:
Email [admin@fab.org]:
Password: admin
Repeat for confirmation: admin
Recognized Database Authentications.
Admin User admin created.
./superset load_examples ./superset init
  1. 配置驱动
纯文本
# Oracle 
$SUPERSET_HOME/bin/pip3 install cx_Oracle -i https://pypi.tuna.tsinghua.edu.cn/simple


# Mysql 
$SUPERSET_HOME/bin/pip3 install mysqlclient -i https://pypi.tuna.tsinghua.edu.cn/simple


superset 4.4 更新 初始化
进入容器, 执行
纯文本
superset db upgrade

superset fab create-admin \
        --username admin \
        --email admin@superset.com \
        --password admin \
        --firstname Superset \
        --lastname Admin

superset init
superset load_examples 

评论栏

分享你的想法,或参与下面的讨论。

参与讨论

支持 Markdown、代码和图片

撰写评论
正在加载编辑器…

友善交流,让讨论更有价值。

更多留言

加载中…