Metabase 项目:BI图表

本地部署

  • 虚拟机
    • 工具:vmware创建linux centos 7 64位虚拟机
    • 硬件:1核1G20G(多文件),桥接
    • 安装:CentOS-7-x86_64-Minimal-2009.iso,192.168.1.88,root 四个空格
  • Metabase
    • docker-compose.yml
    • services:
        metabase:
          container_name: metabase
          image: metabase/metabase
          restart: unless-stopped
          environment:
            - MB_DB_FILE=/metabase-data/metabase.db
          volumes:
            - ./data:/metabase-data
          networks: 
            - ghost_net
      
      networks:
        ghost_net:
          external: true
    • nginx/conf.d/metabase.conf,通过vi的:set paste后粘贴
    • # Metabase Nginx Configuration
      # Redirect all HTTP traffic to HTTPS
      server {
        listen 80;
        server_name metabase.atibmlocal.com;
          
        # Serve ads.txt for Google AdSense
        location /ads.txt {
          alias /usr/share/nginx/html/metabase/ads.txt;
        }
          
        # Serve robots.txt for search engines
        location /robots.txt {
          alias /usr/share/nginx/html/metabase/robots.txt;
        }
          
        # Redirect all other requests to HTTPS
        return 301 https://$host$request_uri;
      }
      
      # HTTPS server configuration
      server {
        listen 443 ssl;
        server_name metabase.atibmlocal.com;
          
        # SSL certificate configuration
        ssl_certificate     /etc/letsencrypt/live/ghost.atibm.com/fullchain.pem;
        ssl_certificate_key /etc/letsencrypt/live/ghost.atibm.com/privkey.pem;
          
        # Logging configuration
        access_log /var/log/nginx/metabase-access.log;
        error_log  /var/log/nginx/metabase-error.log;
          
        # Serve ads.txt for Google AdSense
        location /ads.txt {
          alias /usr/share/nginx/html/metabase/ads.txt;
        }
          
        # Serve robots.txt for search engines
        location /robots.txt {
          alias /usr/share/nginx/html/metabase/robots.txt;
        }
          
        # Main application proxy
        location / {
          # Proxy configuration
          proxy_pass http://metabase:3000;
          proxy_http_version 1.1;
              
          # Header configuration
          proxy_set_header Host              $host;
          proxy_set_header X-Real-IP         $remote_addr;
          proxy_set_header X-Forwarded-Proto $scheme;
          proxy_set_header X-Forwarded-For   $proxy_add_x_forwarded_for;
          proxy_set_header Upgrade           $http_upgrade;
          proxy_set_header Connection        "upgrade";
              
          # Timeout settings
          proxy_connect_timeout 150s;
          proxy_send_timeout    100s;
          proxy_read_timeout    100s;
              
          # Buffer settings
          proxy_buffers         4 32k;
              
          # Client body settings
          client_max_body_size  10m;
          client_body_buffer_size 128k;
        }
      }
  • 访问web后完成初始化设置

生产部署

企业报告事例

  • 数据源sqlite
    • 创建空db:宿主机[ghost@VMCentos7 data]$ sqlite3 kaicong.db "VACUUM;"  
    • 加入数据源:metabase添加数据库选sqlite类型,地址/metabase-data/kaicong.db
    • 数据维护:需要sqlite工具操作db文件
    • 数据图表:metabase可以写sql查询统计输出
  • 数据源mysql
  • 数据源csv
    • 上传功能未开通:需要设置,并选中一个数据库才行
    • 不支持的文件类型: