一、安装

1.1 环境

1.1.1 JDK1.8

略

1.1.2 phantomjs

#解压bzip2工具
yum -y install bzip2
yum install fontconfig#下载解压重命名
wget https://bitbucket.org/ariya/phantomjs/downloads/phantomjs-2.1.1-linux-x86_64.tar.bz2
tar -jxvf phantomjs-2.1.1-linux-x86_64.tar.bz2
mv phantomjs-2.1.1-linux-x86_64 /opt/phantomjs#环境变量
vim /etc/profile
PHANTOMJS_HOME=/opt/phantomjs
export PATH=$PATH:$PHANTOMJS_HOME/binsource /etc/profile
phantomjs --version

1.1.3 mysql客户端

yum install -y mysql

1.2 安装部署

1.2.1 下载

#下载解压
wget https://github.com/edp963/davinci/releases/download/v0.3.0-rc/davinci-assembly_0.3.1-0.3.1-SNAPSHOT-dist-rc.zip
unzip davinci-assembly_0.3.1-0.3.1-SNAPSHOT-dist-rc.zip -d /opt/davinci#把需要的提取出来
mv /opt/davinci/davinci-assembly_0.3.1-0.3.1-SNAPSHOT-dist-rc/* /opt/davinci
rm -rf /opt/davinci/davinci-assembly_0.3.1-0.3.1-SNAPSHOT-dist-rc
rm -rf /opt/davinci/__MACOSX#环境配置
vim /etc/profile
export DAVINCI3_HOME=/opt/davincisource /etc/profile

1.2.2 初始化数据库及表

#创建数据库 
mysql -h bt-01 -P 3306 -uroot -p123456
MySQL [(none)]> create database davinci;#修改初始化脚本
vim $DAVINCI3_HOME/bin/initdb.sh
mysql -P 3306 -h bt-01 -u root -p123456 davinci < $DAVINCI3_HOME/bin/davinci.sqlsh $DAVINCI3_HOME/bin/initdb.sh

1.2.3 配置数据库(元数据)

cd config
cp application.yml.example application.yml
vim application.ymlserver:protocol: httpaddress: bt-04port: 22333## davinci datasource configdatasource:type: com.alibaba.druid.pool.DruidDataSourceurl: jdbc:mysql://bt-01:3306/davinci?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=trueusername: rootpassword: 123456driver-class-name: com.mysql.jdbc.Driver## some mailboxes need to be set separately password for the SMTP service)mail:host: smtp.163.comport: 25username: cesarchoyfromAddress: cesarchoy@163.compassword: XXXXXXXXXXXXXXXXnickname: Davinciphantomjs_home: /opt/phantomjs

1.3 启动

bin/start-server.sh

二、使用

2.1 注册

2.2 Source(配置数据源)

2.3 View(写SQL/配置数据)

2.4 Widget(制作图表)

2.5 Dashboard(形成报板)

2.6 一个成果！

三、推荐

官方文档：https://edp963.github.io/davinci/docs/zh/2.4-dashboard

如果访问不了，请再修改hosts文件

# GitHub Start 
140.82.113.3      github.com
140.82.114.20     gist.github.com151.101.184.133    assets-cdn.github.com
151.101.184.133    raw.githubusercontent.com
151.101.184.133    gist.githubusercontent.com
151.101.184.133    cloud.githubusercontent.com
151.101.184.133    camo.githubusercontent.com
151.101.184.133    avatars0.githubusercontent.com
199.232.68.133     avatars0.githubusercontent.com
199.232.28.133     avatars1.githubusercontent.com
151.101.184.133    avatars1.githubusercontent.com
151.101.184.133    avatars2.githubusercontent.com
199.232.28.133     avatars2.githubusercontent.com
151.101.184.133    avatars3.githubusercontent.com
199.232.68.133     avatars3.githubusercontent.com
151.101.184.133    avatars4.githubusercontent.com
199.232.68.133     avatars4.githubusercontent.com
151.101.184.133    avatars5.githubusercontent.com
199.232.68.133     avatars5.githubusercontent.com
151.101.184.133    avatars6.githubusercontent.com
199.232.68.133     avatars6.githubusercontent.com
151.101.184.133    avatars7.githubusercontent.com
199.232.68.133     avatars7.githubusercontent.com
151.101.184.133    avatars8.githubusercontent.com
199.232.68.133     avatars8.githubusercontent.com# GitHub End#github
140.82.114.3 github.com
199.232.69.194 github.global.ssl.fastly.net
185.199.108.153 assets-cdn.github.com
199.232.96.133 avatars0.githubusercontent.com185.199.108.153  edp963.github.io