metabase安装

# metabase安装

>what: metabase简单使用
>where: x86 docker  docker-compose
>when: 2021.12.16
>who: jiaorongtao
>why: 记录
>how:

参考：https://www.metabase.com/docs/v0.41/operations-guide/installing-metabase.html

## 1.docker部署（注意：metebase端口默认3000）

```dockerfile
#https://www.metabase.com/docs/v0.41/operations-guide/running-metabase-on-docker.html
#docker run -d -p 3000:3000 --name metabase metabase/metabase
[root@JRT data]# docker run -d -p 9001:3000 --name metabase metabase/metabase
Unable to find image 'metabase/metabase:latest' locally
latest: Pulling from metabase/metabase
97518928ae5f: Pull complete 
81cb15c4c5e3: Pull complete 
feb013ba1260: Pull complete 
c99751b9fe6c: Pull complete 
73d4d4bf06fe: Pull complete 
Digest: sha256:c5bab50e3b0d2c521a53d05e5d21ed2236dabc2edfa5c2d576c8fa3d2f2addb6
Status: Downloaded newer image for metabase/metabase:latest
90f754d5b186c093d186d031e36925ca9e6d7a762cdaff54277e2085ac13704b
[root@JRT data]#

```

### 查日志

```bash
[root@JRT metabase]# docker logs metabase 
Warning: environ value jdk-11.0.13+8 for key :java-version has been overwritten with 11.0.13
WARNING: sun.reflect.Reflection.getCallerClass is not supported. This will impact performance.
2021-12-16 01:47:45,290 INFO metabase.util :: Maximum memory available to JVM: 948.0 MB
2021-12-16 01:47:57,459 INFO util.encryption :: Saved credentials encryption is DISABLED for this Metabase instance. ???? 
 For more information, see https://metabase.com/docs/latest/operations-guide/encrypting-database-details-at-rest.html
[root@JRT metabase]#
```

## 2.利用docker-compose部署，并把h2数据库切换至mysql

```bash
#1.mysql安装部署略
#2.在mysql中创建一个空的数据库用作metebase数据存储（注意字符集utf8mb4，排序utf8mb4_general_ci）
#3.安装docker-compose略
#4.写docker-compose.yaml(注意：我是把mysql与metebase分离)
#目录结构
[root@JRT metabase]# ls
data  docker-compose.yaml
vim docker-compose.yaml

version: '3'
services:
  sftp:
    image: "metabase/metabase"
    container_name: metabase
    ports:
      - "9001:3000"
    volumes:
      - './data/metabase-data:/metabase-data'
    environment:
      - 'MB_DB_TYPE=mysql'
      - 'MB_DB_DBNAME=metabase'
      - 'MB_DB_PORT=3306'
      - 'MB_DB_USER=root'
      - 'MB_DB_PASS=123456'
      - 'MB_DB_HOST=1.1.1.1'
      
```

### 查日志

```bash
[root@JRT metabase]# docker logs metabase
2021-12-16 03:08:02,534 INFO sync.util :: FINISHED: step 'classify-tables' for h2 Database 1 'Sample Dataset' (40.2 ms)
2021-12-16 03:08:02,571 INFO sync.util :: FINISHED: Analyze data for h2 Database 1 'Sample Dataset' (5.3 s)
2021-12-16 03:08:02,573 INFO sync.util :: STARTING: Cache field values in h2 Database 1 'Sample Dataset'
2021-12-16 03:08:02,576 INFO sync.util :: STARTING: step 'update-field-values' for h2 Database 1 'Sample Dataset'
2021-12-16 03:08:03,585 INFO sync.util :: FINISHED: step 'update-field-values' for h2 Database 1 'Sample Dataset' (1.0 s)
2021-12-16 03:08:03,595 INFO sync.util :: FINISHED: Cache field values in h2 Database 1 'Sample Dataset' (1.0 s)
2021-12-16 03:08:03,595 INFO sync.util :: FINISHED: Sync h2 Database 1 'Sample Dataset' (8.4 s)
2021-12-16 03:08:03,600 INFO metabase.core :: Metabase Initialization COMPLETE
```

## 3.使用

### 3.1 访问页面

```bash
http://1.117.176.116:9001/
```

### 3.2 创建可视化

将操作的表先导入数据库；

进入页面后，通过metebase引导，即可完成初始化，进入主页面；

点击创建问题---自定义查询---选择库--选择操作的表---右上角查看sql语句--转储sql----写自己的sql

查看视图，操作数据-如设置行，设置列

点击视图--保存到分析即可

### 3.3 查看

进入首页--在分析中浏览所有--即可看见之前保存的图表