开源BI工具MetaBase-安装与使用 https://www.jianshu.com/p/f6b5cf74f57d
官方文档: https://www.metabase.com/docs/latest/
简介
metabase开源的BI工具,支持常见的数据库mysql、mongodb等,官网:http://www.metabase.com/
下载安装
http://downloads.metabase.com/v0.30.0/metabase.jar
Linux 运行启动
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
# h2(默认) export MB_DB_TYPE=h2 export MB_DB_FILE=/the/path/to/my/h2.db java -jar metabase.jar #mysql export MB_DB_TYPE=mysql export MB_DB_DBNAME=metabase export MB_DB_PORT=3306 export MB_DB_USER=<username> export MB_DB_PASS=<password> export MB_DB_HOST=localhost java -jar metabase.jar # 端口 export MB_JETTY_PORT=12345 export MB_JETTY_HOST=0.0.0.0 export MB_JETTY_SSL="true" export MB_JETTY_SSL_Port="8443" export MB_JETTY_SSL_Keystore="path/to/keystore.jks" export MB_JETTY_SSL_Keystore_Password="storepass" java -jar -Xms2048M -Xmx2048M -XX:NewSize=512m -XX:MaxNewSize=1024m -XX:PermSize=512m -XX:MaxPermSize=512m metabase.jar |
Window启动方式:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
rem set MB_JETTY_PORT=12345 rem set MB_JETTY_HOST=0.0.0.0 rem set MB_JETTY_SSL="true" rem set MB_JETTY_SSL_Port="8443" rem set MB_JETTY_SSL_Keystore="path/to/keystore.jks" rem set MB_JETTY_SSL_Keystore_Password="storepass" set MB_DB_TYPE=mysql set MB_DB_DBNAME=metabase set MB_DB_PORT=3306 set MB_DB_USER=username set MB_DB_PASS=pwd set MB_DB_HOST=localhost java -jar -Xms1024M -Xmx1024M -XX:NewSize=512m -XX:MaxNewSize=1024m -XX:PermSize=512m -XX:MaxPermSize=512m metabase.jar |
访问localhost:3000,初次访问需要建立账号